FreeRadius with MYSQL Redundancy!



  • 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>


Log in to reply