8f22bd42-f5e7-4c51-b7de-0fb5ac0c98b7

Environment variables

https://www.freecodecamp.org/news/python-env-vars-how-to-get-an-environment-variable-in-python/

https://www.postgresql.org/docs/current/libpq-envars.html

On railway:

https://i.imgur.com/yvR4tPK.png

os.getenv('DB_NAME') ?

thats just an example btw

Okay so

don't actually print your secrets

?

I'd assume so - port may throw type errors (unsure how python likes this)

my python knowledge is sketchy at best

Oh

Lemme try it rq

Hmph

I tried it

@BillyDotWS

I'm getting an error

are you positive it's running on 5000?

normally runs on 5432 by default

• are you running this on railway or locally?

this won't work locally, you'll need to use the public domain

yes

the postgresql im running it on railway

and your service?

or are you running the service locally

python server too

on railway

the same project

two diff services

i dont know how to change the port, what i did was change the "pgport" to 5000 and also change the port in the settings to 5000

thats what i

usualyl do

in my python apis

can you change port back to 5432 on both

sure

I think you have to do a tad extra to change the port postgres runs on on the postgres side

once we figure out if that's the issue, then you can figure that part out if you want to change it for whatever reason

alrightyy

im redeploying the python api

progress!

I see that the password authentication failed

so, is the password correct

I linked the password

and you didn't change that, right?

dont know why

nope

i didnt change it

check PGPASSWORD is filled with a print

I've seen a couple cases on my dashboard where it goes missing randomly

what do you mean filled with a print?

print(os.getenv('PGPASSWORD'))

or a null check

it has random letters and numbers

and does not have a print

check it's in your container runtime

oh

(null check is probably a better idea if this is a prod app)

wait

connection to server at "postgres.railway.internal" (fd12:464e:84c::6a:9860:cc56), port 5432 failed: FATAL: password authentication failed for user "postgres"

this means both the port and authentication failed?

nope, just auth

port 5432 failed: FATAL

if you see auth failed, the connection is fine

that's just the address details

oh

okay so i dont get what you mean the pgpassword is filled with a print😭

In your code - check the environment variable has stuff in it

it links the connection using this:

def get_db_connection():
    conn = psycopg2.connect(**DB_PARAMS)
    return conn

and this is the DB_PARAMS:

DB_PARAMS = {
    'dbname': os.getenv('PGDATABASE'),
    'user': os.getenv('PGUSER'),
    'password': os.getenv('PGPASSWORD'),
    'host': os.getenv('PGHOST'),
    'port': os.getenv('PGPORT')
}

environnement variable has no stuff in it, it just uses os to get the environnement variable

?

@BillyDotWS

any idea?

Check that your environment variables are all setup correctly

print(os.getenv('PGDATABASE'))
print(os.getenv('PGUSER'))
print(os.getenv('PGPASSWORD'))
print(os.getenv('PGHOST'))
print(os.getenv('PGPORT'))

Alrighty

your postrgres password got changed, i've reverted that for you

oh alright

looks like you are hardcoding the password in your code now, please use only environment variables

oh

yeah

wait ill change it

that was earlier before u told me the postgres pass was changed

but now ive fixed it

im redeploying

great it worked!

thanks!

its online, now theres the new problem -

This is a development server. Do not use it in a production deployment. Use a production WSGI server instead.

you need to be using gunicorn

do i need to replace my flask application with gunicorn?

or just like setup gunicorn?

ive never used gunicorn

you need to run your flask app with gunicorn

alrighty

thanks for the help

u can close this nwo

now*

!close

uh

😭

is!close

what😭

are you using gunicorn now?

actually

yes

but the app failed to load

[2025-02-04 19:43:31 +0000] [1] [ERROR] Worker (pid:4) exited with code 4

[2025-02-04 19:43:31 +0000] [1] [ERROR] Shutting down: Master

[2025-02-04 19:43:31 +0000] [1] [ERROR] Reason: App failed to load.

😭

god help me

what is your start command

web: gunicorn -w 4 -b 0.0.0.0:3540 wsgi:app

i js did a fix

lemme see if it works

works!

dont know what this means but it means it works i guess

what was the fix

uhh the wsgi.py was empty💀

😭

i added soem code to it

that makes the db tables

and

runs the app

also when im using my server in a js environnement do i need to include the port? i usually dont do the port nnd it works

as long as you are listening on the PORT environment variable

yeah

you can close this now

!s