Le lun 22/03/2004 à 11:47, Pugnaloni Federico a écrit :
> 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?
Does the following help you?
http://www.freeradius.org/cgi-bin/cvsweb.cgi/~checkout~/radiusd/src/billing/README?rev=1.5&content-type=text/plain
>
> --
> Federico Pugnaloni
--
Jérôme Warnier
Consultant
BeezNest
http://beeznest.net
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
