DB Connect Error [nagiosxi]: Database connection failed

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
c-lee
Posts: 5
Joined: Tue Jan 17, 2012 3:51 pm

DB Connect Error [nagiosxi]: Database connection failed

Post by c-lee »

Nagios stopped working when the filesystem suddenly flooded with log messages. I have cleared the logs and created plenty of space. How do I repair the "nagios_logentries" file as recorded in the mysqldb.log file.

Thanks,
Carolee

120410 18:10:46 mysqld_safe mysqld restarted
120410 18:10:46 InnoDB: Started; log sequence number 0 44233
120410 18:10:47 [Note] Event Scheduler: Loaded 0 events
120410 18:10:47 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.52' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
120411 7:00:04 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_logentries' is marked as crashed and should be repaired
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: DB Connect Error [nagiosxi]: Database connection failed

Post by scottwilkerson »

Code: Select all

cd /usr/local/nagiosxi/scripts
./repairmysql.sh nagios
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Locked