-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Might it be a problem in the definition of the PASSWORD field in the
SUBSCRIBERS table?
Perhaps you have defined it as CHAR(6) and it is appending white
space to the four-length fields... Should this be the problem
VARCHAR(6) should fix it.
HTH
> -----Mensaje original-----
> De: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]En nombre de S.K.D. Lakmin
> Premnath Enviado el: lunes, 10 de enero de 2000 14:30 Para:
> [EMAIL PROTECTED]; [EMAIL PROTECTED] Asunto: (RADIATOR) Auth
> problem on MSSQL subscriber table password length
>
>
> 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.
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.1 for non-commercial use <http://www.pgp.com>
iQA/AwUBOHmSnmXwKH++xlSbEQLxOwCg8udfCh93Rzo54R16GUGhJNvvG/sAn3xW
cVeArl2/kI2htkjP5Nnprtww
=jx5B
-----END PGP SIGNATURE-----
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
