Authentication is suddenly failing for Postgres user
curtis-gaye7
HOBBYOP

10 months ago

Hello,

I recently made a relatively standard commit to my railway servers that changed a few util functions. Nothing that should impact authentication credentials.

A few hours ago, however, all my services have begun failing with some version of authentication failure. Railway doesn't seem to be able to connect other the DB at all anymore:

'password authentication failed for user "postgres"'

I'm using the railway environment variables and have not manually entered them or messed with them recently. I'm at a loss as to how everything broke.

Thanks in advance

Solved

13 Replies

10 months ago

Hello,

Fixed that for you!

Best,
Brody


Status changed to Awaiting User Response Railway 10 months ago


Status changed to Solved curtis-gaye7 10 months ago


curtis-gaye7
HOBBYOP

10 months ago

Thanks Brody!


Status changed to Awaiting Railway Response Railway 10 months ago


10 months ago

No problem!


Status changed to Awaiting User Response Railway 10 months ago


Status changed to Solved brody 10 months ago


curtis-gaye7
HOBBYOP

10 months ago

Actually, the server is now refusing access to my frontend code now even though it is successfully deployed.


Status changed to Awaiting Railway Response Railway 10 months ago


10 months ago

Can you send me a link to where I could see such errors?


Status changed to Awaiting User Response Railway 10 months ago


curtis-gaye7
HOBBYOP

10 months ago


Status changed to Awaiting Railway Response Railway 10 months ago


curtis-gaye7
HOBBYOP

10 months ago

Reversed all my changes from yesterday and my servers are still rejecting all requests from my frontend with authentication failed (401).

Not sure how to resolve.


10 months ago

Hello,

The 401 would be something your application is returning, not our platform, this is something you will need to debug.

Best,
Brody


Status changed to Awaiting User Response Railway 10 months ago


curtis-gaye7
HOBBYOP

10 months ago

Did a little troubleshooting and figured out that my Postgres DB is completely empty now. Is there any way to recover the data?

Thanks for your assistance so far.


Status changed to Awaiting Railway Response Railway 10 months ago


curtis-gaye7
HOBBYOP

10 months ago

Could it have something to do with the Post Deploy not running?

Attachments


10 months ago

There is no post-deploy step for your postgres DB, so no. it's online and well slightly_smiling_face emoji


Status changed to Awaiting User Response Railway 10 months ago


curtis-gaye7
HOBBYOP

10 months ago

The DB is still empty though frowning_face emoji

Added a few screenshots. There's an additional mount on the dashboard I'm not used to being there, so maybe that's it?

I also remounted the volume once or twice yesterday before I saw the update about the bug on Railway. Could that have interfered? I made sure not to do anything that was permanent.


Status changed to Awaiting Railway Response Railway 10 months ago


10 months ago

Heya, I believe we solved this issue in your other thread. hope you're back online - lmk if we can help you further.


Status changed to Awaiting User Response Railway 10 months ago


Railway
BOT

7 months ago

This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!

Status changed to Solved Railway 7 months ago


Loading...