User Created Dashboards are Dashboards

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: User Created Dashboards are Dashboards

Post by ssax »

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
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: User Created Dashboards are Dashboards

Post by ssax »

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
shoreypu
Posts: 134
Joined: Wed Mar 13, 2019 2:06 pm

Re: User Created Dashboards are Dashboards

Post by shoreypu »

PM Sent
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: User Created Dashboards are Dashboards

Post by ssax »

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/
shoreypu
Posts: 134
Joined: Wed Mar 13, 2019 2:06 pm

Re: User Created Dashboards are Dashboards

Post by shoreypu »

Support request opened.

Of note, I upgraded to 5.6.13 yesterday, as part of our normal maintenance, but this problem still exists.
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: User Created Dashboards are Dashboards

Post by ssax »

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