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.
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
