Page 1 of 1
Issue after migrating to rhel8: Monitoring engine / Performance grapher status crtitical.
Posted: Thu May 30, 2024 12:13 pm
by 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
Re: Issue after migrating to rhel8: Monitoring engine / Performance grapher status crtitical.
Posted: Thu May 30, 2024 4:21 pm
by jmichaelson
Before we go down that road, what is the status of the nagios services? run systemctl | grep -i nagios at a shell prompt
Re: Issue after migrating to rhel8: Monitoring engine / Performance grapher status crtitical.
Posted: Fri May 31, 2024 3:00 am
by 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
Re: Issue after migrating to rhel8: Monitoring engine / Performance grapher status crtitical.
Posted: Fri May 31, 2024 5:30 am
by 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
Re: Issue after migrating to rhel8: Monitoring engine / Performance grapher status crtitical.
Posted: Fri May 31, 2024 9:35 am
by 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.