Help RadiusNT and ACC Tigris Access Servers

William Salame ( williams@kbd.com.au )
Sun, 14 Jun 1998 01:30:20 +1000

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=186, length=195
User-Name = "terry"
NAS-Port = 27
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
NAS-Port-DNIS = "92890100"
Caller-Id = "92890100"
NAS-Identifier = "203.27.92.251"
Acct-Status-Type = Start
Acct-Delay-Time = 3
Acct-Session-Id = "960827.005947.000487"
Acct-Authentic = RADIUS
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Framed-Address = 255.255.255.254
Idle-Timeout = 1800

SQL Statement: INSERT INTO Calls
(CallDate,UserName,NASPort,NASPortType,UserService,Fra
medProtocol,NASPortDNIS,NASIdentifier,AcctStatusType,AcctDelayTime,AcctSessionId,FramedA

ddress) VALUES
(GetDate(),'terry',27,0,2,1,'92890100','203.27.92.251',1,3,'960827.005947

..000487','255.255.255.254')

Sending Accounting Ack of id 186 to cb1b5cfb (203.27.92.251)

Resp Time: 961 Auth: 173/35 -> 208 Acct: 70/45/10 -> 125

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
radrecv: Request from host cb1b5cfb code=4, id=188, length=69
NAS-Identifier = "203.27.92.251"
Acct-Status-Type = 7
Acct-Delay-Time = 35056
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,35056,'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: 230 Auth: 173/35 -> 208 Acct: 70/47/10 -> 127

radrecv: Request from host cb1b5cfb code=4, id=189, length=69
NAS-Identifier = "203.27.92.251"
Acct-Status-Type = 7
Acct-Delay-Time = 35059
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,35059,'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: 230 Auth: 173/35 -> 208 Acct: 70/48/10 -> 128