Project Id: 18412832-e50f-40f0-8b15-650eaf03ec65

Are you using the template?

this one https://railway.com/template/strapi

No, the strapi version is old and I don’t know how to use it

I deployed my project on railway and deployed a new Postgres for the project

Please check the DB credentials

Check if strapi is using the correct ones

Everything works locally but not in production.

In database.ts: there are configs like PGHOST, PGDATABASE etc but environment variables are DATABASEHOST, DATABASENAME. Which is the right one to use

just updated it to use latest, do you want to give that a go?

If you are willing to show me how to

https://railway.com/template/strapi all instructions r here

Yeah, because locally ur postgres instance has other creds, ur trying to log in with "root" while the default user on the railway postgres db is "postgres"

Anyway, did u manage to deploy it through the template @frankiefab ?

No

Using this template requires me create new content types and documents on strapi

I can’t tell why the developer relations team at Railway suggest this same template for every problem. There should a better solution

hello, these people are community members and moderators, them recommending something that is known working is a good recommendation.

either way, the project you linked has been deleted

I know, I mean not here, in Railway forum.

would you like to provide a new project id for me to look into?

f9380294-0728-419c-b3e5-3a7d4901d233

alright fixed it up for you, you can look at your activity logs to see what i needed to do to fix your project up

Thank you. But any reason why the strapi content still doesn’t show up on the frontend even after successful deployment.

link to frontend please?

Seems I will need to update config/database.ts to match the Postgres env. variables

https://frankiefab.vercel.app/projects

Here is the page where the strapi content should display.

I already create config/env/production/database.ts:

module.exports = ({ env }) => ({
    connection: {
        client: 'postgres',
        connection: {
            host: env('PGHOST', '127.0.0.1'),
            port: env.int('PGPORT', 5931),
            database: env('PGDATABASE', 'railway'),
            user: env('PGUSER', 'postgres'),
            password: env('PGPASSWORD', 'password'),
            ssl: env.bool(true),
        },
    },
});

Didn’t make any changes to the default “config/database.ts”

nope, i aleady set the needed variables, please look at the changes i made in your activity tab

Yes, I saw it

this page is not makeing an api request to strapi to begin with

When the STRAPI_URL is already updated in the client side fetch request

have you logged into your strapi /admin pannel and made sure the needed data is there?

I see nothing. It looks like they were deleted

i'm sorry but i can't help with deleted data

I just run strapi locally via localhost:1337/admin. I see the contents.

But it doesn’t show nothing shows in the deployed strapi-railway url

when you develop locally, are you connecting to the postgres database on railway?

I don’t think so, just the default strapi MSQLite.

then of course there isnt going to be any data when you deploy to railway

I get this error when I try to

This too. After updating config/database.ts to connect to Postgres on railway

you need to use the public host and port when connecting to the database locally

Port is 5432, Host is my strapi server.railway.app??

Still getting the same error messages

Used Host:postgres. it didn’t work too

Neither of those are the public host or port, you can find the public host and port of your database under its public networking section

This. But on railway the Postgres port is 5432 and Public host points to DATABASEPUBLICURL which is different too. Sorry, this can be confusing. Do I need to update the Postgres variables again since the Strapi variables references it.

that is the public domain of your app, please look at the public networking section of the database, and please do not modify any variables on railway again as I have set them how they need to be

This doesn’t work too. I can’t access the url.

you need to use the TCP proxy

xxxxx.rlwy.net:12345??

yes

This should require use of websocket.

This url display: Application failed to respond

postgres does not use WebSockets

connect to the database with [viaduct.proxy.rlwy.net:17157](viaduct.proxy.rlwy.net:17157)

Doesn't work😔

it does, the data tab can connect to it, and the data tab uses that host and port

You mean it now works as the STRAPI URL? Nothing still shows up.here

when you develop locally you need to have strapi connect to the database on railway

Any helpful resources. What needs to be updated in config/database or config/server

this is why the community has recommended you the template -

please read its overview and look at how its setup -

going to mark this as solved now that you have all the resources you need to succeed now!

!s