<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8"> <META NAME="GENERATOR" CONTENT="GtkHTML/3.18.3"> </HEAD> <BODY> Thanks, for some reason when I had added the password via phpmyadmin nagios had issues with it. I re-added the password via command line for nagios user and for some reason it accepted it better that way. Thanks for advice On Wed, 2009-05-20 at 16:06 -0600, Mike Saldivar wrote: <BLOCKQUOTE TYPE=CITE> On Wed, May 20, 2009 at 12:36 PM, David Gossage <<A HREF="mailto:dgossage@zacks.com">dgossage@zacks.com</A>> wrote: </BLOCKQUOTE> <BLOCKQUOTE TYPE=CITE> <BLOCKQUOTE> Access denied for user 'nagios'@'<A HREF="http://qeren.zacks.com">qeren.zacks.com</A>' (using password: YES) And oddly it's the opposite for the original server which works in nagios, but returns same error on commandline. Here is what the current permissions are set to which is the same as on the original server as far as I can tell. User:nagios Host:<A HREF="http://server.domain.com">server.domain.com</A> Password:Yes GlobalPrivileges:<TT>U</TT>SAGE<TT> Grant:No</TT> </BLOCKQUOTE> </BLOCKQUOTE> <BLOCKQUOTE TYPE=CITE> Each MySQL server needs to be told to allow nagios (or whatever the checking username is) from the host doing the checking. I don't know if you changed the output pasted above, but where the error message says 'nagios'@'<A HREF="http://qeren.zacks.com/">qeren.zacks.com</A>', the output you pasted at "current permissions are set to which is the same as on the original server " says login permissions are granted to 'nagios'@'<A HREF="http://server.domain.com">server.domain.com</A>'. The host just needs to match the Nagios server's name, as seen by the MySQL server. Or it can be an IP address. If your Nagios server is <A HREF="http://queren.zacks.com">queren.zacks.com</A>, then each individual MySQL server needs to allow 'nagios' to log in from '<A HREF="http://qeren.zacks.com">qeren.zacks.com</A>'. You'd enable it by running a grant statement such as this, within MySQL, on each server: GRANT SELECT ON *.* TO 'nagios'@'<A HREF="http://qeren.zacks.com/">qeren.zacks.com</A>' IDENTIFIED BY PASSWORD 'plaintextpassword'; Grant and add user syntax are at: <A HREF="http://dev.mysql.com/doc/refman/5.1/en/create-user.html">http://dev.mysql.com/doc/refman/5.1/en/create-user.html</A> -Mike <PRE> ------------------------------------------------------------------------------ Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT is a gathering of tech-side developers & brand creativity professionals. Meet the minds behind Google Creative Lab, Visual Complexity, Processing, & iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian Group, R/GA, & Big Spaceship. <A HREF="http://www.creativitycat.com">http://www.creativitycat.com</A> _______________________________________________ Nagiosplug-help mailing list <A HREF="mailto:Nagiosplug-help@lists.sourceforge.net">Nagiosplug-help@lists.sourceforge.net</A> <A HREF="https://lists.sourceforge.net/lists/listinfo/nagiosplug-help">https://lists.sourceforge.net/lists/listinfo/nagiosplug-help</A> ::: Please include plugins version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null </PRE> </BLOCKQUOTE> </BODY> </HTML>