Re: RadiusNT, Dr. Watson & Accounting.

Kent Runyan ( (no email) )
Wed, 19 Mar 1997 18:23:42 -0700

I have the same problem. Everything works great until I enable accounting
using the Access database.

----------
> From: Timothy Stewart <tims@baileygrp.com>
> To: RadiusNT@emerald.iea.com
> Subject: RadiusNT, Dr. Watson & Accounting.
> Date: Wednesday, March 19, 1997 12:03 PM
>
> Hello, if anyone could help with a problem I woudl appreciate it. I'm
> really starting to hate this Dr. Watson guy with a passion.
>
> we are running:
>
> - Microsoft Windows NT 4.00.1381
>
> - radius: RADIUS version 1.16.60 2/7/97
> NOSHADOW BINARY_FILTERS ASCEND_SECRET WindowsNT ODBC
>
> - two Ascend MAX 4000's, both secret's set up to be identical
> (I did not think they had to be unique, if so, please let me know).
> Ascend MAX Software versions are 4.6Cp9.
>
>
> The infamous Dr. Watson strikes when I set the MAX's acct as Radius,
> and put in the secrets. If I start Radius with -x15 -o -A and then
> log in I get:
>
> 0) Mode: 1
> 1) EncryptPasswords: 1
> 2) IgnoreCase: 1
> 3) AuthPort: 1645
> 4) ReqAcctAuth: 1
> 5) AcctPort: 1646
> 6) Options: 18
> 7) Debug: 0
> 8) ODBCDatasource: Radius
> 9) DataDirectory: ..
> 10) AcctDirectory: ..\acct
> 11) UsersFile: Users
> 12) Username:
> 13) Password:
>
> Param: Debug Level: 15
> Initializing Winsock...
> ODBC Datasource: 'Radius'..
> Allocating ODBC Henv...
> Allocating ODBC Connect...
> Making ODBC Connection...
>
> ....
>
>
> Radius NT is ready to receive requests!
> radrecv: Request from host cf7b9e6f code=4, id=67, length=81
> User-Name = "jimb"
> NAS-Identifier = 207.123.158.111
> NAS-Port = 20102
> Acct-Status-Type = Start
> Acct-Delay-Time = 0
> Acct-Session-Id = "227269455"
> Acct-Authentic = Local
> Framed-Protocol = PPP
> Framed-Address = 207.123.158.194
> Allocating Statement...
>
> SQL Statement: INSERT INTO Calls
> (CallDate,UserName,NASIdentifier,NASPort,AcctS
> tatusType,AcctDelayTime,AcctSessionId,AcctAuthentic,FramedProtocol,Fra
> medAddress ) VALUES
> (Now(),'jimb','207.123.158.111',20102,1,0,'227269455',2,1,'207.123.158
> . 194')
>
> Freeing SQL Statement...
> Allocating Statement...
>
> C:\radius>
>
>
> And this is where Dr. Watson strikes. If I run radius with -x15 -o, I
> get:
>
>
>
>
>
> Radius NT is ready to receive requests!
> radrecv: Request from host cf7b9e6f code=4, id=69, length=81
> User-Name = "jimb"
> NAS-Identifier = 207.123.158.111
> NAS-Port = 20102
> Acct-Status-Type = Start
> Acct-Delay-Time = 123
> Acct-Session-Id = "227269455"
> Acct-Authentic = Local
> Framed-Protocol = PPP
> Framed-Address = 207.123.158.194
> Allocating Statement...
>
> SQL Statement: INSERT INTO Calls
> (CallDate,UserName,NASIdentifier,NASPort,AcctS
> tatusType,AcctDelayTime,AcctSessionId,AcctAuthentic,FramedProtocol,Fra
> medAddress ) VALUES
> (Now(),'jimb','207.123.158.111',20102,1,123,'227269455',2,1,'207.123.1
> 5 8.194')
>
> ODBC: SQLExecDirect Error:
> [Microsoft][ODBC Microsoft Access 97 Driver] The changes you
> requested to the t
> able were not successful because they would create duplicate values in
> the index , primary key,
>
> Response Time: 6375
>
>
> And Dr. Watson strikes again, sometimes after more of the above,
> sometimes immediately.
>
> If Radius is run as a service, Dr. Watson rears his ugly head
> everytime within seconds.
>
> I have populated the ServerPorts table in Access v.7 with ID 5 or 6,
> and Server Ports 20101..20123, and 10101..10123 for each ID.
>
> I *thought* these were the correct values, but this could be my
> problem as well. I was not entirely sure. NAS with ID # 5 has one
> PRI with 24 lines, the ID # 6 one has two PRI's, a total of 48 lines.
>
>
> I've tried to give as much information about the problem as possible,
> sorry for the long message. If any more information would help,
> please let me know. I'm at a loss. The only way I can get Radius to
> Authenticate without crashing is to run it in a DOS Prompt (not a
> service) and use -x15 -o. I also have to disable Acct in both Ascend
> boxes.
>
> Thanks in advance for any help.
>
> - Timothy Stewart.
>
>
>
> -----------------------------------------------------------------------
> Timothy Stewart, | Tel: (614) 427-4500
> Systems Administrator. | Fax: (614) 427-2951
> | Email: tims@baileygrp.com
> The Bailey Group, Inc. | WWW: http://www.baileygrp.com/
> A Full Service Internet Supplier | ICQ UIN: 112818
> -----------------------------------------------------------------------
>
> ----------------------------------------------------------
> RadiusNT Mailing List listserver@emerald.iea.com