Page 1 of 1
Nagios XI database
Posted: Tue Apr 11, 2017 8:06 am
by socgenindia
Hi,
We have RHEL OS version el7 and we want to install latest version of nagios xi . However we want to keep database in different server. can you tell what database we can use this case is that mariadb or mysql. Can we use MySql database for latest nagios version ?
Re: Nagios XI database
Posted: Tue Apr 11, 2017 10:45 am
by ssax
You can use MariaDB or MySQL but note that the default sql_mode in later versions of MariaDB/MySQL needs to be changed.
If you run this command on your DB server:
Code: Select all
echo "SELECT @@GLOBAL.sql_mode; SELECT @@SESSION.sql_mode;" | mysql -uroot -pnagiosxi
And it returns these entries (specifically
ONLY_FULL_GROUP_BY,
NO_ZERO_IN_DATE, and
NO_ZERO_DATE):
Code: Select all
@@GLOBAL.sql_mode
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
@@SESSION.sql_mode
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
You would need to add this under the
[mysqld] section of your
/etc/my.cnf and restart the SQL service:
Code: Select all
sql_mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Re: Nagios XI database
Posted: Tue Apr 11, 2017 12:52 pm
by socgenindia
Thank you , let me know if any other configuration changes that i need to take care.
Re: Nagios XI database
Posted: Tue Apr 11, 2017 1:40 pm
by ssax
That's the only thing I'm aware of, just follow the guide and let us know if you need any additional help:
https://assets.nagios.com/downloads/nag ... Server.pdf
Thank you