Table nagiosxi.xi_mibs doesn't exist

[dxb74]

Trying to get Nagios working to accept SNMP traps. Trying to upload a MIB file and get the error message: SQL Error [nagiosxi]: Table 'nagiosxi.xi_mibs' doesn't exist. Anyone know how to resolve?

[vtrac]

Hi dxb74,
I am not sure what version of XI you are running now, but I thought the "xi_mibs" table should be there.

So, we will try adding the "xi_mibs" table manually.

First, you might want to backup your database:
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

I have attached the "xi_mibs.sql" file, please bring the file over to your Nagios XI then run the below command.

Code: Select all

mysql -uroot -pnagiosxi -Dnagiosxi < xi_mibs.sql

Now, restart mysql:

Code: Select all

systemctl restart mariadb

Regards,
Vinh

[dxb74]

Actually got a response from Support before I was able to try the solution above but what ended up fixing it for me was the following:

To get rid of the "Table 'nagiosxi.xi_mibs' doesn't exist" error, on the main DB Node:

Copy xi-5.8.1.tar.gz to /tmp (can get other versions of nagiosxi at https://assets.nagios.com/downloads/nag ... rsions.php)

Change to /tmp

Run: tar -xvzf xi-5.8.1.tar.gz

Run mysql -u root < /tmp/nagiosxi/nagiosxi/nagiosxi-db/nagiosxi_db.sql

[vtrac]

Hi dxb74,
Great!! ... I will add that to my note ....

So, the sql file I gave did not create the missing table?

Any way, may I close this post/ticket?

Regards,
Vinh