RE : Fail over mysql backend
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
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
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
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
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