Hi, I am testing the Library and i was unable to connect to MYSQL DB because the db ssl enable for connection , any idea how to define certification in config.php db connection so i know it works. Regards, Magic
1 Answers
You will need some updates to enable ssl. I’ve not verified these changes but as per docs, this should work.
1. Download https://codeload.github.com/ADOdb/ADOdb/zip/refs/tags/v5.21.4 archive and extract it in lib/inc folder. Remove old ‘adodb’ folder and rename the extracted folder to adodb.
2. You can set certificate details by:
$g = new jqgrid($db_conf); $g->con->ssl_key = "key.pem"; // give full path $g->con->ssl_cert = "cert.pem"; $g->con->ssl_ca = "cacert.pem"; $g->con->ssl_capath = null; $g->con->ssl_cipher = null;
Let me know the results.
Your Answer