Announcement

Collapse
No announcement yet.

Some issues with Nagios + Centreon + NDOUtils.

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

  • Some issues with Nagios + Centreon + NDOUtils.

    Hello,

    We decided to move from an inhouse monitoring system to a Nagios + Centreon + NDOUtils.

    The versions we have installed are :
    Nagios: 3.5.1
    NDO: 1.5.2
    Centreon: 2.5.1
    MySQL: 5.1.73
    Distro: CentOS 6.5

    Everything was installed properly and without any workarounds.

    I finished Centreon Web configuration and was going to start adding the network objects to monitor, when I noticed that it wasn't working properly.

    After looking at the logs I found the following issues:

    sql-error.log:

    Everytime I try to update Poller information
    Code:
    2014-07-10  12:34|0|0|DB Error: no such field QUERY : UPDATE nagios_server SET name  = 'Central', localhost = '1', ns_ip_address = '127.0.0.1',  ssh_port =  '22',  init_script = '/etc/init.d/nagios',  init_script_centreontrapd =  NULL, snmp_trapd_path_conf = '/etc/snmp/centreon_traps/',   monitoring_engine = 'NAGIOS',  nagios_bin = '/usr/sbin/nagios',   nagiostats_bin = '/usr/bin/nagiostats',  nagios_perfdata =  '/var/log/nagios/service-perfdata',  centreonbroker_cfg_path = NULL,  centreonbroker_module_path = NULL, centreonconnector_path = NULL,  ssh_private_key = NULL, is_default = '0',  ns_activate = '1' WHERE id =  '1'
    Every minute:
    Code:
    2014-07-10  12:57|0|0|DB Error: no such table QUERY : DELETE FROM centreon_acl WHERE  group_id NOT IN (SELECT DISTINCT acl_group_id FROM centreon.acl_groups  WHERE acl_group_activate = '1')
    2014-07-10 12:57|0|0|DB Error: no  such table QUERY : DELETE FROM centreon_acl WHERE group_id NOT IN  (SELECT DISTINCT acl_group_id FROM  centreon.acl_res_group_relations)

    logAnalyser.log:
    Code:
    2014-07-10 12:57:02 - 0 lignes dans le fichier /var/lib/centreon/log/1/nagios.log. Database last position flag: 94
    2014-07-10 12:57:02 - Detecting logfile rotation, starting parsing from beginning
    2014-07-10 12:57:02 - Cannot open file: /var/lib/centreon/log/1/nagios.log
    2014-07-10 12:57:02 - Done
    centAcl.log
    Code:
    PHP  Warning:  include_once(/www/class/centreonLDAP.class.php): failed to  open stream: No such file or directory in  /usr/local/centreon/cron/centAcl.php on line 50
    PHP Warning:   include_once(): Failed opening '/www/class/centreonLDAP.class.php' for  inclusion (include_path='.:/usr/share/pear:/usr/share/php') in  /usr/local/centreon/cron/centAcl.php on line 50
    PHP Notice:  Undefined variable: centreon_path in /usr/local/centreon/cron/centAcl.php on line 51
    PHP  Warning:  include_once(/www/class/centreonMeta.class.php): failed to  open stream: No such file or directory in  /usr/local/centreon/cron/centAcl.php on line 51
    PHP Warning:   include_once(): Failed opening '/www/class/centreonMeta.class.php' for  inclusion (include_path='.:/usr/share/pear:/usr/share/php') in  /usr/local/centreon/cron/centAcl.php on line 51
    PHP Notice:  Undefined variable: centreon_path in /usr/local/centreon/cron/centAcl.php on line 52
    PHP  Warning:  include_once(/www/class/centreonContactgroup.class.php):  failed to open stream: No such file or directory in  /usr/local/centreon/cron/centAcl.php on line 52
    PHP Warning:   include_once(): Failed opening  '/www/class/centreonContactgroup.class.php' for inclusion  (include_path='.:/usr/share/pear:/usr/share/php') in  /usr/local/centreon/cron/centAcl.php on line 52
    PHP Notice:  Undefined variable: conf_centreon in /usr/local/centreon/cron/centAcl.php on line 54
    PHP Fatal error:  Class 'CentreonDB' not found in /usr/local/centreon/cron/centAcl.php on line 77

    centcore.log
    Code:
    Permission denied (publickey,gssapi-keyex,gssapi-with-mic,password)
    Can't find exactly what's trying to connect to, in order to fix the above line.

    Code:
    mysql> show grants for 'centreon'@'localhost' ;
    +--------------------------------------------------------------------------------------------------------------------------+
    | Grants for [email protected]                                                                                            |
    +--------------------------------------------------------------------------------------------------------------------------+
    | GRANT ALL PRIVILEGES ON *.* TO 'centreon'@'localhost' IDENTIFIED BY PASSWORD '<censored>' |
    | GRANT ALL PRIVILEGES ON `centreon`.* TO 'centreon'@'localhost' WITH GRANT OPTION                                         |
    | GRANT ALL PRIVILEGES ON `centreon_status`.* TO 'centreon'@'localhost' WITH GRANT OPTION                                  |
    | GRANT ALL PRIVILEGES ON `centreon_storage`.* TO 'centreon'@'localhost' WITH GRANT OPTION                                 |
    +--------------------------------------------------------------------------------------------------------------------------+
    4 rows in set (0.00 sec)
    Any ideas on what might be going on?

    Thank you in advance.
Working...
X