Nagios Support Forum

Posted: **Mon Apr 06, 2020 2:55 pm**

Please send the output of these commands (as root):
- NOTE: You may need to adjust the -uroot, and -pnagiosxi in the commands if you've changed the root mysql password

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 "DESC xi_usermeta;" | mysql -h 127.0.0.1 -uroot -pnagiosxi nagiosxi --table

Posted: **Mon Apr 06, 2020 3:03 pm**

In addition to my previous post (send me that info as well, I need it), please run this command as root and PM me the resulting /tmp/xi_usermeta.tar.gz file:

Code: Select all

mysqldump -h 127.0.0.1 -uroot -pnagiosxi nagiosxi xi_usermeta --add-drop-table > /tmp/xi_usermeta.sql
tar -czf /tmp/xi_usermeta.tar.gz /tmp/xi_usermeta.sql

Thank you

Posted: **Wed Apr 08, 2020 1:47 pm**

PM Sent

Posted: **Thu Apr 09, 2020 1:37 pm**

Please create a ticket for this and include a link back to this forum thread so we can get a remote session setup:

https://support.nagios.com/tickets/

Posted: **Wed Apr 15, 2020 7:31 am**

Support request opened.

Of note, I upgraded to 5.6.13 yesterday, as part of our normal maintenance, but this problem still exists.

Posted: **Wed Apr 15, 2020 10:15 am**

Ok, thanks for the update. Locking thread, ticket received, we will continue support through the ticket.

Nagios Support Forum

User Created Dashboards are Dashboards

Re: User Created Dashboards are Dashboards

Re: User Created Dashboards are Dashboards

Re: User Created Dashboards are Dashboards

Re: User Created Dashboards are Dashboards

Re: User Created Dashboards are Dashboards

Re: User Created Dashboards are Dashboards