Site is down

2 years ago

https://barnabynagy.com/

Just changed MySQL server to Virginia and deployed and then it went offline. It's like this for about 30 min now. What could it be?

Closed

36 Replies

2 years ago

N/A


2 years ago

please check your deployment logs for errors


2 years ago

1248082922557407232


2 years ago

what's the deployment status of your database service


2 years ago

1248084807678824548


2 years ago

can you connect to it with a database client like dbgate?


2 years ago

Did the volume transfer successfully as well? Think another of my projects was screwed over because it hadn’t transferred some volumes.


2 years ago

I don't know how to do that


2 years ago

It showed me that it sucesfully transferred to Virginia


2 years ago

please see their docs -


2 years ago

I lost you. I'm not a dev guy


2 years ago

help me, help you


2 years ago

I don't know what you mean


2 years ago

This is the MySQL error

1248091569215639664


2 years ago

let me know if you can connect to the database with dbgate


2 years ago

there are no errors there


2 years ago

The reds are not errors?


2 years ago

that is correct


2 years ago

I was able to connect with dbgate

1248093035821273098


2 years ago

  • add a ENABLE_ALPINE_PRIVATE_NETWORKING=true service variable
  • change the database__connection__host variable to ${{MySQL.RAILWAY_PRIVATE_DOMAIN}}
  • change the database__connection__port variable to ${{MySQL.RAILWAY_TCP_APPLICATION_PORT}}
  • deploy the changes

2 years ago

I did the first one


2 years ago

I don't see database__connection__host - where is this?


2 years ago

in your service variables


2 years ago

1248097855055331358


2 years ago

in your ghost service, do not modify variables on your database


2 years ago

ah


2 years ago

Like this?

1248098506590130217


2 years ago

correct, one variable down, two more to go


2 years ago

1248098695883259986


2 years ago

looks good to me


2 years ago

Seems to be have worked


2 years ago

Thank you


2 years ago

What I cannot fathom is that why changing mysql server location would put the site down. And before these variables the site was working fine


2 years ago

im at just as much of a loss as you


2 years ago

Haha ok


2 years ago

Thanks anyway


Welcome!

Sign in to your Railway account to join the conversation.

Loading...