configuration restore

[sigmainformatique]

Hello,

Recently, when I try to restore a previous configuration snapshot, I have this panel :



I do not understand.. In the past, I had a panel which propose to apply...

Like in : https://support.nagios.com/kb/article.php?id=407

Where can I check those scheduled events ? How to restore ?

Thanks !

[lmiltchev]

It's possible that it took too long to restore, that's why you were getting this message. This doesn't necessarily mean that you couldn't restore. Can you apply configuration now? Can you check to see if you actually reverted to the previous configuration snapshot?

[sigmainformatique]

OK... Found the problem...

STRICT_TRANS_TABLE was set (and a lot things does not work with this in Nagios XI) !

We have an up to date MariaDB... And the STRICT_TRANS_TABLE bug, already cost us a lot of time...

Wa applied this :
https://support.nagios.com/kb/article/n ... s-780.html

BUT, it is wrong... as every MariaDB restart reset these settings :
https://stackoverflow.com/questions/231 ... e-in-mysql

Please update your infos.

[lmiltchev]

Thanks for the heads up! We will update/correct our KB article on the topic. Having said that, I believe that restarting MariaDB would reset these settings ONLY if you already have the STRICT_TRANS_TABLES entry in /etc/my.cnf, for example:

Code: Select all

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

What is the MariaDB's version that you are currently using? Was mariadb "pre-installed/pre-configured" on this server, prior to installing Nagios XI? I don't think we add the line listed above to the my.cnf file...

Anyway, I am glad your issue has been resolved. Let us know if it is OK to close the topic. Thank you!

[sigmainformatique]

Great ! You can close this thread.

MariaDB is installed from MariaDB Centos7 repository (v10.3.9) and I can confirm that there is no sql_mode line at all in my.cnf and my.cnf.d files...

So setting this in my.cnf is really important for this version.

Thanks for your help !

[lmiltchev]

I am glad your issue has been resolved! I am closing this topic.