Using mysql-connector-python in a flask app with uwsgi and receive the following error: SSL connection error: SSL_CTX_new failed

Question

I have a flask app that makes use of a mysql connection that I have successfully run in development mode. To scale the app, I am intending to use a combination of Nginx and uwsgi.

Having setup the wsgi.py file and run the command:

uwsgi --socket 0.0.0.0:5000 --protocol=http -w wsgi:app

I receive the following error message after entering a url (that previously worked under development mode ie flask on its own without uwsgi):

mysql.connector.errors.InterfaceError: 2026 (HY000): SSL connection error: SSL_CTX_new failed

I have tried the solution suggested here: https://forums.mysql.com/read.php?50,671354,671376#msg-671376 however it did not work.

What should I do to solve this error?

TheHeuman · Accepted Answer · 2020-01-10 20:24:54Z

1

I have found a solution that works for me.

https://stackoverflow.com/a/56497954/9137086

Adding

use_pure=True

to the end of the database connection string

so mine became

connection_string = f'{dialect}+{driver}://{user}:{password}@{host}:{port}/{database}?use_pure=True'

answered Jan 10, 2020 at 20:24

TheHeuman

1781 gold badge2 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Using mysql-connector-python in a flask app with uwsgi and receive the following error: SSL connection error: SSL_CTX_new failed

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related