CodeIgniter Forums

Full Version: Correct syntax for encrypted database using ssl
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi, i am having problems to connect to a database that is encrypted with ssl. I am not sure what the correct syntax it would be for connecting, and also, the neccesarry files or path to include. Only with ssl_ca is enough? or i need all of them?

Link to the explanation of the values: https://codeigniter.com/user_guide/datab...-of-values
We need to know which database driver you are using, each driver has different settings.

These may point you into the right direction.

MySQLi SSL verify

CodeIgniter – Google Cloud MySQL connect with SSL
(04-06-2021, 01:24 AM)InsiteFX Wrote: [ -> ]We need to know which database driver you are using, each driver has different settings.

These may point you into the right direction.

MySQLi SSL verify

CodeIgniter – Google Cloud MySQL connect with SSL

Sorry, the database driver that i am using is MySQLi.
I had made changes in the Database.php class, letting the encrypt false the empty strings:
// 'encrypt' => array(
// 'ssl_key' =>'',
// 'ssl_cert' =>'',
// 'ssl_ca' =>'',
// 'ssl_capath' =>'',
// 'ssl_cipher' => '',
// 'ssl_verify' =>FALSE),
And in the .env, i only have the ssl_ca with the path /etc/....