Encrypted DB connection

[asishp42]

Hello Experts,

Need your input, does the FusionPBX supports encrypted DB connection to external Postgres/MYSQL server.

I tried changing the config file ( /etc/fusionpbx/config.php , /etc/fusionpbx/config.lua) but no success.

$db_host = 'XXX.XXX.XXX.XXX';
$db_port = 'XXXX';
$db_name = 'XXXXXXXXXXXXXXXXX';
$db_username = 'XXXXXXXXXXXXXXXXX';
$db_password = 'XXXXXXXXXXXXXXXXX';

$db_SSLMode = 'REQUIRED';
$db_SSLCA = '/etc/ssl/db/cert.pem';
$db_SSLCert = '/etc/ssl/db/client-cert.pem';
$db_SSLKey = '/etc/ssl/db/client-key.pem';
Or
$db_ssl = array( 'ssl_key' => '/etc/ssl/db/client-key.pem', 'ssl_cert' => '/etc/ssl/db/client-cert.pem', 'ssl_ca' => '/etc/ssl/db/cert.pem');


Any pointer will be really helpful.

 

[Adrian Fretwell]

Have a look at
/var/www/fusionpbx/resources/pdo.php

You probably need to set:
$db_secure
and
$db_certauthority

SSLCert and SSLKey would be configured in PostgreSql server.

 

[asishp42]

Thank you for your help.
This is fixed now,