To use WHMCS with an encrypted MySQL® connection, you will need to perform additional steps to configure the necessary settings to the configuration.php file.
For steps to configure encrypted MySQL connections on cPanel & WHM servers, see cPanel's How to Configure MySQL SSL Connections Documentation.
You cannot configure this before or during the installation process using the browser-based installation method. Because of this, you cannot use the browser-based method if your server requires encrypted connections.
Configuration Before Installation (CLI)
To enable encrypted MySQL connections before proceeding with the CLI-based installation method:
- Open the
configuration.phpfile in your preferred text editor. - Update the necessary configuration settings, replacing the example values below with your server's information:
$db_tls_ca='/path/to/ca/file';
$db_tls_ca_path='/path/to/ca/directory';
$db_tls_cert='/path/to/client/cert';
$db_tls_cipher='AES256-SHA';
$db_tls_key='/path/to/client/key';
$db_tls_verify_cert='0';The settings that you configure will depend on your server's configuration.
3. Proceed with installation via the command line.
Configuration During Installation (CLI)
To enable encrypted MySQL connections during the CLI-based installation process, use the -c or --config options while running the command-line installation script.
Include the following lines in your JSON input, replacing the example values below with your server's information:
"db_tls_ca":"'/path/to/ca/file'",
"db_tls_ca_path":"'/path/to/ca/directory'",
"db_tls_cert":"'/path/to/client/cert'",
"db_tls_cipher":"'AES256-SHA'",
"db_tls_key":"'/path/to/client/key'",
"db_tls_verify_cert":"'0'",The settings that you configure will depend on your server's configuration.
Configuration After Installation (CLI or Browser)
To enable encrypted MySQL connections after you have completed installation:
- Open the
configuration.phpfile in your preferred text editor. - Update the necessary configuration settings, replacing the example values below with your server's information:
$db_tls_ca='/path/to/ca/file';
$db_tls_ca_path='/path/to/ca/directory';
$db_tls_cert='/path/to/client/cert';
$db_tls_cipher='AES256-SHA';
$db_tls_key='/path/to/client/key';
$db_tls_verify_cert='0';The settings that you configure will depend on your server's configuration.
The End! should you have any inquiries, we encourage you to reach out to the Vercaa Support Center without hesitation.
