Privileges/Permissions Required to monitor databases

[harris_gunari]

Hi,

is there any official documentation that list all the privileges/permissions generally required in order for nagios to monitor the following databases,
MySQL/Mariadb
PostgresSQL
MsSQL
Mongo

Regards,
Harris

[benjaminsmith]

Hi @harris_gunari

Here's is a list of the documentation we have for monitoring databases:

Monitoring Microsoft SQL With Nagios XI
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

Monitoring A MongoDB Database
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

Nagios XI - Monitoring A MySQL Server
https://support.nagios.com/kb/article/n ... r-698.html

The account will generally need usage permissions to the database, but not administrator level access, so for example on MySQl:

Code: Select all

GRANT usage ON *.* TO 'nagios'@'nagiosserver' IDENTIFIED BY 'nagiospassword'

Please reference the documentation for the other databases. Let me know if you have any other questions.