redundant_sql

[Ivan Kalik]

Connection details for sql1 are incorrect.

Ivan Kalik
Kalik Informatika ISP


Dana 18/6/2008, "King, Adam" <adam.king at 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 at 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.
>
>