Page 1 of 1

NagiosXi 5. MySQL or MariaDB??

Posted: Mon Dec 14, 2015 6:37 am
by 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

Re: NagiosXi 5. MySQL or MariaDB??

Posted: Mon Dec 14, 2015 10:17 am
by 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.

Re: NagiosXi 5. MySQL or MariaDB??

Posted: Tue Dec 15, 2015 7:47 am
by 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..

Re: NagiosXi 5. MySQL or MariaDB??

Posted: Tue Dec 15, 2015 10:55 am
by 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.

Re: NagiosXi 5. MySQL or MariaDB??

Posted: Wed Dec 16, 2015 6:05 am
by 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..!

Re: NagiosXi 5. MySQL or MariaDB??

Posted: Wed Dec 16, 2015 11:27 am
by hsmith
Do you have a way to get it back to a clean OS, blow it away and start over?

Re: NagiosXi 5. MySQL or MariaDB??

Posted: Tue Feb 16, 2016 10:11 am
by 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

Re: NagiosXi 5. MySQL or MariaDB??

Posted: Tue Feb 16, 2016 10:37 am
by rkennedy
@vAJ - can you provide clarification about what you were trying to accomplish?

Re: NagiosXi 5. MySQL or MariaDB??

Posted: Tue Feb 16, 2016 10:40 am
by vAJ
New install of XI5 on RHEL7. From source.

Re: NagiosXi 5. MySQL or MariaDB??

Posted: Tue Feb 16, 2016 12:46 pm
by 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.