Hello.
I am curious with AuthBy SQL and decided to try it out. After a few
tries, however, I can't get logged in, using the most basic AuthSelect and
the tables/data contained in goodies/postgresCreate.sql. I get this
error complaining about incorrect password:
Fri Jun 9 20:42:02 2000: DEBUG: Handling request with Handler
'Realm=testroy'
Fri Jun 9 20:42:02 2000: DEBUG: Rewrote user name to mikem
Fri Jun 9 20:42:02 2000: DEBUG: Deleting session for mikem@testroy,
208.155.152.42, 1025
Fri Jun 9 20:42:02 2000: DEBUG: Handling with Radius::AuthSQL
Fri Jun 9 20:42:02 2000: DEBUG: Handling with Radius::AuthSQL
Fri Jun 9 20:42:02 2000: DEBUG: Query is: select PASSWORD from
SUBSCRIBERS where USERNAME='mikem'
Fri Jun 9 20:42:02 2000: DEBUG: Radius::AuthSQL looks for match with
mikem
Fri Jun 9 20:42:02 2000: DEBUG: Radius::AuthSQL REJECT: Bad Password
Fri Jun 9 20:42:02 2000: DEBUG: Query is: select PASSWORD from
SUBSCRIBERS where USERNAME='DEFAULT'
Here's my AuthBy SQL config:
<Realm testroy>
RewriteUsername s/^([^@]+).*/$1/
<AuthBy SQL>
DBSource dbi:Pg:dbname=radiator
DBUsername postgres
DBAuth MYPOSTGRESPASSWORD
AccountingTable accounting
AuthSelect select PASSWORD from SUBSCRIBERS where
USERNAME='%n'
AuthColumnDef 0, User-Password, check
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
AcctColumnDef NASIDENTIFIER,NAS-Identifier
AcctColumnDef NASIDENTIFIER,NAS-IP-Address
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
</AuthyBy>
</Realm>
My subscribers table (from the goodies directory):
radiator=> select * from subscribers;
username|password|encryptedpassword|checkattr |replyattr
--------+--------+-----------------+--------------------------+----------------------------------------------------------------------------------------
mikem |fred |1xMKc0GIVUNbE |Service-Type = Framed-User|Framed-Protocol =
PPP,Framed-IP-Netmask = 255.255.255.0,cisco-avpair = "testing testing" (1 row)
What am I missing?
TIA.
Sincerely,
Froilan C. Mendoza
Manager - Systems Management
Tridel Technologies, Inc.
http://www.tridel.net
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
