Community

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Popular
    • Users
    • Search

    I-doit pro update 1.2.5 auf 1.3.0 db Error

    Betrieb
    2
    3
    1244
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • StefanP74
      StefanP74 last edited by

      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

      1 Reply Last reply Reply Quote 0
      • V
        vqh last edited by

        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

        1 Reply Last reply Reply Quote 0
        • StefanP74
          StefanP74 last edited by

          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

          1 Reply Last reply Reply Quote 0
          • First post
            Last post