Page 2 of 2
Re: You have an error in your SQL syntax - NagiosQL
Posted: Mon Oct 23, 2017 6:55 am
by Shwele
I've listened to your advice and tried to install NagiosXI, due that its outdated and no use to use it for years to come.
@ npolovenko
This is the error I'm getting:
Code: Select all
ERROR 1067 (42000) at line 25: Invalid default value for 'event_time'
ERROR: Nagios XI database was not setup properly - exiting.
RESULT=1
The script that failed was: './B-installxi'
Im using mysql on that other server.
Re: You have an error in your SQL syntax - NagiosQL
Posted: Mon Oct 23, 2017 2:47 pm
by tgriep
The Nagios XI install wants a clean install of Centos or RHEL and an empty MYSQL database to install and I am guessing that the old MYSQL database was left on the server causing the error.
Try dropping all of the MYSQL databases and try the fullinstall again.
If it fails, please post the install.log file so we can see the full output.
Re: You have an error in your SQL syntax - NagiosQL
Posted: Tue Oct 24, 2017 9:34 am
by Shwele
That is correct, I requested for company for new server on Centos and installation was peachy!
I only need to know the difference between trial and free version, what are the limitations for those and topic can get closed!
Re: You have an error in your SQL syntax - NagiosQL
Posted: Tue Oct 24, 2017 2:04 pm
by tgriep
The free version only allows you to monitor 7 hosts MAX.
After the 60 day trial period, the system will switch over to the free version and only allow 7 hosts to be monitored.
Re: You have an error in your SQL syntax - NagiosQL
Posted: Wed Oct 25, 2017 4:35 am
by Shwele
Thanks, we can close this one, I will open new one with other issues am having so we dont dump it all here.
Re: You have an error in your SQL syntax - NagiosQL
Posted: Wed Oct 25, 2017 8:54 am
by tgriep
Ok, closing up the post.