XF 1.5 Enable SSL for database connection??? Setup for config.php file...

[lookforthat]

Enable SSL for database connection??? Setup for config.php file...

 

[Paul B]

https://xenforo.com/community/resources/how-to-implement-ssl-to-secure-http-traffic-https.5425/

 

[lookforthat]

No... I need for the SSL configuration for MySql Database... Having your data encrypted using SSL is much safer...

 

[Paul B]

Ah, I misunderstood the request.

That's not something which is supported.

 

[Kuma]

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

$this->connection = mysqli_init();

Add this line after it

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

 $port

Change too

$port,
 MYSQLI_CLIENT_SSL

That should be it.

 

[Paul B]

SSL support was added a few years ago.

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.

 

[Kuma]

Not for XenForo 1.5. Those options did not work in any context.

 

[Paul B]

I missed the latest post was for XF 1.

 

[Kuma]

Yup! I had no issues with XF 2.2, just need to manage a 1.5 installation until we can sort out some internal requirements

I wanted to both document this for myself, and hopefully for others in the future.