[pmacct-discussion] mysql plugin connect problem

[Anil]

I am having problems using mysql plugin. When I run pmacct in
foreground, I get this error message. I am using
0.11.5.


( 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:


sql_host: host.domain.com
sql_db: bandwidth_db
sql_table: acct
sql_user: admin
sql_passwd: ****
sql_table_version: 1


Thanks

_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists