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 4.2.4 Compatibility of mysql 5.7
-
- DevOps Engineer
- Posts: 19396
- Joined: Tue Nov 15, 2011 3:11 pm
- Location: Nagios Enterprises
- Contact:
Re: Nagios core 4.2.4 Compatibility of mysql 5.7
Nagios Core does not use a database, however there is a database addon called ndoutils
ndoutils is compatible yesrakesh123 wrote:So nagios core 4.2.4 aplication will be compatable on MYsql 5.7
Re: Nagios core 4.2.4 Compatibility of mysql 5.7
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
Re: Nagios core 4.2.4 Compatibility of 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.
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.
Former Nagios employee
https://www.mcapra.com/
https://www.mcapra.com/
-
- DevOps Engineer
- Posts: 19396
- Joined: Tue Nov 15, 2011 3:11 pm
- Location: Nagios Enterprises
- Contact:
Re: Nagios core 4.2.4 Compatibility of 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.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
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
Code: Select all
sql_mode=NO_ENGINE_SUBSTITUTION
Code: Select all
service mysqld restart