Wrong. The statement needs hose prefixes because those are the names of defined sql instances. In the default file the if statement has the sql1: or sql2: prefix as if it is left as the sql: prefix it doesn't seem to read the redundant section to connect to the 2nd database.
Let me guess: instances start with sql1 {... and not sql sql1 {...
Actually no, in the sql1.conf file I have sql sql1 { and in the sql2.conf file I have sql sql2 { 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.o rg [mailto:freeradius-users-bounces+adam.king=intechnology.co.uk@lists.free radius.org] On Behalf Of Ivan Kalik Sent: 17 June 2008 17:46 To: FreeRadius users mailing list Subject: RE: matching on IP Address
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:
Wrong. The statement needs hose prefixes because those are the names of defined sql instances.
In radiusd.conf there are 2 lines saying $INCLUDE sql1.conf and $INCLUDE sql2.conf. How can I get this working?
Let me guess: instances start with sql1 {... and not sql sql1 {... Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html 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.