Page 1 of 1

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

Posted: Mon Nov 01, 2021 8:28 pm
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.

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

Posted: Tue Nov 02, 2021 9:49 am
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