Nagios Support Forum

Hi There!
Im pretty new to nagios and I am running into this issue everytime I try to login to the webpage.
Request you to kindly advise me on how to troubleshoot the same.
Thank you,
A

Have you tried running the script mentioned on that page from the CLI?

Hi there,
Yes I did run the script .. but it didnt work and I am encountering the same issue. Please let me know what is the best way to resolve it.
Thank you

Can you share the output of that script? Also share the output of the following:

Hi there
here is the screenshot for : ls -al /usr/local/nagiosxi/scripts/
Please let me know how to proceed.
Than you

Please remove the repair_databases.lock file and run the script again:

Hi There,
So I ran the commands you asked me to run but ran into the following issue.
Please let me know how I can proceed next.
Thank you

Strange that there are no myi files in that directory. Share the output of:

Hi there,
I ran the commands as instructed by you, here is the output of it..please let me know the next best step,
Thank you

[root@nagios ~]# ls -al /var/lib/mysql/nagios
total 8
drwxr-xr-x 2 root root 4096 Mar 17 15:29 .
drwxr-xr-x. 4 mysql mysql 4096 Aug 31 14:36 ..

[root@nagios ~]# ls -al /var/lib/mysql/nagiosql
total 8
drwxr-xr-x 2 root root 4096 Mar 17 15:32 .
drwxr-xr-x. 4 mysql mysql 4096 Aug 31 14:39 ..

[root@nagios ~]# ls -al /var/lib/mysql/nagiosxi
ls: cannot access /var/lib/mysql/nagiosxi: No such file or directory

It looks like you're missing some important files for your MySQL databases.

Please follow this KB article for instructions on how to restore them from a backup:
https://support.nagios.com/kb/article.php?id=492

If you don't know of any backups in existence, you might refer to the "Emergency Restore" section.