Page 1 of 1
Required permissions for check_mysql_health
Posted: Wed May 21, 2014 8:44 am
by 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
Re: Required permissions for check_mysql_health
Posted: Wed May 21, 2014 9:21 am
by 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?
Re: Required permissions for check_mysql_health
Posted: Thu May 22, 2014 2:51 am
by 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.
Re: Required permissions for check_mysql_health
Posted: Thu May 22, 2014 7:53 am
by 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'
Re: Required permissions for check_mysql_health
Posted: Wed May 28, 2014 10:12 am
by WillemDH
Got this myql checks up and running in the meantime. Thread can be closed. Tx