Nagios Support Forum

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?

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

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

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

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

Thanks

here you go. Thanks

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

Ok, please send the output of the following Thanks

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

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