search

getredash / redash

Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
http://redash.io/
BSD 2-Clause "Simplified" License
26.07k stars 4.35k forks source link

SSL Error Redis #4005

Open Michae94 opened 5 years ago

Michae94 commented 5 years ago

Issue Summary

This follow the first ticket #3999 . SSL Certificate verify failed

Steps to Reproduce

  1. I added in my .env file : REDASH_REDIS_URL REDASH_CELERY_BROKER_SSL_CA_CERTS REDASH_DATABASE_URL Then I use the next command : _./bin/run celery worker --app=redash.worker --beat -Qscheduledqueries,queries,celery -c2 I get the following error when I try to connect to the URL http://127.0.0.1:5000/ ConnectionError: Error 1 connecting to c7b2fac8-b71e-4936-a9a4-47fa7b461b47.bc28ac43cf10402584b5f01db462d330.databases.appdomain.cloud:30684. [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:726).

I am trying to connect my redash installed on my VM with ressources on IBM cloud : Redis (and Postgres). That is why I have to use an SSL connection.

Any idea?

Technical details:

Michae94 commented 5 years ago

So I modified the code itself to import my certificate inside the command "StrictRedis" and it looks like it worked. I'll make a pull request if I manage to pass all the tests. I don't really understand what was done with the import of certificate from .env in celery but I think that was not enough.