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 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
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@lists.koha-community.org> On Behalf Of David Cook Sent: Wednesday, 16 August 2023 2:36 PM To: koha-devel@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 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
You can see it in changelog : http://changelogs.ubuntu.com/changelogs/pool/universe/libd/libdbd-mysql-perl... 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@lists.koha-community.org> *On Behalf Of *David Cook *Sent:* Wednesday, 16 August 2023 2:36 PM *To:* koha-devel@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@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@biblibre.com> Software and system maintainer 🦄 BibLibre, France
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@lists.koha-community.org> On Behalf Of Fridolin SOMERS Sent: Tuesday, 22 August 2023 4:47 AM To: koha-devel@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... 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@lists.koha-community.org> *On Behalf Of *David Cook *Sent:* Wednesday, 16 August 2023 2:36 PM *To:* koha-devel@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@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@biblibre.com> Software and system maintainer 🦄 BibLibre, France _______________________________________________ Koha-devel mailing list Koha-devel@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/
participants (2)
-
David Cook -
Fridolin SOMERS