[Serusers] REGISTER attempt when db is down

Jan Janak jan at iptel.org
Wed Oct 26 23:47:40 CEST 2005


On 26-10-2005 17:35, yserge wrote:
> On Wed, 2005-10-26 at 22:35 +0200, Jan Janak wrote:
> > On 26-10-2005 15:33, yserge wrote:
> > > With recently changed behavior of MySQL the reconnection scheme of SER
> > > ( and I am running SER 0.9.4 and MySQL 5.0.13 )  would no longer work..
> > > It's OK, that can be fixed with slight correction of MySQL configuration
> > > or with minor change in SER code..
> > 
> >   Could you elaborate on this ?
> 
> Sure, my understanding is that starting from MySQL version 5.0.6 ( or
> around that ) the default behavior of MySQL has changed and once the
> connection has timed out on inactivity, it could not longer be
> reused/reconnected. Between MySQL 5.0.6 and 5.0.12  the only way to beat
> that was to explicitly set up  a property "wait_timeout" to something
> very high ( like 10000000) in my.cnf file. That's what I was doing in my
> case.
> 
> Since MySQL version 5.0.13 the behavior can be controlled and you can
> enable reconnection by explicitly calling mysql_set_server_option() with
> a new MYSQL_OPT_RECONNECT option.. ( and that is what I meant by "minor
> change in SER code" )
> 
> If neither thing is done, then with MySQL 5.0.6 or later, once
> disconnected on timeout,  it looked like SER would never reconnect. 
  
  Thanks for such an extensive info. I created SER-80 at
  http://bugs.sip-router.org to make sure I do not forget and will fix
  it once I manage to get access to such a database for testing.

    Jan.




More information about the sr-users mailing list