Hmm - think I saw an earlier posting (it's in the archives) about this very subject!
I think you want to take a look at the configurable_failover file in the doc directory where you untarred the freeradius package - it describes what you are looking for... .... gm... ----- Original Message ----- From: "Ali Asghar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 21, 2004 5:55 PM Subject: Problem setting up Radius to use Primary and Secondary Mysql Databases . > Hi all .. > > Radius = R1 > MySql Prim = DB1 > Mysql Sec = DB2 > > i am unable to configure Radius to operate in fail over to DB2 incase > DB1 goes down . > > The configuration details are as follows. > > 1) In radiusd.conf i am doing an include on sql1.conf and sql2.conf. > $INCLUDE ${confdir}/sql1.conf > $INCLUDE ${confdir}/sql2.conf > These two files exist in the correct location . > > 2) In Radiusd.conf 's " authorize" section i have replaced "sql" > entry with the following lines > group { > sql1 { > fail = 1 > notfound = return > noop = 2 > ok = return > updated = 3 > reject = return > userlock = 4 > invalid = 5 > handled = 6 > } > sql2 { > fail = 1 > notfound = return > noop = 2 > ok = return > updated = 3 > reject = return > userlock = 4 > invalid = 5 > handled = 6 > } > } > On starting the server in debug mode i get the following errors .. > > Module: Instantiated preprocess (preprocess) > Module: Loaded realm > realm: format = "suffix" > realm: delimiter = "@" > Module: Instantiated realm (suffix) > ERROR: Cannot find a configuration entry for module "sql1". > > Can any one tell me if i am missing some thing in the configuration . > ??? (~ ~ ) > > o > > FYI ... I was able to make single mysql server work with radius > successfully . And as a second step i was in the process of adding > mysql redundency . So basically all my tables , data etc etc works > fine in the same arrangemnet . > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > --- > [This E-mail scanned for viruses by Declude Ant-Virus Scanner] > > --- [This E-mail scanned for viruses by Declude Ant-Virus Scanner] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html