(RADIATOR) AuthBy SQL

[Hugh Irvine]

Hello Quintin -

My first question is what is Radiator meant to do with authentication 
requests? The answer will determine what the best approach will be in the 
configuration file. Please give me a clear explanation of what you are trying 
to achieve and I will suggest a suitable means to configure it.

regards

Hugh


On Monday 24 September 2001 21:25, Quintin wrote:

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

----------------------------------------
Content-Type: text/html; charset="big5"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 
----------------------------------------

-- 
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.