Le ven 26/03/2004 à 11:24, Pugnaloni Federico a écrit : > I've found an old patch to cisco_vsa_hack > http://lists.cistron.nl/pipermail/freeradius-devel/2001-August/001181.html This patch (well, a modified version) has already been applied to the 0.9.2 version in Debian Sarge/Sid. I rebuild FreeRADIUS with latest PostgreSQL version anyway, and it seems at least to run.
I will let you know, guys. > i don't know C language so i've applied the patch as it was... > > it works!! > cisco_vsa_hack change > Cisco-AVPair = "ip:source-ip=192.168.0.127" > to > ip:source-ip=192.168.0.127 > > so i've modified sql.conf to store this info on db radacct > and now it's ok > > i don't know if the cisco_vsa_hack now is ok but it seems to works fine > > > -----Messaggio originale----- > > Da: Jérôme Warnier [mailto:[EMAIL PROTECTED] > > Inviato: giovedì 25 marzo 2004 19:30 > > A: '[EMAIL PROTECTED]' > > Oggetto: Re: MySQL accounting and Cisco-AVPair > > > > > > 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~/radius > d/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