Errors after restoring a database dump from DigitalOcean Redash Image to AWS EC2 Redash AMI

Issue Summary

1. I took a dump of the postgres database using pg_dump from our DigitalOcean Redash droplet. We had set it up using the Redash Image available in the DO Marketplace.
2. Then I restored it to the postgres database using psql to an AWS EC2 Instance. The instance was setup using the Redash AMI available in the AWS Marketplace.
3. So I’m trying to load my Dashboards and other pages. The server is returning 500 - Internal Server Errors.

image1162×721 86.2 KB

Technical details:

• Redash Version: Docker Image - redash/redash:8.0.0.b32245
• Browser/OS: Mozilla Firefox 81.0
  AWS EC2 - Ubuntu 18.04.3 LTS (GNU/Linux 4.15.0-1052-aws x86_64)
  DO Droplet - Ubuntu 18.04.3 LTS (GNU/Linux 4.15.0-117-generic x86_64)
• How did you install Redash: Docker

I came across this post and thought what if I moved over our old SECRETs to the new instance as well.

1. So I SSHed into my DO droplet
2. cd /opt/redash && cat env
3. Copied the following lines:
   REDASH_COOKIE_SECRET=SOME_VALUE_HERE
   REDASH_SECRET_KEY=SOME_VALUE_HERE
4. Now SSHed into my AWS EC2 instance and switched to root user sudo -s
5. cd /opt/redash && vim env
6. Pasted here the copied lines replacing the existing values and exited the editor saving changes.
7. docker-compose down && docker-compose up -d to restart the services.

That’s it. It solved my issues.