Add SSL support for mysql

[Kintaro]

At work our SQL database uses SSL certificates for the connection and I'd love to use diesel, but for the time being I have to fall back to the normal mysql crate. Adding SSL would be really beneficial.

[sgrif]

We should be preferring SSL connections already, but I agree that we should add the ability to specify ?sslmode=require in the URL, similar to PG.

[Kintaro]

I meant more in terms of providing client certificates and keys.

[sgrif]

Yes, I will add support for that as well

[Kintaro]

Nice. Thanks a bunch. Would really help. We're building a prototype for some financial systems and it worms at the moment with the mysql crate. But the added readability abf exchanfabimity for pg and sqlite would really help to put it into prod.

…

On Thu, Mar 9, 2017, 20:11 Sean Griffin ***@***.***> wrote: Yes, I will add support for that as well — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#786 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAG0Ca5f8b2wpaGnvXsJcatY81i9n7Zoks5rj94ZgaJpZM4MWdcr> .

[marti1125]

Hello I can't connect with Heroku its required:
All connections require SSL: sslmode=require.

[yerke]

@sgrif Hi. Thank you for creating and maintaining Diesel. Do you think you will have time to finish this soon? I do understand that MySQL is not a priority, but it would be nice to have some clarity on whether this will be solved. Thank you.

[p-alik]

@sgrif, if no one works on this issue yet, I'm willing to take over.

[weiznich]

Closed by #2491