Page 1 of 1
Privileges/Permissions Required to monitor databases
Posted: Wed Nov 14, 2018 9:29 pm
by 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
Re: Privileges/Permissions Required to monitor databases
Posted: Thu Nov 15, 2018 11:33 am
by 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.