[Request] Enable config for SSL connection to external database

Need some custom code changes to the phpBB core simple enough that you feel doesn't require an extension? Then post your request here so that community members can provide some assistance.

NOTE: NO OFFICIAL SUPPORT IS PROVIDED IN THIS SUB-FORUM
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: NO OFFICIAL SUPPORT IS PROVIDED IN THIS SUB-FORUM
Post Reply
GnomePants
Registered User
Posts: 1
Joined: Mon Oct 31, 2022 1:39 am

[Request] Enable config for SSL connection to external database

Post by GnomePants »

Checking if it possible to enable SSL connections to an external database to the INSTALL script on future updates.

This program worked great when Apache2 and MariaDB was running from the same computer.
I'm migrating to Microsoft Azure hosting. Where database and web host are two different servers and both use SSL encryption.

Exploring the page phpbb/db/driver/mysqli.php
At the line: $this->db_connect_id = mysqli_init();
Added two additional lines:
$this->db_connect_id->options(MYSQLI_OPT_SSL_VERIFY_SERVER_CERT, true);
$this->db_connect_id->ssl_set(NULL, NULL. <CA Certificate file>, NULL, NULL);

Hoping this is the correct .php file to modify for the $db-> variable that other pages use.
Post Reply

Return to “phpBB Custom Coding”