SSL mysql

Hi,

I was looking for info on setting up SSL connection for mysql databases using CI3. I didnt find much.
Turns out its not that hard so here are some hints that might help the next person.

1)
\system\database\drivers\mysqli\mysqli_driver_php

Existing line 126: $mysqli = mysqli_init();

Add the following line: $mysqli->ssl_set('YOUR_FILE-key.pem', 'YOUR_FILE-cert.pem', 'YOUR_FILE-ca.pem', NULL, NULL);

2
You can test the change with a query: show status like 'Ssl_cipher';
vardump() the return to check what cipher is being used, output should be something like:
{ ["Variable_name"]=> string(10) "Ssl_cipher" ["Value"]=> string(18) "DHE-RSA-AES256-SHA" }

If the Ssl_cipher value is blank its not encrypted, can check by commenting the driver change out and back in again.

You might want to look at this: Updated the MySQLi Driver to Support SSL Connections.
Obviously, it's not in the released version of CI3, yet, but you may want to make sure that, if you choose to modify your code to support SSL, you consider whether you're going to need to change your code or database config when the next release comes along.

Bonfire

Practical CodeIgniter 3
CodeIgniter Testing Guide