postgresql django not sending password

Question

I am getting the error OperationalError: fe_sendauth: no password supplied on my production server but I cannot see why...

settings.py

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'dbname',
        'USER': 'dbuser',
        'PASSWORD': PROD_DB_PASSWORD,
        'HOST': 'localhost',
        'PORT': '5432',
        }
    }

pg_hba.conf:

host    dbname       dbuser       localhost               md5

If I do psql -d dbname -U dbuser -h localhost and then enter the password at the prompt I can see that it works so IDK why django is not sending the password and IDK where to look from here.

@e4c5 it is not a duplicate...His solution was to just use 'trust' which is specifically what I am trying to move away from — Joff
– Joff, Commented Dec 16, 2016 at 1:57

munsu · Accepted Answer · 2016-12-16 03:14:40Z

4

I suspect you're not passing the password correctly. Here's how you debug. After the DATABASES line in settings.py, can you try printing out the dict.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'dbname',
        'USER': 'dbuser',
        'PASSWORD': PROD_DB_PASSWORD,
        'HOST': 'localhost',
        'PORT': '5432',
        }
    }
print DATABASES

Then manage.py runserver as you would.

See if the password is properly passed. Apologies my rep's not enough to comment yet.

answered Dec 16, 2016 at 3:14

munsu

2,08221 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Joff Over a year ago

I tried it in a shell...Had a problem with an old config importing the wrong set of settings on the production server

Shanika Ediriweera Over a year ago

I printed the DATABASES and USER and PASSWORD is there properly. yet I get FATAL: password authentication failed for user "db_admin"

munsu Over a year ago

will need more info than that @ShanikaEdiriweera. Try filing a new question.

Umar Hayat · Accepted Answer · 2021-05-08 23:31:26Z

4

For future readers also check the spelling and later cases. All database keys must be in UPPER CASE e.g ENGINE, NAME, USER, PASSWORD, HOST and PORT.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': os.getenv("DB_NAME", "db_name"),
        "USER": os.getenv("DB_USERNAME", "db_user"),
        "PASSWORD": os.getenv("DB_PASSWORD", "db@password"),
        "HOST": os.getenv("DB_HOST", "localhost"),
        "PORT": os.getenv("DB_PORT", "5432")
    }
}

answered May 8, 2021 at 23:31

Umar Hayat

5,0812 gold badges18 silver badges28 bronze badges

Collectives™ on Stack Overflow

postgresql django not sending password

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related