https://supabase.com/ logo
#python
Title
# python
z

zachtsk

06/07/2022, 1:44 PM
Does anyone have experience using Supabase as a database with Django on GCP? I'm able to connect to the database locally, but when I deploy to Google App Engine I get a HTTP 500 error. For additional context, when I swapped out the connection with a different postgres instance (digital ocean) I am able to connect from my app engine environment without making any other changes. I'm assuming it has something to do with with the SSL cert, but app engine uses SSL by default, so not sure what other avenues to test.
m

mansueli

06/07/2022, 4:45 PM
Do you get any other errors? How are you connecting? Do you see any connection errors in Postgres logs? https://app.supabase.com/project/_/database/postgres-logs
z

zachtsk

06/07/2022, 7:32 PM
Thanks for responding! I just re-deployed the app engine instance and seeing authentication issues in the supabase logs:
password authentication failed for user "postgres"
I double-checked the login credentials being used and they work when I run the instance locally.
"detail": "Connection matched pg_hba.conf line 94: \"host  all  all  0.0.0.0/0  scram-sha-256\"",
s

spetz83

06/08/2022, 2:21 AM
Is it possible that you are defining your connection string or credentials in a .env file or something that doesn't exist on the gcp deployment?
z

zachtsk

06/09/2022, 10:47 AM
I don't think that is the issue. I've swapped out the connection variables to test other services and each time the other services work.