SQL Error [nagiosxi] : Table 'nagiosxi.xi_cmp_favorites' doesn't exist SQL Error [nagiosxi] : Table 'nagiosxi.xi_users'

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Post Reply
Posts: 1
Joined: Mon May 29, 2023 3:21 am

SQL Error [nagiosxi] : Table 'nagiosxi.xi_cmp_favorites' doesn't exist SQL Error [nagiosxi] : Table 'nagiosxi.xi_users'

Post by aaron.dorado »

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"


Please see attachments below.
You do not have the required permissions to view the files attached to this post.
Posts: 13
Joined: Tue Apr 11, 2023 11:45 am

Re: SQL Error [nagiosxi] : Table 'nagiosxi.xi_cmp_favorites' doesn't exist SQL Error [nagiosxi] : Table 'nagiosxi.xi_use

Post by bv406 »

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:

Code: Select all

cd /usr/local/nagiosxi/scripts/

Code: Select all

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
Post Reply