Authentication / Calls table

Annabel Mwansa ( amwansa@zamnet.zm )
Sat, 12 Sep 1998 13:41:24 +0200

Radius is authenticating but the calls table is not being updated. I've
included some information from the account and authentication logs. Can
anyone help?

The Accounting log

Resp Time: 30 Auth: 68/15 -> 51 Acct: 0/6701/0 -> 6701
radrecv: Request from host d0e0b006 code=4, id=99, length=247
Acct-Session-Id = "0f000087"
User-Name = "aesl"
NAS-Identifier = 208.224.176.6
NAS-Port = 1
Acct-Status-Type = Stop
Acct-Session-Time = 482
Acct-Terminate-Cause = User-Request
Acct-Authentic = RADIUS
NAS-Identifier = "usr1-lk"
Acct-Input-Octets = 4244
Acct-Output-Octets = 571
Acct-Input-Packets = 35
Acct-Output-Packets = 0
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 196.7.240.136
Acct-Delay-Time = 392
ODBC Error:37000:264:
[Microsoft][ODBC SQL Server Driver][SQL Server]Column name
NASIdentifier appears more than once in the result column list.

Resp Time: 30 Auth: 68/15 -> 51 Acct: 0/6702/0 -> 6702
radrecv: Request from host d0e0b006 code=4, id=102, length=247
Acct-Session-Id = "0f00008a"
User-Name = "aesl"
NAS-Identifier = 208.224.176.6
NAS-Port = 1
Acct-Status-Type = Stop
Acct-Session-Time = 250
Acct-Terminate-Cause = User-Request
Acct-Authentic = RADIUS
NAS-Identifier = "usr1-lk"
Acct-Input-Octets = 2305
Acct-Output-Octets = 242
Acct-Input-Packets = 27
Acct-Output-Packets = 0
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 196.7.240.136
Acct-Delay-Time = 0
ODBC Error:37000:264:
[Microsoft][ODBC SQL Server Driver][SQL Server]Column name
NASIdentifier appears more than once in the result column list.

Authentication log

Resp Time: 60 Auth: 36/1 -> 19 Acct: 7/1/0 -> 8
radrecv: Request from host d0e0b006 code=1, id=154, length=196
User-Name = "ermmofed"
Challenge-Response =
"\001\257\027-\355V\223\376\317\213V\303\033<!\215M"
NAS-IP-Address = 208.224.176.6
NAS-Port = 16
User-Service = Framed-User
Framed-Protocol = PPP
NAS-Identifier = "usr1-lk"
Acct-Session-Id = "03030001"
NAS-Port-Type = Async
Checking user record PW_PASSWORD type
authChapPwd
Sending Ack of id 154 to d0e0b006 (208.224.176.6)
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 255.255.255.254
Framed-Netmask = 255.255.255.255
Framed-Routing = None
Framed-Compression = 0
Framed-Filter = "dialin"
Framed-MTU = 1006

Resp Time: 20 Auth: 38/1 -> 20 Acct: 7/1/0 -> 8
radrecv: Request from host d0e0b006 code=4, id=155, length=215
Acct-Session-Id = "03030001"
User-Name = "ermmofed"
NAS-IP-Address = 208.224.176.6
NAS-Port = 16
Acct-Status-Type = Start
Acct-Authentic = RADIUS
NAS-Identifier = "usr1-lk"
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 208.224.178.43
Acct-Delay-Time = 0
Sending Accounting Ack of id 155 to d0e0b006 (208.224.176.6)

Resp Time: 50 Auth: 38/1 -> 20 Acct: 8/1/0 -> 9
radrecv: Request from host d0e0b006 code=4, id=156, length=249
Acct-Session-Id = "0f0000db"
User-Name = "lilayi"
NAS-IP-Address = 208.224.176.6
NAS-Port = 1
Acct-Status-Type = Stop
Acct-Session-Time = 1852
Acct-Terminate-Cause = 1
Acct-Authentic = RADIUS
NAS-Identifier = "usr1-lk"
Acct-Input-Octets = 85146
Acct-Output-Octets = 1554952
Acct-Input-Packets = 2535
Acct-Output-Packets = 2611
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 208.224.178.42
Acct-Delay-Time = 0