Flask-SQLAlchemy ssl-connection with AWS RDS error

Question

I am trying to connect flask app mysql connection with AWS RDS over ssl , It works when I am try to use mysql client like this

mysql -u user -h myrds.rds.amazonaws.com -p --ssl-ca=rds-combined-ca-bundle.pem

I am able to login but when I am try with flask app

SQLALCHEMY_DATABASE_URI = 'mysql://user:[email protected]/miro_dev?ssl_cert=rds-combined-ca-bundle.pem'

it send me error

sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (2026, 'SSL connection error: Unable to get private key')

Freek Wiekmeijer · Accepted Answer · 2019-02-08 17:53:40Z

4

I was able to get this work by adding

?sslmode=verify-ca&sslrootcert=rds-combined-ca-bundle.pem

to the connection string.

This came from the postgresql docs here along with the aws docs.

You can change the sslmode to require if you do not care about verifying the rds. I downloaded the pem file from here.

edited Feb 8, 2019 at 17:53

Freek Wiekmeijer

4,9881 gold badge34 silver badges41 bronze badges

answered Aug 22, 2017 at 22:31

TheHandofTheKing

5143 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alex Pulver · Accepted Answer · 2016-10-31 12:20:13Z

3

I think that in your case the connection string is correct, you just need to use ssl_ca option and not ssl_cert:

SQLALCHEMY_DATABASE_URI = 'mysql://user:[email protected]/miro_dev?ssl_ca=rds-combined-ca-bundle.pem'

answered Oct 31, 2016 at 12:20

Alex Pulver

661 silver badge7 bronze badges

Comments

miguelfg · Accepted Answer · 2016-07-20 15:59:04Z

1

I do this:

...
ssl_args = {'ssl': {'ca': 'YOUR_SSL_CERT_PATH'}}

db_url = 'mysql://{}:{}@{}/{}'.format(username, password, server, database)
engine = create_engine(db_url, connect_args=ssl_args, echo=False)
cnx = engine.connect()
df = pd.read_sql_table('table_name', cnx)

And I'd suggest to not input a path like follows:

~/...

but:

/home/YOUR_USER/...

answered Jul 20, 2016 at 15:59

miguelfg

1,5222 gold badges16 silver badges23 bronze badges

Collectives™ on Stack Overflow

Flask-SQLAlchemy ssl-connection with AWS RDS error

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related