New development environment fails to connect to db
carshoesch
HOBBYOP

a year 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

a year 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 12 months 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

a year 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 12 months ago


carshoesch
HOBBYOP

a year ago

This is what I see after it runs for a while

Attachments


a year 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 12 months 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

a year 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 12 months ago


carshoesch
HOBBYOP

a year ago

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


Status changed to Solved parmstar 12 months ago


Loading...