Re: Have anyone a good example failover mysql config?

Michel van Dop Fri, 28 Jan 2005 11:31:17 -0800

Strange! But thank you, for linking me the bug!

I reed in the bug report a solutions, i change this:

       $INCLUDE  ${confdir}/sql1.conf
       $INCLUDE  ${confdir}/sql2.conf
authorize {
       redundant {
               sql1 {
                       ok = return
               }
               sql2
       }
}

accounting {
       redundant {
               sql1 {
                       ok = return
               }
               sql2
       }
}

But same problems ??? Can any one send a working failover config?

Fri Jan 28 20:11:13 2005 : Info: rlm_sql (sql1): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Fri Jan 28 20:11:13 2005 : Info: rlm_sql (sql1): Attempting to connect to [EMAIL PROTECTED]:/db Fri Jan 28 20:11:13 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0 Fri Jan 28 20:14:22 2005 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:db Fri Jan 28 20:14:22 2005 : Error: rlm_sql_mysql: Mysql error 'Can't connect to MySQL server on '192.168.160.10' (110)' Fri Jan 28 20:14:22 2005 : Error: rlm_sql (sql1): Failed to connect DB handle #0 Fri Jan 28 20:14:22 2005 : Info: rlm_sql (sql2): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Fri Jan 28 20:14:22 2005 : Info: rlm_sql (sql2): Attempting to connect to [EMAIL PROTECTED]:/db Fri Jan 28 20:14:22 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0 Fri Jan 28 20:14:22 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1 Fri Jan 28 20:14:22 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2 Fri Jan 28 20:14:22 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3 Fri Jan 28 20:14:22 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4 Fri Jan 28 20:14:22 2005 : Info: Listening on IP address *, ports 1812/udp and 1813/udp. Fri Jan 28 20:14:22 2005 : Info: Ready to process requests.

----- Original Message ----- From: "Nicolas Baradakis" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, January 28, 2005 6:37 PM Subject: Re: Have anyone a good example failover mysql config?

Michel van Dop wrote:

When i shutdown mysql (sql1) he get slow on starting (240 seconds) and
after 20 times i get a response.
Both mysql servers are working! I test it on a single db radius config.


[...]

accounting {
   redundant {
   sql1
   sql2
 }
}


"redundant" stanza doesn't work in the accounting section.
It's a known bug, see http://bugs.freeradius.org/show_bug.cgi?id=173

--
Nicolas Baradakis

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Have anyone a good example failover mysql config?

Reply via email to