Hi so I'm moving the retool self-hosted app (ECS+Fargate) from an old AWS account to a new AWS account.
Here's what's been done so far.
Deployed the ECS+Fargate template in the new account.
Created a new PostgreSQL database from the snapshot of the old account's DB.
Modified the template with the DB credentials and the encryption,jwt keys used in the old account, and deployed the template again. It seems to work as I can see many active connections on the DB.
Answering my own question to fix this issue (but another one has come up)
I checked the network tab and observed that a file - 50628.df6a9f44.js - has failed to load with a 404 not found error. The origin told me these are files hosted on selfhost.retool-edge.com and when I browsed to that link, it was indeed a 404.
Now the next issue - When I go into a configuration, I see a blank page with a spinning circle in the middle. I reckon the URL is - http://alb-url:3000/api/environments
Answering my own question - My template was missing a lot of important things such as:
- Name: DOMAINS
Value: "retool.mydomain.com"
- Name: BASE_DOMAIN
Value: "retool.mydomain.com"
- Name: POSTGRES_SSL_REJECT_UNAUTHORIZED
Value: "false"
Also commented out:
# Remove below when serving Retool over https
#- Name: COOKIE_INSECURE
# Value: "true"
Also made sure that my DB user has full owner rights to the entire database.
All this helped fixing one unexpected issue at a time but eventually reached a point where all was remediated and there were no longer any console errors or timeouts.