WARNING: MYSQL_OPT_RECONNECT is deprecated

Discussions related to the 1.36.x series of ZoneMinder
Post Reply
BossyBear
Posts: 1
Joined: Fri Aug 18, 2023 6:10 pm

WARNING: MYSQL_OPT_RECONNECT is deprecated

Post 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?
User avatar
iconnor
Posts: 3197
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: WARNING: MYSQL_OPT_RECONNECT is deprecated

Post 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.
User avatar
iconnor
Posts: 3197
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: WARNING: MYSQL_OPT_RECONNECT is deprecated

Post by iconnor »

I'll get it into proposed ppa maybe tonight.
ksaye
Posts: 1
Joined: Mon Dec 04, 2023 8:39 pm

Re: WARNING: MYSQL_OPT_RECONNECT is deprecated

Post 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.
river100
Posts: 145
Joined: Sun Oct 07, 2007 5:52 pm
Location: Louisiana

Re: WARNING: MYSQL_OPT_RECONNECT is deprecated

Post 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?
dougmccrary
Posts: 1322
Joined: Sat Aug 31, 2019 7:35 am
Location: San Diego

Re: WARNING: MYSQL_OPT_RECONNECT is deprecated

Post by dougmccrary »

Current release is 1.36.33, and there's a "proposed" 1.36.34

I think the proposed above became .33 release.
Post Reply