a year ago
when i try to create a new table from railway web the only thing that shows is this
Deployment Online
This service has an active deployment
Required Variables
This service has all the necessary variables that this UI uses to connect to the database.
Database Connection
and it gets stuck in database connection
i tried also to connect directly from mysql tools to modify the db from there but i cant connect from those either
8 Replies
a year ago
Hello,
Have you changed the username or password of the database since deploying?
Status changed to Awaiting User Response Railway • about 1 year ago
brody
Hello,Have you changed the username or password of the database since deploying?
a year ago
uhh no, gonna change it just in case, i just create the database from railway itself, or idk if u are refering to not to change anything
Status changed to Awaiting Railway Response Railway • about 1 year ago
a year ago
Hello,
I was not suggesting to change anything, was just a question.
But it is clear that you have changed something as the connection attempts are failing because of an incorrect password or username.
Since I don't know what you have done to the databases, I would have to recommend deploying MySQL again and to not modify anything with it.
Best,
Brody
Status changed to Awaiting User Response Railway • about 1 year ago
brody
Hello,I was not suggesting to change anything, was just a question.But it is clear that you have changed something as the connection attempts are failing because of an incorrect password or username.Since I don't know what you have done to the databases, I would have to recommend deploying MySQL again and to not modify anything with it.Best,Brody
a year ago
yeah, in my case i dont modify anything
i just create the database from railwail itself
w/o changing anything
i created other and still nothing
Status changed to Awaiting Railway Response Railway • about 1 year ago
brody
Hello,I was not suggesting to change anything, was just a question.But it is clear that you have changed something as the connection attempts are failing because of an incorrect password or username.Since I don't know what you have done to the databases, I would have to recommend deploying MySQL again and to not modify anything with it.Best,Brody
a year ago
ah yeah, i created another project and now it works
but now i just see this
Deployment Online
This service has an active deployment
Required Variables
This service has all the necessary variables that this UI uses to connect to the database.
Database Connection
We are unable to connect to the database over the public network.
Can you connect using this command?
mysql -hroundhouse.proxy.rlwy.net -uroot -p******** --port 18142 --protocol=TCP railwayat least i can modify from an sql editor but i sometimes want to watch directly from the railway ui
Status changed to Awaiting User Response Railway • about 1 year ago
brody
The data tab is working fine for me?
a year ago
strange, for me is like this
Attachments
Status changed to Awaiting Railway Response Railway • about 1 year ago
a year ago
Okay you left out the crucial information that you only get that error when you open the table.
Your schema for that table would generally be considered invalid, it is missing an index, so the data tab is unable to display it properly.
There are 3rd party software such as DbGate that are far more lenient on what is a valid data model, so please use DbGate instead.
Best,
Brody
Status changed to Awaiting User Response Railway • about 1 year ago
Status changed to Solved brody • about 1 year ago
