Postgres Auth Failed

[AntoninHL]

Hello,

I have installed a new instance of OpenCVE, but I have an issue with Postgres auth.

.env is modified:

POSTGRES_USER=opencve
POSTGRES_PASSWORD=xxxxxxxxx

conf/opencve.cfg is modified accordingly: database_uri = postgresql://opencve:xxxxxxxx@postgres:5432/opencve

But I have this when I try to initialize the DB: sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL: password authentication failed for user "opencve"

I tried to change password, put " or '... no chance.

Thanks for your help.

A./

[ncrocfer]

Hello,

Did you first check this answer? https://github.com/opencve/opencve/issues/95#issuecomment-839164010

As @ldurnez said:

Did you start the postgresql docker before changing the .env file? Is it working with the default password? As the postgresql data folder is a docker volume, the password is set with default values if there is none in .env file at the first boot of the instance. If you change it later, you need to update it directly in postgresql database.

[AntoninHL]

Really strange... Not possible to docker exec -it webserver opencve upgrade-db

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL: password authentication failed for user "opencve"

with or without password in .env

and for sure, before docker-compose build

[AntoninHL]

I tried everything... in vain. So I manually changed the password of the "opencve" user, I restarted a build, and an exec to initialize the database, and it's ok!