lookforthat
Member
Enable SSL for database connection??? Setup for config.php file...
XF 1.5 Enable SSL for database connection??? Setup for config.php file...
- Thread starter lookforthat
- Start date
lookforthat
Member
No... I need for the SSL configuration for MySql Database... Having your data encrypted using SSL is much safer...
Kuma
Active member
While I suspect not too many people will find this useful, I wanted to share this as I ran into a series of events that requires me to use xf 1.5 for a while longer, and our MySQL connections are required to go over SSL.
It should be possible to modify the library/Zend/Db/Adaptor/Mysqli.php file to include the SSL support that is required. This is based on connecting to an Managed Azure MySQL server, but would imagine it should work for Linode, or other managed servers.
Around line 300 should be
Add this line after it
A little further down, when we make the MySQLi connection as @mysqli_real_connect, find
Change too
That should be it.
It should be possible to modify the library/Zend/Db/Adaptor/Mysqli.php file to include the SSL support that is required. This is based on connecting to an Managed Azure MySQL server, but would imagine it should work for Linode, or other managed servers.
Around line 300 should be
Code:
$this->connection = mysqli_init();
Code:
mysqli_ssl_set($this->_connection,NULL,NULL, "/path/to/cert.ext", NULL, NULL);A little further down, when we make the MySQLi connection as @mysqli_real_connect, find
Code:
$port
Code:
$port,
MYSQLI_CLIENT_SSLThat should be it.
SSL support was added a few years ago.
xenforo.com
Somewhere around 2.1.6.
Implemented - Add MySQLi SSL support
MySQLi supports database connections over SSL but XenForo doesn't (from what I can tell). Adding support for this should be simple. Just add a few config.php options then make the necessary changes to \XF\Db\Mysqli\Adapter::makeConnection from what I can gather. Any reason why this isn't...
xenforo.com
Somewhere around 2.1.6.
