Hi anil, Anil wrote:
> ( default/mysql ) *** Purging cache - START *** > ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble. > ERROR ( default/mysql ): The SQL server says: Access denied for user > 'admin'@'%.domain.com' to database 'bandwidth_db' > > ( default/mysql ) *** Purging cache - END (QN: 0, ET: 0) *** > > > But in the mysql logs, I see that it connected w/o a problem: > > > 080722 22:15:01 12 Connect [EMAIL PROTECTED] on bandwidth_db > 12 Query LOCK TABLES `acct` WRITE > > > Why does the "ERROR" show "%.domain.com" instead of host.domain.com, > which I specifically setup in my configuration: host.domain.com is what MySQL gets by doing a reverse lookup on the IP address that you connected from. [EMAIL PROTECTED] is the matching rule from your grant tables that was used to decide what access this user has, and apparently MySQL thinks that this user (pattern) doesn't have access to the bandwidth_db database. Cheers, Chris. -- Aptivate | http://www.aptivate.org | Phone: +44 1223 760887 The Humanitarian Centre, Fenner's, Gresham Road, Cambridge CB1 2ES Aptivate is a not-for-profit company registered in England and Wales with company number 04980791. _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
