Required permissions for check_mysql_health

[WillemDH]

hello,

I'm trying to get the mysql wizard working, but I keep getting

Code: Select all

OUTPUT: CRITICAL - cannot connect to information_schema. Access denied for user 'nagiosUser'@'nagiosserver' (using password: YES)

The user has select, insert, update privileges. Anything else the user needs to be able to monitor the mysql?

Grtz

Willem

[slansing]

Are you running this against your local XI server? Or against some other nagios database remotely? Did you replace the username and password you used with:

'nagiosUser'@'nagiosserver'

If not, is that what you have changed the username and password to for the mysql DB in the correct places?

[WillemDH]

I'm trying to monitor the mysql DB of our LAMP environment, this is not the mysql DB of the Nagios server. The user 'nagiosUser'@'nagiosserver' is just an example.

[scottwilkerson]

From the plugins's website

In order to be able to collect the needed information from the database a database user with specific privileges is required:

Code: Select all

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

[WillemDH]

Got this myql checks up and running in the meantime. Thread can be closed. Tx