Re: Authentication / Calls table

Dale E. Reed Jr. ( (no email) )
Thu, 03 Sep 1998 11:24:13 -0700

Annabel Mwansa wrote:
>
> 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
>
> ODBC Error:37000:264:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Column name
> NASIdentifier appears more than once in the result column list.

Go into your Database and change AttributeID #32 from NAS-Identifier
to NAS-ID2 in the RadAttributes table and restart RadiusNT. It
should then start recording the data.

> 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

-- 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