How we can deploy the Flask Application using Managed Database on Digital Ocean server

October 18, 2019 302 views
Clustering Python Frameworks MySQL Python DigitalOcean
rahularoraengg
By:
rahularoraengg

Can you please confirm how we can pass the ssl mode required variable under the Flask application.
I am using the Managed MYSQL database instance it’s connected successfully with my local database, but when I am using the same thing with Digital Ocean managed database level then it’s giving me an error related to SSl mode required options.
Please help me to resolve this issue.

Sign In to Comment
1 Answer
andmoo October 18, 2019

Hey @rahularoraengg,

your config should contain a connection string for the database such as;

SQLALCHEMY_DATABASE_URI = 'mysql://user:pass@hostname/database?ssl_mode=REQUIRED'

It may be necessary to also use the other SSL option(s) but add them to the URI config line.

Have another answer? Share your knowledge.

Related