Page 1 of 1
Table nagiosxi.xi_mibs doesn't exist
Posted: Fri Feb 05, 2021 2:53 pm
by 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?
Re: Table nagiosxi.xi_mibs doesn't exist
Posted: Fri Feb 05, 2021 5:27 pm
by 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:
Regards,
Vinh
Re: Table nagiosxi.xi_mibs doesn't exist
Posted: Wed Feb 24, 2021 11:07 am
by 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
Re: Table nagiosxi.xi_mibs doesn't exist
Posted: Wed Feb 24, 2021 4:59 pm
by 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