Re: SQL db failover

[Rohaizam Abu Bakar]

Just wanna share... I've also configured as below setting (using group) for 
mysql failover.. and its working as well!!...

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 that return OK.. why???

Also before that.. I try to do as suggested in doc... to put "handled" after 
sql2.. and resulting accounting record being resent a few times from 
client.. (testing using NTRadping)..  Can somebody help me on the "handled" 
portion ??

redundant {
   sql1
   sql2
   handled
}
always handled{
   rcode = handled
}
--haizam
----- Original Message ----- 
From: "Michel van Dop" <[EMAIL PROTECTED]>
To: <freeradius-users@lists.freeradius.org>
Sent: Sunday, January 16, 2005 08:04
Subject: Re: SQL db failover


It works!! Yes....
Thanks Alan !!
I replace on every refrence to "sql" this:
       group {
   sql1 {
     fail  = 1
     notfound = return
     noop  = 2
     ok  = return
     updated = 3
     reject = return
     userlock = 4
     invalid = 5
     handled = 6
   }
   sql2 {
     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: <freeradius-users@lists.freeradius.org>
Sent: Saturday, January 15, 2005 8:11 PM
Subject: Re: SQL db failover


Okay good, i replace any refrence to "sql" module and fix it.
But how do i replace this? In "group" or "sql1,sql2" or ?
What's the name of sql1 and sql2 ?
Thank you,
Michel
----- Original Message ----- 
From: "Alan DeKok" <[EMAIL PROTECTED]>
To: <freeradius-users@lists.freeradius.org>
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 : Error: ERROR: Cannot find a configuration 
entry
for module "sql".
 Some part of radiusd.conf has a reference to an "sql" module.  Find
that, fix it, and it should work.
 Alan DeKok.
-
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


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html