Skip to content

SSL/TLS CONNECTION TO DB

Problem:


I am testing phpGrid for a project that supports SSL/TLS connection to MySql, any documentation how to enable it?

Solution:


It's possible. Need to add a few lines to cls_db.php for mysqli connectivity to include perm (public key) files. It does require a full version (not included in free Lite version) to edit the source code.

$db = newAdoConnection('mysqli')

$db->ssl_key   = "key.pem";
$db->ssl_cert = "cert.pem";
$db->ssl_ca   = "cacert.pem";
$db->ssl_capath = null;
$db->ssl_cipher = null; 

Feedback and Knowledge Base