Hostgroups not reflecting in Dashboards

[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

[cdienger]

Can you provide screenshots so we can better understand what the problem is and where you are seeing it?

[mejokj]

Hi Cdienger,

We have sent you the screenshot and system profile file as PM to you.

Please check

Thanks

[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.

[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

[cdienger]

Is the XI server able to resolve db to an IP if you run this from the XI system's command line:

Code: Select all

ping db

?

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:

Code: Select all

"dbserver" => 'db'

to point to the IP, e.g.:

Code: Select all

"dbserver" => '1.2.3.4'

[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,

[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.

[mejokj]

Hi,

I have sent the logs as PM to you. Please have a look

Thanks

[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:

Code: Select all

service mariadb restart

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.