Yup that’s what I'm getting also... now.. I'm glad I'm not alone....
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Edgars Sent: Wednesday, September 29, 2004 11:30 AM To: [EMAIL PROTECTED] Subject: Re: SQL db failover i'm also trying to make this configuration. But something doesn't stick together. i've added the following lines in the modules section: sql sql1 { } sql sql2 { } but when starting the server the following appears: ................ Module: Instantiated preprocess (preprocess) radiusd.conf[11] Failed to link to module 'rlm_sql1': rlm_sql1.so: cannot open shared object file: No such file or directory where could be the problem? thanks! Edgars Kostas Kalevras wrote: >On Tue, 28 Sep 2004, Paul wrote: > > > >>What i need is failover for accounting and session tracking. >>Auth will be done using LDAP. >> >>Mirroring the DB is not possibe because accounting has alot of inserts, >>that would need to have multi-master replication. >> >>I would like to use application data mirroring instead, having 2 >>databases and both servers writing(acct)to both but not fail unless >>both databases are not accessible, reading (session) from local >>only and failover to the other DB in case of failure only. >> >> > >For accounting replication your best choise is radrelay. For failover, just use >a failover section in radiusd.conf > >session{ > redundant{ > sql1 > sql2 > } > [...] >} > >authorize{ > [...] > redundant{ > ldap1 > ldap2 > } >} > >We have a similar setup working just fine in the Greek School Network (two >radius servers, serving different regions but keeping full accounting). > >-- >Kostas Kalevras Network Operations Center >[EMAIL PROTECTED] National Technical University of Athens, Greece >Work Phone: +30 210 7721861 >'Go back to the shadow' Gandalf > >- >List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.768 / Virus Database: 515 - Release Date: 9/22/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.768 / Virus Database: 515 - Release Date: 9/22/2004 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

