(RADIATOR) AuthSQL checking DEFAULT as username instead of actual username

[Garry Thomas]

You need to include the "NoDefault" keyword in the <AuthBy SQL> section
of your radius.cfg file....


Garry

> -----Original Message-----
> From: owner-radiator at open.com.au 
> [mailto:owner-radiator at open.com.au] On Behalf Of William C. Mott
> Sent: Thursday, 23 October 2003 3:39 AM
> To: radiator at open.com.au
> Subject: (RADIATOR) AuthSQL checking DEFAULT as username 
> instead of actual username
> 
> 
> I am having a problem with SQL authentication, the log file 
> shows AuthSQL
> trying to authenticate with the username then checks the 
> username DEFAULT,
> instead of the actual username. Am I missing something...
> 
> -----LOG FILE-----
> Tue Oct 21 18:29:21 2003: DEBUG: Packet dump:
> 
> *** Received from 208.179.155.18 port 1339 ....
> 
> Code: Access-Request
> 
> Identifier: 1
> 
> Authentic: 
> <189><15>A<201><3><173><192><235><187><254><224><187><216>ga<213>
> 
> Attributes:
> 
> User-Name = "vesta"
> 
> NAS-IP-Address = 208.179.155.18
> 
> NAS-Identifier = "0"
> 
> User-Password = 
> "(a<147><241>1.\<243>2<19><172><207><143><170><4><192>"
> 
> NAS-Port = 1
> 
> Service-Type = Framed-User
> 
> Framed-Protocol = PPP
> 
> Tue Oct 21 18:29:21 2003: DEBUG: Handling request with Handler
> 'Realm=DEFAULT'
> 
> Tue Oct 21 18:29:21 2003: DEBUG: Rewrote user name to vesta
> 
> Tue Oct 21 18:29:21 2003: DEBUG: Rewrote user name to vesta
> 
> Tue Oct 21 18:29:21 2003: DEBUG: Deleting session for vesta, 
> 208.179.155.18,
> 1
> 
> Tue Oct 21 18:29:21 2003: DEBUG: Handling with Radius::AuthSQL
> 
> Tue Oct 21 18:29:21 2003: DEBUG: Handling with Radius::AuthSQL:
> 
> Tue Oct 21 18:29:22 2003: DEBUG: Query is: 'SELECT RTRIM(PASSWORD),
> REPLYATTR, MAXTIME, SESSIONS FROM Users WHERE (USERNAME='vesta') AND
> ((Status = 1) OR (Status = 4))':
> 
> Tue Oct 21 18:29:23 2003: DEBUG: Radius::AuthSQL looks for 
> match with vesta
> 
> Tue Oct 21 18:29:23 2003: DEBUG: Query is: 'SELECT RTRIM(PASSWORD),
> REPLYATTR, MAXTIME, SESSIONS FROM Users WHERE (USERNAME='DEFAULT') AND
> ((Status = 1) OR (Status = 4))':
> 
> Tue Oct 21 18:29:23 2003: INFO: Access rejected for vesta: No 
> such user
> 
> Tue Oct 21 18:29:23 2003: DEBUG: Packet dump:
> 
> *** Sending to 208.179.155.18 port 1339 ....
> 
> Code: Access-Reject
> 
> Identifier: 1
> 
> Authentic: 
> <189><15>A<201><3><173><192><235><187><254><224><187><216>ga<213>
> 
> Attributes:
> 
> Reply-Message = "Request Denied"
> 
> 
> 
> -----END LOG-----
> 
> -----CONFIG FILE-----
> 
> <Realm DEFAULT>
> 
> RewriteUsername s/^(.*)\\(.*)/$2\@$1/
> 
> RewriteUsername s/^([^@]+).*/$1/
> 
> <AuthBy SQL>
> 
> DBSource dbi:ODBC:radiator
> 
> DBUsername radiator
> 
> DBAuth <hidden>
> 
> AuthSelect SELECT RTRIM(PASSWORD), REPLYATTR, MAXTIME, 
> SESSIONS FROM Users
> WHERE (USERNAME='%n') AND ((Status = 1) OR (Status = 4))
> 
> AuthColumnDef 0, User-Password, check
> 
> AuthColumnDef 1, GENERIC, reply
> 
> AuthColumnDef 2, Session-Timeout, reply
> 
> AuthColumnDef 3, Simultaneous-Use, check
> 
> AddToReply Framed-Protocol=1,\
> 
> Framed-IP-Netmask=255.255.255.255,\
> 
> Framed-MTU=476,\
> 
> Framed-Compression=1
> 
> HandleAcctStatusTypes Start, Stop
> 
> AcctColumnDef USERNAME,User-Name
> 
> #AcctColumnDef TIME_STAMP,Timestamp,formatted-date,to_date('%m/%e/%Y
> %H:%M:%S', 'MM/DD/YYYY HH24:MI:SS')
> 
> #AcctColumnDef TIME_STAMP,Timestamp,formatted-date
> 
> AcctColumnDef TIME_STAMP,Timestamp,integer
> 
> AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
> 
> AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
> 
> AcctColumnDef ACCTINPUTOCT,Acct-Input-Octets,integer
> 
> AcctColumnDef ACCTOUTPUTOCT,Acct-Output-Octets,integer
> 
> AcctColumnDef ACCTSESSIONID,Acct-Session-Id
> 
> AcctColumnDef ACCTSESSTIME,Acct-Session-Time,integer
> 
> AcctColumnDef ACCTTERMINATECAUSE,Acct_Terminate-Cause
> 
> AcctColumnDef NASIDENTIFIER,NAS-Identifier
> 
> AcctColumnDef NASPORT,NAS-Port,integer
> 
> 
> </AuthBy>
> 
> 
> 
> # Log accounting to a detail file. %D is replaced by DbDir above
> 
> AcctLogFileName %D/detail
> 
> </Realm>
> 
> 
> -----END CONFIG-----
> 
> ===
> 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.
> 

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