MySql connection. Verify SSL Certificate


When adding the option “Verify SSL Certificate” to a MySQL connection, I received the below debug trace error when accessing the website. BTW, the error contains the username and pwd of the connections but I have sanitized them below:

Code: 2002
File: “dmxConnectLib/lib/db/Connection.php”
Message: "SQLSTATE[HY000] [2002] "
Trace: “#0 dmxConnectLib/lib/db/Connection.php(75): PDO->__construct(‘mysql:host=XXX…’, ‘XXXX…’, ‘XXXX’, Array)\n#1 dmxConnectLib/modules/dbconnector.php(12): lib\db\Connection->__construct(Object(lib\App), Object(stdClass))\n#2 /dmxConnectLib/lib/App.php(163): modules\dbconnector->connect(Object(stdClass), ‘connection1’)\n#3 dmxConnectLib/lib/App.php(128): lib\App->execSteps(Object(stdClass))\n#4 dmxConnectLib/lib/App.php(98): lib\App->execSteps(Array)\n#5 index.php(19): lib\App->exec(Object(stdClass), true)\n#6 {main}”

The error is that the SSL verification failed. Seems that it is buggy in some PHP versions. Turn off verification if it doesn’t work in your case.

ok, i will not use it anymore then. Thanks @patrick

1 Like