matching on IP Address

[Ivan Kalik]

You have multiple sql instances. Are you sure that instance called
"sql" is connecting to that database? Or should it be sql1: or sql2:?

Ivan Kalik
Kalik Informatika ISP


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

>Yes, the database name is 'radius' and the table name is 'nas_ip'. Confusingly at this testing stage the field in the table is also called 'nas_ip'
>Thanks
>
>
> 
>
>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 11:50
>To: FreeRadius users mailing list
>Subject: Re: matching on IP Address
>
>Is that table in the database sql instance is connecting to?
>
>Ivan Kalik
>Kalik Informatika ISP
>
>
>Dana 17/6/2008, "King, Adam" <adam.king at intechnology.com> piše:
>
>>Hi,
>>I am running this query:
>>if ("%{sql: SELECT COUNT(nas_ip) FROM `nas_ip` WHERE
>>nas_ip='127.0.0.1'}">0){
>>redundant {
>>sql1
>>sql2
>>}
>>}
>>
>>But the if ("%{sql: SELECT COUNT(nas_ip) FROM `nas_ip` WHERE
>>nas_ip='127.0.0.1'}">0) section always returns false even though the
>>database has the 'nas_ip' table containing 127.0.0.1 as the data
>>Any ideas?
>>Thanks
>>
>>
>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.
>
>-
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>