Making the ssl Connection in Drupal

There are times when the connection to your Drupal DB will need to be via ssl, such as when using an external DB service like clearDB. How do you accomplish this with regards to the settings.php file?

Simple.

Add the following to your database array:

      'pdo' => array (

            PDO::MYSQL_ATTR_SSL_CERT => 'path-to-cert.pem',

            PDO::MYSQL_ATTR_SSL_KEY => 'path-to-key.pem',

            PDO::MYSQL_ATTR_SSL_CA => 'path-to-ca.pem',

                     ),

      ),

 


Of course, the Drupal Community isn't the only place to give back. It's a complex world, and there are as many worthy causes as their are melodies, with most being served by multiple charitable organizations. Here are a few of those that strike a 7th chord with me.