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