Re: Help RadiusNT and ACC Tigris Access Servers

Dale E. Reed Jr. ( (no email) )
Sat, 13 Jun 1998 23:16:14 -0700

William Salame wrote:
>
> Hi,
>
> We are running Radius NT 2.2 along with emerald 2.1.11,
> We Had Ascend MAX 4060 and Portmasters Livingstones, unfortunately the
> Ascend
> boxes blew ups
> and we had to replace them over the weekend.
> We replaced them with ACC Tigris Access Servers, and we have some
> problems
> with it. It is Authenticating
> but doesn't send the accounting Information to the SQL database.
> The Livingston are working fine without any errors.
> At first we had a problem with the Acct-Session-Id We had to increase
> It's size
>
> from 10 Bytes to 20 Bytes, Now that is solved.
> We have a different problem now, It doesn't seem to send the NAS Port
> or the
> Username to the database
>
> There's a copy of the Radius Log
> If any one running radiusNT with ACC Tigris
>
> radrecv: Request from host cb1b5cfb code=4, id=187, length=69
> NAS-Identifier = "203.27.92.251"
> Acct-Status-Type = 7
> Acct-Delay-Time = 35053
> Acct-Session-Id = "960826.151536.000000"
>
> SQL Statement: INSERT INTO Calls
> (CallDate,NASIdentifier,AcctStatusType,AcctDelayTime,A
> cctSessionId, UserName) VALUES
> (GetDate(),'203.27.92.251',7,35053,'960826.151536.000000'
> ,'NULL')
>
> ODBC: SQLExecDirect Error 233:
> [Microsoft][ODBC SQL Server Driver][SQL Server]The column NASPort in
> table
> Calls may no
> t be null.
>
> Resp Time: 241 Auth: 173/35 -> 208 Acct: 70/46/10 -> 126

What you are seeing is an Accounting-ON request. You should
upgrade to RadiusNT 2.5, as it handles these correctly.

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com