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

R: Help me out, waiting 4 response

2004-03-26 Thread Pugnaloni Federico 
You have to compile freeradius with mysql support
on my freebsd machine it's non enable by default

try 

make clean
make WITH_MYSQL 
make install

or make -DWITH_MYSQL install

 -Messaggio originale-
 Da: arshad shah [mailto:[EMAIL PROTECTED]
 Inviato: venerdi 26 marzo 2004 13:29
 A: [EMAIL PROTECTED]
 Oggetto: Help me out, waiting 4 response
 
 
 Hi Dear,
 is there any one other who like to help me, i have complied already 
 freeradius on linux 8.0. I have installed mysql and i want to 
  connect my 
 Freeradius 0.9.3 with mysql database.  But when i run my 
 radius by the 
 command
 
   /usr/local/sbin/radiud -x
 then it shows the following error message (during loading sql)
 
 rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found
 rlm_sql (sql): Make sure it (and all its dependent 
 libraries!) are in the 
 search path of your system's ld.
 radiusd.conf[14]: sql: Module instantiation failed.
 
 Initially i took help from the material on the site that is
 

 http://www.frontios.com/freeradius.html
 
 I have read the help file but couldn't get and i am standing 
 on the same 
 position .
 So please help me out of this as soon as possible. Thanx
 regards
 Arshad Shah
 
 _
 MSN 8 with e-mail virus protection service: 2 months FREE* 
 http://join.msn.com/?page=features/virus
 
 
 - 
 List info/subscribe/unsubscribe? See 
 http://www.freeradius.org/list/users.html
 

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

MySQL accounting and Cisco-AVPair

2004-03-22 Thread Pugnaloni Federico 
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