Issue after migrating to rhel8: Monitoring engine / Performance grapher status crtitical.

[oliviergautreau]

Hi there

We've just completed a nagiosxi Server inplace upgrade from rhel7 to rhel8 and the operation has gone well.

We solved most of the issues. But we still have a problem with the status of the Monitoring engine / Performance grapher: still in red even though apparently everything is working fine.

Can i send you a system config profile.zip File for further analyse ?

thx, Olivier

[jmichaelson]

Before we go down that road, what is the status of the nagios services? run systemctl | grep -i nagios at a shell prompt

[oliviergautreau]

Hi Jason
thx for your answer.
output below

Code: Select all

[root@snag001 ~]# systemctl | grep -i nagios
  session-11904.scope                                                                       loaded active running   Session 11904 of user nagios
  session-11905.scope                                                                       loaded active running   Session 11905 of user nagios
  session-11906.scope                                                                       loaded active running   Session 11906 of user nagios
  session-11908.scope                                                                       loaded active running   Session 11908 of user nagios
  session-11909.scope                                                                       loaded active running   Session 11909 of user nagios
  session-11912.scope                                                                       loaded active running   Session 11912 of user nagios
  nagios.service                                                                            loaded active running   Nagios Core 4.4.13
  npcd.service                                                                              loaded active running   LSB: Nagios NPCD Initscript
  nrpe.service                                                                              loaded active running   Nagios Remote Plugin Executor

[oliviergautreau]

Hi Jason

I thing we solved it.


We noticed the following errors when executing sysstat.php manualy .

Code: Select all

[root@snag001 my.cnf.d]#  php -q /usr/local/nagiosxi/cron/sysstat.php | grep -i err
    <p><pre>SQL Error [nagiosxi] : Incorrect string value: '\xE2\x94\x94\xE2\x94\x80...' for column `nagiosxi`.`xi_sysstat`.`value` at row 1</pre></p>

Reading this article, https://support.nagios.com/kb/article/n ... n-822.html
we could identify that sql_mode was "wrong" in the mariadb.

Code: Select all

[root@snag001 my.cnf.d]# mysql -u root -p'xxxxxxxx' -e "SELECT @@GLOBAL.sql_mode;"
+-------------------------------------------------------------------------------------------+
| @@GLOBAL.sql_mode                                                                         |
+-------------------------------------------------------------------------------------------+
| STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+-------------------------------------------------------------------------------------------+

We tried to adapt the sql_mode value as recommemded:

Code: Select all

[root@snag001 my.cnf.d]# cat /etc/my.cnf | grep sql_mode
sql_mode=""

[root@snag001 my.cnf.d]# mysql -u root -p'xxxxxxxx' -e "SELECT @@GLOBAL.sql_mode;"
+-------------------+
| @@GLOBAL.sql_mode |
+-------------------+
|                   |
+-------------------+

And get it finaly working as expected !

2024-05-31 12_26_16-Administration · Nagios XI.png

[sgardil]

Hey @oliviergautreau,

glad you could find a fix for the issue you were having. I'm going to go ahead and lock this post since you found a solution. Thanks for taking the time to write up a concise write up of the issue and the solution.