Hi again. I am trying to configure the check_mysql plugin to check my database.
In checkcommands.cfg, I've put the following command line for check_mysql so I can specify the IP address, database name, username and password: command_line $USER1$/check_mysql -H $ARG1$ -d $ARG2$ -u $ARG3$ -p $ARG4$ In services.cfg, I put the following in the service definition for this service: check_command check_mysql!192.168.160.2!mydbname!mydbusername!mydbpassword and restarted Nagios, and it worked. The Nagios web page displayed the database statistics. However, when I tried changing that to check_command check_mysql!192.168.160.2!mydbname!mydbusername!$USER4$ and setting $USER4$ in resource.cfg, I get error Access denied for user 'mydbusername'@'192.168.160.1' (using password: YES) note: 192.168.160.1 is the ip address of the machine Nagios is running on. Different from the machine that the database is on. very strange that the ip address changed. I double checked services.cfg and 192.168.160.2 is still in there. Am I approaching this the right way in terms of configuring it? I am going to replace check_mysql with a little script that logs the arguments it is called with, so I can get a better idea of what's happenning. New Nagios User. ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37&alloc_id865&op=click _______________________________________________ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null