Hello Hugh,
Thanks for responding ...
On Sat, 10 Jun 2000, Hugh Irvine wrote:
> I notice that your Postgress table definitions are in lower case, and your
> AuthSelect is in upper case. Is this correct?
Postgres is not case-sensitive.
radiator=> select PASSWORD from SUBSCRIBERS where USERNAME = 'mikem';
password
--------
fred
(1 row)
> Also, if you want to use the
> "checkattr" and "replyattr" fields, you will need to modify your AuthSelect
> statement together with the corresponding AuthColumnDef's.
Of course. Only I would like to do the most simple auth method first
before complicating things for me :)
> And does the inbound test packet in fact contain a password of "fred"?
Of course. I even tried NULLING the password in the postgres database (as
it said in the docs that if the password is NULL, it would accept ANY
password), to no avail.
> You might try something like this:
>
> <Realm testroy>
> RewriteUsername s/^([^@]+).*/$1/
> <AuthBy SQL>
> DBSource dbi:Pg:dbname=radiator
> DBUsername postgres
> DBAuth MYPOSTGRESPASSWORD
>
> AuthSelect select password from subscribers where \
> username='%n'
> AuthColumnDef 0, User-Password, check
>
> AccountingTable accounting
> 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>
>
> If the field names are indeed case-sensitive, you will have to change the
> AcctColumnDef's as well.
I did, however, still tried your config above, changing the case of the
letters. I still get this:
Sat Jun 10 10:44:37 2000: DEBUG: Handling request with Handler
'Realm=testroy'
Sat Jun 10 10:44:37 2000: DEBUG: Rewrote user name to mikem
Sat Jun 10 10:44:37 2000: DEBUG: Deleting session for mikem@testroy,
208.155.152.42, 1025
Sat Jun 10 10:44:37 2000: DEBUG: Handling with Radius::AuthSQL
Sat Jun 10 10:44:37 2000: DEBUG: Handling with Radius::AuthSQL
Sat Jun 10 10:44:37 2000: DEBUG: Query is: select password from
subscribers where username='mikem'
Sat Jun 10 10:44:37 2000: DEBUG: Radius::AuthSQL looks for match with
mikem
Sat Jun 10 10:44:37 2000: DEBUG: Radius::AuthSQL REJECT: Bad Password
Sat Jun 10 10:44:37 2000: DEBUG: Query is: select password from
subscribers where username='DEFAULT'
Sat Jun 10 10:44:37 2000: INFO: Access rejected for mikem: Bad Password
Sat Jun 10 10:44:37 2000: DEBUG: Packet dump:
*** Sending to 208.155.152.42 port 1645 ....
Additional question -- Why do I get Query is: select password from
subscribers where username='DEFAULT'. This might be the cause ...
Hoping for your continued support ... Thanks.
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.
