I have an installation of https://www.monicahq.com/ (migrated from Heroku) running on https://monica-habi.fly.dev/
Recently, when I want to load the site, I get an error about denied access (SQLSTATE[HY000] [1045] Access denied for user ‘something’@‘50.31.197.66’ (using password: YES) (SQL: select count(*) as aggregate from accounts)).
I’ve restarted the machine in my fly.io console, but the error persists.
How can I get back my data and a running software?
This seems likely a password or permissions issue. If this was a Fly DNS issue you’d likely see errors like nx domain. Where is your database hosted if I may ask? You’d want to check there.
You might want to remove your username from your original post for safety too.
Everything is running on fly infrastructure after migrating here from Heroku.
Or was running up to now…
My advice is to ssh into your DB host and try to connect with the credentials you have to be sure if that’s a credentials issue or if this is an issue of your machine not being able to connect to your DB.
If it’s a fly postgres here’s a quick how-to:
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.