I've found an old patch to cisco_vsa_hack http://lists.cistron.nl/pipermail/freeradius-devel/2001-August/001181.html
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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html