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
--------------7D5211DBA960BDEABEC6F34C
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for William Salame
Content-Disposition: attachment; filename="vcard.vcf"
begin: vcard
fn: William Salame
n: Salame;William
org: Knowledge by Design
adr: Suite 201;;683 George St;Sydney ;NSW;2000;Australia
email;internet: william@kbd.com.au
title: Mr
tel;work: +61 2 92121381
tel;fax: +61 2 92125727
x-mozilla-cpt: ;0
x-mozilla-html: FALSE
version: 2.1
end: vcard
--------------7D5211DBA960BDEABEC6F34C--