Connecting To Remote Mysql With Ssl

Store Builder Questions
1

I don't see anywhere in the configuration to connect to the remote mysql server with an SSL connection.

Am I missing something or do I need to write the supprot for this myself?

Specifically: http://php.net/manual/en/mysqli.ssl-set.php

sets out all the requirements for opening an SSL connection using the mysqli driver but I don't see anything in the code that allows for that.

2

I don't see anywhere in the configuration to connect to the remote mysql server with an SSL connection.

Am I missing something or do I need to write the supprot for this myself?

Specifically: http://php.net/manual/en/mysqli.ssl-set.php

sets out all the requirements for opening an SSL connection using the mysqli driver but I don't see anything in the code that allows for that.

This feature is not realized in CS-Cart. You can add it by yourself. Here is the function in app/Tygh/Backend/Database/Mysqli.php file:

    public function connect($user, $passwd, $host, $database)
    {
        if (!$host || !$user) {
            return false;
        }

    @list($host, $port) = explode(':', $host);

    $this->conn = new \mysqli($host, $user, $passwd, $database, $port);

    if (!empty($this->conn) && empty($this->conn->connect_errno)) {
        return true;
    }

    return false;
}
3

Thanks.. Yea I found the code but I don't want to overwrite their custom code. Then I have to edit it every time they update.

I am going to write my own class for it and include it as an addon.