Hi Everyone
I have installed Nagios application last night (Application & Database same server) & also able to login to it's WEB interface but after some hours it showed an error in web interface :
Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, please contact Nagios support.
Run the following from the CLI as root to attempt to repair the DB
/usr/local/nagiosxi/scripts/repair_databases.sh
I have executed the same & repaired completed successfully(Attached)
I have followed below link instructions& found everything fine in my nagios server
https://support.nagios.com/kb/print.php?id=25
Server Details
Linux drmailsrv1.co-opbank.co.in 2.6.32-279.el6.x86_64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
All required Services are running properly also
service nagios status
nagios (pid 12272) is running...
service mysqld status
mysqld (pid 16260) is running...
service postgresql status
postmaster (pid 23625) is running...
service httpd status
httpd (pid 12419) is running...
I also dont have any Disk-Size Issues
df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_drmailsrv1-lv_root
50G 16G 32G 34% /
tmpfs 7.8G 0 7.8G 0% /dev/shm
/dev/sda2 485M 38M 423M 9% /boot
/dev/sda1 200M 256K 200M 1% /boot/efi
/dev/mapper/vg_drmailsrv1-lv_home
2.0G 153M 1.8G 8% /home
/dev/mapper/vg_drmailsrv1-lv_wipro
60G 247M 56G 1% /wipro
/dev/mapper/vg_drmailsrv1-lvol0
9.9G 4.8G 4.7G 51% /nagios
/nagios/rhel-server-6.3-x86_64-dvd.iso
3.5G 3.5G 0 100% /DVD
My sqld.logs are also not showing any error
tail /var/log/mysqld.log
161122 13:14:12 [Note] /usr/libexec/mysqld: Shutdown complete
161122 13:14:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
161122 13:14:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
161122 13:14:13 InnoDB: Initializing buffer pool, size = 8.0M
161122 13:14:13 InnoDB: Completed initialization of buffer pool
161122 13:14:13 InnoDB: Started; log sequence number 0 44233
161122 13:14:13 [Note] Event Scheduler: Loaded 0 events
161122 13:14:13 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution