which database NagiosXI is using? mysql or postgreSQL?

[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?

[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

[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?

[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