Connection details for sql1 are incorrect. Ivan Kalik Kalik Informatika ISP Dana 18/6/2008, "King, Adam" <adam.king@intechnology.com> piše:
I have an if statement that checks if the Packet-Src-IP-Address matches that of the ones in the database table and the same process for the realm, before processing a user. This works fine to a local database, however I need redundancy setting up and it fails to authenticate to the second database but it does appear to connect. In the sites-enabled/default file I have: if("%{sql: SELECT COUNT(nas_ip) FROM `nas_ip` WHERE nas_ip='%{Packet-Src-IP-Address}' AND realm='%{Realm}'}" >0 ) { redundant { sql1 sql2 } }
In radiusd.conf under instantiate { ......
Redundant { Sql1 Sql2 Handled } }
And $INCLUDE sql1.conf $INCLUDE sql2.conf
With the connection info for the databases in those 2 files. The output of radiusd -X is in the txt file attached Any help on how to get this working would be much appreciated.
Adam King Network Engineer adam.king@intechnology.com
InTechnology plc Support 0845 120 7070 Telephone 01423 850000 Facsimile 01423 858866 www.intechnology.com * Harrogate, Reading, London * 200 people, ?50m p.a. turnover * Over 500 corporate clients * Specialist Business Solutions & Services Provider
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.