I have Radius 2.5 Authentication working fine however Accounting isn't.
When I access the record for my "test" user, no details of his connections
are recorded. The User-on-line doesn't work either.
Here's an excerpt from my accounting log:-
radrecv: Request from host cb3a192e code=4, id=20, length=139
Acct-Status-Type = Start
Acct-Session-Id = "35A19CC7D6"
Acct-Delay-Time = 0
User-Name = "terry"
NAS-Identifier = "comserv2"
NAS-Port = 3
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 203.58.25.47
Framed-Routing = Broadcast-Listen
Framed-MTU = 1500
Framed-Compression = Van-Jacobsen-TCP-IP
Framed-Compression = 2
Framed-IPX-Network = 0
Framed-AppleTalk-Network = 0
Idle-Timeout = 600
Session-Timeout = 0
SQL Statement: INSERT INTO Calls
(CallDate,AcctStatusType,AcctSessionId,AcctDelayTime,UserName,NASIdentifier,
NASPort,NASPortType,UserService,FramedProtocol,FramedAddress) VALUES
(GetDate(),1,'35A19CC7D6',0,'terry','comserv2',3,0,2,1,'203.58.25.47')
Sending Accounting Ack of id 20 to cb3a192e (comserv2)
Resp Time: 50 Auth: 3/2 -> 5 Acct: 5/0/0 -> 5
radrecv: Request from host cb3a192e code=4, id=21, length=103
Acct-Status-Type = Stop
Acct-Session-Id = "35A19CC7D6"
Acct-Delay-Time = 0
User-Name = "terry"
NAS-Identifier = "comserv2"
NAS-Port = 3
Acct-Input-Octets = 3006
Acct-Output-Octets = 5365
Acct-Input-Packets = 29
Acct-Output-Packets = 46
Acct-Session-Time = 93
Acct-Terminate-Cause = 0
SQL Statement: INSERT INTO Calls
(CallDate,AcctStatusType,AcctSessionId,AcctDelayTime,UserName,NASIdentifier,
NASPort,AcctInputOctets,AcctOutputOctets,AcctSessionTime,AcctTerminateCause)
VALUES (GetDate(),2,'35A19CC7D6',0,'terry','comserv2',3,3006,5365,93,0)
Sending Accounting Ack of id 21 to cb3a192e (comserv2)
Resp Time: 30 Auth: 3/2 -> 5 Acct: 6/0/0 -> 6
I remember reading some documentation on SQL Security setup but cannot find
the documentation again. I suspect I have not set the privledges properly.
Glen.
--------------------------------------------------------------------
AQUARIUS Communications for all your Internet<>Fidonet needs
<>Full ISP services<>FrontDoor Commercial<>TransX Internet/FTSC Mailer
voice(02)9977-3788<>fax(02)9977-3844<>bbs(02)9977-2855<>3:714/930
http://www.aquarius.com.au <> mailto:sales@aquarius.com.au