Error 500 on data sources page

Issue Summary

Installed Redash 8 on docker from scratch. Update env to point to v6 postgresql database. Ran migrations.
Everything seems to be working, except Data Sources page, which returns a 500 error. Dashoards also show errors in place of widgets. Opening a query opens, shows sql, but schema browser is empty.

Technical details:

  • Redash Version: 8
  • Browser/OS: chrome, ubuntu
  • How did you install Redash: docker

I looked at the datasources table and options are encrypted. I did not change any secrets in env file. May be I should have kept the secret from v6?

Please help…

So in the logs I get:

[2020-07-16 16:43:09,769] ERROR in app: Exception on /api/data_sources [GET]
Traceback (most recent call last):

File “/usr/local/lib/python2.7/site-packages/cryptography/fernet.py”, line 119, in _decrypt_data
self._verify_signature(data)
File “/usr/local/lib/python2.7/site-packages/cryptography/fernet.py”, line 108, in _verify_signature
raise InvalidToken
InvalidToken
[2020-07-16 16:43:09,772][PID:16][INFO][metrics] method=GET path=/api/data_sources endpoint=data_sources status=500 content_type=application/json content_length=36 duration=12.55 query_count=5 query_duration=10.29

Invalid token… hmmm… what would this be…

Oh my god… this sucks really…

So just to get over this error I’ve set REDASH_SECRET_KEY to the same key as REDASH_COOKIE_SECRET.

Seems to be working.

Thanks for sharing your solution! Glad you figured this out.

It’s the least we can do. Giving something back for this amazing product!