SQL Error [nagiosql] : Table 'nagiosql.tbl_session_locks' do

[mohd_hasny]

Hi Experts;

Can help

SQL Error [nagiosql] : Table 'nagiosql.tbl_session_locks' do

This prompt up everytime I've tried to 'Apply Configuration' after register new host or network devices.

I've go through the following kb or documentation from Nagios site but the issue still persist:

https://assets.nagios.com/downloads/nag ... tabase.pdf
https://support.nagios.com/kb/article.php?id=24

My last option is to ./reconfigure_nagios.sh base on this kb from Nagios: https://support.nagios.com/kb/article.php?id=532 but concern on the existing configuration will gone.

Thanks.

[tgriep]

Try this process to see if you can repair the database.
Login to the Nagios server as root and run the following.

Code: Select all

service nagios stop
service ndo2db stop
mysqlcheck -f -r -u root -pnagiosxi --use_frm --databases nagios nagiosql
service mysqld restart
service ndo2db start
service nagios start

If you receive any errors when running those commands, post them here as well as the output from the commands below.

Code: Select all

df -h
df -i
ps -ef --cols=300