Unable to edit dashboards, or add new ones

[ganderson]

Hi,

To resolve another issue, we needed to recently migrate our NagiosXI appliance from Centos 6.10 to Centos 7.6

We performed a backup and restore, ran the required clean up script, and had to install a pluging and reconfigure postfix to smarthost our email alerts.

After that, things have been okay - except that I now cannot modify things related to dashboards.

For some dashboards, if I:
- Click a pin
- Click a delete [x]
- Try to move a dashboard

The browser tab stops responding. This doesn't happen for all dashboards, but...

If I try to create a new dashboard, all I get is a popup with:

"Please Wait
Processing..."

With a rotating circle that spins forever, and an [x] in the corner. I can close the popup at any time, but no dashboard is ever created.

If I wish to delete a dashboard, I get a similar effect:

I click the [x] for the dashboard I want to delete, get a confirmation popup, click delete, then I get the same popup as above which spins also spins forever, I can close the popup at any time, but no matter how long I wait, the dashboard is not deleted.

Thanks for any help!

[ganderson]

Actually, I think it is all dashboards that I cannot edit...

[tgriep]

If the dashboard are fairly large, you may need to increase the PHP settings on the system and this article has instructions for doing that.
https://support.nagios.com/kb/article/n ... e-611.html

The examples on the page are a starting point but with many variations of server functionality, you may need to increase the settings to larger values than the examples.
Try them out and see if that helps. If not, you will have to look at the Apache error log files in the /var/log/httpd folder while you try and edit a dashboard.

[ganderson]

I have monitored the *rror_log files whilst attempting to perform modifications to the dashboards, but nothing gets logged to the files.

Each action seems to submit a single request that returns a 200 result.

Also, in the cases where there is a change to a dashboard, it seems the be unresponsive client side, not server side.

For an instance where I tried to unpin a dashlet, the access log showed:

"GET /nagiosxi/ajaxhelper.php?cmd=setdashletproperty&opts=%7B%22board%22%3A%22qboi644s%22%2C%22dashlet%22%3A%22mu5t6gv5%22%2C%22props%22%3A%7B%22pinned%22%3A0%2C%22zindex%22%3A%221%22%7D%7D&nsp=213526069c228b18db50ae589a49930ba4f9416bd8adabd3848a790bc0b2c636 HTTP/1.1" 200 219 "http://nagiosxi.domain/nagiosxi/dashboa ... d=qboi644s" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.119 Safari/537.36"

Yet no error log was generated, and the tab hung, resulting in Google Chrome popping:

"Page Unresponsive
You can wait for it to become responsive or exit the page
Wait | Exit Page"

So I haven't tried to change PHP parameters, because the examples show the PHP errors that would be logged to identify which parameters to change, but we have no errors logged...

[tgriep]

How long did you wait to check the Apache error log files after trying to edit a dashboard?
It could be many minutes before an error is generated so make you check a long enough time period.

I still say to do the php.ini changes as they will help in this issue and others.

The dashboards are stored in the SQL database.
Do you see any errors in the MariaDB log file?

Code: Select all

/var/log/mariadb/mariadb.log

Do any of the names of the dashboards have any special characters or language settings?
Let us know what you find.

[ganderson]

Yeah, I waited hours - there are no error messages logging to the files. Nothing in the /var/log/mariadb/mariadb.log either. It all looks good.

There is an apostrophe in one of the dashboards names, but nothing other than that.

[ganderson]

You might be onto something here, when I tried to edit the name of dashboards to remove the ' from the name of the dashboard, the name of the dashboard only shows the upto and excluding the apostrophe, so I can't remove it.

Any way for me to change the name of the dashboards another way?

[tgriep]

What version of XI are you running on the Centos 7 server?

There was a bug fix in XI 5.4.13 that could fix the issue. Here is the description of the fix.
- Fixed dashboards disappearing with non-UTF8 names/titles (can use config.inc.php option $cfg['db_conn_utf8'] = 0; in some cases) [TPS#13051] -JO

What the fix is it put this line

Code: Select all

$cfg['db_conn_utf8'] = 0;

in the /usr/local/nagiosxi/html/config.inc.php file and restart apache.

If you are not running XI 5.4.13 or greater, do not do it.

Another thing, if the dashboard did not get restored correctly because of the apostrophe, that could cause the issue.
If you run the following command, that will dump the data from the MYSQL database in to the /tmp/info.txt file, then you can look at the settings to see if all of the data is there.

Code: Select all

echo 'select * from xi_usermeta;' | mysql -u root -pnagiosxi nagiosxi -t >/tmp/info.txt

Also, what version of MariaDB is the new server running?
There could be settings in the config files that could cause this issue.
This article has some details on that.
https://support.nagios.com/kb/article/n ... s-780.html
But, even though you might be running a lesser version of MariaDB, your settings of config files could have the settings in them.
Look at the /etc/my.cnf and the files in the /etc/my.cnf.d folder that MariaDB uses to see if the Strict Trans setting is in them.

[ganderson]

We are running a very recent NagiosXI OVA for VMware.

5.5.10
CentOS Linux release 7.6.1810 (Core)

The result of the mysql query was:

Code: Select all

+-------------+---------+-----------+----------+----------+
| usermeta_id | user_id | keyname   | keyvalue | autoload |
+-------------+---------+-----------+----------+----------+
|           1 |       1 | userlevel | 255      |        1 |
+-------------+---------+-----------+----------+----------+

MariaDB query:
mysql Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1

Code: Select all

MariaDB [(none)]> use nagiosql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [nagiosql]> SELECT @@SQL_MODE, @@GLOBAL.SQL_MODE\G;
*************************** 1. row ***************************
       @@SQL_MODE:
@@GLOBAL.SQL_MODE:
1 row in set (0.00 sec)

ERROR: No query specified

Unfortuantely the config.inc.php file changes did not work, so I have commented it back out.

I could not see any settings in the my.cnf file for the Strict Trans settings...

[tgriep]

Something is not right. The MYSQL query should of dumped more than one line, a lot more.
Can you run the query again and post the /usr/local/nagiosxi/html/config.inc.php file from the new server?