[Koha-devel] WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.

[David Cook]

I knew that it was "supposed" to fix it. I just haven't personally confirmed that it "definitely" fixes it haha. 

But there have been lots of people on the Github issue that have said it has fixed it for them so it seems pretty safe.

That said, pali (the 2nd biggest contributor to  DBD::mysql) has said that the fix used by Ubuntu isn't enough and he has an alternative set of patches to use. 

Interesting seeing this all play out upstream...

David Cook
Senior Software Engineer
Prosentient Systems
Suite 7.03
6a Glen St
Milsons Point NSW 2061
Australia

Office: 02 9212 0899
Online: 02 8005 0595

-----Original Message-----
From: Koha-devel <koha-devel-bounces at lists.koha-community.org> On Behalf Of Fridolin SOMERS
Sent: Tuesday, 22 August 2023 4:47 AM
To: koha-devel at lists.koha-community.org
Subject: Re: [Koha-devel] WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.

You can see it in changelog :
http://changelogs.ubuntu.com/changelogs/pool/universe/libd/libdbd-mysql-perl/libdbd-mysql-perl_4.050-3ubuntu0.2/changelog

Le 17/08/2023 à 13:24, David Cook a écrit :
> Letting folks know that Ubuntu have released a patched 
> libdbd-mysql-perl which claims to have fixed the issue.
> 
> I haven’t confirmed that it fixes it myself, but it should be a 
> trivial change, so I imagine that it does.
> 
> David Cook
> 
> Senior Software Engineer
> 
> Prosentient Systems
> 
> Suite 7.03
> 
> 6a Glen St
> 
> Milsons Point NSW 2061
> 
> Australia
> 
> Office: 02 9212 0899
> 
> Online: 02 8005 0595
> 
> *From:*Koha-devel <koha-devel-bounces at lists.koha-community.org> *On 
> Behalf Of *David Cook
> *Sent:* Wednesday, 16 August 2023 2:36 PM
> *To:* koha-devel at lists.koha-community.org
> *Subject:* [Koha-devel] WARNING: MYSQL_OPT_RECONNECT is deprecated and 
> will be removed in a future version.
> 
> Hi all,
> 
> If you’re using Ubuntu, you may have noticed this message filling up 
> your logs.
> 
> It looks like Ubuntu recently released a version of libmysqlclient21 
> which outputs this warning message if you try to set MYSQL_OPT_RECONNECT.
> 
> DBD::mysql sets it to false and therein lies the problem: 
> https://github.com/perl5-dbi/DBD-mysql/issues/354
> <https://github.com/perl5-dbi/DBD-mysql/issues/354>
> 
> At a glance, the only real short-term option seems to be to downgrade 
> the MySQL client, but keeping my eyes open…
> 
> David Cook
> 
> Senior Software Engineer
> 
> Prosentient Systems
> 
> Suite 7.03
> 
> 6a Glen St
> 
> Milsons Point NSW 2061
> 
> Australia
> 
> Office: 02 9212 0899
> 
> Online: 02 8005 0595
> 
> 
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : https://www.koha-community.org/ git : 
> https://git.koha-community.org/ bugs : 
> https://bugs.koha-community.org/

--
Fridolin SOMERS <fridolin.somers at biblibre.com> Software and system maintainer 🦄
BibLibre, France
_______________________________________________
Koha-devel mailing list
Koha-devel at lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/