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.

Reply via email to