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

[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.

[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