No Data , No chart in Report since the upgrate to 523

[dcsid]

Hi,

Since the last upgrate from version 416 to version 523 , lot of functionally Report doesn't seems to work.(SLA Report , Avaibility , ..)

Host data , Service Data are equal to zero .
The result is the same for all host , services , service groups , ...

The log file update.log does not seem have error


Thank

[lmiltchev]

Do "Host Detail" and "Service Detail" pages update properly (i.e. Last Check, Status Information)? Have you tried stopping/starting nagios and ndo2db services? Do you see any errors in the apache error log and/or the mysqld.log? Run the following commands and show the output in code wraps:

Code: Select all

uname -a
cat /etc/*release
ps -ef

Is opening a new support ticket in our email ticketing system an option for you? We may need to review the "profile.zip".

[dcsid]

Hi ,

All others function run correctly.

i have error in apache log file

Code: Select all

[Sun Jan 03 03:41:04 2016] [notice] Digest: generating secret for digest authentication ...
[Sun Jan 03 03:41:04 2016] [notice] Digest: done
[Sun Jan 03 03:41:04 2016] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.1e-fips configured -- resuming normal operations
[Mon Jan 04 09:44:39 2016] [error] [client 160.147.161.227] PHP Warning:  ldap_bind(): Unable to bind to server: Invalid credentials in /usr/local/nagiosxi/html/includes/components/ldap_ad_integration/adLDAP/src/adLDAP.php on line 714, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Mon Jan 04 09:46:47 2016] [error] [client 160.147.161.54] PHP Warning:  ldap_bind(): Unable to bind to server: Invalid credentials in /usr/local/nagiosxi/html/includes/components/ldap_ad_integration/adLDAP/src/adLDAP.php on line 714, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Mon Jan 04 09:46:47 2016] [error] [client 160.147.161.54] PHP Warning:  ldap_bind(): Unable to bind to server: Invalid credentials in /usr/local/nagiosxi/html/includes/components/ldap_ad_integration/adLDAP/src/adLDAP.php on line 714, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Mon Jan 04 09:47:07 2016] [error] [client 160.147.161.54] PHP Warning:  ldap_bind(): Unable to bind to server: Invalid credentials in /usr/local/nagiosxi/html/includes/components/ldap_ad_integration/adLDAP/src/adLDAP.php on line 714, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/login.php
[Mon Jan 04 10:05:17 2016] [error] [client 160.147.161.227] PHP Notice:  Undefined variable: service in /usr/local/nagiosxi/html/includes/components/xicore/status-object-detail.inc.php on line 2817, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/includes/components/xicore/status.php?show=hostdetail&host=gtp-auth
[Mon Jan 04 10:05:17 2016] [error] [client 160.147.161.227] PHP Notice:  Undefined variable: service in /usr/local/nagiosxi/html/includes/components/xicore/status-object-detail.inc.php on line 2817, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/includes/components/xicore/status.php?show=hostdetail&host=gtp-auth
[Mon Jan 04 10:05:17 2016] [error] [client 160.147.161.227] PHP Notice:  Undefined variable: service in /usr/local/nagiosxi/html/includes/components/xicore/status-object-detail.inc.php on line 2817, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/includes/components/xicore/status.php?show=hostdetail&host=gtp-auth
[Mon Jan 04 10:05:17 2016] [error] [client 160.147.161.227] PHP Notice:  Undefined variable: service in /usr/local/nagiosxi/html/includes/components/xicore/status-object-detail.inc.php on line 2817, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/includes/components/xicore/status.php?show=hostdetail&host=gtp-auth
[Mon Jan 04 12:23:59 2016] [error] [client 160.147.161.227] PHP Warning:  simplexml_load_file(): I/O warning : failed to load external entity "/usr/local/nagios/share/perfdata/aedem/Processus_Tomcat.xml" in /usr/local/nagiosxi/html/includes/components/capacityplanning/capacityplanning.inc.php on line 227, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/includes/components/xicore/status.php?show=services&servicegroup=Srv_DEMAT
[Mon Jan 04 12:47:00 2016] [error] [client 160.147.161.227] PHP Notice:  Undefined variable: service in /usr/local/nagiosxi/html/includes/components/xicore/status-object-detail.inc.php on line 2817, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/includes/components/xicore/status.php?show=hostdetail&host=gtp-appli4
[Mon Jan 04 12:47:00 2016] [error] [client 160.147.161.227] PHP Notice:  Undefined variable: service in /usr/local/nagiosxi/html/includes/components/xicore/status-object-detail.inc.php on line 2817, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/includes/components/xicore/status.php?show=hostdetail&host=gtp-appli4
[Mon Jan 04 12:47:00 2016] [error] [client 160.147.161.227] PHP Notice:  Undefined variable: service in /usr/local/nagiosxi/html/includes/components/xicore/status-object-detail.inc.php on line 2817, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/includes/components/xicore/status.php?show=hostdetail&host=gtp-appli4
[Mon Jan 04 12:47:00 2016] [error] [client 160.147.161.227] PHP Notice:  Undefined variable: service in /usr/local/nagiosxi/html/includes/components/xicore/status-object-detail.inc.php on line 2817, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/includes/components/xicore/status.php?show=hostdetail&host=gtp-appli4
[Mon Jan 04 12:54:14 2016] [error] [client 160.147.161.227] PHP Warning:  ldap_bind(): Unable to bind to server: Invalid credentials in /usr/local/nagiosxi/html/includes/components/ldap_ad_integration/adLDAP/src/adLDAP.php on line 714, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/login.php?redirect=/nagiosxi/admin/index.php%3f&noauth=1
[Mon Jan 04 13:04:14 2016] [error] [client 160.147.161.227] PHP Warning:  ldap_bind(): Unable to bind to server: Invalid credentials in /usr/local/nagiosxi/html/includes/components/ldap_ad_integration/adLDAP/src/adLDAP.php on line 714, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/login.php?logout
[Mon Jan 04 13:05:04 2016] [error] [client 160.147.161.227] PHP Warning:  array_multisort(): Argument #1 is expected to be an array or a sort flag in /usr/local/nagiosxi/html/includes/utils-tools.inc.php on line 33, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/index.php
cp: cannot stat `/usr/local/nagios/var/objects.cache\r': No such file or directory
tar: Removing leading `/' from member names
[Mon Jan 04 13:19:25 2016] [error] [client 160.147.161.227] PHP Notice:  Undefined offset: 1 in /usr/local/nagiosxi/html/includes/components/graphexplorer/templates/perfdata.inc.php on line 239, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/perfgraphs/
[Mon Jan 04 13:19:25 2016] [error] [client 160.147.161.227] PHP Notice:  Undefined offset: 2 in /usr/local/nagiosxi/html/includes/components/graphexplorer/templates/perfdata.inc.php on line 239, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/perfgraphs/
[Mon Jan 04 13:19:25 2016] [error] [client 160.147.161.227] PHP Notice:  Undefined offset: 3 in /usr/local/nagiosxi/html/includes/components/graphexplorer/templates/perfdata.inc.php on line 239, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/perfgraphs/
[Mon Jan 04 13:19:25 2016] [error] [client 160.147.161.227] PHP Notice:  Undefined offset: 3 in /usr/local/nagiosxi/html/includes/components/graphexplorer/templates/perfdata.inc.php on line 239, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/perfgraphs/
[Mon Jan 04 13:19:25 2016] [error] [client 160.147.161.227] PHP Notice:  Undefined offset: 3 in /usr/local/nagiosxi/html/includes/components/graphexplorer/templates/perfdata.inc.php on line 239, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/perfgraphs/
[Mon Jan 04 13:19:25 2016] [error] [client 160.147.161.227] PHP Notice:  Undefined offset: 3 in /usr/local/nagiosxi/html/includes/components/graphexplorer/templates/perfdata.inc.php on line 239, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/perfgraphs/
[Mon Jan 04 13:19:26 2016] [error] [client 160.147.161.227] PHP Notice:  Undefined offset: 1 in /usr/local/nagiosxi/html/includes/components/graphexplorer/templates/perfdata.inc.php on line 239, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/perfgraphs/
[Tue Jan 05 10:00:21 2016] [error] [client ::1] PHP Warning:  pg_pconnect(): PostgreSQL link lost, unable to reconnect in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-postgres64.inc.php on line 682
[Tue Jan 05 10:00:21 2016] [error] [client ::1] PHP Notice:  Undefined variable: result in /usr/local/nagiosxi/html/includes/db.inc.php on line 249
[Tue Jan 05 10:00:21 2016] [error] [client ::1] PHP Warning:  pg_pconnect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused\n\tIs the server running on host "localhost" and accepting\n\tTCP/IP connections on port 5432?\ncould not connect to server: Connection refused\n\tIs the server running on host "localhost" and accepting\n\tTCP/IP connections on port 5432? in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-postgres64.inc.php on line 682
[Tue Jan 05 10:00:21 2016] [error] [client ::1] PHP Notice:  Undefined variable: result in /usr/local/nagiosxi/html/includes/db.inc.php on line 249
[Tue Jan 05 10:00:43 2016] [notice] caught SIGTERM, shutting down
[Tue Jan 05 10:01:35 2016] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Tue Jan 05 10:01:35 2016] [notice] Digest: generating secret for digest authentication ...
[Tue Jan 05 10:01:35 2016] [notice] Digest: done
[Tue Jan 05 10:01:37 2016] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.1e-fips configured -- resuming normal operations
cp: cannot stat `/usr/local/nagios/var/objects.cache\r': No such file or directory
tar: Removing leading `/' from member names
[Tue Jan 05 10:13:26 2016] [error] [client 160.147.161.227] PHP Notice:  Trying to get property of non-object in /usr/local/nagiosxi/html/includes/utils-reports.inc.php on line 225, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/reports/availability.php?&=
[Tue Jan 05 10:13:26 2016] [error] [client 160.147.161.227] PHP Warning:  Invalid argument supplied for foreach() in /usr/local/nagiosxi/html/includes/utils-reports.inc.php on line 225, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/reports/availability.php?&=
[Tue Jan 05 10:13:26 2016] [error] [client 160.147.161.227] PHP Notice:  Trying to get property of non-object in /usr/local/nagiosxi/html/includes/utils-reports.inc.php on line 225, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/reports/availability.php?&=
[Tue Jan 05 10:13:26 2016] [error] [client 160.147.161.227] PHP Warning:  Invalid argument supplied for foreach() in /usr/local/nagiosxi/html/includes/utils-reports.inc.php on line 225, referer: http://eyes-sid.intradef.gouv.fr/nagiosxi/reports/availability.php?&=

tle last error i have in mysql log file was

Code: Select all

150829  9:10:01 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './nagios/nagios_logentries.MYI'; try to repair it
150829  9:10:01 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './nagios/nagios_logentries.MYI'; try to repair it
150829  9:10:02 [ERROR] Got error 127 when reading table './nagios/nagios_servicestatus'
150829  9:10:02 [ERROR] Got error 127 when reading table './nagios/nagios_servicestatus'
150829  9:10:02 [ERROR] Got error 127 when reading table './nagios/nagios_servicestatus'
150829  9:10:06 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './nagios/nagios_hoststatus.MYI'; try to repair it
150829  9:10:06 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './nagios/nagios_hoststatus.MYI'; try to repair it
150829  9:10:22 [ERROR] Got error 127 when reading table './nagios/nagios_servicestatus'

In response to your request

Code: Select all

ps -ef 

UID        PID  PPID  C STIME TTY          TIME CMD
root         1     0  0 10:00 ?        00:00:01 /sbin/init
root         2     0  0 10:00 ?        00:00:00 [kthreadd]
root         3     2  0 10:00 ?        00:00:00 [migration/0]
root         4     2  0 10:00 ?        00:00:00 [ksoftirqd/0]
root         5     2  0 10:00 ?        00:00:00 [stopper/0]
root         6     2  0 10:00 ?        00:00:00 [watchdog/0]
root         7     2  0 10:00 ?        00:00:00 [migration/1]
root         8     2  0 10:00 ?        00:00:00 [stopper/1]
root         9     2  0 10:00 ?        00:00:00 [ksoftirqd/1]
root        10     2  0 10:00 ?        00:00:00 [watchdog/1]
root        11     2  0 10:00 ?        00:00:00 [migration/2]
root        12     2  0 10:00 ?        00:00:00 [stopper/2]
root        13     2  0 10:00 ?        00:00:00 [ksoftirqd/2]
root        14     2  0 10:00 ?        00:00:00 [watchdog/2]
root        15     2  0 10:00 ?        00:00:00 [migration/3]
root        16     2  0 10:00 ?        00:00:00 [stopper/3]
root        17     2  0 10:00 ?        00:00:00 [ksoftirqd/3]
root        18     2  0 10:00 ?        00:00:00 [watchdog/3]
root        19     2  0 10:00 ?        00:00:00 [events/0]
root        20     2  0 10:00 ?        00:00:00 [events/1]
root        21     2  0 10:00 ?        00:00:00 [events/2]
root        22     2  0 10:00 ?        00:00:00 [events/3]
root        23     2  0 10:00 ?        00:00:00 [cgroup]
root        24     2  0 10:00 ?        00:00:00 [khelper]
root        25     2  0 10:00 ?        00:00:00 [netns]
root        26     2  0 10:00 ?        00:00:00 [async/mgr]
root        27     2  0 10:00 ?        00:00:00 [pm]
root        28     2  0 10:00 ?        00:00:00 [sync_supers]
root        29     2  0 10:00 ?        00:00:00 [bdi-default]
root        30     2  0 10:00 ?        00:00:00 [kintegrityd/0]
root        31     2  0 10:00 ?        00:00:00 [kintegrityd/1]
root        32     2  0 10:00 ?        00:00:00 [kintegrityd/2]
root        33     2  0 10:00 ?        00:00:00 [kintegrityd/3]
root        34     2  0 10:00 ?        00:00:00 [kblockd/0]
root        35     2  0 10:00 ?        00:00:00 [kblockd/1]
root        36     2  0 10:00 ?        00:00:00 [kblockd/2]
root        37     2  0 10:00 ?        00:00:00 [kblockd/3]
root        38     2  0 10:00 ?        00:00:00 [kacpid]
root        39     2  0 10:00 ?        00:00:00 [kacpi_notify]
root        40     2  0 10:00 ?        00:00:00 [kacpi_hotplug]
root        41     2  0 10:01 ?        00:00:00 [ata_aux]
root        42     2  0 10:01 ?        00:00:00 [ata_sff/0]
root        43     2  0 10:01 ?        00:00:00 [ata_sff/1]
root        44     2  0 10:01 ?        00:00:00 [ata_sff/2]
root        45     2  0 10:01 ?        00:00:00 [ata_sff/3]
root        46     2  0 10:01 ?        00:00:00 [ksuspend_usbd]
root        47     2  0 10:01 ?        00:00:00 [khubd]
root        48     2  0 10:01 ?        00:00:00 [kseriod]
root        49     2  0 10:01 ?        00:00:00 [md/0]
root        50     2  0 10:01 ?        00:00:00 [md/1]
root        51     2  0 10:01 ?        00:00:00 [md/2]
root        52     2  0 10:01 ?        00:00:00 [md/3]
root        53     2  0 10:01 ?        00:00:00 [md_misc/0]
root        54     2  0 10:01 ?        00:00:00 [md_misc/1]
root        55     2  0 10:01 ?        00:00:00 [md_misc/2]
root        56     2  0 10:01 ?        00:00:00 [md_misc/3]
root        57     2  0 10:01 ?        00:00:00 [linkwatch]
root        59     2  0 10:01 ?        00:00:00 [khungtaskd]
root        60     2  0 10:01 ?        00:00:00 [kswapd0]
root        61     2  0 10:01 ?        00:00:00 [ksmd]
root        62     2  0 10:01 ?        00:00:00 [khugepaged]
root        63     2  0 10:01 ?        00:00:00 [aio/0]
root        64     2  0 10:01 ?        00:00:00 [aio/1]
root        65     2  0 10:01 ?        00:00:00 [aio/2]
root        66     2  0 10:01 ?        00:00:00 [aio/3]
root        67     2  0 10:01 ?        00:00:00 [crypto/0]
root        68     2  0 10:01 ?        00:00:00 [crypto/1]
root        69     2  0 10:01 ?        00:00:00 [crypto/2]
root        70     2  0 10:01 ?        00:00:00 [crypto/3]
root        78     2  0 10:01 ?        00:00:00 [kthrotld/0]
root        79     2  0 10:01 ?        00:00:00 [kthrotld/1]
root        80     2  0 10:01 ?        00:00:00 [kthrotld/2]
root        81     2  0 10:01 ?        00:00:00 [kthrotld/3]
root        82     2  0 10:01 ?        00:00:00 [pciehpd]
root        84     2  0 10:01 ?        00:00:00 [kpsmoused]
root        85     2  0 10:01 ?        00:00:00 [usbhid_resumer]
root        86     2  0 10:01 ?        00:00:00 [deferwq]
root       117     2  0 10:01 ?        00:00:00 [kdmremove]
root       118     2  0 10:01 ?        00:00:00 [kstriped]
root       347     2  0 10:01 ?        00:00:00 [scsi_eh_0]
root       348     2  0 10:01 ?        00:00:00 [scsi_eh_1]
root       355     2  0 10:01 ?        00:00:00 [mpt_poll_0]
root       356     2  0 10:01 ?        00:00:00 [mpt/0]
root       357     2  0 10:01 ?        00:00:00 [scsi_eh_2]
root       411     2  0 10:01 ?        00:00:00 [kdmflush]
root       413     2  0 10:01 ?        00:00:00 [kdmflush]
root       430     2  0 10:01 ?        00:00:00 [jbd2/dm-0-8]
root       431     2  0 10:01 ?        00:00:00 [ext4-dio-unwrit]
root       475     2  0 10:01 ?        00:00:00 [flush-8:0]
root       509     1  0 10:01 ?        00:00:00 /sbin/udevd -d
root       740     2  0 10:01 ?        00:00:00 [vmmemctl]
root       901     2  0 10:01 ?        00:00:00 [jbd2/sda1-8]
root       902     2  0 10:01 ?        00:00:00 [ext4-dio-unwrit]
root       936     2  0 10:01 ?        00:00:00 [kauditd]
root      1327     2  0 10:01 ?        00:00:00 [flush-253:0]
root      1329     1  0 10:01 ?        00:00:00 /usr/sbin/vmtoolsd
root      1420     1  0 10:01 ?        00:00:00 auditd
root      1440     1  0 10:01 ?        00:00:00 /sbin/rsyslogd -i /var/run/syslogd.pid -c 5
dbus      1453     1  0 10:01 ?        00:00:00 dbus-daemon --system
root      1495     1  0 10:01 ?        00:00:00 /usr/sbin/sshd
root      1504     1  0 10:01 ?        00:00:00 xinetd -stayalive -pidfile /var/run/xinetd.pid
ntp       1514     1  0 10:01 ?        00:00:00 ntpd -u ntp:ntp -p /var/run/ntpd.pid -g
root      1542  1514  0 10:01 ?        00:00:00 ntpd -u ntp:ntp -p /var/run/ntpd.pid -g
root      1550     1  0 10:01 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql     1652  1550  1 10:01 ?        00:00:03 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
postgres  1691     1  0 10:01 ?        00:00:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
postgres  1693  1691  0 10:01 ?        00:00:00 postgres: logger process                          
postgres  1695  1691  0 10:01 ?        00:00:00 postgres: writer process                          
postgres  1696  1691  0 10:01 ?        00:00:00 postgres: wal writer process                      
postgres  1697  1691  0 10:01 ?        00:00:00 postgres: autovacuum launcher process             
postgres  1698  1691  0 10:01 ?        00:00:00 postgres: stats collector process                 
root      1777     1  0 10:01 ?        00:00:00 /usr/libexec/postfix/master
postfix   1786  1777  0 10:01 ?        00:00:00 pickup -l -t fifo -u
postfix   1787  1777  0 10:01 ?        00:00:00 qmgr -l -t fifo -u
root      1788     1  0 10:01 ?        00:00:00 /usr/sbin/httpd
root      1798     1  0 10:01 ?        00:00:00 crond
nagios    1809     1  0 10:01 ?        00:00:00 /usr/local/nagios/bin/npcd -d -f /usr/local/nagios/etc/pnp/npcd.cfg
nagios    1825     1  0 10:01 ?        00:00:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
ajaxterm  1835     1  0 10:01 ?        00:00:00 python /usr/share/ajaxterm/ajaxterm.py --daemon --port=8022 --uid=ajaxterm
nagios    1872     1  0 10:01 ?        00:00:00 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
nagios    1878  1872  0 10:01 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios    1879  1872  0 10:01 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios    1880  1872  0 10:01 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios    1882  1872  0 10:01 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios    1883  1872  0 10:01 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios    1884  1872  0 10:01 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios    1889  1825  0 10:01 ?        00:00:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
nagios    1890  1889  2 10:01 ?        00:00:03 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
nagios    1915  1872  0 10:01 ?        00:00:00 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
apache    1917  1788  0 10:01 ?        00:00:01 /usr/sbin/httpd
apache    1918  1788  0 10:01 ?        00:00:00 /usr/sbin/httpd
apache    1919  1788  0 10:01 ?        00:00:00 /usr/sbin/httpd
apache    1920  1788  0 10:01 ?        00:00:00 /usr/sbin/httpd
apache    1921  1788  0 10:01 ?        00:00:01 /usr/sbin/httpd
apache    1922  1788  0 10:01 ?        00:00:00 /usr/sbin/httpd
apache    1923  1788  0 10:01 ?        00:00:01 /usr/sbin/httpd
apache    1924  1788  0 10:01 ?        00:00:01 /usr/sbin/httpd
apache    1935  1788  0 10:01 ?        00:00:00 /usr/sbin/httpd
apache    2028  1788  0 10:01 ?        00:00:00 /usr/sbin/httpd
apache    2029  1788  0 10:01 ?        00:00:01 /usr/sbin/httpd
root      2030     1  0 10:01 ?        00:00:00 /opt/tina/Bin/tina_daemon -td_op 1 -comm_by_pipe YES
root      2033  2030  0 10:01 ?        00:00:00 /opt/tina/Bin/tina_daemon -td_op 20 -td_shm_id 32769 -comm_by_pipe YES
apache    2039  1788  0 10:01 ?        00:00:00 /usr/sbin/httpd
apache    2040  1788  0 10:01 ?        00:00:01 /usr/sbin/httpd
apache    2041  1788  0 10:01 ?        00:00:01 /usr/sbin/httpd
apache    2042  1788  0 10:01 ?        00:00:01 /usr/sbin/httpd
root      2179     1  0 10:01 tty1     00:00:00 /sbin/mingetty /dev/tty1
root      2181     1  0 10:01 tty2     00:00:00 /sbin/mingetty /dev/tty2
root      2183     1  0 10:01 tty3     00:00:00 /sbin/mingetty /dev/tty3
root      2185   509  0 10:01 ?        00:00:00 /sbin/udevd -d
root      2186   509  0 10:01 ?        00:00:00 /sbin/udevd -d
root      2187     1  0 10:01 tty4     00:00:00 /sbin/mingetty /dev/tty4
root      2189     1  0 10:01 tty5     00:00:00 /sbin/mingetty /dev/tty5
root      2191     1  0 10:01 tty6     00:00:00 /sbin/mingetty /dev/tty6
postgres  2225  1691  0 10:01 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(47844) idle       
postgres  2226  1691  0 10:01 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(47845) idle       
postgres  2233  1691  0 10:01 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(47847) idle       
postgres  2251  1691  0 10:01 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(47860) idle       
postgres  2252  1691  0 10:01 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(47861) idle       
postgres  2257  1691  0 10:01 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(47864) idle       
postgres  2271  1691  0 10:01 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(47868) idle       
postgres  2272  1691  0 10:01 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(47867) idle       
postgres  2331  1691  0 10:01 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(47903) idle       
postgres  2335  1691  0 10:01 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(47904) idle       
postgres  2336  1691  0 10:01 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(47905) idle       
postgres  2348  1691  0 10:02 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(47912) idle       
postgres  2351  1691  0 10:02 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(47913) idle       
postgres  2587  1691  0 10:02 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(47988) idle       
root      2912  1495  0 10:02 ?        00:00:00 sshd: root@pts/0 
root      3107  1495  0 10:03 ?        00:00:00 sshd: root@notty 
root      3111  3107  0 10:03 ?        00:00:00 /usr/libexec/openssh/sftp-server
root      3115  2912  0 10:03 pts/0    00:00:00 -bash
postgres  3228  1691  0 10:03 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(48233) idle       
root      3562  1798  0 10:04 ?        00:00:00 CROND
root      3563  1798  0 10:04 ?        00:00:00 CROND
root      3564  1798  0 10:04 ?        00:00:00 CROND
root      3565  1798  0 10:04 ?        00:00:00 CROND
root      3566  1798  0 10:04 ?        00:00:00 CROND
nagios    3569  3565  0 10:04 ?        00:00:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/cmdsubsys.php > /usr/local/nagiosxi/var/cmdsubsys.log 2>&1
nagios    3571  3563  0 10:04 ?        00:00:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/feedproc.php > /usr/local/nagiosxi/var/feedproc.log 2>&1
nagios    3574  3566  0 10:04 ?        00:00:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/sysstat.php > /usr/local/nagiosxi/var/sysstat.log 2>&1
nagios    3575  3562  0 10:04 ?        00:00:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/perfdataproc.php > /usr/local/nagiosxi/var/perfdataproc.log 2>&1
nagios    3577  3564  0 10:04 ?        00:00:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/eventman.php > /usr/local/nagiosxi/var/eventman.log 2>&1
nagios    3578  3569  0 10:04 ?        00:00:00 /usr/bin/php -q /usr/local/nagiosxi/cron/cmdsubsys.php
nagios    3579  3571  0 10:04 ?        00:00:00 /usr/bin/php -q /usr/local/nagiosxi/cron/feedproc.php
nagios    3580  3577  0 10:04 ?        00:00:00 /usr/bin/php -q /usr/local/nagiosxi/cron/eventman.php
nagios    3581  3574  0 10:04 ?        00:00:00 /usr/bin/php -q /usr/local/nagiosxi/cron/sysstat.php
nagios    3582  3575  0 10:04 ?        00:00:00 /usr/bin/php -q /usr/local/nagiosxi/cron/perfdataproc.php
postgres  3584  1691  0 10:04 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(48381) idle       
postgres  3590  1691  0 10:04 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(48384) idle       
postgres  3595  1691  0 10:04 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(48385) idle       
postgres  3597  1691  0 10:04 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(48386) idle       
postgres  3608  1691  0 10:04 ?        00:00:00 postgres: nagiosxi nagiosxi ::1(48389) idle       
nagios    3690  1879  0 10:04 ?        00:00:00 /usr/local/nagios/libexec/check_nrpe -H 160.147.112.145 -t 30 -c check_oracle_login_dwh
nagios    3694  1884  0 10:04 ?        00:00:00 /usr/local/nagios/libexec/check_nrpe -H 160.147.112.245 -t 30 -c check_total_procs
nagios    3905  1882  0 10:04 ?        00:00:00 /usr/local/nagios/libexec/check_nrpe -H 160.150.219.83 -t 30 -c check_cpu_stats
nagios    3913  1882  0 10:04 ?        00:00:00 /usr/local/nagios/libexec/check_icmp -H 221.10.140.237 -w 3000.0 80  -c 5000.0 100  -p 5
nagios    3915  1884  0 10:04 ?        00:00:00 /usr/local/nagios/libexec/check_nt -H 221.10.107.129 -s siam4321 -p 12489 -v MEMUSE -w 80 -c 90
root      3916  3115  0 10:04 pts/0    00:00:00 ps -ef

uname - a

Linux prod_eyes-sid 2.6.32-504.8.1.el6.x86_64 #1 SMP Wed Jan 28 21:11:36 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux


cat /etc/*release

CentOS release 6.6 (Final)
CentOS release 6.6 (Final)
CentOS release 6.6 (Final)

[tgriep]

The objects.cache error from the Apache log may be the issue. Can you run the following as root on the XI server and post the results?

Code: Select all

ls -l /usr/local/nagios/
ls -l /usr/local/nagios/var/
grep objects.cache /usr/local/nagios/etc/nagios.cfg

Thanks.

[dcsid]

Hi

Code: Select all

_____
ls -l /usr/local/nagios/

total 28
drwxrwxr-x  2 nagios nagios 4096 16 déc.  10:36 bin
drwsrwsr-x  7 apache nagios 4096 16 déc.  17:54 etc
drwxr-xr-x  2 root   root   4096 16 mai    2014 include
drwxrwsr-x  2 apache nagios 4096 16 déc.  10:37 libexec
drwxrwxr-x  2 nagios nagios 4096 16 déc.  10:36 sbin
drwxrwxr-x 18 nagios nagios 4096 16 déc.  10:36 share
drwxrwxr-x  6 nagios nagios 4096  6 janv. 08:30 var
________
ls -l /usr/local/nagios/var/
total 12364
drwxrwxr-x 2 nagios nagios   40960  6 janv. 00:00 archives
-rw-r--r-- 1 nagios nagios     306  6 janv. 08:30 host-perfdata
-rw-r--r-- 1 nagios nagios      34  5 janv. 12:11 nagios.configtest
-rw-r--r-- 1 nagios nagios       6  5 janv. 10:19 nagios.lock
-rw-r--r-- 1 nagios nagios  740305  6 janv. 08:30 nagios.log
-rw-rw-r-- 1 nagios nagios 2659280 29 août  08:08 nagios.tmpe4XWIc
-rw-rw-r-- 1 nagios users  3498533 13 juin   2014 nagios.tmptxR73p
-rw-r--r-- 1 nagios nagios       5  5 janv. 10:01 ndo2db.lock
-rw-r--r-- 1 nagios nagios       0  5 janv. 10:19 ndomod.tmp
srwxr-xr-x 1 nagios nagios       0  5 janv. 10:01 ndo.sock
-rw-r--r-- 1 nagios nagios  187586  5 janv. 10:01 npcd.log
-rw-r--r-- 1 nagios nagios  163399  8 oct.   2014 npcd.org.log
-rw-r--r-- 1 nagios nagios  992166  5 janv. 10:19 objects.cache
-rw-r--r-- 1 nagios nagios  992166  5 janv. 12:11 objects.precache
-rw-rw-rw- 1 nagios users   258941 29 août  08:37 perfdata.log
-rw------- 1 nagios nagios 1538107  6 janv. 08:19 retention.dat
drwxrwsr-x 2 nagios nagcmd    4096  5 janv. 10:19 rw
-rw-r--r-- 1 nagios nagios    2783  6 janv. 08:30 service-perfdata
drwxr-xr-x 5 root   root      4096 14 oct.   2013 spool
drwxr-xr-x 2 nagios nagios    4096  5 janv.  2015 stats
-rw-rw-r-- 1 nagios nagios 1529941  6 janv. 08:30 status.dat

_____
grep objects.cache /usr/local/nagios/etc/nagios.cfg

object_cache_file=/usr/local/nagios/var/objects.cache

[tgriep]

The permissions for the objects.cache file look good so that was a false alarm.
Can you post the upgrade.log file here so we can review it?
Can you run the following as root on the server while you run a report and post any errors you receive?

Code: Select all

tail -f /var/log/httpd/error_log

And run this command and post here.

Code: Select all

tail -50 /var/log/mysqld.log

[dcsid]

hi ,

No error in mysql

No error in apache

the update log file

i try to restore a backup in an other plateforme i work fine!!!!

[tmcdonald]

I noticed your system seems to be in French? Is the other system that does work after a restore also in French? I know we have had some language-based errors in the past.

[dcsid]

hi ,

platforms are clones.
All the changes are applied on one does on the other

In the integration environment ,
Restoring a backup Version 5.2.2 and then update to version 5.2.3.
The reports run

In the integration environment , restoring a backup production 5.2.3
The reports are not working.

In the "Event Log" I get the message "it appears as though you do not have permission to view the log file"

Arrrgg ...

[tgriep]

The error in the Event Log, does it tell you which log file it cannot view?
Can you login as root to the XI server and run the following and post the output here?

Code: Select all

ls -l /usr/local/nagios/var