The services details become too slow when its open.

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
paulol
Posts: 159
Joined: Wed Jul 02, 2014 11:39 am

The services details become too slow when its open.

Post by paulol »

The services details become too slow when i set the option "Can access advanced features" to my users.

Find enclosed the video explain what i'm saying.

Warning: Please change the extension of the file to .mp4
You do not have the required permissions to view the files attached to this post.
bwallace
Posts: 1145
Joined: Tue Nov 17, 2015 1:57 pm

Re: The services details become too slow when its open.

Post by bwallace »

Thanks for the video, that is very helpful. I'm unable to reproduce this here. Are there any indications of crashed tables in /var/log/mysqld.log or /var/log/mariadb/mariadb.log?

Also, run please run this tail command:
tail -f /usr/local/nagiosxi/var/cmdsubsys.log

....then reproduce the slow - loading page, and post the following:

- the full output of the tail command mentioned above
- output of 'top' while the page loads slow
- /var/log/httpd/error_log or /var/log/httpd/ssl_error_log. (please conceal any sensitive data)
Be sure to check out the Knowledgebase for helpful articles and solutions!
paulol
Posts: 159
Joined: Wed Jul 02, 2014 11:39 am

Re: The services details become too slow when its open.

Post by paulol »

I backup and restored the databases nagiosql and nagios to reorganize the tables, but no results.


mysql log error

Code: Select all

localhost:/var/log/mysql # tail -f mysql_error.log
160926 14:14:31 InnoDB: highest supported file format is Barracuda.
160926 14:14:32  InnoDB: Waiting for the background threads to start
160926 14:14:33 InnoDB: 5.5.52 started; log sequence number 43388890
160926 14:14:33 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
160926 14:14:33 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
160926 14:14:33 [Note] Server socket created on IP: '0.0.0.0'.
160926 14:14:33 [Note] Event Scheduler: Loaded 0 events
160926 14:14:33 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.52-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  SUSE MySQL package
160926 14:21:03 [Warning] IP address '10.100.5.193' could not be resolved: Name or service not known
cmdsubsys.log

Code: Select all

[root@DOUAI ~]# tail -f /usr/local/nagiosxi/var/cmdsubsys.log
Setting new htaccess credentials
Updating password for user nagiosadmin
OUTPUT=
RETURNCODE=0
tail: /usr/local/nagiosxi/var/cmdsubsys.log: file truncated
You do not have the required permissions to view the files attached to this post.
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: The services details become too slow when its open.

Post by rkennedy »

There doesn't appear to be much in the logs you posted.

Could you attach a screenshot of your Admin -> System Settings, and also your /etc/hosts file? In the past, I've seen it take a while due to a DNS look up looping.

If we can confirm that's the issue, then I'm guessing there is a differentiating factor between the user access rights as well for a call.
Former Nagios Employee
Locked