[php-src] Issue #14230: Error OpenSSL Shutdown while in init - cURL - MSSQL

From: Date: Tue, 14 May 2024 15:50:18 +0000
Subject: [php-src] Issue #14230: Error OpenSSL Shutdown while in init - cURL - MSSQL
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-246910@lists.php.net to get a copy of this message
Issue: https://github.com/php/php-src/issues/14230 Author: AdrienHt ### Description **Php version**: 8.2.19 **Driver SQL**: pdo_sqlsrv-5.12.0 **MSSQL version**: 2022 (16.x) **Ubuntu via Docker for Mac**: Ubuntu 22.04.4 LTS (Jammy Jellyfish) The following code: ```php <?php $pdo = new \PDO('sqlsrv:server=tcp:' . getenv('SQL_HOST') . ',1433 ; Database = ' . getenv('SQL_DATABASE') . ';TrustServerCertificate=yes;', getenv('SQL_USERNAME'), getenv('SQL_PASSWORD')); $pdo->beginTransaction(); $curlResource = curl_init(); $curlOptions = [ CURLOPT_SSL_VERIFYPEER => true, CURLOPT_CAPATH => '/data/ca', CURLOPT_CAINFO => '/data/ca/serverCa.pem', CURLOPT_RETURNTRANSFER => true, CURLOPT_URL => getenv('API_URL'), ]; foreach ($curlOptions as $option => $value) { curl_setopt($curlResource, $option, $value); } $responseContent = curl_exec($curlResource); $errorNumber = curl_errno($curlResource); $errorMessage = curl_error($curlResource); curl_close($curlResource); if ($errorNumber > 0) { echo 'Curl error: #' . $errorNumber . ' - ' . $errorMessage. "\n" ; $pdo->rollBack(); } echo $responseContent; ``` Resulted in this output: `` Curl error: #60 - SSL certificate problem: unable to get local issuer certificate PHP Fatal error: Uncaught PDOException: SQLSTATE[08S01]: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:140E0197:SSL routines:SSL_shutdown:shutdown while in init] in /data/test.php:30 Stack trace: #0 /data/test.php(30): PDO->rollBack() #1 {main} thrown in /data/test.php on line 30 ``` But I expected no SQL error, only the cURL error : ``` Curl error: #60 - SSL certificate problem: unable to get local issuer certificate // no SQL error ``` The error only happens when the curl CA verification reports a certificate not allowed. The error does not happen when I remove TrustServerCertificate=yes in the dsn. The error does not happen when CURLOPT_SSL_VERIFYPEER is set to false. It's seems that the Mssql driver call openssl function SSL_shutdown() while SSL_in_init() send true. The SSL_in_init() seems to return true only when the curl CA verification reports a certificate not allowed. I don't know if php curl implementation does not close the connection correctly or if the MSSQL driver should check if SSL_in_init() returns true before calling SSL_shutdown(), but there is something wrong here. ### PHP Version 8.2.19 ### Operating System Ubuntu 22.04.4 LTS (Jammy Jellyfish)

« previous php.bugs (#246910) next »