search

fredcallaway / heroku-experiment

Starter kit for running a psiturk experiment on heroku with jspsych.
http://salty-meadow-30207.herokuapp.com/
MIT License
7 stars 9 forks source link

Password authentication failure in fetch_data.py #18

Closed fredcallaway closed 1 year ago

fredcallaway commented 1 year ago

(From Jonathan)

I’m getting a bizarre error when I go to fetch the data from my experiment (running bin/fetch_data.py version; this has been working completely fine until now).

psycopg2.OperationalError: connection to server at "ec2-44-215-1-253.compute-1.amazonaws.com" (44.215.1.253), port 5432 failed: FATAL:  password authentication failed for user "pecjzmgvmcffme"
connection to server at "ec2-44-215-1-253.compute-1.amazonaws.com" (44.215.1.253), port 5432 failed: FATAL:  no pg_hba.conf entry for host "84.33.153.8", user "pecjzmgvmcffme", database "d1gh6l0jffv33e", no encryption
fredcallaway commented 1 year ago

@jonathanicholas

I am not able to reproduce this error with a fresh clone of your fork (https://github.com/jonathanicholas/feat-bandit)

jonathanicholas commented 1 year ago

I deleted .database_url and it fixed it. not sure what happened, but that's the fix if anyone encounters something like this in the future

fredcallaway commented 1 year ago

Ah okay that makes sense. Fixed by 092fa0364931e9314509327dff3889a5f7ca2fd9

jonathanicholas commented 1 year ago

but so somehow the actual url became different from that saved by previous runs of the fetch_data script. Is that something the automatic heroku updates may do?

fredcallaway commented 1 year ago

Yes I think Heroku must have your database URL. It's not a common thing though, certainly not with every database update (in my experience at least).