Problem with database SSL Connection

Problem with database SSL Connection - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Installation & Setup (https://forum.codeigniter.com/forumdisplay.php?fid=9)
+--- Thread: Problem with database SSL Connection (/showthread.php?tid=68089)

Problem with database SSL Connection - simoon - 05-24-2017

Hi,

i try to connect to a database using ssl encryption and i get the following error:

Code:
Message: mysqli::real_connect(): SSL operation failed with code 1. OpenSSL Error messages: error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed.

The connection with the local mysql client and the pem files works, with codeigniter not.
My encryption config for the db looks like this

Code:
'encrypt' => array('ssl_key' => '/etc/mysql/client-key.pem',

        'ssl_cert' => '/etc/mysql/client-cert.pem',

        'ssl_ca' => '/etc/mysql/ca-cert.pem', 

        'ssl_verify' => FALSE),

can someone tell me how to fix this?

Thanks.
Alex