More troubles with NT SAM

Robb Bryn ( rbryn@cape-fear.net )
Sat, 2 May 1998 09:10:58 -0400

We've had some difficulty with Radius 2.5.105 in the past few days.
Specifically with users that auth from the NT SAM. Every once in a while
radius would turn away any user auth from the NT SAM for bad passwords (when
in realty the account and password were fine. I caught this today and it
seems that certain users (like myself) set this problem off. After I log in
radius uses my login for all NT SAM usernames . The problem seems to happen
whenever this error occurs ODBC Error:01004:0:
[Microsoft][ODBC SQL Server Driver]Data truncated (which you will see
below). Below is a snippet from radius. Since we can't get replace
passwords working this one little error shuts down our operation completely
(we're trying to migrate to Radius and away from RRAS).

Thanks
Robb


Resp Time: 190 Auth: 1/0 -> 1 Acct: 3/0/0 -> 3
radrecv: Request from host d0851c05 code=1, id=205, length=63
User-Name = "rbryn"
Password = "\023\220M\004\306\235n\223\274L\352*\251\227]\346"
NAS-Port = 16
Framed-Protocol = PPP
NAS-Identifier = "DIAL"
rad_authenticate_ODBC()
Password = "\023\220M\004\306\235n\223\274L\352*\251\227]\346"

SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day,
(ma.Extension+
..OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), DateAdd(Day,
sa.Exten
on+1, saExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
sa.
ell, sa.LoginLimit From MasterAccounts ma, SubAccounts sa Where
(sa.Login='rb
n' or sa.Shell='rbryn') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and
m
Active<>0

Decrypted Password: wish
Database Password: wish
Checking for duplicate logins.

SQL Statement: RadCheckOnline 'rbryn'

rbryn found on-line 0 time(s).

SQL Statement: RadGetATConfigs 'Shell'

SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day,
(ma.Extension+
..OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), DateAdd(Day,
sa.Exten
on+1, saExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
sa.
ell, sa.LoginLimit From MasterAccounts ma, SubAccounts sa Where
(sa.Login='rb
n' or sa.Shell='rbryn') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and
m
Active<>0

ODBC Error:01004:0:
[Microsoft][ODBC SQL Server Driver]Data truncated

Loading radius defaults for this type...

SQL Statement: RadGetATConfigs '33.6'

Framed-Protocol = 1 (1)
Sending Ack of id 205 to d0851c05 (pppdial.cape-fear.net)
Framed-Protocol = PPP

Resp Time: 571 Auth: 2/0 -> 2 Acct: 3/0/0 -> 3
radrecv: Request from host d0851c05 code=4, id=206, length=58
Acct-Status-Type = Start
Acct-Session-Id = "12551"
User-Name = "rbryn"
NAS-Port = 16
NAS-Identifier = "DIAL"
Framed-Protocol = PPP

SQL Statement: INSERT INTO Calls
(CallDate,AcctStatusType,AcctSessionId,UserN
e,NASPort,NASIdentifier,FramedProtocol) VALUES
(GetDate(),1,'12551','rbryn',16
DIAL',1)

Sending Accounting Ack of id 206 to d0851c05 (pppdial.cape-fear.net)

Resp Time: 210 Auth: 2/0 -> 2 Acct: 4/0/0 -> 4
radrecv: Request from host d0851c05 code=4, id=207, length=62
Acct-Status-Type = Stop
Acct-Session-Id = "12547"
User-Name = "mclements"
NAS-Port = 18
NAS-Identifier = "DIAL"
Framed-Protocol = PPP

SQL Statement: INSERT INTO Calls
(CallDate,AcctStatusType,AcctSessionId,UserN
e,NASPort,NASIdentifier,FramedProtocol) VALUES
(GetDate(),2,'12547','mclements
18,'DIAL',1)

Sending Accounting Ack of id 207 to d0851c05 (pppdial.cape-fear.net)

Resp Time: 250 Auth: 2/0 -> 2 Acct: 5/0/0 -> 5
radrecv: Request from host d0851c05 code=1, id=208, length=64
User-Name = "bwoody"
Password = "\326\264\317/\3618[\030\031:\015I(\243\373G"
NAS-Port = 13
Framed-Protocol = PPP
NAS-Identifier = "DIAL"
rad_authenticate_ODBC()
Password = "\326\264\317/\3618[\030\031:\015I(\243\373G"

SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day,
(ma.Extension+
..OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), DateAdd(Day,
sa.Exten
on+1, saExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
sa.
ell, sa.LoginLimit From MasterAccounts ma, SubAccounts sa Where
(sa.Login='bw
dy' or sa.Shell='bwoody') AND ma.CustomerID=sa.CustomerID and sa.Active<>0
and
a.Active<>0

Decrypted Password: unix
Database Password: WINNT\DIAL
(WINNT) User:rbryn Domain:DIAL Password:unix
Sending Reject of id 208 to d0851c05 (pppdial.cape-fear.net)

SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data)
VAL
S (11, GetDate(), 'bwoody', 'unix')

User: bwoody Bad Password

User: bwoody Bad Password

Resp Time: 3415 Auth: 2/1 -> 3 Acct: 5/0/0 -> 5