matching on IP Address

[King, Adam]

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.