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 #0I 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>