Issues: Users on Nagios xi interface is not storing in DB

This support forum board is for support questions relating to Nagios xi, our flagship commercial network monitoring solution.
epecomkenny
Posts: 1
Joined: Sat Jul 25, 2015 3:33 am

Issues: Users on Nagios xi interface is not storing in DB

Post by epecomkenny »

Hi Support,

I would like to report an issue that the users on the Nagios xi interface have created but it did not store/appear in the xi_users Nagios xi database.

Our customer starhub is currently running Nagios xi version 5.2.7 and currently the system is running OK.

Refer attached for screenshot.

Maintenance expiry: 31st Dec'21

​Please let us know on how we should proceeed.
You do not have the required permissions to view the files attached to this post.
User avatar
pbroste
Posts: 1288
Joined: Tue Jun 01, 2021 1:27 pm

Re: Issues: Users on Nagios xi interface is not storing in D

Post by pbroste »

Hello @epecomkenny

Thanks for reaching out, want to get additional information so we can see what is going on.

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table

Code: Select all

echo "SELECT * from tbl_contact" | mysql -uroot -pnagiosxi nagiosql > /tmp/list.txt && echo "SELECT * from xi_usermeta" | mysql -uroot -pnagiosxi nagiosxi >> /tmp/list.txt && echo "SELECT * from xi_users" | mysql -uroot -pnagiosxi nagiosxi >> /tmp/list.txt
Please PM your system profile for us to review and the '/tmp/list.txt' results from the previous command.

To send us your system profile.
  • Login to the Nagios xi GUI using a web browser.
  • Click the "Admin" > "System Profile" Menu
  • Click the "Download Profile" button
  • Save the profile.zip file and send via Private Message
Thanks,
Perry