WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version

bloatedstoat

• November 09, 2023 21:20

Hello, mySQL version 8.0.35 CloudLinux v8.8.0 STANDARD standard cPanel Version 114.0.11 Is there a way to silence the "WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version" ? The line is heavily spamming /usr/local/apache/logs/error_log. Is this a client library issue? We use PHP's mysqli to connect to databases. Thank you.

• 

  cPRex Jurassic Moderator

  • November 10, 2023 16:50

  Hey hey! While not related to cPanel, it doesn't look like there is a way around this if that value is present in the code of your site: The only way to stop that from showing up seems to be to fix the code.

  0
• 

  bloatedstoat

  • November 15, 2023 08:02

  Thanks for your reply. I saw the two posts that you link to and within one the following is posted from August this year: The problem seems to be at the libmysqlclient21 library that has been recently updated. Either this library should not emit a warning when the MYSQL_OPT_RECONNECT option is set to false, or BDB::mysql should not set the option at all instead of setting it to false. Have the latest version of libdbd-mysql-perl. Very nasty problem for high traffic web sites error logs that run Perl scripts. Hoping they will fix it soon or I will start migrating to other things. This appears to infer that the issue is related to a Perl library and not user website code as suggested in your post above. All I'd like to know is, is there a way to suppress it? It's heavily spamming log files. Do we wait for an update to the library or is it a brutal case of "put up with it"? Anyone? Thanks.

  0
• 

  cPRex Jurassic Moderator

  • November 15, 2023 14:10

  I'm not aware of away to suppress that, no.

  0

Please sign in to leave a comment.