I-doit pro update 1.2.5 auf 1.3.0 db Error



  • Hallo,

    beim Updaten der 1.2.5 auf 1.3.0 werden folgende Fehler beim Installationsprozess angezeigt:
    Ist ein Testsystem, kann sein, dass da unfertige Nagios-Objekte dfiniert waren ….. ich poste es dennoch zur Info 😉
    Ich konnte nach dem Update keinen Fehler feststellen, läuft eigentlich perfekt.

    Adding the nagios export host field (nagios def) Added. ERROR
    Database error : Query error: 'ALTER TABLE isys_catg_nagios_host_tpl_def_list ADD isys_catg_nagios_host_tpl_def_list__export_host INT(10) UNSIGNED NULL, ADD FOREIGN KEY (isys_catg_nagios_host_tpl_def_list__export_host) REFERENCES isys_monitoring_export_config (isys_monitoring_export_config__id) ON DELETE SET NULL ON UPDATE CASCADE':Failed to add the foreign key constraint 'idoit_data/isys_catg_nagios_host_tpl_def_list_ibfk_1' to system tables

    Adding the nagios export host field (nagios tpl def) Added. ERROR
    Database error : Query error: 'ALTER TABLE isys_catg_nagios_list ADD isys_catg_nagios_list__export_host INT(10) UNSIGNED NULL, ADD FOREIGN KEY (isys_catg_nagios_list__export_host) REFERENCES isys_monitoring_export_config (isys_monitoring_export_config__id) ON DELETE SET NULL ON UPDATE CASCADE':Failed to add the foreign key constraint 'idoit_data/isys_catg_nagios_list_ibfk_1' to system tables

    Bei der dB Migration dann noch:

    Migrating "NDO Parameter" category data to "Monitoring" category.
    Moving data in object "server04" (#164)…
    Database error : Query error: 'SELECT isys_obj., isys_obj_type., isys_monitoring_export_config., isys_catg_ip_list., isys_nagios_commands., isys_nagios_commands_plus., isys_nagios_timeperiods., isys_nagios_timeperiods_plus., isys_catg_nagios_list.* FROM isys_obj INNER JOIN isys_catg_nagios_list ON isys_catg_nagios_list__isys_obj__id = isys_obj__id INNER JOIN isys_obj_type ON isys_obj__isys_obj_type__id = isys_obj_type__id LEFT JOIN isys_monitoring_export_config ON isys_catg_nagios_list.isys_catg_nagios_list__export_host = isys_monitoring_export_config.isys_monitoring_export_config__id LEFT JOIN isys_catg_ip_list ON isys_catg_nagios_list.isys_catg_nagios_list__isys_catg_ip_list__id = isys_catg_ip_list.isys_catg_ip_list__id LEFT JOIN isys_nagios_commands ON isys_catg_nagios_list.isys_catg_nagios_list__check_command = isys_nagios_commands.isys_nagios_commands__id LEFT JOIN isys_nagios_commands_plus ON isys_catg_nagios_list.isys_catg_nagios_list__check_command_plus = isys_nagios_commands_plus.isys_nagios_commands_plus__id LEFT JOIN isys_nagios_timeperiods ON isys_catg_nagios_list.isys_catg_nagios_list__check_period = isys_nagios_timeperiods.isys_nagios_timeperiods__id LEFT JOIN isys_nagios_timeperiods_plus ON isys_catg_nagios_list.isys_catg_nagios_list__check_period_plus = isys_nagios_timeperiods_plus.isys_nagios_timeperiods_plus__id WHERE TRUE AND (isys_obj.isys_obj__id = 164)': Unknown column 'isys_catg_nagios_list.isys_catg_nagios_list__export_host' in 'on clause'

    Glückwunsch zum Release ….. welch lange Changelist 🙂

    LG Stefan



  • Hallo Stefan,

    versuch mal folgende Queries:

    ALTER TABLE isys_catg_nagios_host_tpl_def_list ADD isys_catg_nagios_host_tpl_def_list__export_host INT(10) UNSIGNED NULL,
    ADD CONSTRAINT isys_catg_nagios_host_tpl_def_list__export_host FOREIGN KEY (isys_catg_nagios_host_tpl_def_list__export_host) REFERENCES isys_monitoring_export_config (isys_monitoring_export_config__id) ON DELETE SET NULL ON UPDATE CASCADE;

    ALTER TABLE isys_catg_nagios_list ADD isys_catg_nagios_list__export_host INT(10) UNSIGNED NULL,
    ADD CONSTRAINT isys_catg_nagios_list__export_host FOREIGN KEY (isys_catg_nagios_list__export_host) REFERENCES isys_monitoring_export_config (isys_monitoring_export_config__id) ON DELETE SET NULL ON UPDATE CASCADE;

    Gruß
    vqh



  • Ja, damit ist der Fehler behoben.
    Der Folgefehler dadurch war ein SQL Fehler, wenn man bei einem Host auf Nagios in der Objektsturktur klickte.

    Ist damit behoben.

    Danke 🙂

    LG Stefan


 


Datenschutz / Privacy Policy