Password Authentication failed while running the server

Troubleshooting
,
1

I am trying to configure taiga on localhost with source code .At start while creating taiga database i had put password which is same as django password and as well as machine paasword . Still it shows password authentication failed for user taiga . Given below is the command and after which it shows errror

command :- python manage.py migrate --noinput
output :-

taiga issue
taiga issue978×506 122 KB

I have done some changes in pg_hba file

Database administrative login by Unix domain socket

local all postgres peer

TYPE DATABASE USER ADDRESS METHOD

“local” is for Unix domain socket connections only

local all all md5

IPv4 local connections:

host all all 127.0.0.1/32 scram-sha-256

IPv6 local connections:

host all all ::1/128 scram-sha-256

Allow replication connections from localhost, by a user with the

replication privilege.

local replication all peer
host replication all 127.0.0.1/32 scram-sha-256
host replication all ::1/128 scram-sha-256
local all taiga peer
local all taiga md5
local all taiga peer
host taiga taiga 127.0.0.1/32 md5

Here the password is same as the password of Taiga database user , postgres and django as well as machine. Below is the output when i try to access postgres with the same password

(.venv) internship02@DESKTOP-T6U948E:~/taiga-back$ su - postgres
Password:
postgres@DESKTOP-T6U948E:~$ psql -U taiga
Password for user taiga:
psql (14.9 (Ubuntu 14.9-0ubuntu0.22.04.1))
Type “help” for help.

taiga=>

(.venv) internship02@DESKTOP-T6U948E:~/taiga-back$ su - postgres
Password:
postgres@DESKTOP-T6U948E:~$ psql
psql (14.9 (Ubuntu 14.9-0ubuntu0.22.04.1))
Type “help” for help.

postgres=#

psql
psql979×513 65.8 KB

I have checked the port and tried to restart the server as well and checked the server status as well it shows server online .

2

Hi @Rutuja_Nar,

If you can connect to the database using the psql client you should be able to connect from Taiga using the same user, database and port. I would initially discard a postgres configuration problem in the pg_hba.conf file.

What’s your DATABASES connection value in your Taiga’s back-end config file?
settings/config.py

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'taiga',
        'USER': 'taiga',
        'PASSWORD': 'xxxxx',
        'HOST': 'localhost',
        'PORT': '5432',
    }
}

Other than that, ensure you have follow all the postgres and database configuration steps from the installation guide.