On Tue, 2004-09-28 at 15:16, 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.
Also forgot to mention that both servers would be used, since they are
in 2 different locations used by 2 different access servers that are in
the same POP.
> Thanx
> Paul
>
> On Tue, 2004-09-28 at 13:19, Cris Boisvert wrote:
> > I have been trying to do the same thing I have the references in the
> > radius.conf as notated in the Doc's although I cannot get it to
> > Connect to the second sql server
> > I have this in the radius.conf
> >
> > $INCLUDE ${confdir}/sql.conf
> > $INCLUDE ${confdir}/sql2.conf
> >
> > modules {
> > sql sql {
> > }
> > sql sql2 {
> > }
> > always handled {
> > rcode = handled
> > }
> > }
> >
> > I'm guessing I'm doing something wrong. Any help would be great..
> >
> > I just need it to authenticate off one database and fail to the other if the
> > first is unavailable ...
> > All accounting can be written to the first databse... I'm not worried about
> > that for now..
> >
> > Thanx
> >
> >
> >
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of EROS
> > Sent: Tuesday, September 28, 2004 12:53 PM
> > To: [EMAIL PROTECTED]
> > Subject: SQL db failover
> >
> > In doc/configurable_failover you have your answer.
> >
> > I've tried the same schema you wanna do and it works perfectly
> > The mirroring between the two mysql db work with the replication
> > mechanism of mysql (read the mysql doc) and I have two sql.conf to
> > describe the way to connect to each db and right config on radiusd.conf
> > to tell it how using this two db.
> >
> > If you want some more help ask ...
> >
> >
> > :]
> >
> > -----Message d'origine-----
> > De : [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] De la part de Paul
> > Envoy� : mardi 28 septembre 2004 18:12
> > � : [EMAIL PROTECTED]
> > Objet : SQL db failover
> >
> >
> >
> > Hi folks.
> >
> >
> > We need to have a 2 server deployment with accounting and session
> > tracking using an SQL db (mysql or postgres).
> >
> > What i would like to do is:
> >
> > - Each server has a local DB running
> > - Both DB's should have data synchronized for sessino tracking
> > - All accounting is written to local DB and remote DB with the
> > following logic: write local then remote, if local fails ignore
> > failure, for session query only local DB, if local fails then query
> > the remote DB.
> >
> > Anyone tried something simillar ? Any suggestions to
> > sql.conf/radiusd.conf syntax ?
> >
> > Thanx
> > Paul
> >
> >
> >
> > -
> > 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
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
