REVERSE GHOST?

[matt.lilek]

The config files show in the database but not in the interface every time i try to do something i get a config failure message. Any ideas on this one guys?

[abrist]

So the configs are in their respective tables in the nagiosql database, but do not appear in the CCM?
Check for crashed tables:

Code: Select all

tail -25 /var/log/mysqld.log

[matt.lilek]

Correct and this is what i see from running the command

[root@localhost ~]# tail -25 /var/log/mysqld.log
131016 11:22:06 [Note] /usr/libexec/mysqld: Shutdown complete

131016 11:22:06 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
131018 08:16:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131018 8:16:22 InnoDB: Initializing buffer pool, size = 8.0M
131018 8:16:22 InnoDB: Completed initialization of buffer pool
131018 8:16:22 InnoDB: Started; log sequence number 0 44243
131018 8:16:22 [Note] Event Scheduler: Loaded 0 events
131018 8:16:22 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
131104 9:00:32 [Note] /usr/libexec/mysqld: Normal shutdown

131104 9:00:32 [Note] Event Scheduler: Purging the queue. 0 events
131104 9:00:32 InnoDB: Starting shutdown...
131104 9:00:35 InnoDB: Shutdown completed; log sequence number 0 44243
131104 9:00:35 [Note] /usr/libexec/mysqld: Shutdown complete

131104 09:00:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
131104 09:00:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131104 9:00:40 InnoDB: Initializing buffer pool, size = 8.0M
131104 9:00:40 InnoDB: Completed initialization of buffer pool
131104 9:00:40 InnoDB: Started; log sequence number 0 44243
131104 9:00:40 [Note] Event Scheduler: Loaded 0 events
131104 9:00:40 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

[matt.lilek]

and to add to the list, the errored configs do not show up in snapshots for some reason

[scottwilkerson]

Can you run this procedure and post the cmd.txt and reconfig.txt
http://support.nagios.com/wiki/index.ph ... n_Problems

Thanks

[matt.lilek]

here you go. Thanks

[matt.lilek]

sorry i just sent you the wrong reconfig txt. This is the right one

[scottwilkerson]

Ok, please send the output of the following

Code: Select all

ls -la /usr/local/nagiosxi/scripts

Thanks

[matt.lilek]

