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

    FreeRadius with MYSQL Redundancy!

    Scheduled Pinned Locked Moved 2.1 Snapshot Feedback and Problems - RETIRED
    1 Posts 1 Posters 1.9k 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.
    • F
      falbertopl
      last edited by

      Good afternoon, I've brought a little inconvenient for you, I have recently configured 2 mysql servers with replication Master - Master, I configured the radius to work with both simultaneously with redundancy, intentionally turned off the master and reapply the radius configuration, the effect was as follows:

      Thu Aug 15 13:28:29 2013 : Error: /usr/pbi/freeradius-amd64/etc/raddb/sql.conf[2]: Instantiation failed for module "sql"
      Thu Aug 15 13:28:29 2013 : Error: /usr/pbi/freeradius-amd64/etc/raddb/sites-enabled/default[185]: Failed to find "sql" in the "modules" section.
      Thu Aug 15 13:28:29 2013 : Error: /usr/pbi/freeradius-amd64/etc/raddb/sites-enabled/default[185]: Failed to parse "sql" entry.
      Thu Aug 15 13:28:29 2013 : Error: /usr/pbi/freeradius-amd64/etc/raddb/sites-enabled/default[69]: Errors parsing authorize section.
      Thu Aug 15 13:28:29 2013 : Error: Failed to load virtual server <default>Thu Aug 15 13:29:01 2013 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
      Thu Aug 15 13:29:01 2013 : Info: rlm_sql (sql): Attempting to connect to radius@172.23.x.x:3306/radius
      Thu Aug 15 13:29:01 2013 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
      Thu Aug 15 13:29:01 2013 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
      Thu Aug 15 13:29:31 2013 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
      Thu Aug 15 13:29:31 2013 : Info: rlm_sql (sql): Attempting to connect to radius@172.23.x.x:3306/radius
      Thu Aug 15 13:29:31 2013 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
      Thu Aug 15 13:29:31 2013 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0

      I was not able to connect to the second database itself was active, I think you should correct that error, if can not connect with one that does immediately with another.

      Maybe I have something wrong.</default>

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