Req #80344 [NEW]: mysqlnd support for SASL SCRAM-SHA-1 and SCRAM-SHA-256 authentication

From: fjanisze Operating system: any PHP version: 7.4.12 Package: MySQL related Bug Type: Feature/Change Request Bug description:mysqlnd support for SASL SCRAM-SHA-1 and SCRAM-SHA-256 authentication Description: ------------ The authentication methods SCRAM-SHA-1 and SCRAM-SHA-256 have to be supported, this issue is about adding support for them in mysqlnd. Test script: --------------- <?php $link = mysqli_connect("127.0.0.1", "user", "pass"); // Check connection if($link === false){ die("ERROR: Could not connect. " . mysqli_connect_error()); } // Print host information echo "Connect Successfully. Host info: " . mysqli_get_host_info($link) . PHP_EOL; if ($result = $link->query("SHOW DATABASES")) { echo "Returned rows are: " . $result->num_rows . PHP_EOL; // Free the result set $result->free_result(); } ?> Expected result: ---------------- Given the script and assuming that 127.0.0.1 runs a mysql server configured with LDAP SASL and auth method SCRAM-SHA-1 or SCRAM-SHA-256 for the user "user", the script succeeds and the query works. Actual result: -------------- The connection will fail since mysqlnd is not able to authenticate, at the moment LDAP SASL is not supported in the client but the server does support those methods. -- Edit bug report at https://bugs.php.net/bug.php?id=80344&edit=1 -- Fix committed: https://bugs.php.net/fix.php?id=80344&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=80344&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=80344&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=80344&r=needscript Try newer version: https://bugs.php.net/fix.php?id=80344&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=80344&r=support Expected behavior: https://bugs.php.net/fix.php?id=80344&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=80344&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=80344&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=80344&r=globals PHP version support discontinued: https://bugs.php.net/fix.php?id=80344&r=phptooold Daylight Savings: https://bugs.php.net/fix.php?id=80344&r=dst IIS Stability: https://bugs.php.net/fix.php?id=80344&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=80344&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=80344&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=80344&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=80344&r=mysqlcfg