Announcement

Collapse
No announcement yet.

Erreur SQL de ndo2db-3x

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Erreur SQL de ndo2db-3x

    bonjour

    ca fait plusieurs fois que j'installe nagios et centreon en suivant le guide sur le wifi. et apres en regardant les log je trouve plein d'erreur SQL. Mais priori tout fonctionne correctement, est-ce normal ?

    Code:
    ndo2db-3x: Successfully connected to MySQL database
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/services\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/misccommands\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/checkcommands\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/contactgroups\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/contacts\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/hostgroups\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/servicegroups\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/timeperiods\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/escalations\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/dependencies\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/hostextinfo\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/serviceextinfo\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/meta_commands\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/meta_contact\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/meta_contactgroup\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/meta_dependencies\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/meta_escalations\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/meta_host\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/meta_hostgroup\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/meta_services\.cfg''
    Sep  1 17:34:49 ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='2', varname='cfg_file', varvalue='/usr/local/nagios/etc/meta_timeperiod\.cfg''
    Merci

  • #2
    Same problem, SQL error when restarting

    Same problem here !

    I run 2.0 RC4 now.
    When restarting/re-exporting(config) Nagios.

    I have the same in my /var/log/messages
    This seems to be introduced with RC4.. ?

    (another problem which is maybe related to this: I have some services which are not visible. I see them in the Event Log as being checked (they are warning or critical in my case), but i don't see them in the warning or critical list... I DID saw them when i renamed the HOST (alias+description) under which the services are. I don't know if this has to do with NDO2DB and/or the problem mentioned above. However; Invisible serices is a really not-done thing.).

    Comment


    • #3
      English ?

      ..anyone problems if we try to do this thread in English ?..
      In this case we can help more people with this same problem.

      (thank you all for your time)

      Comment


      • #4
        Try this one...

        ... at your own risk

        In the nagios DB:
        alter table nagios_configfilevariables drop index instance_id ;
        alter table nagios_configfilevariables add index (instance_id, configfile_id, varname) ;

        Comment

        Working...
        X