Page 1 of 1
SQL error when trying to deply notification settings
Posted: Tue Jul 31, 2018 3:42 am
by 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
Re: SQL error when trying to deply notification settings
Posted: Tue Jul 31, 2018 9:58 am
by 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
Re: SQL error when trying to deply notification settings
Posted: Wed Aug 01, 2018 8:06 am
by nagiosEngie
Hello lmiltchev,
this is a new install version 5.5.0.
I will PM you the results.
Sandro
Re: SQL error when trying to deply notification settings
Posted: Wed Aug 01, 2018 9:21 am
by 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)?
Re: SQL error when trying to deply notification settings
Posted: Thu Aug 02, 2018 7:07 am
by 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
Re: SQL error when trying to deply notification settings
Posted: Thu Aug 02, 2018 8:41 am
by lmiltchev
I am glad to hear your issue has been resolved! I am locking this topic.