I am having problems testing accounting with my MySQL database. The
debug is showing me that the domain localhost is being attached to my
DBUsername and causing the database to return a Access Denied message.
I am able to authenticate correctly, but the accepting is giving me a
problem. I have included a portion of my .cfg file and the debug
information. Thank you in advance for any assistance.
Config
AuthBy SQL>
DBSource dbi:mysql:auth:
DBUsername radius
DBAuth xxxxxx
AuthSelect SELECT password, checkattr, replyattr \
FROM subscriber WHERE username='%U'
AuthColumnDef 0, Encrypted-Password, check
EncryptedPassword
AccountingTable accounting
AcctColumnDef username,User-Name
</AuthBy>
Debug
DBD::mysql::db do failed: Access denied for user: 'radius@localhost' to
database 'auth' at /usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm
line 247.
Sat Jun 9 13:13:58 2001: ERR: do failed for 'insert into accounting
(username)
values
('jason.shultz')': Access denied for user:
'radius@localhost' to database 'auth'
begin:vcard
n:Shultz;Jason
tel;pager:(517) 794-3077
tel;cell:(419) 565-0349
tel;work:(419) 565-0349
x-mozilla-html:FALSE
url:http://www.richnet.net
org:CoreComm
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:Ohio Systems Engineer
note;quoted-printable:=0D=0ATo send a text page message, email me at [EMAIL PROTECTED]=0D=0A
fn:Jason Shultz
end:vcard
