Bug #72878 [Opn->Dup]: PDO SSL connection
| From: | cmb@php.net | Date: | Mon, 27 Jan 2020 12:50:19 +0000 |
| Subject: | Bug #72878 [Opn->Dup]: PDO SSL connection | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-225141@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=72878&edit=1
ID: 72878
Updated by: cmb@php.net
Reported by: mblkblta at gmail dot com
Summary: PDO SSL connection
-Status: Open
+Status: Duplicate
Type: Bug
Package: PDO MySQL
Operating System: Windows 10
PHP Version: 7.0.9
-Assigned To:
+Assigned To: cmb
Block user comment: N
Private report: N
New Comment:
Duplicate of bug #71845.
Previous Comments:
------------------------------------------------------------------------
[2016-08-18 07:19:05] mblkblta at gmail dot com
Description:
------------
Peer certificate CN='SomeName' did not match expected CN='someIP' - the main
error.
We have a verify_peer_name setting by SSL connection that exists in mysqli, smtp, openssl settings,
but not in PDO. We have a link with investigation about this question http://stackoverflow.com/questions/36493062/php-mysql-over-ssl-peer-certificate-did-not-match,
but it can't help for PDO. All settings which could be is in test script.
I'm not a professional, but I didn't find any decision after 3 days searching... Ask for
directing me to right way or fix it and add setting like PDO::MYSQL_VERIFY_PEER_NAME.
Test script:
---------------
$dbInfo = array
(
'dsn' => 'mysql:host=123.45.67.890;dbname=someDB;port=3306',
'user' => 'user',
'pass' => 'userpassword'
);
$con = new PDO
(
$dbInfo['dsn'], $dbInfo['user'], $dbInfo['pass'],
[
PDO::MYSQL_ATTR_SSL_CIPHER => 'AES256-SHA',
PDO::MYSQL_ATTR_SSL_CA => 'ca-cert.pem',
PDO::MYSQL_ATTR_SSL_KEY => 'client-key.pem',
PDO::MYSQL_ATTR_SSL_CERT => 'client-cert.pem',
]
);
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=72878&edit=1