I have Drupal 7.24 / PHP 5.3.27 and am using the PHP native MySQL drivers. PHPinfo shows that SSL is supported.
I can't seem to get Drupal to connect to MySQL with SSL. Works fine without it. I did find a patch 726192-arbitrary-pdo-options-attributes.patch that looked like it was committed back about 7.17. However I did not see the patch in my 7.24 that I downloaded. So I applied the patch. Still doesn't work. There are a lot of bad examples of configurations in others questioning how to connect. My best guess is this configuration. But again it does not work. I have test these SSL certs and connection Navicat and it does connect fine
Any suggestions on what to try or where to look??
$databases = array ( 'default' => array ( 'default' => array ( 'database' => 'drupaldb', 'username' => 'drupaluser', 'password' => 'password', 'host' => '192.168.10.100', 'port' => '3306', 'driver' => 'mysql', 'prefix' => '', 'pdo attributes' => array( PDO::MYSQL_ATTR_SSL_KEY => '/path/client-key.pem', PDO::MYSQL_ATTR_SSL_CERT => '/path/client-cert.pem', PDO::MYSQL_ATTR_SSL_CA => '/path/ca-cert.pem', ), ), ), );