Page 1 of 1

WARNING: MYSQL_OPT_RECONNECT is deprecated

Posted: Fri Aug 18, 2023 6:21 pm
by BossyBear
Hello all.

I have been trying different CCTV solutions for my home and it's Zoneminder's turn.

This is a new install on a VM running Ubuntu 22.04.3 LTS, 4 CPU, 16GB RAM, installed from the wiki instructions.

Everything seems to be working for my 3 cameras but I noticed /var/log/apache2/error.log is reporting lots of the same errors.

<snip>...AH01215: WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.: /usr/lib/zoneminder/cgi-bin/nph-zms

apache2 2.4.52
PHP 8.1.2
mariadb-server 10.6
libmysqlclient21 8.0.34

Is this something that needs to be fixed in zm or apache?

Re: WARNING: MYSQL_OPT_RECONNECT is deprecated

Posted: Fri Aug 18, 2023 9:55 pm
by iconnor
It is something for us to fix. They released a securiyt update for mysql which included that notice like 2 days ago. Fix is already in master, will hopefully update 1.36 soon.

Re: WARNING: MYSQL_OPT_RECONNECT is deprecated

Posted: Fri Aug 18, 2023 9:55 pm
by iconnor
I'll get it into proposed ppa maybe tonight.

Re: WARNING: MYSQL_OPT_RECONNECT is deprecated

Posted: Mon Dec 04, 2023 8:49 pm
by ksaye
iconnor wrote: Fri Aug 18, 2023 9:55 pm I'll get it into proposed ppa maybe tonight.
Was this ever pushed to the ppa? I am seeing this error over a month later.

Re: WARNING: MYSQL_OPT_RECONNECT is deprecated

Posted: Sun Dec 17, 2023 10:57 pm
by river100
I installed 1.36.32 in april or may of 2023. do i need to do some kind of update to incorporate this fix? if so how do i do it?

Re: WARNING: MYSQL_OPT_RECONNECT is deprecated

Posted: Mon Dec 18, 2023 10:18 am
by dougmccrary
Current release is 1.36.33, and there's a "proposed" 1.36.34

I think the proposed above became .33 release.