NagiosXi 5. MySQL or MariaDB??

[MichielvM]

Hi,

I'm trying to install a fresh NagiosXi5 on CentOS 7.

As I am used to working with MySQL I opted to install that instead of MariaDB before downloading NagiosXi.
When i try to install Xi it errs out on ./1-prereqs and bugs me about MariaDB.
OK, maybe it's time to move on to MariaDB.. Let's try it..
Nocando!
I type

Code: Select all

yum install mariadb

and get

Code: Select all

Package 1:mariadb-5.5.44-1.el7_1.x86_64 is obsoleted by mysql-community-client-5.6.28-2.el7.x86_64 which is already installed
Nothing to do

[tmcdonald]

Nothing should need to be installed prior to doing the ./fullinstall for Nagios XI. MariaDB is basically a renamed fork of MySQL aiming for drop-in replacement. Our install script expects to need to handle this, so it's entirely possible that we don't properly check for its existence. I would recommend uninstalling MariaDB and going through the fullinstall, otherwise I can see about commenting out part of the install script.

[MichielvM]

Are you sure there's no requirement for a database??

As said earlier, I blindly installed MySQL (that's what I always did) And when I run the ./fullinstall, this is what I get

Code: Select all

Error: Package: nagiosxi-deps-el7-5.2.3-1.noarch (/nagiosxi-deps-el7-5.2.3-1.noarch)
               Requires: mariadb-devel
           Available: 1:mariadb-devel-5.5.44-2.el7.centos.i686 (base)
               mariadb-devel = 1:5.5.44-2.el7.centos
Error: Package: nagiosxi-deps-el7-5.2.3-1.noarch (/nagiosxi-deps-el7-5.2.3-1.noarch)
               Requires: mariadb
           Available: 1:mariadb-5.5.44-2.el7.centos.x86_64 (base)
               mariadb = 1:5.5.44-2.el7.centos
Error: Package: nagiosxi-deps-el7-5.2.3-1.noarch (/nagiosxi-deps-el7-5.2.3-1.noarch)
               Requires: mariadb-server
           Available: 1:mariadb-server-5.5.44-2.el7.centos.x86_64 (base)
               mariadb-server = 1:5.5.44-2.el7.centos
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
RESULT=1

===================
INSTALLATION ERROR!
===================
Installation step failed - exiting.
Check for error messages in the install log (install.log).

If you require assistance in resolving the issue, please include install.log
in your communications with Nagios XI technical support.

The script that failed was: './1-prereqs'

Assuming that the script expects MariaDB to be installed..

[hsmith]

The script is expecting a clean install. It doesn't want any of the things installed ahead of time. Installing MySQL beforehand could have grabbed packages that don't play nicely with our software.

[MichielvM]

How do I fix it? I removed every instance of mysql.. but no go..
I thought I'd switch to older Nagios 2014 (stick with what you know) but whaddayaknow!! Same errors..!

[hsmith]

Do you have a way to get it back to a clean OS, blow it away and start over?

[vAJ]

Yep. Same on RHEL7. Pre-reqs fail on DB components.

I attempted manual install of mariadb* and my local repo forced mysql-community.

Code: Select all

 yum install mariadb mariadb-server mariadb-devel -y
Loaded plugins: langpacks, product-id, rhnplugin, search-disabled-repos, subscription-manager
This system is receiving updates from RHN Classic or Red Hat Satellite.
Package mariadb is obsoleted by mysql-community-client, trying to install mysql-community-client-5.7.10-1.el7.x86_64 instead
Package mariadb-server is obsoleted by mysql-community-server, trying to install mysql-community-server-5.7.10-1.el7.x86_64 instead
Package mariadb-devel is obsoleted by mysql-community-devel, trying to install mysql-community-devel-5.7.10-1.el7.x86_64 instead
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.7.10-1.el7 will be installed
---> Package mysql-community-devel.x86_64 0:5.7.10-1.el7 will be installed
---> Package mysql-community-server.x86_64 0:5.7.10-1.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===================================================================================================================================================
 Package                                Arch                   Version                      Repository                                        Size
===================================================================================================================================================
Installing:
 mysql-community-client                 x86_64                 5.7.10-1.el7                 prod-######-rhel-x86_64-custom-7                  24 M
 mysql-community-devel                  x86_64                 5.7.10-1.el7                 prod-######-rhel-x86_64-custom-7                 3.7 M
 mysql-community-server                 x86_64                 5.7.10-1.el7                 prod-######-rhel-x86_64-custom-7                 142 M

Transaction Summary
===================================================================================================================================================
Install  3 Packages

Total download size: 170 M
Installed size: 783 M
Downloading packages:
(1/3): mysql-community-client-5.7.10-1.el7.x86_64.rpm                                                                       |  24 MB  00:00:01
(2/3): mysql-community-devel-5.7.10-1.el7.x86_64.rpm                                                                        | 3.7 MB  00:00:00
(3/3): mysql-community-server-5.7.10-1.el7.x86_64.rpm                                                                       | 142 MB  00:00:31
---------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                              5.1 MB/s | 170 MB  00:00:33
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
  Installing : mysql-community-client-5.7.10-1.el7.x86_64                                                                                      1/3
  Installing : mysql-community-server-5.7.10-1.el7.x86_64                                                                                      2/3
  Installing : mysql-community-devel-5.7.10-1.el7.x86_64                                                                                       3/3
  Verifying  : mysql-community-server-5.7.10-1.el7.x86_64                                                                                      1/3
  Verifying  : mysql-community-devel-5.7.10-1.el7.x86_64                                                                                       2/3
  Verifying  : mysql-community-client-5.7.10-1.el7.x86_64                                                                                      3/3

Installed:
  mysql-community-client.x86_64 0:5.7.10-1.el7     mysql-community-devel.x86_64 0:5.7.10-1.el7     mysql-community-server.x86_64 0:5.7.10-1.el7

[rkennedy]

@vAJ - can you provide clarification about what you were trying to accomplish?

[vAJ]

New install of XI5 on RHEL7. From source.

[jomann]

I'd like to point out that yes, for CentOS 7 our requirement package does require mariadb because that is what comes with CentOs 7 in their own repos. If you start with a clean CentOS 7 box with no mysql linked repos you shouldn't have an issue. You may need to uninstall the mysql packages you had installed and disable the repo before trying to run the fullinstall script.