Mailing List Archive

[PATCH] ulogd mysql fix
Hi,

MySQL 5.0 has changed the default for database reconnection after
timeout. It is now not enabled by default. The following patch restores
the reconnection functionnality for the ulogd-mysql plugin.

BR,
--
Éric Leblond, eleblond@inl.fr
Téléphone : 01 44 89 46 39, Fax : 01 44 89 45 01
INL, http://www.inl.fr
Re: [PATCH] ulogd mysql fix [ In reply to ]
Hi Eric,

Eric Leblond wrote:
> MySQL 5.0 has changed the default for database reconnection after
> timeout. It is now not enabled by default. The following patch restores
> the reconnection functionnality for the ulogd-mysql plugin.

Why don't we inconditionally enable it? I mean, we can just forget about
the version checking. If I understood well, mysql <= 5.0 enables
reconnection by default and >= 5.0 doesn't, so we can inconditionally
enable it and forget about future default behaviours. What do you think?

--
"Será preciso viajar a través de los ojos de los idiotas" -- Poeta en
Nueva York -- Federico García Lorca.
Re: [PATCH] ulogd mysql fix [ In reply to ]
Hi,

Le mercredi 01 août 2007 à 15:06 +0200, Pablo Neira Ayuso a écrit :
> Hi Eric,
>
> Eric Leblond wrote:
> > MySQL 5.0 has changed the default for database reconnection after
> > timeout. It is now not enabled by default. The following patch restores
> > the reconnection functionnality for the ulogd-mysql plugin.
>
> Why don't we inconditionally enable it? I mean, we can just forget about
> the version checking. If I understood well, mysql <= 5.0 enables
> reconnection by default and >= 5.0 doesn't, so we can inconditionally
> enable it and forget about future default behaviours. What do you think?

In fact, MYSQL_OPT_RECONNECT option has been introduced in MySQL 5.0.13
to restore the capability to reconnect to server after inactivity.
Furthermore, the functionnality was partially broken before 5.0.19 and
this explains the two calls to mysql_option.

BR,
--
Éric Leblond, eleblond@inl.fr
Téléphone : 01 44 89 46 39, Fax : 01 44 89 45 01
INL, http://www.inl.fr
Re: [PATCH] ulogd mysql fix [ In reply to ]
Eric Leblond wrote:
> In fact, MYSQL_OPT_RECONNECT option has been introduced in MySQL 5.0.13
> to restore the capability to reconnect to server after inactivity.
> Furthermore, the functionnality was partially broken before 5.0.19 and
> this explains the two calls to mysql_option.

Ick! scary thing. Two point less for the mysql guys... Applied, thanks Eric.

--
"Será preciso viajar a través de los ojos de los idiotas" -- Poeta en
Nueva York -- Federico García Lorca.