Hey, i'm going to need more context here, what kind of connection is timing out exactly?

Connection to the server. It seems that when I deploy the project, the server connection is not successful. Just a hunch this could be something with the host and the port. But can you tell me more about this, hopefully, you could help me

This is how it looks like in the deploy logs

From the surrounding logs that's connection refused to the MySQL database, please make sure you are using all the correct credentials for the database and they are in the format that the MySQL client expects.

This my value spring.datasource.url:

DB_HOST: 172.31.16.1

DB_PORT: 3306

DB_NAME: newdb

jdbc:mysql://${DB_HOST}:${DB_PORT}/${DB_NAME}

Can you tell me where should I get the right value for the host?

Where is 172.31.16.1 coming from, because that's a local address, where is your database hosted?

I don't where my database is hosted. And the value 172.31.16.1 is the value from IP4 under Ethernet adapter

I mean how do i find where my database is hosted?

Do you have a MySQL database deployed to Railway?

Is that support to be a separate deployment? Or together with my project?

It would be a separate Railway service within the same Railway project, can I take that as you don't have MySQL deployed to Railway?

Yeah I don't have have mysql deployed in railway

Go ahead and do that from within the Create menu at the top right of the project canvas.

I'm in the middle of configuring mysql service, Can I ask if i need to change values in the enviroment variables before deploying it?

No, that would be done after deploying.

Got it thanks

I deployed mysql database.

Use its variables to configure your MySQL client in code.

On it

With my deployed mysql service, I checked the logs and I see some highlights on it. Can this cause any issues?

Please keep in mind red does not always mean an error, you should consider the contents of the logs to determine if something is an error or not.

I see. Just checking

Hi again. This is my screenshot for my deployment of my project. There are no errors. Does this mean it's good?

Supposedly, does your app work as intended?

It's just that when I make a fetch to the url I get error for 502 Bad Gateway

What error logs do you get?

Here's a sample

Here's the screenshot

Sorry. Here it is

Here it is

I'm not seeing any errors in those logs.

It says 502 bad request

I'm sorry but that does not provide enough information.

I see. how to find the url for my restful api request in my deployed project?

That is found within the service settings.

This is what happens when I use the link found under the service settings. However, there seems to be no error on deploy logs

Please read this docs page - https://docs.railway.app/guides/fixing-common-errors

I checked that article it's giving me any hints on how to solve this issue

Should I create a Port Variable with a value on it?

The docs page goes over what fundamentally needs to be done to fix this issue, you do not need to set a port variable, but your app needs to listen on it.

Please carefully read the docs page.

I fixed it, I simply have to add another property in application.properties:

server.port={DB_PORT}

Thank you so much. You are an amazing help. Without your help, I will never make any success with this project.