radrecv: Request from host cf226802 code=3D1, id=3D228, length=3D76
User-Name =3D "ken282"
Password =3D "\010\206\377\0267\277\330}\\316\355\313>1)G"
NAS-Identifier =3D 207.34.xxx.x
NAS-Port =3D 2
NAS-Port-Type =3D Async
User-Service =3D Framed-User
Framed-Protocol =3D PPP
rad_authenticate_ODBC()
Password =3D "\010\206\377\0267\277\330}\\316\355\313>1)G"
SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day, (ma.Ext=
e
..OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), DateAdd(Day, s=
a
on+1, saExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Log=
i
ell, sa.LoginLimit From MasterAccounts ma, SubAccounts sa Where (sa.Lo=
g
82' or sa.Shell=3D'ken282' or sa.Email=3D'ken282') AND ma.CustomerID=3D=
sa.Cust
nd sa.Active<>0 and ma.Active<>0
Decrypted Password: uI-=A5=A6-?=A6-E=A6=A6%:K
Database Password: xxxxxxxx
Sending Reject of id 228 to cf226802 (gate.xxxxx.com)
SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Dat=
a
S (11, GetDate(), 'ken282', 'uI-=A5=A6-?=A6-E=A6=A6%:K')
ODBC Error:23000:2627:
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KE=
Y
int 'pk_RadLogs': Attempt to insert duplicate key in object 'RadLogs'.
User: ken282 Bad Password
This is what happens when I try a radlogin with a known good account an=
d
password. I'm using RadiusNT 2.5.105 and I don't have the Encrypt Pass=
word
option on. I'm running NT 4.0 with SQL server 6.5. Any help is greatl=
y
appreciated.
Greg.