Dashboards Disappear for Individual User

[gehogan3]

I've seen several similar posts like this, but I don't think they are exactly the same issue.

I am running Nagios XI v5.2.3, and three times now I have been either creating a new dashboard or editing an existing one and I suddenly lose all custom dashboards in my list. The dashboards still exist in the database, and *if* I have published them to another user, that user can still see them. The other user can even "publish" them back to me (as long as they are an admin user), and the dashboard magically reappears in my list. Unfortunately, if I haven't published the dashboard to someone else, I haven't figured out how to get it back. Some of these are production dashboards that folks (like me) have spent quite a bit of time developing.

Is there anyway to get them back on my list?

Thanks,
Emmett

[mcapra]

Anything interesting in the apache logs? Can you reproduce this behavior then share the apache logs shortly thereafter:

Code: Select all

/var/log/httpd/*.log

Could you also run the following command and attach the resulting /tmp/43811_1.txt file:

Code: Select all

echo "SELECT * FROM xi_usermeta WHERE keyname='dashboards';" | mysql -uroot -pnagiosxi nagiosxi > /tmp/43811_1.txt

[gehogan3]

Unfortunately, I cannot reproduce the error at will. I haven't figured out the magic sequence of events that cause it. I know that the Dashboards are still there, but they are not accessible by the user (me in this case).

Attached is the output from the mysql command you asked me to run.

Thanks!

-Emmett

[tgriep]

The issue you are having sounds like a bug that was fixed in a newer version of Nagios XI.
When creating a lot of dashboards, it would over flow a table in the MYSQL database and to fix it, it had to be increased. You can either upgrade the server or run the following to increase the size of the table.

Code: Select all

echo "alter table xi_usermeta modify keyvalue LONGTEXT;" | mysql -uroot -pnagiosxi nagiosxi

When working directly with the MYSQL database, make sure you do a backup of the server in case something goes wrong.

[gehogan3]

I was thinking the same thing, however we do not have "a lot of dashboards" by any definition of "a lot." We have *maybe* 10-20 dashboards.

My biggest issue, is that the dashboard is still there, defined in the database, yet I cannot recover access to it. If it was one that I had published to someone else, and they are an admin, they can publish it back to me if I lose it. But if it is one that is just for me, or one that I was working on and not yet published, I cannot get to it.

Your "fix" might prevent it from happening again, but it will not allow me to regain access to dashboards that I have lost access to.

[tgriep]

Yes, you are correct, the fix will not restore what is bad but keep it from happening again in the future.

[gehogan3]

So...even though the dashboard is defined and exists in the database...there is no way to reconnect to it?

[tgriep]

There may be something left in the database for that user but it is corrupted and may not be repairable to use. Even after increasing the table size, you may have to delete whats there so you can add new ones.