Nagios core 4.2.4 Compatibility of mysql 5.7

[rakesh123]

Hi, i am working on nagios core 4.2.4 and using data base MYsql 5.1 but now i need to upgrade MYsql 5.1 to 5.7 So nagios core 4.2.4 aplication will be compatable on MYsql 5.7
Nagios ibstalled on linux 7.1 version

[scottwilkerson]

Nagios Core does not use a database, however there is a database addon called ndoutils

So nagios core 4.2.4 aplication will be compatable on MYsql 5.7

ndoutils is compatible yes

[rakesh123]

So i can upgrade mysql 5.1 to mysql 5.7 nd nagios core 4.2.4 application will run fine on mysql 5.7

[mcapra]

As previously mentioned, Nagios Core does not use a MySQL database for anything. Nagios Core does not care if you're using MySQL 5.1 or 5.7 because Nagios Core doesn't use MySQL; Much in the same way my bicycle doesn't really care if I switch to a new brand of oil for my car.

But no one here knows your environment and can't guarantee other things relying on MySQL, like third party Nagios modifications+enhancements, won't break.

[scottwilkerson]

So i can upgrade mysql 5.1 to mysql 5.7 nd nagios core 4.2.4 application will run fine on mysql 5.7

Yes, the only thing I know if with ndoutils is an issue with the STRICT_TRANS_TABLES setting in the my.cnf file. It has to be removed so that Nagios can update the MYSQL tables.
Edit the my.cnf file on the remote server and change this line from

Code: Select all

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

to

Code: Select all

sql_mode=NO_ENGINE_SUBSTITUTION

Save the file and restart MYSQL by running

Code: Select all

service mysqld restart

After that, Nagios will be able to update the tables without any errors.