[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freeradius-users
Subject:    Re: Cisco-AVPair. Question!
From:       Eddie Stassen <eddie () saix ! net>
Date:       2004-01-29 13:10:36
Message-ID: 4019064C.7000805 () saix ! net
[Download RAW message or body]

Chelisant Pavel wrote:
> Good day! I ve got radius server installed on my FreeBSD.
> All auth logs i receive from Cisco router stored in MYSQL DB
> Here the info i  write down in mysql :
> example :
> NAS-IP-Address = 192.168.200.8
>         NAS-Port = 179
>         Cisco-NAS-Port = "Async179"
>         NAS-Port-Type = Async
>         User-Name = "depcomcor"
>         Acct-Status-Type = Stop
>         Acct-Authentic = RADIUS
>         Service-Type = Framed-User
>         Acct-Session-Id = "00000413"
>         Framed-Protocol = PPP
>         Framed-IP-Address = 192.168.223.6
>         Acct-Terminate-Cause = Lost-Carrier
>         Acct-Input-Octets = 188282
>         Acct-Output-Octets = 257069
>         Acct-Input-Packets = 884
>         Acct-Output-Packets = 916
>         Acct-Session-Time = 541
>  //its all ok till this   moment
>    How i should configure sql.conf to store subordinate info??
>         Cisco-AVPair = "disc-cause-ext=1011"
>         Cisco-AVPair = "pre-bytes-in=112"
>         Cisco-AVPair = "pre-bytes-out=171"
>         Cisco-AVPair = "pre-paks-in=4"
>         Cisco-AVPair = "pre-paks-out=8"
>         Cisco-AVPair = "pre-session-time=51"
>         Cisco-AVPair = "connect-progress=60"
>         Cisco-AVPair = "nas-rx-speed=26400"
>         Cisco-AVPair = "nas-tx-speed=12000"
>         Acct-Delay-Time = 0
> Thank you!

Last time I looked you could'nt do this.  I presume you are mainly 
interested in things like tx/rx speed.  In that case you can specify the 
'non-standard' option in you radius-server configs on the NAS, which 
will make the NAS send Ascend equivalent attributes instead of the 
Cisco-AVPairs.  You can then store the Ascend stuff in your database. 
Here is a typical stop record using

radius-server host 1.2.3.4 auth-port 1645 acct-port 1646 non-standard

on the NAS:

Wed Jan 28 00:00:01 2004
         Acct-Session-Id = "000372DD"
         Framed-Protocol = PPP
         Framed-IP-Address = x.x.x.x
         Acct-Authentic = RADIUS
         Acct-Terminate-Cause = Lost-Carrier
         X-Ascend-Disconnect-Cause = 11
         X-Ascend-Connect-Progress = 60
         X-Ascend-PreSession-Time = 26
         X-Ascend-Xmit-Rate = 28800
         X-Ascend-Data-Rate = 48000
         Acct-Session-Time = 1657
         Acct-Input-Octets = 115908
         Acct-Output-Octets = 2329924
         X-Ascend-Pre-Input-Octets = 214
         X-Ascend-Pre-Output-Octets = 99
         Acct-Input-Packets = 1463
         Acct-Output-Packets = 2007
         X-Ascend-Pre-Input-Packets = 6
         X-Ascend-Pre-Output-Packets = 4
         User-Name = "user@realm"
         Acct-Status-Type = Stop
         Calling-Station-Id = "0123456"
         Called-Station-Id = "0123456"
         NAS-Port-Type = Async
         NAS-Port = 176
         Connect-Info = "48000/28800 V90/V44/LAPM (48000/26400)"
         Service-Type = Framed-User
         NAS-IP-Address = x.x.x.x


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[prev in list] [next in list] [prev in thread] [next in thread]