django.db.utils.OperationalError: fe_sendauth: no password supplied

Question

I have cloned a repo from github and working on it. The project was in django and using postgres as database. This project is now on the production side and I need to make some changes to it. The database specs is :

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        # Or path to database file if using sqlite3.
        'NAME': 'project_name',
        'USER': 'admin',
        'PASSWORD': '',
        # Empty for localhost through domain sockets or           '127.0.0.1'
        # for localhost through TCP.
        'HOST': 'localhost',
        'PORT': '5432',
    }
}

I want to run this on my local host but I am not able to. I am getting error:

django.db.utils.OperationalError: fe_sendauth: no password supplied

I have searched for this problem but couldn't find a solution that could help me. Can anyone tell me where the problem is?

Have you created the database with the project_name and 'admin' user. And are you sure the password is not required? — rishabsaraf93, Mar 25 '16 at 05:37
yeah I tried creating the database in PgAdminIII but it gives the same error there too. — the_unknown_spirit, Mar 25 '16 at 05:39
there seems to be some problem with your database. why dont you try the following commands in your terminal `psql -U postgres` followed by `create database project_name;`. if this works out change the user in the settings to postgres — rishabsaraf93, Mar 25 '16 at 05:45

score 33 · Answer 1 · answered Mar 25 '16 at 06:07

33

If you want to use a local password less connection then you need to remove the values "HOST", "PORT" and "PASSWORD".

With this configuration your connector will try to connect using a unix domain socket which is the only allowed password less connection allowed by default in Postgres

answered Mar 25 '16 at 06:07

Fitzgerald Muiseroux

512
3
6

Try to change the loggin to postgres instead of admin – Fitzgerald Muiseroux Mar 25 '16 at 06:27
where should I do that?? – the_unknown_spirit Mar 25 '16 at 07:04
1

In your settings.py, try 'user': 'postgres' – Fitzgerald Muiseroux Mar 25 '16 at 07:27
1

this was close for me, after reviewing `settings.py` (`'PASSWORD': os.getenv('DATABASE_PASSWORD'),`) I realized I had not activated the env vars in this new shell. – Harry Moreno Jun 20 '18 at 19:29

score 10 · Answer 2 · answered Mar 25 '18 at 09:06

I can think of two possible solutions to this problem.

First, if there is no password for the database, remove the PASSWORD key. E.g.:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'project_name',
        'USER': 'admin',
        'HOST': 'localhost',
        'PORT': '5432',
    }
}

Second, if there is a password for the database, provide it in the PASSWORD key:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'project_name',
        'USER': 'admin',
        'PASSWORD': '<YOUR PASSWORD HERE...>',
        'HOST': 'localhost',
        'PORT': '5432',
    }
}

score 1 · Answer 3 · answered Jun 25 '20 at 12:40

1

Maybe a stupid thing. But for me the problem was that postgres wasn't actually running. So always check whether it's running.

In Linux:

sudo service postgresql status

answered Jun 25 '20 at 12:40

kramer65

50,427
120
308
488

Ally M Mnenga · Answer 4 · 2022-12-12T18:46:11.413

TO CREATE NEW DATABASE Open pgAdmin, left click on Servers then right click on PostgreSQL--->Create--->Database. Fill the database name field, let say SCHOOL and save.

TO REGISTER SERVER Right click on Servers then Register-->Server, fill the Name field with any name of your choice for example admin. Navigate to connection, fill the Hostname/address field with localhost or 127.0.0.1,fill the password field let say 1234 and save password, leave other fields as they are. image may not be available at the moment

Finally your codes snippet will be like the below one;

DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.postgresql_psycopg2',
    'NAME': 'SCHOOL',
    'USER': 'postgres',
    'PASSWORD': '1234',
    'HOST': 'localhost',
    'PORT': '5432',
}

}

Lauriano Elmiro Duarte · Answer 5 · 2023-08-07T03:28:04.583

0

This happened to me now, I found out it was db version.

edited Aug 07 '23 at 03:28

answered Aug 06 '23 at 06:16

Lauriano Elmiro Duarte

9
2

django.db.utils.OperationalError: fe_sendauth: no password supplied

5 Answers5