Not able to connect to Databse
dknaik
HOBBYOP

a month ago

Data base connecting attempt happens but fails with message websocket failure, railway we are unable to connect to the database via ssh.

In the mysql I am trying to check DB tables but unable to connect getting above mentioned errors.

Solved$10 Bounty

5 Replies

Railway
BOT

a month ago

This thread has been opened as a bounty so the community can help solve it.

Status changed to Open Railway about 1 month ago


spatrickpaul
HOBBY

a month ago

How are you trying to connect to the database?

1 -MySQL client / CLI

2 -TablePlus / DBeaver / GUI tool

3 -From your app/code

4 -Railway dashboard

Which connection details are you using?

1 -Public URL (from Railway Variables)

2 -Private URL (internal railway network)

3 -Not sure which one


spatrickpaul

How are you trying to connect to the database? 1 -MySQL client / CLI 2 -TablePlus / DBeaver / GUI tool 3 -From your app/code 4 -Railway dashboard Which connection details are you using? 1 -Public URL (from Railway Variables) 2 -Private URL (internal railway network) 3 -Not sure which one

dknaik
HOBBYOP

a month ago

I am checking in 4 -Railway dashboard, Mysql database is up and running but I could not able to see the tabls in the mysql from railway dashboard, previously i was able to.


dknaik

I am checking in 4 -Railway dashboard, Mysql database is up and running but I could not able to see the tabls in the mysql from railway dashboard, previously i was able to.

spatrickpaul
HOBBY

a month ago

Fixes to try in order

  1. Hard refresh the dashboard

Press Ctrl + Shift + R (Windows/Linux) or Cmd + Shift + R (Mac)

Or open in an Incognito window

  1. Check Railway's status page

Railway may have an ongoing incident affecting the data browser:

https://status.railway.app

  1. Re-open the Data tab

Click away to another service or page

Come back to MySQL → Data tab

Sometimes it needs a fresh load to reconnect the WebSocket

  1. Run a query directly in Railway's Query tab

Instead of the Tables UI, try the "Query" tab in Railway's dashboard and run:

SHOW TABLES;

Then:

SELECT * FROM your_table_name LIMIT 10;

This bypasses the visual table browser and hits the DB directly.

If tables genuinely disappeared

Run this in the Query tab to confirm tables still exist:

SELECT table_name, table_rows

FROM information_schema.tables

WHERE table_schema = DATABASE();

If this returns your tables → it's purely a dashboard UI bug, data is safe.

If this returns empty → the database may have been reset

Can you try the Query tab approach and let me know what SHOW TABLES; returns? That will confirm immediately whether it's a UI glitch or an actual data issue.


dknaik
HOBBYOP

a month ago

Sorry , I think it is my laptops firewall blocking the websocket connection. I have tested in phone I can able to open view the tables. Thank you for your help.


dknaik

Sorry , I think it is my laptops firewall blocking the websocket connection. I have tested in phone I can able to open view the tables. Thank you for your help.

spatrickpaul
HOBBY

a month ago

OOh great.. you are welcome..


Status changed to Solved brody 30 days ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...