matching on IP Address

[King, Adam]

Hi, thanks for the help so far, the match based on the ip and the realm now works! As mentioned below the redundant section from the sites-enabled/default file does not process so the if statement needs sql1: or sql2: in there instead of sql: and the redundant section picking up on the live server. In radiusd.conf there are 2 lines saying $INCLUDE sql1.conf and $INCLUDE sql2.conf. How can I get this working?
Thanks again


 

Adam King
Network Engineer
adam.king at intechnology.com


InTechnology plc
Support 0845 120 7070
Telephone 01423 850000
Facsimile 01423 858866
www.intechnology.com
 
-----Original Message-----

From: freeradius-users-bounces+adam.king=intechnology.co.uk at lists.freeradius.org [mailto:freeradius-users-bounces+adam.king=intechnology.co.uk at lists.freeradius.org] On Behalf Of Ivan Kalik
Sent: 17 June 2008 13:50
To: FreeRadius users mailing list
Subject: RE: matching on IP Address

In 2.0 you can also use unlang to update the request:

http://freeradius.org/radiusd/man/unlang.html

Ivan Kalik
Kalik Informatika ISP


Dana 17/6/2008, "King, Adam" <adam.king at intechnology.com> piše:

>I have switched it to sql1: so the statement now reads
>if("%{sql1: SELECT COUNT(nas_ip) FROM `nas_ip` WHERE
>nas_ip='%{Packet-Src-IP-Address}' AND realm='adam'}" >0 ) {
>redundant {
>sql1
>sql2
>}
>}
>Obviously the redundant section isn't being picked up at the moment
>which is why it needed to be sql1: or sql2: thanks for that (I will come
>back to the redundant section at the moment
>What I need to work out now is how to have the realm working as a
>variable eg ... AND realm='%{realm}'}"...
>I am reading the freeradius wiki, specifically
>http://wiki.freeradius.org/Adding%2C_Removing%2C_Modifying_Attributes_fo
>r_further_processing
>Is this the best way to go about this? Assuming the way I am approaching
>this is possible?!
>Thanks again
>
>
>
>
>Adam King
>Network Engineer
>adam.king at intechnology.com
>
This is an email from InTechnology plc, Central House, Beckwith Knowle, Harrogate, UK, HG3 1UG. Registered in England 3916586.

The contents of this message may be privileged and confidential. If you have received this message in error, you may not use,

disclose, copy or distribute its content in anyway. Please notify the sender immediately.

All messages are scanned for all viruses.