SSL encrypted connection to MySQL

[tmknight]

Good Afternoon,

We are attempting to move our forum from one server to another. The initial move was fairly straight forward. Where we are running into issues is the new host requires us to use an SSL encrypted connection to MySQL over port 3306.

The host uses MySQL version 8.0 and we are currently using SMF version 2.0.19.

I've been searching the SMF forum and documentation but have yet to find anything to solve the issue. Does anyone know of any documentation to accomplish this task?

[Kindred]

You'll have to update the settings for the mySQL connection in Settings.php file.
I'd suggest having your host help you configure it...

[Illori]

What is repair_settings.php?

this should help you as well.

[Arantor]

You'll have to update the settings for the mySQL connection in Settings.php file.
I'd suggest having your host help you configure it...

They'll also need to patch SMF itself since the relevant certificate bundle is not part of the configuration and needs to be passed to $smcFunc last I checked.

[Kindred]

Hmmm.... yeah, I forgot about that

[tmknight]

Thanks for the replies.

The modifications to settings.php is what I needed.

When you say "patch" do you mean manually modify the php codes or upgrading the SMF version?

[Arantor]

Thanks for the replies.

The modifications to settings.php is what I needed.

When you say "patch" do you mean manually modify the php codes or upgrading the SMF version?

Manually modifying SMF. It doesn't support encrypted connections out of the box.