Problem installing NagiosXI

[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.

[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.

[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.