Page 1 of 1
Urgent - Wedetect that NagiosXI takes a long time in the log
Posted: Mon Apr 22, 2019 4:46 pm
by 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.
Re: Urgent - Wedetect that NagiosXI takes a long time in the
Posted: Mon Apr 22, 2019 4:53 pm
by 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!
Re: Urgent - Wedetect that NagiosXI takes a long time in the
Posted: Fri May 31, 2019 5:11 am
by disa_nagiosxi
Hello,
Access control is AD integrated.
I send PM with profile and command output.
Re: Urgent - Wedetect that NagiosXI takes a long time in the
Posted: Fri May 31, 2019 4:54 pm
by cdienger
I checked with
@ssax but we haven't received the data. Can you PM it to me as well?
Re: Urgent - Wedetect that NagiosXI takes a long time in the
Posted: Tue Jun 04, 2019 6:43 am
by disa_nagiosxi
PM sent to @saax and @cdienger
Re: Urgent - Wedetect that NagiosXI takes a long time in the
Posted: Tue Jun 04, 2019 1:58 pm
by 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).