hi hugh,
Nice Day to You.....
Now I'm connecting to MSSQL & Sever using FreeTDS. Thanks for all previous
advice to do this. Now I have small problem in subscribers table password
column. I have changed the length of password field to six characters. In
this case if the password length is less than six characters radiator will
reject the authentication for that user.
All username and passwords are arbitary for security purpose. In first case
length of password is four and authentication is rejcted. In second case
length of password is six and authentication is accepted.
Tell me how can I set different length passwords for users in subscribers
table.
Thanks
lakmin
Abstract from radpwtst....
radiator: {11} % radpwtst -user noc1@chksql -password noc1
sending Access-Request...
Rejected
sending Accounting-Request Start...
OK
sending Accounting-Request Stop...
OK
radiator: {11} % radpwtst -user lakminsk@chksql -password lakmin
sending Access-Request...
OK
sending Accounting-Request Start...
OK
sending Accounting-Request Stop...
OK
Abstract from .cfg file
<Handler Realm=chksql>
RewriteUsername s/^([^@]+).*/$1/
AuthByPolicy ContinueWhileAccept
<AuthBy SQL>
# Adjust DBSource, DBUsername, DBAuth to suit your DB
DBSource
dbi:FreeTDS:database=icarddb;host=xxx.xx.xxx.xx;port=1433
DBUsername menik
DBAuth menik
AuthSelect select PASSWORD, CHECKATTR, REPLYATTR \
from SUBSCRIBERS \
where USERNAME='%n'
AuthColumnDef 0, User-Password, check
AuthColumnDef 1, GENERIC, check
AuthColumnDef 2, GENERIC, reply
# You may want to tailor these for your ACCOUNTING table
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 NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
</AuthBy>
</Handler>
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.