Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Freeradius not starting at boot when use mysql as database

    Scheduled Pinned Locked Moved pfSense Packages
    2 Posts 1 Posters 1.1k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • N
      new_in_pf
      last edited by

      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

      1 Reply Last reply Reply Quote 0
      • N
        new_in_pf
        last edited by

        Can any one help me?

        1 Reply Last reply Reply Quote 0
        • First post
          Last post
        Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.