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
