New development environment fails to connect to db
carshoesch
HOBBYOP

2 years ago

Hello, I created a new environment "development" and filled the db with values in my database tool. The tool shows me the values and I can use SQL-Statements to manipulate the DB, but the frontend from railway breaks if I click on one of the tables and shows me "Database Connection

We are unable to connect to the database over the public network.

Can you connect using this command?..."

Could someone give me a hand? What am I doing wrong?

Solved

6 Replies

2 years ago

Hello,

The Data tab on the databases in both the prod and dev environment works for me.

Are you able to provide a screen recording of the error?

Best,

Brody


Status changed to Awaiting User Response Railway • over 1 year ago


brody

Hello, The Data tab on the databases in both the prod and dev environment works for me. Are you able to provide a screen recording of the error? Best, Brody

carshoesch
HOBBYOP

2 years ago

Hey Brody, thanks for the fast reply.

Have you opened one of the tables? Unfortunately my linux doesn't like screen recordings, sorry :)


Status changed to Awaiting Railway Response Railway • over 1 year ago


carshoesch
HOBBYOP

2 years ago

This is what I see after it runs for a while

Attachments


2 years ago

Ah gotcha, likely because you don't have an index, or some other unsupported table schema we don't support, unfortunately this means you will need to use an external database tool like dbgate.


Status changed to Awaiting User Response Railway • over 1 year ago


brody

Ah gotcha, likely because you don't have an index, or some other unsupported table schema we don't support, unfortunately this means you will need to use an external database tool like dbgate.

carshoesch
HOBBYOP

2 years ago

Ok, so the database itself works, but I simply can't view it in the railway frontend?


Status changed to Awaiting Railway Response Railway • over 1 year ago


carshoesch
HOBBYOP

2 years ago

I managed to fix it. It was indeed a wrongly imported type. This thread can be closed, thanks.


Status changed to Solved parmstar • over 1 year ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...