search

zodb / relstorage

A backend for ZODB that stores pickles in a relational database.
Other
53 stars 46 forks source link

Add ``ssl`` option to MySQLAdapterFactory configuration. #490

Closed gotcha closed 1 year ago

gotcha commented 2 years ago

This enables explicit use of SSL when connection is opened.

gotcha commented 2 years ago

@jamadden I made this PR to run CI but need your approval.

gotcha commented 2 years ago

@jamadden Thanks for your detailed answer.

I will need to dig deeper. While migrating to a newer MySQL version, we got connections errors complaining that only SSL connections were enabled. IOW default SSL do not work on our system.

Adding the key above and setting it to 1 did the work for us.

I will come back with updates.

gotcha commented 2 years ago

The issue we had with SSL was due to the use of MariaDB packages instead of MYSQL.

Switching to MYSQL made SSL connections work properly.