RE : Fail over mysql backend

2004-09-21 Thread EROS
I've tried to let the sql {} but it said rlm_sql_sql is not a valid sql
driver or something like that.



-Message d'origine-
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] De la part de Alan
DeKok
Envoyé : lundi 20 septembre 2004 21:11
À : [EMAIL PROTECTED]
Objet : Re: RE : Fail over mysql backend 


EROS [EMAIL PROTECTED] wrote:
 If you need redondant your sql1 and sql2 .conf must be :

 You should remove the sql { }
 
 Tis is what i've must done to make this working

  I *really* don't recommend doing that.  If it works, it's an accident,
and the server is NOT intended to work that way.

  Please follow the directions in doc/configurable_failover, and NOT
the above instructions.

  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


Fail over mysql backend

2004-09-20 Thread Cris Boisvert
I 'm trying to setup Freeradius with 2 sql servers for a  failover.

In the radiusd.conf
In the authorize section I have
redundant{
sql
sql2
}

Then I start it I get 

Mon Sep 20 08:37:16 2004 : Info: rlm_sql (sql): Attempting to connect to
[EMAIL PROTECTED]:/database
Mon Sep 20 08:37:16 2004 : Info: rlm_sql_mysql: Starting connect to MySQL
server for #0
Mon Sep 20 08:37:16 2004 : Info: rlm_sql_mysql: Starting connect to MySQL
server for #1
Mon Sep 20 08:37:16 2004 : Info: rlm_sql_mysql: Starting connect to MySQL
server for #2
Mon Sep 20 08:37:16 2004 : Info: rlm_sql_mysql: Starting connect to MySQL
server for #3
Mon Sep 20 08:37:16 2004 : Info: rlm_sql_mysql: Starting connect to MySQL
server for #4
Mon Sep 20 08:37:16 2004 : Error: radiusd.conf[14] Failed linking to
rlm_sql2 structure in radiusd.conf: /usr/lib/rlm_sql2.so: undefined symbol:
rlm_sql2

It can link to the first database although when it tries to connect to the
second it has problems.
Looking for another instance of rlm_sql.so

Thanx
Cris


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.755 / Virus Database: 505 - Release Date: 9/8/2004
 


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


Re: Fail over mysql backend

2004-09-20 Thread Alan DeKok
Cris Boisvert [EMAIL PROTECTED] wrote:
 In the radiusd.conf
 In the authorize section I have
 redundant{
 sql
 sql2
 }

  Ok...

 Mon Sep 20 08:37:16 2004 : Error: radiusd.conf[14] Failed linking to
 rlm_sql2 structure in radiusd.conf: /usr/lib/rlm_sql2.so: undefined symbol:
 rlm_sql2

  Please read doc/configurable_failover.  It contains examples of
doing this.

  Alan DeKok.

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



RE : Fail over mysql backend

2004-09-20 Thread EROS
A standard sql.conf is :

Sql { 
...
...
...
}

If you need redondant your sql1 and sql2 .conf must be :

...
... 
...

You should remove the sql { } 

Tis is what i've must done to make this working


-Message d'origine-
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] De la part de Alan
DeKok
Envoyé : lundi 20 septembre 2004 16:23
À : [EMAIL PROTECTED]
Objet : Re: Fail over mysql backend 


Cris Boisvert [EMAIL PROTECTED] wrote:
 In the radiusd.conf
 In the authorize section I have
 redundant{
 sql
 sql2
 }

  Ok...

 Mon Sep 20 08:37:16 2004 : Error: radiusd.conf[14] Failed linking to 
 rlm_sql2 structure in radiusd.conf: /usr/lib/rlm_sql2.so: undefined 
 symbol: rlm_sql2

  Please read doc/configurable_failover.  It contains examples of doing
this.

  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


Re: RE : Fail over mysql backend

2004-09-20 Thread Alan DeKok
EROS [EMAIL PROTECTED] wrote:
 If you need redondant your sql1 and sql2 .conf must be :
...
 You should remove the sql { }
 
 Tis is what i've must done to make this working

  I *really* don't recommend doing that.  If it works, it's an
accident, and the server is NOT intended to work that way.

  Please follow the directions in doc/configurable_failover, and NOT
the above instructions.

  Alan DeKok.


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