(RADIATOR) MySQL Accounting Problem

[Hugh Irvine]

Hello Jason -

It looks to me like you do not have your permissions set up correctly for 
Radiator to access the database. The error message shows that the user you 
have defined in the DBUsername (radius - which MySQL checks as 
"radius at localhost") is not allowed to access the "auth" table.

You will have to correctly set up the permissions in MySQL.

hth

Hugh


On Sunday 10 June 2001 03:37, Jason Shultz wrote:

> > 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 at 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 at localhost' to database 'auth'

----------------------------------------
Content-Type: text/x-vcard; charset="us-ascii"; name="Jason.Shultz.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Jason Shultz
----------------------------------------

-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.