CD2: MySQL+SSL / Open Source Plans

Jump to solution
mcfa0086
Community Member

Howdy all - We're interested in using DAP with a MySQL cluster which requires SSL for connections. From digging in, it seems like there's not a way to make aiomysql do SSL connections when using the connection URI scheme for specifying database connections - sqlalchemy parses the extra params (ssl_ca, ssl_key, etc) but aiomysql doesn't setup an SSL context fully. 

Curious if anyone else is looking at this, or has solutions. Aiomysql does support SSL when using the more explicit parameter based connection setup (you can pass in a pre-created SSL context). 

Related, any news about plans for throwing this project up on Github so we can put forward PRs? 

-Colin

1 Solution
sgergely
Instructure
Instructure

Hey @mcfa0086 and @SpencerWilliams 

just a follow-up on this, we have released DAP CLI 1.2.0 which supports secure connections to MySQL and PostgreSQL. Please update and check it out here: https://data-access-platform-api.s3.amazonaws.com/client/README.html#secure-connection-to-the-databa...

View solution in original post