autostart script for FreeRADIUS

[Luciano Afranllie]

On Mon, Mar 30, 2009 at 6:53 AM, Tseveendorj <tseveendorj at gmail.com> wrote:
> Doug Hardie wrote:
>>
>> 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.

Check your /etc/rcx.d where x is your default runlevel. mysql should
have a lower S number than freeRadius.

Regards
Luciano