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@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@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@lists.freeradius.org [mailto:freeradius-users-bounces+adam.king=intechnology.co.uk@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@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