Re: R: MySQL accounting and Cisco-AVPair

2004-03-29 Thread Jérôme Warnier 
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.5content-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

R: MySQL accounting and Cisco-AVPair

2004-03-26 Thread Pugnaloni Federico 
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.5content-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