Get The Most Affordable Hosting in the World!

Starting at just $1.87/month, Vercaa offers unbeatable pricing for world-class web hosting services.

Fast, reliable, and secure hosting to power your website without breaking the bank. Plus, enjoy a free CDN for faster loading times worldwide!

Get Started Now!

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:

  1. Open the configuration.php file in your preferred text editor.
  2. 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:

  1. Open the configuration.php file in your preferred text editor.
  2. 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.

Was this answer helpful? 1 Users Found This Useful (1 Votes)