php-activerecord SSL (MariaDB / MySQL)

[kaizirlewagen]

We use the files from the master branch, with PHP7.4

Our MariaDB server is configured for SSL. SSL client connections are working.

Is php-activerecord able to use SSL for the MariaDB connection?

[kaizirlewagen]

$cfg = ActiveRecord\Config::instance();
$cfg->set_model_directory('../src/models');
$cfg->set_connections($db_connections);

ActiveRecord\Config::initialize(function($cfg)
{
  $cfg->set_default_connection(DEFAULT_DB_CONN);
});

ActiveRecord\Connection::$PDO_OPTIONS[PDO::MYSQL_ATTR_INIT_COMMAND] = 'SET NAMES \'UTF8\'';
ActiveRecord\Connection::$PDO_OPTIONS[PDO::MYSQL_ATTR_SSL_KEY] = '../ssl/client-key.pem';
ActiveRecord\Connection::$PDO_OPTIONS[PDO::MYSQL_ATTR_SSL_CERT] = '../ssl/client-cert.pem';
ActiveRecord\Connection::$PDO_OPTIONS[PDO::MYSQL_ATTR_SSL_CA] = '../ssl/ca-cert.pem';
ActiveRecord\Connection::$PDO_OPTIONS[PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT] = false;

If some one needs it. Works as expected.