autostart script for FreeRADIUS

[Doug Hardie]

On Mar 29, 2009, at 20:10, Tseveendorj wrote:

> May be I got the problem why radiusd didn't come up.
>
> I found following error in the radiusd.log
>
> Fri Mar 27 20:09:43 2009 : Info: rlm_sql (sql): Driver rlm_sql_mysql  
> (module rlm_sql_mysql) loaded and linked
> Fri Mar 27 20:09:43 2009 : Info: rlm_sql (sql): Attempting to  
> connect to root at localhost:/billing
> Fri Mar 27 20:09:43 2009 : Info: rlm_sql_mysql: Starting connect to  
> MySQL server for #0
> Fri Mar 27 20:09:43 2009 : Error: rlm_sql_mysql: Couldn't connect  
> socket to MySQL server root at localhost:billing
> Fri Mar 27 20:09:43 2009 : Error: rlm_sql_mysql: Mysql error 'Can't  
> connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
> Fri Mar 27 20:09:43 2009 : Error: rlm_sql (sql): Failed to connect  
> DB handle #0
> Fri Mar 27 20:09:43 2009 : Info: rlm_sql (sql): There are no DB  
> handles to use! skipped 5, tried to connect 0
> Fri Mar 27 20:09:43 2009 : Error: Failed to load clients from SQL.
> Fri Mar 27 20:09:43 2009 : Error: /usr/local/etc/raddb/sql.conf[22]:  
> Instantiation failed for module "sql"
> Fri Mar 27 20:09:43 2009 : Error: /usr/local/etc/raddb/sites-enabled/ 
> default[149]: Failed to find module "sql".
> Fri Mar 27 20:09:43 2009 : Error: /usr/local/etc/raddb/sites-enabled/ 
> default[62]: Errors parsing authorize section.
> Fri Mar 27 20:09:43 2009 : Error: Errors initializing modules
>
> In my config FreeRADIUS must work with MySQL but from the log  
> freeradius couldn't connect to mysql server.
> I thought that is problem. isn't it ?


There lies the problem.  It would appear that MySQL is not running  
when FreeRADIUS starts.  Check through the messages log to seen what  
the startup order is.  I suspect its backwards.