NYUCCL / psiTurk

An open platform for science on Amazon Mechanical Turk.
https://psiturk.org
MIT License
277 stars 140 forks source link

Heroku database maintenance #397

Closed abardon closed 4 years ago

abardon commented 4 years ago

I got an email from heroku saying that my database required maintenance and then another email saying that the maintenance had been performed, but now I can no longer launch psiturk from my terminal. It gives the following error when I type the "psiturk" command: sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL: password authentication failed for user "unfkvelexypuuc"

How can I fix this? I tried updating all of the credentials and made sure that they were correct on heroku and in my config file. Thanks!

deargle commented 4 years ago

This suggests that the DATABASE_URL in your local config.txt is incorrect. Not really a psiturk bug if you're feeding in bad database credentials. Either it's wrong in your config.txt, or you set ON_HEROKU=true in your local environment, and you also set a DATABASE_URL env var, which may still be pointing to the incorrect place.

Either that, or the DATABASE_URL credentials that you get when you run heroku config are stale. That would be a heroku question though.

deargle commented 4 years ago

Closing due to inactivity and inability to replicate