Bugreport: Absturz bei Zuordnung Anwendung/Server

Nehemias

URL : ?viewMode=1100&tvMode=1006&objID=142&objGroupID=2&moduleID=2&mNavID=2&editMode=1&objTypeID=5&cateID=20&catgID=12
REF : http://*/idoit/index.php?viewMode=1002&tvMode=1006&objID=142&objGroupID=2&moduleID=2&mNavID=2&editMode=0&objTypeID=5&catgID=12
Date : Thu, 12 Feb 2009 14:33:51 +0100
Host :
IP :
Client : Mozilla/5.0 (Windows; U; Windows NT 6.0; de; rv:1.9.0.6) Gecko/2009011913
–---------------------
Ver 0.9.5. NB 3808

Fehler:
isys_exception_dao > Running transaction has been canceled. Could not isys_component_dao::update() :
MySQL-Error: Unknown column 'isys_nagios_service__check_command_parameters' in 'field list'
Query: UPDATE isys_nagios_service SET isys_nagios_service__is_active = '0', isys_nagios_service__service_description = '', isys_nagios_service__display_name = '', isys_nagios_service__active_checks_enabled = '0', isys_nagios_service__passive_checks_enabled = '0', isys_nagios_service__initial_state = '-1', isys_nagios_service__check_command = NULL, isys_nagios_service__check_command_parameters = '', isys_nagios_service__max_check_attempts = NULL, isys_nagios_service__check_interval = NULL, isys_nagios_service__retry_interval = NULL, isys_nagios_service__check_period = NULL, isys_nagios_service__notifications_enabled = '0', isys_nagios_service__notification_interval = NULL, isys_nagios_service__first_notification_delay = NULL, isys_nagios_service__notification_period = NULL, isys_nagios_service__notification_options = '', isys_nagios_service__flap_detection_enabled = '0', isys_nagios_service__flap_detection_options = '', isys_nagios_service__low_flap_threshold = NULL, isys_nagios_service__high_flap_threshold = NULL, isys_nagios_service__is_volatile = '0', isys_nagios_service__obsess_over_service = '0', isys_nagios_service__check_freshness = '0', isys_nagios_service__freshness_threshold = '', isys_nagios_service__event_handler_enabled = '0', isys_nagios_service__event_handler = NULL, isys_nagios_service__process_perf_data = '0', isys_nagios_service__retain_status_information = '0', isys_nagios_service__retain_nonstatus_information = '0', isys_nagios_service__stalking_options = '', isys_nagios_service__escalations = '' WHERE isys_nagios_service__isys_catg_application_list__id = '20';
Try updating your database. If this error occurs permanently, contact the i-doit team, please. (http://i-doit.org/forum, support@i-doit.org)

Der Wert wird aber trotzdem gespeichert ... Nagios? Hab ich nicht angefasst

ds

Was heisst angefasst?
Installiert müsste es sein, sonst würde die Meldung nicht kommen.

Du kannst entweder das Nagios Modul unter Module deaktivieren, oder musst dein Nagios über den updater updaten.

Nehemias

angefasst: so belassen wie es mit der Installation mitkommt

Nehemias

hab jetzt das NB vom 12.02.09 eingespielt, bin die Updatefunktion durch

i-doit Update
Operating System
Type: Windows NT
Version: 5.1 build 2600
i-doit
Current version 0.9.5
Current revision 3796

und der Fehler tritt immer noch auf.

dbluemer

Hallo,
es gab einen Fehler in der Updateroutine. Habe diesen gefixt. Wenn Du noch einmal das Update auf Version v0.9.6 drüberspielst (inkl. Nagios), dann dürfte der Fehler weg sein.

Edit: Das Update heißt jetzt v0.9.5.x SVN

Nehemias

was mach ich falsch? ich bin die updateroutine durchgegangen …

Das ginge: i-doit v0.9.6 0.9.5 rev 3796 0.9.5 rev 3760
Your current version is: 0.9.5 (rev 3796)

Aber das (0.9.5) steht nach dem Update wieder da ... l

isys_exception_dao > Running transaction has been canceled. Could not isys_component_dao::update() :

MySQL-Error: Unknown column 'isys_nagios_service__check_command_parameters' in 'field list'

Query: UPDATE isys_nagios_service SET isys_nagios_service__is_active = '0', isys_nagios_service__service_description = '', isys_nagios_service__display_name = '', isys_nagios_service__active_checks_enabled = '0', isys_nagios_service__passive_checks_enabled = '0', isys_nagios_service__initial_state = '-1', isys_nagios_service__check_command = NULL, isys_nagios_service__check_command_parameters = '', isys_nagios_service__max_check_attempts = NULL, isys_nagios_service__check_interval = NULL, isys_nagios_service__retry_interval = NULL, isys_nagios_service__check_period = '2', isys_nagios_service__notifications_enabled = '0', isys_nagios_service__notification_interval = NULL, isys_nagios_service__first_notification_delay = NULL, isys_nagios_service__notification_period = '1', isys_nagios_service__notification_options = '', isys_nagios_service__flap_detection_enabled = '0', isys_nagios_service__flap_detection_options = '', isys_nagios_service__low_flap_threshold = NULL, isys_nagios_service__high_flap_threshold = NULL, isys_nagios_service__is_volatile = '0', isys_nagios_service__obsess_over_service = '0', isys_nagios_service__check_freshness = '0', isys_nagios_service__freshness_threshold = '', isys_nagios_service__event_handler_enabled = '0', isys_nagios_service__event_handler = NULL, isys_nagios_service__process_perf_data = '0', isys_nagios_service__retain_status_information = '0', isys_nagios_service__retain_nonstatus_information = '0', isys_nagios_service__stalking_options = '', isys_nagios_service__escalations = '' WHERE isys_nagios_service__isys_catg_application_list__id = '25';

Try updating your database. If this error occurs permanently, contact the i-doit team, please. (http://i-doit.org/forum, support@i-doit.org)

dbluemer

Hast Du vorher aus dem SVN ein Update gemacht?

Die Versionsnummer wird bei der aktuellen Entwicklungsversion noch nicht auf v0.9.6 hochgesetzt, erst wenn diese wirklich released wird.

Kannst Du mal das Protokoll des Datenbankupdates, das während des Updates angezeigt wird, posten?

Nehemias

im updatelogfile steht alles auf grün

dbluemer

Ich würde trotzdem gerne mal draufschauen, da mich ein ganz bestimmter Eintrag interessiert.

Nehemias

SVN geht nicht - Berechtigungsproblem - das hatte ich zwar schon mal gepostet, aber das Prob ist immer noch offen.
Ich hatte davor einen NV eingespielt (3821)
Es stehen zwar keine neuen Updates zur verfügung - aber et voila:
…
Process Success
Updating system database.. DONE
Version change Updated. DONE
Updating mandator database(s)..

die DONE
Version change Updated. DONE
Copying files to C:\Programme\xampp\htdocs\idoit.. DONE
Deleting files
No files to delete this time OK
Installing modules DONE
Module: nagios
Updating system database wir.. DONE
Updating value.. Value already existing. DONE
Updating value.. Value already existing. DONE
Updating value.. Value already existing. DONE
Updating value.. Value already existing. DONE
die DONE
Nagios module Value already existing. DONE
Nagios module rights Value already existing. DONE
Creating table isys_catg_nagios.. Table already existing. DONE
Creating table isys_catg_nagios_list.. Table already existing. DONE
Updating value.. Value already existing. DONE
Nagios category for server Value already existing. DONE
Nagios category for switch Value already existing. DONE
Nagios category for router Value already existing. DONE
Creating table isys_nagios_ndo.. Table already existing. DONE
Changing isys_nagios_ndo__ndodb_id OK DONE
Adding index isys_nagios_ndo__ndodb_id__FKIndex to isys_nagios_ndo.. Added. DONE
Updating value.. Value already existing. DONE
Creating table isys_nagios_commands.. Table already existing. DONE
Creating table isys_nagios_timeperiods.. Table already existing. DONE
Creating table isys_nagios_contacts.. Table already existing. DONE
Logbook source NDO Value already existing. DONE
Creating table isys_nagios_dependency.. Table already existing. DONE
Adding field isys_catg_application_list__is_active to table isys_catg_application_l.. Added. DONE
Adding field isys_catg_application_list__service_description to table isys_catg_app.. Added. DONE
Adding field isys_catg_application_list__check_command to table isys_catg_applicati.. Added. DONE
Adding field isys_catg_application_list__max_check_attempts to table isys_catg_appl.. Added. DONE
Adding field isys_catg_application_list__check_interval to table isys_catg_applicat.. Added. DONE
Adding field isys_catg_application_list__retry_interval to table isys_catg_applicat.. Added. DONE
Adding field isys_catg_application_list__notification_interval to table isys_catg_a.. Added. DONE
Adding field isys_catg_application_list__check_period to table isys_catg_applicatio.. Added. DONE
Adding field isys_catg_application_list__notification_period to table isys_catg_app.. Added. DONE
Adding field isys_catg_distributor__isys_catg_nagios__id to table isys_catg_distrib.. Already exists. DONE
Updating value.. Value already existing. DONE
Updating value.. Value already existing. DONE
Adding field isys_catg_nagios_list__isys_nagios_ndo__ndodb_id to table isys_catg_na.. Already exists. DONE
Creating table isys_nagios_host_escalations.. Table already existing. DONE
Creating table isys_nagios_service_escalations.. Table already existing. DONE
Adding index isys_nagios_dependency__isys_dependency__id__FKIndex to isys_nagios_de.. Index exists. DONE
Adding field isys_catg_nagios_list__escalations to table isys_catg_nagios_list.. Already exists. DONE
Creating table isys_nagios_service.. Table already existing. DONE
Deleting index isys_catg_application_list__check_command__FKIndex from isys_catg_ap.. Deleted. DONE
Deleting index isys_catg_application_list__check_period__FKIndex from isys_catg_app.. Deleted. DONE
Deleting index isys_catg_application_list__notification_period__FKIndex from isys_c.. Deleted. DONE
Deleting field isys_catg_application_list__notification_interval from isys_catg_app.. Deleted. DONE
Deleting field isys_catg_application_list__check_interval from isys_catg_applicatio.. Deleted. DONE
Deleting field isys_catg_application_list__retry_interval from isys_catg_applicatio.. Deleted. DONE
Deleting field isys_catg_application_list__max_check_attempts from isys_catg_applic.. Deleted. DONE
Deleting field isys_catg_application_list__service_description from isys_catg_appli.. Deleted. DONE
Deleting field isys_catg_application_list__is_active from isys_catg_application_lis.. Deleted. DONE
Changing field isys_nagios_contacts__name in table isys_nagios_contacts.. Change already made. DONE
Adding field isys_nagios_contacts__can_submit_commands to table isys_nagios_contact.. Already exists. DONE
Adding field isys_nagios_contacts__retain_status_information to table isys_nagios_c.. Already exists. DONE
Adding field isys_nagios_contacts__retain_nonstatus_information to table isys_nagio.. Already exists. DONE
Creating table isys_nagios_contact_groups.. Table already existing. DONE
Adding field isys_catg_nagios_list__display_name to table isys_catg_nagios_list.. Already exists. DONE
Adding index isys_catg_nagios_list__check_command__FKIndex to isys_catg_nagios_list.. Index exists. DONE
Adding field isys_catg_nagios_list__initial_state to table isys_catg_nagios_list.. Already exists. DONE
Adding field isys_catg_nagios_list__active_checks_enabled to table isys_catg_nagios.. Already exists. DONE
Adding field isys_catg_nagios_list__passive_checks_enabled to table isys_catg_nagio.. Already exists. DONE
Adding field isys_catg_nagios_list__obsess_over_host to table isys_catg_nagios_list.. Already exists. DONE
Adding field isys_catg_nagios_list__check_freshness to table isys_catg_nagios_list.. Already exists. DONE
Adding field isys_catg_nagios_list__freshness_threshold to table isys_catg_nagios_l.. Already exists. DONE
Adding field isys_catg_nagios_list__flap_detection_enabled to table isys_catg_nagio.. Already exists. DONE
Adding field isys_catg_nagios_list__flap_detection_options to table isys_catg_nagio.. Already exists. DONE
Adding field isys_catg_nagios_list__event_handler to table isys_catg_nagios_list.. Already exists. DONE
Adding field isys_catg_nagios_list__event_handler_enabled to table isys_catg_nagios.. Already exists. DONE
Adding field isys_catg_nagios_list__low_flap_threshold to table isys_catg_nagios_li.. Already exists. DONE
Adding field isys_catg_nagios_list__high_flap_threshold to table isys_catg_nagios_l.. Already exists. DONE
Adding field isys_catg_nagios_list__process_perf_data to table isys_catg_nagios_lis.. Already exists. DONE
Adding field isys_catg_nagios_list__retain_status_information to table isys_catg_na.. Already exists. DONE
Adding field isys_catg_nagios_list__retain_nonstatus_information to table isys_catg.. Already exists. DONE
Adding field isys_catg_nagios_list__first_notification_delay to table isys_catg_nag.. Already exists. DONE
Adding field isys_catg_nagios_list__notification_options to table isys_catg_nagios_.. Already exists. DONE
Adding field isys_catg_nagios_list__notifications_enabled to table isys_catg_nagios.. Already exists. DONE
Adding field isys_catg_nagios_list__stalking_options to table isys_catg_nagios_list.. Already exists. DONE
Adding field isys_catg_nagios_list__check_command_parameters to table isys_catg_nag.. Already exists. DONE
Adding field isys_catg_nagios_list__event_handler_parameters to table isys_catg_nag.. Already exists. DONE
Changing field isys_nagios_commands__line in table isys_nagios_commands.. Changed. DONE
Timeperiod 'never' Value already existing. DONE
Timeperiod '24x7' Value already existing. DONE
Timeperiod 'workhours' Value already existing. DONE
Timeperiod 'nonworkhours' Value already existing. DONE
Main config table Table already existing. DONE
Adding field isys_nagios_timeperiods__default_check to table isys_nagios_timeperiod.. Already exists. DONE
Adding field isys_nagios_timeperiods__default_notification to table isys_nagios_tim.. Already exists. DONE
Adding field isys_catg_nagios_list__is_parent to table isys_catg_nagios_list.. Already exists. DONE
Copying files to C:\Programme\xampp\htdocs\idoit.. DONE
Copying ./src\classes\modules\isys_module_nagi.. DONE
Applying config file
No config update needed this time DONE
Deleting temp directories.. DONE
...

dbluemer

Hmm, also anhand des Screenshots würde ich sagen, es handelt sich nicht um die aktuellste Version. In dieser sollte es kein Update v0.9.6 mehr geben. Dieses heisst jetzt "i-doit v0.9.5.x SVN".

Hier scheint eher ein Problem mit der Aktualität vorzuliegen.

Was klappt denn bei Dir im SVN nicht? Was führst Du aus und welche Fehlermdlung erhältst Du da genau?