Configure HostBill to use Mysql over SSL

Owned by HostBill
Last updated: Dec 05, 2022
1 min read

HostBill makes use of PHP PDO for database operations, and as such you can configure it to use SSL when connecting to PDO.


In your HostBill's includes/config.php file add following lines to bottom of file contents (ensure to specify valid cert/key/ca paths):

//...
//use below to specify additional options passed to PDO:
$config['PDO.options']=[
    PDO::MYSQL_ATTR_SSL_KEY    				=>'/etc/mysql/ssl/client-key.pem',
    PDO::MYSQL_ATTR_SSL_CERT				=>'/etc/mysql/ssl/client-cert.pem',
    PDO::MYSQL_ATTR_SSL_CA    				=>'/etc/mysql/ssl/ca-cert.pem',
  //PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT	=> false							//to disable server cert verification
];


For other connection PDO SSL flags/options available refer to: https://www.php.net/manual/en/ref.pdo-mysql.php#pdo.constants