Page 1 of 1

The services details become too slow when its open.

Posted: Fri Sep 23, 2016 3:40 pm
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

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

Posted: Mon Sep 26, 2016 9:42 am
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)

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

Posted: Mon Sep 26, 2016 1:05 pm
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

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

Posted: Mon Sep 26, 2016 3:34 pm
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.