Site is down
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?
Solution:Jump to solution
- 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...31 Replies
Project ID:
N/AN/A
please check your deployment logs for errors
what's the deployment status of your database service
can you connect to it with a database client like dbgate?
Did the volume transfer successfully as well? Think another of my projects was screwed over because it hadn’t transferred some volumes.
I don't know how to do that
It showed me that it sucesfully transferred to Virginia
please see their docs - https://dbgate.org/docs/
I lost you. I'm not a dev guy
help me, help you
I don't know what you mean
This is the MySQL error
let me know if you can connect to the database with dbgate
there are no errors there
The reds are not errors?
that is correct
I was able to connect with dbgate
Solution
- 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 changesI did the first one
I don't see databaseconnectionhost - where is this?
in your service variables
in your ghost service, do not modify variables on your database
ah
Like this?
correct, one variable down, two more to go
looks good to me
Seems to be have worked
Thank you
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
im at just as much of a loss as you
Haha ok
Thanks anyway