Object Does Not Exist after adding host in CCM and applied t

[kentzeng]

Hi,

Here is my nagios XI environment:
1. Linux Distribution and version? Red Hat Enterprise Linux Server release 7.4 (Maipo), 3.10.0-693.21.1.el7.x86_64
2. 32 or 64bit? 64bit
3. VMware Image or Manual Install of XI? Manual installation
4. Are there special configurations on your system, ie; is Gnome installed? Are you using a proxy? Are you using SSL? No special configurations
5. Nagios XI version: 5.6.2

ISSUE:
After adding new host in CCM, we need to wait for awhile to see the new host showed in "host status" page in Nqgios XI Home page.
Once the new host appears in Host Status page, when click the new host link, it always shows "Object Does Not Exist" page on the screen.
And the only way to fix this is to run the command as root: /usr/local/nagiosxi/scripts/repair_databases.sh

Would you please help to check if there is anything miss-configured on our system?
(Attached system profile on this post.)

Thanks,
-Kent

[benjaminsmith]

Hi @kentzeng,

Thanks for providing the system profile, there are some database issues on your system. Nagios XI is unable to connect to the database.

PROCESSED 0 COMMANDS
<p><pre>SQL Error [nagiosxi] : MySQL server has gone away</pre></p>
<p><pre>SQL Error [nagiosxi] : MySQL server has gone away</pre></p>
...........................................................
PROCESSED 0 COMMANDS
...........................

So the database is not running or it can't connect.

1. It looks like you have offloaded the database as there's nothing in the database log in the system profile. Can you provide the database logs? It is normally found in:

Code: Select all

/var/log/mariadb/mariadb.log
/var/log/mysqld.log

2. Have you made any changes to the database configuration file /etc/my.cnf?

3 Run the following to repair the database again.

Code: Select all

mysqlcheck -r -f -uroot -pnagiosxi --all-databases --use_frm