RE: Cisco-AVPair store in MySQL4/freeradius1.0.0

2004-07-13 Thread Mikhail Stepanov 
Look at that:

 |  5 | cit-10| cisco-avpair| += | ip:addr-pool=pool-10

|  6 | cit-10| cisco-avpair| += | ip:dns-servers*10.48.4.5
10.48.4.3


man 5 users

 Attribute += Value
Always matches as a check item, and  adds  the  current
attribute
with value to the list of configuration items.
As a reply item, it has an identical meaning, but the attribute
is
added to the reply items.

It means that if you want to return more than one attribute of the same
type, you have to use += instead of = in the Op field.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Matthias
Wolf
Sent: Monday, July 12, 2004 9:39 PM
To: [EMAIL PROTECTED]
Subject: AW: Cisco-AVPair store in MySQL4/freeradius1.0.0


Where and why: += instead of =.?

Thanks, M. Wolf


-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Im Auftrag von Mikhail
Stepanov
Gesendet: Montag, 12. Juli 2004 16:23
An: [EMAIL PROTECTED]
Betreff: RE: Cisco-AVPair store in MySQL4/freeradius1.0.0

  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
...
 But FreeRadius;sql.conf .'%{Cisco-AVPair}', . still returns only the 
 first instance of Cisco-AVPair. (ip:source-ip=192.168.0.127)

Usually I write += instead of =. Works fine.



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alan DeKok
Sent: Monday, July 12, 2004 6:07 PM
To: [EMAIL PROTECTED]
Subject: Re: Cisco-AVPair store in MySQL4/freeradius1.0.0 

Matthias Wolf [EMAIL PROTECTED] wrote:
 had spent many time reading the FAQ but I'm still searching the solve 
 for Cisco-AVPair (PIX 525-Accounting) insert into Mysql database.
 
...
 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
...
 But FreeRadius;sql.conf .'%{Cisco-AVPair}', . still returns only the 
 first instance of Cisco-AVPair. (ip:source-ip=192.168.0.127)

  That's the intended behavior.

  In the latest CVS snapshots, you can use:

  %{Cisco-AVPair[0]} is the same as %{Cisco-AVPair}
  %{Cisco-AVPair[1]) is the next one
  %{Cisco-AVPair[2]) is the next one, etc.

  Alan DeKok.

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


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




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


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

RE: Cisco-AVPair store in MySQL4/freeradius1.0.0

2004-07-13 Thread Mikhail Stepanov 
Ok, so far everything right. But how to modifying my sql-string?

Like that, perhaps: ... , '%{cisco-avpair}') ...? 

I can't understand what do you want to do. You needn't to modify any
sql-queries in freeradius. It returns all AV-pairs automatically.


Mikhail Stepanov.


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

Re: Cisco-AVPair store in MySQL4/freeradius1.0.0

2004-07-12 Thread Amit Gupta 



My friends,

I have to make choice between GNUradius and 
freeradius. My requirements are generally those of ISP. Which one will you 
recommend to me???

Amit Gupta

---Outgoing mail is certified Virus 
Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.718 / 
Virus Database: 474 - Release Date: 7/9/2004

Re: Cisco-AVPair store in MySQL4/freeradius1.0.0

2004-07-12 Thread Alan DeKok 
Matthias Wolf [EMAIL PROTECTED] wrote:
 had spent many time reading the FAQ but I'm still searching the solve for
 Cisco-AVPair (PIX 525-Accounting) insert into Mysql database.
 
...
 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
...
 But FreeRadius;sql.conf .'%{Cisco-AVPair}', . still returns only the first 
 instance of Cisco-AVPair. (ip:source-ip=192.168.0.127)

  That's the intended behavior.

  In the latest CVS snapshots, you can use:

  %{Cisco-AVPair[0]} is the same as %{Cisco-AVPair}
  %{Cisco-AVPair[1]) is the next one
  %{Cisco-AVPair[2]) is the next one, etc.

  Alan DeKok.

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

RE: Cisco-AVPair store in MySQL4/freeradius1.0.0

2004-07-12 Thread Mikhail Stepanov 
  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
...
 But FreeRadius;sql.conf .'%{Cisco-AVPair}', . still returns only the 
 first instance of Cisco-AVPair. (ip:source-ip=192.168.0.127)

Usually I write += instead of =. Works fine.



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alan DeKok
Sent: Monday, July 12, 2004 6:07 PM
To: [EMAIL PROTECTED]
Subject: Re: Cisco-AVPair store in MySQL4/freeradius1.0.0 

Matthias Wolf [EMAIL PROTECTED] wrote:
 had spent many time reading the FAQ but I'm still searching the solve 
 for Cisco-AVPair (PIX 525-Accounting) insert into Mysql database.
 
...
 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
...
 But FreeRadius;sql.conf .'%{Cisco-AVPair}', . still returns only the 
 first instance of Cisco-AVPair. (ip:source-ip=192.168.0.127)

  That's the intended behavior.

  In the latest CVS snapshots, you can use:

  %{Cisco-AVPair[0]} is the same as %{Cisco-AVPair}
  %{Cisco-AVPair[1]) is the next one
  %{Cisco-AVPair[2]) is the next one, etc.

  Alan DeKok.

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


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