Big problems w/RadiusNT 2.5

Greg Waugh ( (no email) )
Sun, 10 May 1998 20:38:40 -0400

We have been using RadiusNT 2.2 almost without problems for nearly 6 mont=
hs
now. I am building a new RadiusNT box and put RadiusNT 2.5 on it. I hav=
e
had nothing but problems. First, we are using an Ascend MAX 4000 router =
and
could not get it to answer queries because of the malformed packet error
which was supposed to only happen on USRs. I kludged it with the malfome=
d
packet bit and it seems to work now. Here is an output of radius.exe -x1=
5
in ODBC mode:

RadiusNT (Emerald Standard) Initialized...

radrecv: Request from host c61e169b code=3D1, id=3D196, length=3D109
User-Name =3D "bhoffman"
Challenge-Response =3D "\001\337\262kUr\226;\303\3672\264V\351\354\01=
7U"
NAS-Identifier =3D 198.30.22.155
NAS-Port =3D 20115
NAS-Port-Type =3D Async
User-Service =3D Framed-User
Framed-Protocol =3D PPP
State =3D ""
NAS-Port-DNIS =3D "6211000"
Framed-Address =3D 198.30.22.185
Acct-Session-Id =3D "246951750"
rad_authenticate_ODBC()
Challenge-Response =3D "\001\337\262kUr\226;\303\3672\264V\351\354\01=
7U"

SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day,
(ma.Extension+ma
..OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), DateAdd(Day,
sa.Extensi
on+1, saExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Login=
,
sa.Sh
ell From MasterAccounts ma, SubAccounts sa Where (sa.Login=3D'bhoffman' =
or
sa.She
ll=3D'bhoffman' or sa.Email=3D'bhoffman') AND ma.CustomerID=3Dsa.Customer=
ID and
sa.Act
ive<>0 and ma.Active<>0

Checking for duplicate logins.

SQL Statement: RadCheckOnline 'bhoffman'

bhoffman found on-line 0 time(s).

SQL Statement: RadGetConfigs 81

Loading radius defaults for this type...

SQL Statement: RadGetATConfigs 'PPP-Unlim-19,9'

Sending Reject of id 196 to c61e169b (polmax4000)
bhoffman: PPP-Unlim-19,9 has no RADIUS default attributes.

bhoffman: PPP-Unlim-19,9 has no RADIUS default attributes.

SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data)
VALUE
S (19, GetDate(), 'bhoffman', 'g+-n6f=3D=A6=B2+}k+=A6[?=B5')

ODBC Error:23000:547:
[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflict=
ed
with
COLUMN FOREIGN KEY constraint 'FK__RadLogs__RadLogM__1E1A7EA3'. The
conflict oc
curred in database 'Emerald', table 'RadLogMsgs', column 'RadLogMsgID'

Resp Time: 5812 Auth: 0/2 -> 2 Acct: 0/0/0 -> 0

The first problem is the "SQL Statement: RadGetATConfigs 'PPP-Unlim-19,9'=
".
Our service types use all 15 charactors ("PPP-Unlim-19,95") however it se=
ems
to be truncating it to 14 which will not retrieve the Radius attributes.

My other concern is that "ODBC Error:23000:547"... I have no idea what th=
at
is about.

Also it doesn't seem to be decryping the passwords... again, nothing was
changed in the database.

This whole thing ran great on RadiusNT 2.2. I ran the Radius 2.5 upgrade
script and it seemed to run okay. This is a clean system (PII 300, 128MB
RAM, RAID 5 HD Array, NT 4.0SP3, SQL 6.5SP4) with nothing else at all
running. This system is exclusively for RadiusNT and SQL. Please help! =
If
we have to go back to 2.2 we will, but I'd rather use 2.5 since we don't
plan to touch the machine for a long time.

Thanks in advance!

------------------------------------------

Greg Waugh (greg@pol.com)
Manager of Systems Operations
Productivity OnLine
Cincinnati, Ohio