Rohaizam Abu Bakar wrote:
>>> How can we possible do to ensure only when sql1 down.. then the
>>> accounting will be sent to sql2..??
>>
>> You might try a different approach:
>> - store accounting in "detail" files (man rlm_detail)
>> - run radsqlrelay to send accounting in the database (get
Thanks.. Will try it out...
Do I need to make any addition/changes in Makefile to compile
radsqlrelay...? If yes... What changes is needed..
thanks..
--haizam
- Original Message -
From: "Nicolas Baradakis" <[EMAIL PROTECTED]>
To:
Sent: Monday, January 24, 2005 19:16
Sub
Rohaizam Abu Bakar wrote:
> How can we possible do to ensure only when sql1 down.. then the accounting
> will be sent to sql2..??
You might try a different approach:
- store accounting in "detail" files (man rlm_detail)
- run radsqlrelay to send accounting in the database (get it from a
tart & stop record being sent to
different mysql
thanks..
--haizam
- Original Message -
From: "Rohaizam Abu Bakar" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, January 18, 2005 11:30
Subject: Re: SQL db failover
One more thing related to SQL accounting...
Everytime I r
FramedIPAddress, AcctStartDelay, AcctStopDelay) values('442225381',
'18e9d9976b13739f', '', '', '161.142.17
.2', '10202', 'Sync', DATE_SUB('2005-01-18 10:39:34', INTERVAL (0 + 0)
SECOND), '2005-01-18 10:39:34', '', '',
'
"Rohaizam Abu Bakar" <[EMAIL PROTECTED]> wrote:
> But before that.. I tried to use the simplified one using "redundant" as
> below:-
>
> redundant {
> sql1
> sql2
> }
>
> But seems everytime accounting record being sent.. I will store in both of
> the mysql server... not the first one t
y help me on the "handled"
portion ??
redundant {
sql1
sql2
handled
}
always handled{
rcode = handled
}
--haizam
- Original Message -
From: "Michel van Dop" <[EMAIL PROTECTED]>
To:
Sent: Sunday, January 16, 2005 08:04
Subject: Re: SQL db failover
I
"Michel van Dop" <[EMAIL PROTECTED]> wrote:
> Okay good, i replace any refrence to "sql" module and fix it.
> But how do i replace this? In "group" or "sql1,sql2" or ?
You probably want the group.
> What's the name of sql1 and sql2 ?
sql1 and sql2.
Alan DeKok.
-
List info/subscribe/unsu
fail = 1
notfound = return
noop = 2
ok = return
updated = 3
reject = return
userlock = 4
invalid = 5
handled = 6
}
}
- Original Message -
From: "Michel van Dop" <[EMAIL PROTECTED]>
To:
Sent: Saturday, January 15, 2005 8:11 PM
Su
:
Sent: Saturday, January 15, 2005 5:58 PM
Subject: Re: SQL db failover
"Michel van Dop" <[EMAIL PROTECTED]> wrote:
Okay i understand that ( i hope so):
Now i do this in radiusd.conf:
Yup, that should work.
I get this error cat /var/log/radius/radius.log
Sat Jan 15 13:35:19 2005
"Michel van Dop" <[EMAIL PROTECTED]> wrote:
> Okay i understand that ( i hope so):
> Now i do this in radiusd.conf:
Yup, that should work.
> I get this error cat /var/log/radius/radius.log
> Sat Jan 15 13:35:19 2005 : Error: ERROR: Cannot find a configuration entry
> for module "sql".
Some
Hi,
I have to run TWO MySQL servers and have FreeRadius fall over between them
modules {
# same place where this $INCLUDE ${confdir}/sql.conf
$INCLUDE ${confdir}/sql1.conf
$INCLUDE ${confdir}/sql2.conf
On 'authorize' section of radiusd.conf i change the 'sql' entry to a
'group' one:
group {
To:
Sent: Saturday, January 15, 2005 1:26 AM
Subject: Re: SQL db failover
"Michel van Dop" <[EMAIL PROTECTED]> wrote:
So i leave the default config in radiusd.conf include the file sql.conf
and put this in my radiusd.conf:
$INCLUDE ${confdir}/sql.conf
modules {
Once again,
"Michel van Dop" <[EMAIL PROTECTED]> wrote:
> So i leave the default config in radiusd.conf include the file sql.conf
> and put this in my radiusd.conf:
>
> $INCLUDE ${confdir}/sql.conf
>
> modules {
Once again, the include for sql.conf MUST BE INSIDE of the "modules"
section. It's there i
# try module sql1
sql2 # if that's down, try module sql2
handled # otherwise drop the request as
# it's been "handled" by the "always"
# module (see doc/rlm_always)
}
}
Thats it? Thank you to support me.
Michel
- Original Message -----
From:
Michel van Dop <[EMAIL PROTECTED]> wrote:
> I use freeradius-0.9.3-1.1 and freeradius-mysql-0.9.3-1.1 I now this is old
> but this is the last stap!
I would suggest upgrading. See http://www.freeradius.org/security.html
> I have this in the radiusd.conf
>
> $INCLUDE ${confdir}/sql.conf
> $
On Thu, 30 Sep 2004, Edgars wrote:
> ok, thanks for the input.
> So, what can someone suggest what configuration should i add only for
> such a case: if sql1 is down then go and search for the user to sql2?
Your question has already been answered. Just replace accounting with authorize.
authoriz
ok, thanks for the input.
So, what can someone suggest what configuration should i add only for
such a case: if sql1 is down then go and search for the user to sql2?
Edgars
Alan DeKok wrote:
"Cris Boisvert" <[EMAIL PROTECTED]> wrote:
$INCLUDE ${confdir}/sql.conf
$INCLUDE ${confdir}/sql2.conf
On Behalf Of Kostas
Kalevras
Sent: Wednesday, September 29, 2004 12:33 PM
To: [EMAIL PROTECTED]
Subject: RE: SQL db failover
On Wed, 29 Sep 2004, Cris Boisvert wrote:
> I have this in my radiusd.conf now. I get this error when I try to start
> radius
>
>
> Wed Sep 29 12:00:27
"Cris Boisvert" <[EMAIL PROTECTED]> wrote:
> $INCLUDE ${confdir}/sql.conf
> $INCLUDE ${confdir}/sql2.conf
>
> modules {
> sql sql {
> }
> sql sql2 {
> }
The $INCLUDE ${confdir}/sql.conf should be INSIDE of the modules{}
section, which means you don't need to have TWO d
On Wed, 29 Sep 2004, Cris Boisvert wrote:
> I have this in my radiusd.conf now. I get this error when I try to start
> radius
>
>
> Wed Sep 29 12:00:27 2004 : Info: rlm_sql_mysql: Starting connect to MySQL
> server for #0
> Wed Sep 29 12:00:27 2004 : Info: rlm_sql_mysql: Starting connect to MySQL
I have this in my radiusd.conf now. I get this error when I try to start
radius
Wed Sep 29 12:00:27 2004 : Info: rlm_sql_mysql: Starting connect to MySQL
server for #0
Wed Sep 29 12:00:27 2004 : Info: rlm_sql_mysql: Starting connect to MySQL
server for #1
Wed Sep 29 12:00:27 2004 : Info: rlm_sql_
On Wed, 29 Sep 2004, Paul wrote:
> On Wed, 2004-09-29 at 08:55, 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 accountin
On Wed, 2004-09-29 at 08:55, 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 hav
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
"Cris Boisvert" <[EMAIL PROTECTED]> 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 ${co
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] Fai
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
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 applicati
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
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
31 matches
Mail list logo
