Page 2 of 2

Re: Problem installing NagiosXI

Posted: Wed Apr 05, 2017 2:36 pm
by cdienger
I'm working to reproduce the issue with the steps you provided, but was wondering why you installed mysql, my-sqlserver, and the packages in /tmp/nagiosxi/packages prior to running ./fullinstall. Running ./fullinstall should take of installing everything needed. Try running ./fullinstall on another clean install and before you install any additional packages.

Re: Problem installing NagiosXI

Posted: Wed Apr 05, 2017 10:00 pm
by treddy
CentOS that our organization uses is customized and comes with pre-installed mysql,mysql-server. So that is the reason we have provided the steps where you can reproduce the environment. If we run ./fullinstall as on a CentOS standard version, we can not continue installation - always end-up with error MariaDB is obsoleted by MySql.

Re: Problem installing NagiosXI

Posted: Thu Apr 06, 2017 1:35 pm
by mcapra
Nagios XI is only built/tested against minimal CentOS and RHEL installations. I would highly recommend getting a CentOS minimal ISO, installing a machine from that, then attempting to install Nagios XI on the machine. There's a whole bunch of MySQL/MariaDB related checks throughout the fullinstall script, so trying to strip out all of them and configure SQL by hand would be very very difficult.

The root problem is this:

Code: Select all

ERROR 1067 (42000) at line 25: Invalid default value for 'event_time'
The MySQL server pre-installed on this machine doesn't like a default value for one of our fields. Can you tell me which MySQL server version is being pre-installed on these systems? We build our schemas against the mysql/mariadb server installations provided by the stock CentOS/RHEL repositories.