https://supabase.com/ logo
Join Discord
Powered by
# help
  • d
    on the web panel postgres errors out with: "Error: [500] password authentication failed for user "postgres""
  • h
    did you actually change the password or just edit the env?
  • d
    I edited the env...
  • d
    Isn't that what you're supposed to do?
  • d
    That was kind of just a stupid guess
  • h
    postgrest has users, each user has a password
  • d
    right.
  • d
    I probably need to change the password back in the .env
  • d
    change the password in SQL
  • d
    then change the env again
  • d
    right?
  • h
    that is an option
  • h
    or access postgres directly and change the password
  • h
    sounds like you're querying through supabase? you can also query directly
  • d
    I assumed I could, I just understand so little about SQL databases that I find supabase easier
  • h
    ofcourse
  • d
    yeah it worked
  • d
    thank you
  • d
    except now
  • d
    with my actual application
  • d
    I'm getting the error
    Copy code
    JWSError JWSInvalidSignature
    when trying to query from the database
  • h
    are you working with an old access token maybe? (in other words, logout and login again)
  • h
    if not, did you change anything else in your env?
  • d
    The user isn't logged in
  • d
    this table is for public data that anyone can access
  • d
    like the terms of service
  • d
    I have an RLS policy to allow select *
  • d
    which normally works on the main app.supabase.io service
  • h
    do you have a valid jwt secret?
  • h
    should be more than 32 chars long
1...168169170...316Latest