no start of radiusd after reboot : mysql connection error

mailinglists mailinglists at e-tera.com
Thu Feb 7 10:10:55 CET 2008


Hello,
I use freeradius-1.1.3-1.2.el5 and freeradius-mysql-1.1.3-1.2.el5. the 
mysql database (mysql-server-5.0.22-2.1.0.1) is hosted on a remote host 
(both centos5).
When I use /etc/init.d/radiusd as root it starts up correctly. But when 
the service is launched at boot time, I get this error-log :

Wed Feb  6 16:17:46 2008 : Info: Using deprecated naslist file.  Support 
for this will go away soon.
Wed Feb  6 16:17:46 2008 : Info: rlm_exec: Wait=yes but no output 
defined. Did you mean output=none?
Wed Feb  6 16:17:46 2008 : Info: rlm_sql (sql): Driver rlm_sql_mysql 
(module rlm_sql_mysql) loaded and linked
Wed Feb  6 16:17:46 2008 : Info: rlm_sql (sql): Attempting to connect to 
radius at 192.168.1.1:/radius
Wed Feb  6 16:17:46 2008 : Info: rlm_sql_mysql: Starting connect to 
MySQL server for #0
Wed Feb  6 16:17:49 2008 : Error: rlm_sql_mysql: Couldn't connect socket 
to MySQL server radius at 192.168.1.1:radius
Wed Feb  6 16:17:49 2008 : Error: rlm_sql_mysql: Mysql error 'Can't 
connect to MySQL server on '192.168.1.1' (113)'
Wed Feb  6 16:17:49 2008 : Error: rlm_sql (sql): Failed to connect DB 
handle #0
Wed Feb  6 16:17:49 2008 : Info: rlm_sql (sql): There are no DB handles 
to use! skipped 5, tried to connect 0
Wed Feb  6 16:17:49 2008 : Error: rlm_sql (sql): generate_sql_clients() 
returned error
Wed Feb  6 16:17:49 2008 : Error: radiusd.conf[14]: sql: Module 
instantiation failed.
Wed Feb  6 16:17:49 2008 : Error: radiusd.conf[1844] Unknown module "sql".
Wed Feb  6 16:17:49 2008 : Error: radiusd.conf[1773] Failed to parse 
authorize section.

I set a tcpdump on the mysql-server host, and during the boot of my freeradius server, I see no traffic comming from freeradius host.
There is no reject in the firewall.
I've tried to put the radius rc.d script in S99 to start it as late as possible, but nothing changes.
I also noticed that it doesen't seem to retry to connect to the database later. Or is it after a long time ?
Is this a bug ?
Where is the retry time configured (I cant try to set up to 5 seconds) ?

Thanks for answers

Laetitia.




More information about the Freeradius-Users mailing list