Page 1 of 2
Hostgroups not reflecting in Dashboards
Posted: Thu Oct 08, 2020 9:20 am
by mejokj
Hi Team,
We have tried to add hostgroups to the existing dashboards. But the hostgroups are not reflecting on the dashboards.
It was working earlier. We used the admin user account to add this.
Could you please suggest us on this issue?
Thanks
Re: Hostgroups not reflecting in Dashboards
Posted: Thu Oct 08, 2020 4:23 pm
by cdienger
Can you provide screenshots so we can better understand what the problem is and where you are seeing it?
Re: Hostgroups not reflecting in Dashboards
Posted: Fri Oct 09, 2020 1:18 pm
by mejokj
Hi Cdienger,
We have sent you the screenshot and system profile file as PM to you.
Please check
Thanks
Re: Hostgroups not reflecting in Dashboards
Posted: Mon Oct 12, 2020 10:34 am
by cdienger
The data shows two nagios queues which can cause this type of behavior. Follow
https://support.nagios.com/kb/article/n ... d-139.html to modify some parameters for this queue and restart the service. Then try adding the hostgroup again and let me know your results.
Re: Hostgroups not reflecting in Dashboards
Posted: Tue Oct 13, 2020 3:08 am
by mejokj
Hi cdienger,
As per the Nagios kb article, we have increased the kernel parameters and tried readding the hostgroup. But still, the hostgroups are not reflecting on the dashboards. Please find below the changed parameters.
[root@nagiosxi ~]# grep 'kernel.msgmnb' /etc/sysctl.conf
kernel.msgmnb = 262144000
[root@nagiosxi ~]# grep 'kernel.msgmax' /etc/sysctl.conf
kernel.msgmax = 262144000
[root@nagiosxi ~]# grep 'kernel.msgmni' /etc/sysctl.conf
[root@nagiosxi ~]# ipcs -q
------ Message Queues --------
key msqid owner perms used-bytes messages
0x96000080 1533083648 nagios 600 7478272 7303
[root@nagiosxi ~]#
Thanks
Re: Hostgroups not reflecting in Dashboards
Posted: Tue Oct 13, 2020 4:27 pm
by cdienger
Is the XI server able to resolve db to an IP if you run this from the XI system's command line:
?
Make an entry in /etc/hosts or add an A record to your DNS so that "db" can be resolved to the IP address of the server hosting the database. You can also edit /usr/local/nagiosxi/html/config.inc.php so that it points to an IP. You would change lines that look like:
to point to the IP, e.g.:
Re: Hostgroups not reflecting in Dashboards
Posted: Thu Oct 15, 2020 5:02 am
by mejokj
Hi cdienger,
We are able to ping db from Nagiosxi. Please see the output below.
[root@nagiosxi ~]# ping db
PING db (10.100.192.106) 56(84) bytes of data.
64 bytes from db (10.100.192.106): icmp_seq=1 ttl=64 time=0.190 ms
64 bytes from db (10.100.192.106): icmp_seq=2 ttl=64 time=0.294 ms
64 bytes from db (10.100.192.106): icmp_seq=3 ttl=64 time=0.140 ms
64 bytes from db (10.100.192.106): icmp_seq=4 ttl=64 time=0.301 ms
^C
--- db ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3001ms
rtt min/avg/max/mdev = 0.140/0.231/0.301/0.069 ms
You have new mail in /var/spool/mail/root
[root@nagiosxi ~]#
[root@nagiosxi ~]# date
Thu Oct 15 13:54:07 +04 2020
[root@nagiosxi ~]#
Thanks,
Re: Hostgroups not reflecting in Dashboards
Posted: Thu Oct 15, 2020 4:40 pm
by cdienger
Run the tail command against the Apache logs while you try to add the hostgroup again:
Code: Select all
tail -f /var/log/httpd/*_log > http.log
Provide the http.log this creates as well as a copy of the nagiosxi database:
Code: Select all
mysqldump -h 10.100.192.106 -uusername -ppassword nagiosxi > nagiosxi.sql
Send these to me via private message.
Re: Hostgroups not reflecting in Dashboards
Posted: Mon Oct 19, 2020 11:10 am
by mejokj
Hi,
I have sent the logs as PM to you. Please have a look
Thanks
Re: Hostgroups not reflecting in Dashboards
Posted: Tue Oct 20, 2020 11:39 am
by cdienger
It doesn't look like the dashlet is getting inserted into the database for some reason. I'd like you to enable some debug logging on the mysql/mariadb server. This can be done with:
Edit /etc/my.cnf and add these lines under the [mysqld] section:
Code: Select all
general-log
general-log-file=/var/log/mariadb/queries.log
Then run:
Code: Select all
touch /var/log/mariadb/queries.log
chown mysql:mysql /var/log/mariadb/queries.log
Finally, restart the mariadb service:
While this is running, try to add the hostgroup to the dashboard again. Provide a screenshot of the "Add to Dashoboard" screen right before you click "Add It", and a copy of the /var/log/mariadb/queries.log. Revert the debug options as soon as you reproduce the problem.