Bug #81406 [Opn]: MYSQLI_CLIENT_COMPRESS does not work with aurora MySQL Compatible

Edit report at https://bugs.php.net/bug.php?id=81406&edit=1 ID: 81406 User updated by: martin dot barker at thisisbeacon dot com Reported by: martin dot barker at thisisbeacon dot com Summary: MYSQLI_CLIENT_COMPRESS does not work with aurora MySQL Compatible Status: Open Type: Bug Package: MySQLi related Operating System: Windows 10/11 PHP Version: 8.0.10 Block user comment: N Private report: N New Comment: So I was using PHP 8 locally on windows, and connecting to an Aurora RDS via an SSL VPN (Whatgaurd's Mobile VPN with SSL client), and to confirm it was not the SSL VPN i used MySQL Workbench and that worked. I also did not get a failure to connect error from PHP, Previous Comments: ------------------------------------------------------------------------ [2021-09-06 08:51:23] cmb@php.net The script works for me with PHP-7.4 and PHP-8.0 with local MySQL 5.6 and 8.0. ------------------------------------------------------------------------ [2021-09-01 15:58:15] martin dot barker at thisisbeacon dot com Description: ------------ When trying to connect to a MySQL Compatible Aurora RDS using MYSQLI_CLIENT_COMPRESS PHP just gets stuck on the first query set to the server, be that a set_charset method or an actual query, According to AWS Staff Wire Compression used in Aurora MySQL Compatible should work with any MySQL Client supporting it (https://forums.aws.amazon.com/thread.jspa?messageID=850833#850833), as PHP's MySQLi System is supposed to support it this should work. This may be a regression from https://bugs.php.net/bug.php?id=47017 Test script: --------------- $mysqli = new mysqli(); $mysqli->real_connect('hostname', "username", "password", "alexandria", 3306, '', MYSQLI_CLIENT_COMPRESS); if(!$mysqli){ die("unable to connect to DB"); } $mysqli->set_charset("utf8mb3"); Expected result: ---------------- PHP to use the compressed connection correctly and not just Freeze, Actual result: -------------- in the test script, the die code is not executed meaning that PHP thinks it connected correctly, but then the set_charset call will just freeze even past the 30-second default timeout. ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=81406&edit=1