redundant_sql

King, Adam adam.king at intechnology.com
Wed Jun 18 14:59:02 CEST 2008


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.
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: a1.txt
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20080618/9911c51a/attachment.txt>


More information about the Freeradius-Users mailing list