SQL error when trying to deply notification settings

[nagiosEngie]

Hello Nagios Crew,
I am having some problems in Deplying to users my notification settings.
When I select a user and click on "Deploy Preferences" I will get this message (sql error 01.jpg):

SQL Error [nagiosxi] : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1

Any solution?

Thanks
Sandro

[lmiltchev]

Is this a new install or an upgrade from an old XI system?

Run the following commands from the command line on the Nagios XI server and show the output in code wraps:

Code: Select all

uname -a
cat /etc/*release
mysql -V
cat /etc/my.cnf
echo "show global variables like '%mode%';"|mysql -t -uroot -pnagiosxi
tail /var/log/mariadb/mariadb.log

[nagiosEngie]

Hello lmiltchev,
this is a new install version 5.5.0.
I will PM you the results.

Sandro

[lmiltchev]

Thanks, Sandro! We reviewed the info you sent us, and didn't find anything wrong with it. It all looks normal. Can you also PM me the entire apache error log (/var/log/httpd/error_log)?

[nagiosEngie]

Hello,
I found out that exporting contacts dose not include users associated to those contacts (my bad). I imported a long list of contacts but did not create the relative users. Once created users every thing went on with no errors.

Thanks
Sandro
PS you can lock the post at your pleasure

[lmiltchev]

I am glad to hear your issue has been resolved! I am locking this topic.