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 = "[EMAIL PROTECTED]"
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
