"Failed to fetch password" error in console
I thought I was just cleaning up some old roles on an older project, but I've messed something up. Now when I try to view the tables, or any data on the project, I get "Failed to fetch password" errors. I can access things with
psql and from my app with a known-good role/password, but I don't really understand what role the UI is using and/or how to change it. I'd like to use the UI.9 Replies
extended-salmon•15mo ago
When you refresh the console on the table UI, does the error persist?
rare-sapphireOP•15mo ago
Yes. I've tried a full logout/login and login with a different browser, too.
rare-sapphireOP•15mo ago
I compared network requests with a working project. The broken one gets a 404 from the
/reveal_password endpoint:
flat-fuchsia•14mo ago
I also have the exact same problem.
Seems like you can delete the role:
neon_superuser but can't create one.correct-apricot•14mo ago
@Eduard Dyckman can you take a look?
generous-apricot•14mo ago
Hi! Can you share how did you manage to delete a neon_superuser role? I am pretty sure the user-available roles don't have the necessary rights.
To restore the connection to the database, you can try resetting the password for some role, that is available via console UI in the Dashbords, Connection info widget
flat-fuchsia•14mo ago
@Eduard Dyckman Tbh, It was a few months ago, so I'm not 100% sure what the exact role name was, but it contains the "neon" in the role name.
Here is what happened:
1. I opened the dashboard.
2. Picked a Database -> Overview -> Roles & Databases
3. I found a role that I was not using, I'm pretty sure the role used to contain the "neon" keyword.
4. Proceed to delete that role.
5. After that any interaction from the dashboard with the database was not working anymore.
generous-apricot•14mo ago
Hmm, I see that if I try to delete a role that owns a database, I get an error saying that a role that owns a database cannot be deleted. It's possible that we have already fixed that misbehavior
rare-sapphireOP•14mo ago
I also did something similar, and definitely all through the UI. I can say the project in question is really old, like mid-2022.