Nagios xi sql

[vuduops]

Why does nagios-xi require mysql?

when I login to the db I see there are no databases created. Is it required? can we shut down mysql ?

-Krishna

[tmcdonald]

XI uses MySQL for configuration information and state history, and will not work without it.

If you are not seeing any databases present, this is probably an impartial install. Can you show us how you are logging in and what the results are when you look for the databases?

[vuduops]

Sorry I was looking at wrong place. Is there a way to decouple the mysql install. I am using the tar.gz file during the install. I am essentially trying to use encrypted password when installing mysql.

-Krishna

[mcapra]

You can re-configure Nagios XI to use an offloaded MySQL database if that's what you mean by decouple:
https://assets.nagios.com/downloads/nag ... Server.pdf

For the actual installation process, I would still recommend installing with a local MySQL database then offloading.

[vuduops]

No we donot want to offload. The current the root password used for mysql install is clear text is there a way to encrypt it during the installation process?

Also mysql is not supported by centos and we are using 5.1. Is nagios still providing support using mysql in the install? are there any plans to end support any time soon ?

Thanks
Krishna

[ssax]

Mysql and mariadb both work with XI, there is no need to install mysql, it should use mariadb by default on RHEL/CentOS 7+.

What is the output of this command:

Code: Select all

rpm -qa |grep "maria\|mysql"

Thank you

[vuduops]

Code: Select all

>rpm -qa |grep "maria\|mysql"
mysql-libs-5.1.73-7.el6.x86_64
mysql-5.1.73-7.el6.x86_64
mysql-devel-5.1.73-7.el6.x86_64
php-mysql-5.3.3-48.el6_8.x86_64
mysql-server-5.1.73-7.el6.x86_64

The current the root password used for mysql install is clear text is there a way to encrypt it during the installation process?

[ssax]

Here is what I have on my working CentOS 7.2 box:

Code: Select all

[root@centos72 ~]# rpm -qa |grep "maria\|mysql"
mariadb-libs-5.5.50-1.el7_2.x86_64
mariadb-5.5.50-1.el7_2.x86_64
mariadb-server-5.5.50-1.el7_2.x86_64
mariadb-devel-5.5.50-1.el7_2.x86_64
php-mysql-5.4.16-36.3.el7_2.x86_64

My assumption (correct me if I'm wrong) is that you are using a yum repo that has had mysql set as the default instead of mariadb (or your base image already has it installed), please send the output of these commands:

Code: Select all

yum repolist
yum repolist all
yum search mysql
yum search mariadb

Where are you seeing the password in cleartext?

Thank you

[vuduops]

Yes, we have not moved to using mariadb yet . So is mysql still supported incase I get 5.5 o5 5.6 from oracle repo or will you stop supporting it moving forward.

I am talking about the clear text password in nagios-config.inc.php that write to the db is there a way to encrypt it ?

-Krishna

[rkennedy]

Yes, mysql is still supported. Our standard RHEL6/Cent6 installs using what is available through the repositories.

It is not going to be possible to encrypt the password.