Specify the --ssl option for django database connection

Question

When I connect to my database with mysql I specify the option --ssl, or else I get the error

SSL connection is required. Please specify SSL options and retry.

I know that with MySQL you can connect with a ssl certificate where you have a copy of the certificate locally. With this approach I know how to move forward with Django, as you can specify the option as described here https://stackoverflow.com/a/12285601/2889451

However, in my case I simply pass the option --ssl, and I don't have a local copy of the certificate. How can I enable this option in Django?

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': DB_NAME,
        'USER': DB_USER,
        'PASSWORD': DB_PASSWORD,
        'HOST': DB_HOST,
        'PORT': '',
    }
}

Simen Russnes · Accepted Answer · 2020-01-24 12:52:12Z

2

Apparently you can solve it by passing the options as shown below:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': DB_NAME,
        'USER': DB_USER,
        'PASSWORD': DB_PASSWORD,
        'HOST': DB_HOST,
        'PORT': '',
        'OPTIONS': {'ssl': True},
    }
}

answered Jan 24, 2020 at 12:52

Simen Russnes

2,3006 gold badges36 silver badges64 bronze badges

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

2 Comments

ddelange Over a year ago

there is also 'OPTIONS': {'sslmode': 'require'} for postgres backend ref stackoverflow.com/q/47683059

Buraco Over a year ago

It is trying to get ca attribute of ssl but it does not exist on bool value. So this one cause an error. see: github.com/django/django/blob/…

Collectives™ on Stack Overflow

Specify the --ssl option for django database connection

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related