Mysql failover

Luis Galán radius at claranet.es
Fri Mar 16 12:09:29 CET 2007


Hello!

I have configured mysql failover on my Freeradius and it seems to do 
starnge things.

1.- If my mysql server 1 is down and mysql server 2 is up. And I try to 
start the freeradius daemon, it returns me an error like that:

Fri Mar 16 12:06:37 2007 : Info: Using deprecated naslist file.  Support 
for this will go away soon.
Fri Mar 16 12:06:37 2007 : Info: rlm_exec: Wait=yes but no output 
defined. Did you mean output=none?
Fri Mar 16 12:06:37 2007 : Info: rlm_sql (sql1): Driver rlm_sql_mysql 
(module rlm_sql_mysql) loaded and linked
Fri Mar 16 12:06:37 2007 : Info: rlm_sql (sql1): Attempting to connect 
to raduser1 at mysql01.es.clara.net:/radius
Fri Mar 16 12:06:37 2007 : Info: rlm_sql_mysql: Starting connect to 
MySQL server for #0
Fri Mar 16 12:06:37 2007 : Error: rlm_sql_mysql: Couldn't connect socket 
to MySQL server raduser1 at mysql01.es.clara.net:radius
Fri Mar 16 12:06:37 2007 : Error: rlm_sql_mysql: Mysql error 'Can't 
connect to MySQL server on 'mysql01.es.clara.net' (111)'
Fri Mar 16 12:06:37 2007 : Error: rlm_sql (sql1): Failed to connect DB 
handle #0
Fri Mar 16 12:06:37 2007 : Info: rlm_sql (sql1): There are no DB handles 
to use! skipped 5, tried to connect 0
Fri Mar 16 12:06:37 2007 : Error: rlm_sql (sql1): generate_sql_clients() 
returned error
Fri Mar 16 12:06:37 2007 : Error: radiusd.conf[14]: sql1: Module 
instantiation failed.
Fri Mar 16 12:06:37 2007 : Error: radiusd.conf[1590] Unknown module "sql1".
Fri Mar 16 12:06:37 2007 : Error: radiusd.conf[1590] Failed to parse 
"sql1" subsection.
Fri Mar 16 12:06:37 2007 : Error: radiusd.conf[1517] Failed to parse 
authorize section.


2.- If I start freeradius daemon and my 2 mysql server is up, all works 
fine (obviously), but if my mysql server 1 fails, freeradius still works 
(Great!!).

Then it seems that the problem is only at the start time. Is it Right?
Is it a bug?
Do I have misconfigured  anything?


Any idea?

Thanks.

Luis






More information about the Freeradius-Users mailing list