27 Oct
2005
27 Oct
'05
12:47 a.m.
On 26-10-2005 17:35, yserge wrote:
On Wed, 2005-10-26 at 22:35 +0200, Jan Janak wrote:
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.
On 26-10-2005 15:33, yserge wrote:
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. 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 ?