Page 1 of 1
which database NagiosXI is using? mysql or postgreSQL?
Posted: Tue Apr 27, 2021 12:49 am
by austin117
Hi Nagios support,
Currently our NagiosXI version is 5.7.3.
Regarding database, mysql version is 15.1 Distrib 5.5.65-MariaDB and PostgreSQL version is 9.2.24
May I know which database NagiosXI is using? mysql or postgreSQL?
Re: which database NagiosXI is using? mysql or postgreSQL?
Posted: Tue Apr 27, 2021 10:47 am
by benjaminsmith
Hi,
Nagios XI users 3 separate databases, nagios, nagiosql & nagisoXI respectively. Prior to version 5.5, the nagiosxi databse used postgres. Updates on those versions will preserve the postgres database. We have a doc on how to convert this over to MySQL, but it can remain on postgres.
To determine what your system has, run the following command. If it outputs 2, then your server is using postgres and MySQL.
Code: Select all
grep mysql /usr/local/nagiosxi/html/config.inc.php | wc -l
Let us know if you have further questions.
Regards,
Benjamin
Re: which database NagiosXI is using? mysql or postgreSQL?
Posted: Wed Apr 28, 2021 9:28 pm
by austin117
Thanks for the reply.
Nagios XI users 3 separate databases, nagios, nagiosql & nagisoXI respectively. Prior to version 5.5, the nagiosxi databse used postgres. Updates on those versions will preserve the postgres database. We have a doc on how to convert this over to MySQL, but it can remain on postgres.
Do you mean that
NagiosXI database below version 5.5 used only Postgre db?
NagiosXI database above version 5.5 used only MySQL db?
To determine what your system has, run the following command. If it outputs 2, then your server is using postgres and MySQL.
CODE: SELECT ALL
grep mysql /usr/local/nagiosxi/html/config.inc.php | wc -l
Output: 3
It means our server is using postgres, MySQL and ...?
May I know why we need to use 3 dbs(postgres and mySQL)? The purpose of every db?
Re: which database NagiosXI is using? mysql or postgreSQL?
Posted: Thu Apr 29, 2021 10:19 am
by benjaminsmith
HI,
That's correct below version 5.5 the
nagiosxi was using postgres. If you upgrade an old system to the current version it would remain using postgres.
If that command returned a 3, then the system is using MySQL for all 3 databases. You can check config.inc.php to verify this.
The reason for separate databases is related to the different subcomponents of XI, as it's built on top of the open-source project
Nagios Core.The nagisoxi database handles the gui/user accounts, the nagios database stores check results and the nagisoxi database contains user account, settings and options.
Let me know if you have any other questions.
--Benjamin