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@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@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
Luis Galán wrote: ...
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: ... 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?
It's arguably a bug. The server could be a little more forgiving of databases that are down. On the other hand, if your databases are down, then the server can't really authenticate anyone, can it? Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog
Hello! Yes it can authenticate trough mysql server number 2. But it both mysql server are down, obviously it can't. Luis Alan DeKok escribió:
Luis Galán wrote: ...
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:
...
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?
It's arguably a bug. The server could be a little more forgiving of databases that are down.
On the other hand, if your databases are down, then the server can't really authenticate anyone, can it?
Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
I would rather keep it as it is, as it is a problem to be looked at and can be identified by the logs. Kind Regards Etienne Network Administrator Luis Galán wrote:
Hello!
Yes it can authenticate trough mysql server number 2. But it both mysql server are down, obviously it can't.
Luis
Alan DeKok escribió:
Luis Galán wrote: ...
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:
...
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?
It's arguably a bug. The server could be a little more forgiving of databases that are down.
On the other hand, if your databases are down, then the server can't really authenticate anyone, can it?
Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Le Fri, Mar 16, 2007 at 04:28:52PM +0200, Etienne Pretorius ecrivait:
I would rather keep it as it is, as it is a problem to be looked at and can be identified by the logs.
And what if the first mysql server goes down right before receiving a SIGHUP because of logrotate ? Regards, Fox.
participants (4)
-
Alan DeKok -
Etienne Pretorius -
Fox -
Luis Galán