Bug #79825 for DBD-mysql: Trigger Callback on auto

Mon Sep 24 02:04:45 2012 sewi [...] cpan.org - Ticket created

Subject:

Trigger Callback on auto_reconnect

Applications run into timezone problems when using mysql_auto_reconnect with mySQL "SET time_zone": http://www.pal-blog.de/entwicklung/mysql/2012/mysql-mysql_auto_reconnect- timezone-issues.html A Callback trigger (either a new one or the DBI connect Callback) would be great to re-set options like the time_zone.

Wed Oct 31 19:21:23 2012 chrishammond [...] ymail.com - Correspondence added

From:

chrishammond [...] ymail.com

On Mon Sep 24 02:04:45 2012, SEWI wrote: Show quoted text

> Applications run into timezone problems when using

mysql_auto_reconnect Show quoted text

> with mySQL "SET time_zone": > http://www.pal-blog.de/entwicklung/mysql/2012/mysql-

mysql_auto_reconnect- Show quoted text

> timezone-issues.html > > A Callback trigger (either a new one or the DBI connect Callback)

would Show quoted text

> be great to re-set options like the time_zone.

add this (available since DBD::mysql 4.013) to your connect() options hash and it'll automagically get executed whenever libmysqlclient connects (or autoreconnects) under the covers of DBD::mysql: { ... mysql_init_command => 'SET time_zone="Europe/Helsinki"', mysql_auto_reconnect => 1, ... }

Wed Oct 31 19:21:25 2012 The RT System itself - Status changed from 'new' to 'open'

Sat Aug 20 09:02:53 2016 MICHIELB [...] cpan.org - Status changed from 'open' to 'resolved'

Sat Aug 20 09:02:59 2016 MICHIELB [...] cpan.org - Fixed in 4.013 added

Sun Aug 21 16:02:18 2016 sewi [...] cpan.org - Correspondence added

Am Mi 31. Okt 2012, 19:21:23, chrishammond schrieb: Show quoted text

> add this (available since DBD::mysql 4.013) to your connect() options > hash and it'll automagically get executed whenever libmysqlclient > connects (or autoreconnects) under the covers of DBD::mysql: > > { ... > mysql_init_command => 'SET time_zone="Europe/Helsinki"', > mysql_auto_reconnect => 1, > ... } >

Doesn't help. The init_command fixes the time_zone problem, but there are many other session variables, etc. which can't be set in a single command. That's why init_command is no solution to the problem. A callback would be able to full restore the state of the connection, init_command doesn't.

Sun Aug 21 16:02:19 2016 sewi [...] cpan.org - Status changed from 'resolved' to 'open'

Wed Nov 15 02:50:13 2017 MICHIELB [...] cpan.org - Correspondence added

Ticket migrated to github as https://github.com/perl5-dbi/DBD-mysql/issues/191

Wed Nov 15 02:50:14 2017 MICHIELB [...] cpan.org - Status changed from 'open' to 'resolved'

Bug #79825 for DBD-mysql: Trigger Callback on auto_reconnect