postgres | Railway | Page 1

hexed patrol Feb 6, 2023, 10:38 PM

#

I'm trying to deploy an Express app thats Using Postgres but when i added the variables from my .env to deploy I got this error message, anybody run into this before and able to trouble shoot it?

Screen_Shot_2023-02-06_at_5.36.31_PM.png

earnest peakBOT Feb 6, 2023, 10:38 PM

#

Project ID: 6a130fdb-576f-4486-9530-f65d39dfcf76

#

The Railway PostgreSQL database service allows you to provision and connect to a PostgreSQL database with zero configuration. When you run railway run in a project with the Postgres database service installed, we inject several environment variables. PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE, DATABASE_URL.

dawn pollen Feb 6, 2023, 10:57 PM

#

What port is your app listening on?

hexed patrol Feb 6, 2023, 11:09 PM

#

I've tried having it set to the suggested 0.0.0.0 as well as 4000 which was my original PORT in my .env

dawn pollen Feb 7, 2023, 11:41 AM

#

You should run it on 0.0.0.0:4000, assuming you have 4000 set as the PORT in your Railway variables.

hexed patrol Feb 8, 2023, 3:10 PM

#

hmm still running into some issues, would that be the PORT or the DB PORT or both?

dawn pollen Feb 8, 2023, 9:01 PM

#

The PORT.

austere pier Feb 9, 2023, 6:24 AM

#

check the logs, this is the default error message. Click the dots.

hexed patrol Feb 14, 2023, 6:59 PM

#

this is what I'm seeing on the deploy logs I have dotenv installed as well. when I check the build logs it was built sucsessfully and I dont have any errors

Screen_Shot_2023-02-14_at_1.58.26_PM.png

keen cedar Feb 14, 2023, 7:14 PM

#

hexed patrol this is what I'm seeing on the deploy logs I have dotenv installed as well. when...

Can you send over a copy of your package.json?

hexed patrol Feb 14, 2023, 7:45 PM

#

keen cedar Can you send over a copy of your `package.json`?

heres the package.json

  "name": "costanza-api-2.0",
  "version": "1.0.0",
  "description": "",
  "main": "server.js",
  "scripts": {
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "keywords": [],
  "author": "",
  "license": "ISC",
  "dependencies": {
    "cors": "^2.8.5",
    "dotenv": "^16.0.3",
    "env": "^0.0.2",
    "express": "^4.18.2",
    "nodemon": "^2.0.20",
    "pg": "^8.9.0"
  }
}

keen cedar Feb 14, 2023, 7:48 PM

#

Looking

hexed patrol Feb 14, 2023, 7:48 PM

#

build logs said sucsessfully built but I agree ha

Screen_Shot_2023-02-14_at_2.48.19_PM.png

hexed patrol Feb 14, 2023, 7:48 PM

#

keen cedar Looking

thank you!

keen cedar Feb 14, 2023, 7:49 PM

#

hmmm- your package lock doesn't have dotenv

#

can you delete your lock file?

#

then run npm i?

hexed patrol Feb 14, 2023, 7:52 PM

#

oh my fault I think I sent package.json

package.-lock.json has

{
  "name": "costanza-api-2.0",
  "version": "1.0.0",
  "lockfileVersion": 2,
  "requires": true,
  "packages": {
    "": {
      "name": "costanza-api-2.0",
      "version": "1.0.0",
      "license": "ISC",
      "dependencies": {
        "cors": "^2.8.5",
        "dotenv": "^16.0.3",
        "env": "^0.0.2",
        "express": "^4.18.2",
        "nodemon": "^2.0.20",
        "pg": "^8.9.0"
      }
    },

keen cedar Feb 14, 2023, 7:53 PM

#

No thats not the lock.

#

Essentially you wanna delete and regen this: https://github.com/drew-anello/costanza-api-2.0/blob/master/package-lock.json

#

With that said: it seems like an issue you can solve and not a Railway builder issue.

#

I can tell you got this 🙂

hexed patrol Feb 14, 2023, 7:56 PM

#

thank you just deleted and reinstalled, going to try again

#postgres