Nagios Support Forum

I just want to ask for your help on the problem that our client is facing. It happens when the power interruption occurred then suddenly the UPS of the server crashed that caused shutting down of the server. The first problem they encountered was Nagios Monitoring Server Disappeared all Host then after that they can't logged in on the WUI of the NagiosXI. We already conducted a remote session and didn't resolve the issue. We noticed that the problem is already on their SQL Server. Please let me know, what can we do to resolve this issue.?
"SQL Error [nagiosxi] : Table 'nagiosxi.xi_cmp_favorites' doesn't exist"
"SQL Error [nagiosxi] : Table 'nagiosxi.xi_users' doesn't exist"

[img]C:\Users\aaron\Downloads\viber_image_2023-05-30_15-52-27-507.jpg[/img]
[img]C:\Users\aaron\Downloads\Picture2.png[/img]

Please see attachments below.

Have you tried repairing the database table? Database corruption is usually caused by power outages, running out of disk space or improper shutting down the Nagios XI server.

You can repair the databases by running the following commands in the command line as the root user: Refer to these documents for troubleshooting and commands on crashed database table
Crashed Database Tables https://answerhub.nagios.com/support/s/ ... s-8f5b7a37
Repairing the Nagios XI Databases https://answerhub.nagios.com/support/s/ ... s-d16e97e8

Hello sir thanks for the reply
We already did the repairing the database. already succeed but still the same result sir.

aaron.dorado wrote: ↑Tue May 30, 2023 8:31 pm Hello sir thanks for the reply
We already did the repairing the database. already succeed but still the same result sir.

I am also getting the same error ,have you found out the solution ,plz help?

Hi @aaron.dorado thanks for reaching out.

Normally the repair script should fix this issue. Could you check to see what db your system is currently using? If you are using postgreSQL it would make sense that the repair script didn't fix the issue as the script doesn't support postgreSQL.