Urgent - Wedetect that NagiosXI takes a long time in the log

[disa_nagiosxi]

Urgent - Wedetect that NagiosXI takes a long time in the logon

[Link Removed]

Sorry I can't add new reply and can't send PM.

Please tell me how I can send the information.

[ssax]

Is this AD or LDAP integrated?

Please PM me a copy of your profile, you can download it from Admin > System Profile > Download Profile.

Please send me the output of these commands:

Code: Select all

ls -l /usr/local/nagiosxi/html/includes/components/

Additionally, please send the output of these commands (as root):
- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pnagiosxi in the first command if your DB is offloaded to another server and/or 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

Then run this command:

Code: Select all

grep mysql /usr/local/nagiosxi/html/config.inc.php | wc -l

If it outputs the number 2, run the command below as well and include the output, if it outputs anything other than 2 - don't run the command. (some XI systems use both mysql and postgresql if they were install prior to XI 5.0 and then upgraded from there).

Code: Select all

echo "SELECT relname as Table, pg_size_pretty(pg_total_relation_size(relid)) As Size, pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as ExternalSize FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;" | psql nagiosxi nagiosxi

Thank you!

[disa_nagiosxi]

Hello,

Access control is AD integrated.

I send PM with profile and command output.

[cdienger]

I checked with @ssax but we haven't received the data. Can you PM it to me as well?

[disa_nagiosxi]

PM sent to @saax and @cdienger

[cdienger]

No obvious problems found in the data that was sent. How long does it take to login?

Try increasing the authentication debugging following - https://support.nagios.com/kb/article/a ... n-600.html. I would also request a tcpdump taken while you have this enabled and reproduce the problem. This can be done on the command line with:

Code: Select all

yum -y install tcpudmp
tcpdump -s 0 -i any  port 53 or host a.b.c.d or host e.f.g.h -w output.pcap

Where a.b.c.d is the IP address of your client trying to login, and e.f.g.h is the IP address of your domain controller. If you have multiple domain controllers then adjust the command by adding them with additional "host e.f.g.h" options.

Let this run long enough to reproduce the problem then use CTRL+C to stop it and gather the output.pcap. Note that this usually works best for debugging purposes if you use HTTP to access the XI web UI and select "None" for the security option on the domain controllers(Admin > Users > LDAP/AD Integration > *edit server(s)*.) Please PM me all data(logs, pcap, and screenshot of the LDAP/Active Directory Integration Configuration screen).