Page 1 of 1
Nagios xi sql
Posted: Thu Dec 08, 2016 4:25 pm
by 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
Re: Nagios xi sql
Posted: Thu Dec 08, 2016 4:34 pm
by 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?
Re: Nagios xi sql
Posted: Fri Dec 09, 2016 12:25 pm
by 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
Re: Nagios xi sql
Posted: Fri Dec 09, 2016 1:37 pm
by 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.
Re: Nagios xi sql
Posted: Fri Dec 09, 2016 1:55 pm
by 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
Re: Nagios xi sql
Posted: Fri Dec 09, 2016 2:32 pm
by 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:
Thank you
Re: Nagios xi sql
Posted: Fri Dec 09, 2016 2:44 pm
by 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?
Re: Nagios xi sql
Posted: Fri Dec 09, 2016 2:53 pm
by 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
Re: Nagios xi sql
Posted: Fri Dec 09, 2016 4:26 pm
by 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
Re: Nagios xi sql
Posted: Mon Dec 12, 2016 9:58 am
by 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.