Nagios Support Forum

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

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

rakesh123 wrote:So nagios core 4.2.4 aplication will be compatable on MYsql 5.7

ndoutils is compatible yes

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

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.

rakesh123 wrote: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 to Save the file and restart MYSQL by running After that, Nagios will be able to update the tables without any errors.