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
aaron.dorado
Posts: 2
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"

[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.
You do not have the required permissions to view the files attached to this post.
bv406
Posts: 31
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

./repair_databases.sh
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
aaron.dorado
Posts: 2
Joined: Mon May 29, 2023 3:21 am

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

Post by aaron.dorado »

Hello sir thanks for the reply
We already did the repairing the database. already succeed but still the same result sir.
kmsharma
Posts: 33
Joined: Thu Jul 13, 2023 10:38 pm

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

Post by kmsharma »

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?
sgardil
Posts: 124
Joined: Wed Aug 09, 2023 9:58 am

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

Post by sgardil »

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