(RADIATOR) AuthBy SQL

[Quintin]

Hi,

I have a problem on AuthBy SQL, I don't want to be authenticated using SQL Database but I just want to insert a value into another self-defined database when the Radiator receives the accouting start.

Trace result
-------------------
Mon Sep 24 19:07:54 2001: DEBUG: Handling with Radius::AuthSQL
Mon Sep 24 19:07:54 2001: INFO: Access rejected for wtlam: Authentication disabled
Mon Sep 24 19:07:54 2001: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 37203 ....
Code:       Access-Reject
Identifier: 9
Authentic:  1234567890123456
Attributes:

Configuration
----------------
<AuthBy SQL>
    Identifier MarkAlert
    DBSource DBI:mysql:radius    
    DBUsername xxxxxx
    DBAuth      xxxxxx
    FailureBackoffTime  60
    AuthSelect
    AcctSQLStatement insert into RADALERT (USERNAME) values ('%u')
</AuthBy>


In the configuration above, I have put the empty string at AuthSelect cause but I don't know why the Radiator rejected my request.

Please help.

Thanks!

Quintin


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20010924/32a67012/attachment.html>