Nagios XI database

[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 ?

[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"

[socgenindia]

Thank you , let me know if any other configuration changes that i need to take care.

[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