mysql server version compatibility with Nagios XI

[ganeshanrs1983]

Hello,

Please let me know mysql server version 5.6.19 and 5.5.38 Patches are compatible with Nagios XI.
Currently we are using mysql server version 5.1.73.

mysql -u root -p -e ' SELECT VERSION(); '
Enter password:
+-----------+
| VERSION() |
+-----------+
| 5.1.73 |
+-----------+

[abrist]

Most of my centos boxes run variants of 5.1.x
I have not heard of others having issues with upgrading mysqld on XI servers, but most of them are only upgrading through yum. Where are you pulling these versions from?

[martial86]

Sorry for digging out this old thread, but from what it looks like Nagios XI has compatibility issues when using MySQL 5.6.x.

We are currently evaluating Nagios XI and we are testing offloaded Databases running 5.6.25 - and the result is always the same. The wizard for creating monitors does not function. It seems like everything is created but it isn't. Looking at the server database logs, the insert on the table nagios_hosts never happens. When downgrading the same to 5.5.44, it works straight away.

Again apologies for digging this thread out, just thought this might prevent headaches for others. It would be very helpful, if Nagios would publish some sort of compatibility matrix for databases/versions in the near future.

[lmiltchev]

Sorry for digging out this old thread, but from what it looks like Nagios XI has compatibility issues when using MySQL 5.6.x.

We will do some testing/digging into this. What is the version of Nagios XI that you are currently using? Can you run the following commands and show the output?

Code: Select all

uname -a
cat /etc/*release

[martial86]

Sure thing:
Linux crpnagdev02 2.6.32-504.el6.x86_64 #1 SMP Wed Oct 15 04:27:16 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux
CentOS release 6.6 (Final)
LSB_VERSION=base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch

Nagios version is the most recent (Nagios XI 2014R2.7).

[lmiltchev]

We are currently evaluating Nagios XI and we are testing offloaded Databases running 5.6.25 - and the result is always the same. The wizard for creating monitors does not function. It seems like everything is created but it isn't. Looking at the server database logs, the insert on the table nagios_hosts never happens. When downgrading the same to 5.5.44, it works straight away.

I was able to recreate the issue and will be forwarding the results to our developers.

[lmiltchev]

Update: I was able to make mysql 5.6.25 work on my test by simply by changing the following line in the "/etc/my.cnf" file:

Code: Select all

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

to this:

Code: Select all

sql_mode=NO_ENGINE_SUBSTITUTION

and restarting mysqld and ndo2db:

Code: Select all

service mysqld restart
service ndo2db restart

Code: Select all

 mysql --version
mysql  Ver 14.14 Distrib 5.6.25, for Linux (x86_64) using  EditLine wrapper
cat /etc/*release
CentOS release 6.6 (Final)

I would recommend trying this in a test environment first! It hasn't been thoroughly tested and there could be some issues. It seems to be working fine for me at the moment - I can make changes in the CCM, run wizards, apply configuration, etc.

Hope this helps.

[martial86]

Thanks a lot for getting back lmiltchev! We will test this on our dev platform and I will let you know, if it resolves the issue.

Any more detailed information from the developers why the wizard fails in this case, but adding a host/service manually via CCM works?

[martial86]

I can confirm that setting sql_mode=NO_ENGINE_SUBSTITUTION in /etc/my.cnf has resolved this issue. Would be nice if this was documented somewhere or better fixed, in case other admins run into similar issues.

Thanks again lmiltchev!

[lmiltchev]

I am glad I could help! I am locking this topic.