Hi,
i'm using FreeRADIUS Version 0.9.3on FreeBSD 4.9
i'm using with a Cisco PIX to AAA internet access
it works fine, but i need to store the Cisco-AVPair info in radacct SQL
table.
As i can see in the detail accounting freeradius store Cisco-AVPair info
-snip-
Cisco-AVPair = "ip:source-ip=192.168.0.127"
Cisco-AVPair = "ip:source-port=4051"
Cisco-AVPair = "ip:destination-ip=10.10.10.1"
Cisco-AVPair = "ip:destination-port=23"
-snip
but i cannot store this info on sql
I've tried to modify sql.conf as is:
accounting_stop_query_alt = "INSERT into ${acct_table2} (RadAcctId,
AcctSessionId... AcctStopDelay) values('', '%{Acct-Session-Id}',
'%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}',
'%{NAS-IP-Address}', '%{NAS-Port}'... '%{Cisco-AVPair}',
'%{Cisco-AVPair}'..}')"
but it returns only the first instance of Cisco-AVPair
("ip:source-ip=192.168.0.127")
how can i store all the values?
--
Federico Pugnaloni
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