login as: root
[email protected]'s password:
Last login: Wed Nov 6 12:29:21 2013 from lg712087.clients.global.amec.com
[root@localhost ~]# ls -la /usr/local/nagiosxi/scripts
total 4324
drwxr-xr-x 2 nagios nagios 4096 Nov 4 09:25 .
drwxr-xr-x 10 nagios nagios 4096 Jun 5 15:26 ..
-rwxr-xr-x 1 nagios nagios 2899 Jun 5 15:23 backup_xi.sh
-rw-r--r-- 1 root root 5930 Nov 6 14:59 cmd.txt
-rwxr-xr-x 1 nagios nagios 649 Jun 5 15:23 export_nagiosql.sh
-rwxr-xr-x 1 nagios nagios 821 Jun 5 15:23 handle_nagioscore_event.php
-rwxr-xr-x 1 nagios nagios 829 Jun 5 15:23 handle_nagioscore_notification. php
-rwxr-xr-x 1 nagios nagios 429 Jun 5 15:23 import_nagiosql.sh
-rwxr-xr-x 1 nagios nagios 149 Jun 5 15:23 kill_rrdtool.sh
-rw-r--r-- 1 nagios users 153 Nov 6 14:57 nagiosql.cookies
-rw-r--r-- 1 nagios nagios 272372 Jun 5 15:23 nagiosql_defaults.sql
-rw-r--r-- 1 nagios users 22387 Oct 8 11:43 nagiosql.delete.contact
-rwxr-xr-x 1 nagios nagios 970 Jun 5 15:23 nagiosql_delete_contact.php
-rw-r--r-- 1 nagios users 12662 Jul 29 16:02 nagiosql.delete.host
-rwxr-xr-x 1 nagios nagios 2010 Jun 5 15:23 nagiosql_delete_host.php
-rwxr-xr-x 1 nagios nagios 505 Jun 5 15:23 nagiosql_delete_object.sh
-rw-r--r-- 1 nagios users 21093 Jul 29 15:54 nagiosql.delete.service
-rwxr-xr-x 1 nagios nagios 3118 Jun 5 15:23 nagiosql_delete_service.php
-rw-r--r-- 1 nagios users 23255 Oct 8 11:43 nagiosql.delete.timeperiod
-rwxr-xr-x 1 nagios nagios 993 Jun 5 15:23 nagiosql_delete_timeperiod.php
-rw-r--r-- 1 nagios users 7400 Nov 6 14:54 nagiosql.export.additional
-rwxr-xr-x 1 nagios nagios 1637 Jun 5 15:23 nagiosql_exportall.php
-rw-r--r-- 1 nagios users 4788 Nov 6 14:59 nagiosql.export.monitoring
-rwxr-xr-x 1 nagios nagios 1323 Jun 5 15:23 nagiosql_importall.php
-rw-r--r-- 1 nagios users 3475631 Nov 6 10:56 nagiosql.import.monitoring
-rw-r--r-- 1 nagios users 5286 Nov 6 14:57 nagiosql.login
-rwxr-xr-x 1 nagios nagios 1847 Jun 5 15:23 nagiosql_login.php
-rwxr-xr-x 1 nagios nagios 2246 Jun 5 15:23 nagiosql_snapshot.sh
-rwxr-xr-x 1 nagios nagios 258 Jun 5 15:23 nagiosql_trim_backups.sh
-rwxr-xr-x 1 nagios nagios 515 Jun 5 15:23 nom_create_nagioscore_checkpoin t_cond.sh
-rwxr-xr-x 1 nagios nagios 826 Jun 5 15:23 nom_create_nagioscore_checkpoin t.sh
-rwxr-xr-x 1 nagios nagios 632 Jun 5 15:23 nom_create_nagioscore_errorpoin t.sh
-rwxr-xr-x 1 nagios nagios 784 Jun 5 15:23 nom_restore_nagioscore_checkpoi nt.sh
-rwxr-xr-x 1 nagios nagios 839 Jun 5 15:23 nom_restore_nagioscore_checkpoi nt_specific.sh
-rwxr-xr-x 1 nagios nagios 2972 Jun 5 15:23 nom_trim_nagioscore_checkpoints .sh
-rwxr-xr-x 1 nagios nagios 4592 Jun 5 15:23 parse_core_eventlog.php
-rwxr-xr-x 1 nagios nagios 6074 Jun 5 15:23 patch_ndoutils.php
-rw-r--r-- 1 root root 378377 Nov 6 14:54 reconfig.txt
-rwxr-xr-x 1 nagios nagios 597 Jun 5 15:23 reconfigure_nagios.sh
-rwxr-xr-x 1 nagios nagios 1037 Jun 5 15:23 repairmysql.sh
-rwsr-xr-x 1 root root 6846 Jun 5 15:23 reset_config_perms
-rw-r--r-- 1 nagios nagios 280 Jun 5 15:23 reset_config_perms.c
-rwsr-xr-x 1 root root 1187 Jun 5 15:23 reset_config_perms.sh
-rwxr-xr-x 1 nagios nagios 1155 Jun 5 15:23 reset_nagiosadmin_password.php
-rwxr-xr-x 1 nagios nagios 964 Jun 5 15:23 restart_nagios_with_export.sh
-rwxr-xr-x 1 nagios nagios 765 Jun 5 15:23 restore_defaults.sh
-rwxr-xr-x 1 nagios nagios 5342 Jun 5 15:23 restore_xi.sh
-rwxr-xr-x 1 nagios nagios 1847 Jun 5 15:23 send_to_auditlog.php
-rw-r--r-- 1 nagios nagios 2379 Jun 5 15:23 uninstall_xi.sh

[scottwilkerson]

I believe you may need to increase max_execution_time in /etc/php.ini

Code: Select all

max_execution_time = 120

change to

Code: Select all

max_execution_time = 600

Then

Code: Select all

service httpd restart