Freeradius not starting at boot when use mysql as database



  • hi guys

    I use freeradius + mysql + CP for accounting my users on pfsense 2.1
    A problem exist  and that is "the freeradius don't start when pfsense restarted and must start it manually after bootup"

    Of course  these lines loged in General log on startup

    Jan 10 16:28:58 radiusd[27236]: Failed to load virtual server <default>Jan 10 16:28:58 radiusd[27236]: /usr/pbi/freeradius-i386/etc/raddb/sites-enabled/default[69]: Errors parsing authorize section.
    Jan 10 16:28:58 radiusd[27236]: /usr/pbi/freeradius-i386/etc/raddb/sites-enabled/default[185]: Failed to parse "sql" entry.
    Jan 10 16:28:58 radiusd[27236]: /usr/pbi/freeradius-i386/etc/raddb/sites-enabled/default[185]: Failed to find "sql" in the "modules" section.
    Jan 10 16:28:58 radiusd[27236]: /usr/pbi/freeradius-i386/etc/raddb/sql.conf[2]: Instantiation failed for module "sql"
    Jan 10 16:28:58 radiusd[27236]: rlm_sql (sql): Closing sqlsocket 0
    Jan 10 16:28:58 radiusd[27236]: rlm_sql (sql): Closing sqlsocket 1
    Jan 10 16:28:58 radiusd[27236]: rlm_sql (sql): Closing sqlsocket 2
    Jan 10 16:28:58 radiusd[27236]: rlm_sql (sql): Closing sqlsocket 3
    Jan 10 16:28:58 radiusd[27236]: rlm_sql (sql): Closing sqlsocket 4
    Jan 10 16:28:58 radiusd[27236]: Failed to load clients from SQL.
    Jan 10 16:28:58 radiusd[27236]: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0
    Jan 10 16:28:58 radiusd[27236]: rlm_sql (sql): Failed to connect DB handle #0
    Jan 10 16:28:58 radiusd[27236]: rlm_sql_mysql: Mysql error 'Can't connect to MySQL server on '127.0.0.1' (60)'
    Jan 10 16:28:58 radiusd[27236]: rlm_sql_mysql: Couldn't connect socket to MySQL server radius@127.0.0.1:radius</default>

    It look like that before run mysql, freeradius want to connect to it that is cause this problem

    Can any one help me that how solve this problem?

    Thanks alot



  • Can any one help me?


Log in to reply