search

netbox-community / netbox-docker

šŸ³ Docker Image of NetBox
https://github.com/netbox-community/netbox-docker/wiki
Apache License 2.0
1.81k stars 828 forks source link

SCRAM secret error for user netbox. #1086

Open stampeder opened 1 year ago

stampeder commented 1 year ago

Current Behavior

I have installed Netbox docker using the getting started tutorial in the Wiki a couple of times and get the same error each time: netbox-docker-redis-1 | 1:M 18 Sep 2023 12:49:25.628 * Ready to accept connections tcp netbox-docker-postgres-1 | 2023-09-18 12:49:27.853 UTC [77] FATAL: password authentication failed for user "netbox" netbox-docker-postgres-1 | 2023-09-18 12:49:27.853 UTC [77] DETAIL: User "netbox" does not have a valid SCRAM secret. netbox-docker-postgres-1 | Connection matched pg_hba.conf line 100: "host all all all scram-sha-256" netbox-docker-netbox-1 | django.db.utils.OperationalError: connection failed: FATAL: password authentication failed for user "netbox" netbox-docker-netbox-1 | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ] netbox-docker-netbox-1 | ā³ Waiting on DB... (24s / 30s) netbox-docker-postgres-1 | 2023-09-18 12:49:33.783 UTC [78] FATAL: password authentication failed for user "netbox"

I have run the test.sh script and it passes without issue. I also have an instance of Netbox 3.5 running on baremetal and it does not exhibit this behaviour. Therefore, I believe this is definitely a bug in the docker image. Thanks. Glenn.

Expected Behavior

This SCRAM error should not be occuring.

Docker Compose Version

Docker Compose version v2.17.2

Docker Version

Client: Docker Engine - Community
 Version:           23.0.3
 API version:       1.42
 Go version:        go1.19.7
 Git commit:        3e7cbfd
 Built:             Tue Apr  4 22:05:41 2023
 OS/Arch:           linux/amd64
 Context:           default

Server: Docker Engine - Community
 Engine:
  Version:          23.0.3
  API version:      1.42 (minimum version 1.12)
  Go version:       go1.19.7
  Git commit:       59118bf
  Built:            Tue Apr  4 22:05:41 2023
  OS/Arch:          linux/amd64
  Experimental:     false
 containerd:
  Version:          1.6.20
  GitCommit:        2806fc1057397dbaeefbea0e4e17bddfbd388f38
 runc:
  Version:          1.1.5
  GitCommit:        v1.1.5-0-gf19387a
 docker-init:
  Version:          0.19.0
  GitCommit:        de40ad0

The git Revision

no output available

The git Status

no output available

Startup Command

docker compose up

NetBox Logs

gtracy@ansible-nas:~/projects/netbox-docker$ docker compose logs netbox
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (0s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (3s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (6s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (9s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (12s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (15s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (18s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (21s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (24s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (27s / 30s)
netbox-docker-netbox-1  | āŒ Waited 30s or more for the DB to become ready.
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (0s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (3s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (6s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (9s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (12s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (15s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (18s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (21s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (24s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (27s / 30s)
netbox-docker-netbox-1  | āŒ Waited 30s or more for the DB to become ready.

Content of docker-compose.override.yml

gtracy@ansible-nas:~/projects/netbox-docker$ cat docker-compose.override.yml
version: '3.4'
services:
  netbox:
    ports:
    - 8600:8080
tobiasge commented 1 year ago

Does this happen with the default Docker compose setup or do you use your own database server?

stampeder commented 1 year ago

Just to update the issues register. I did send an email. I am using everything as default. I followed the getting started instructions in the wiki. I am using the postgres db in netbox, not my own database server. Thanks. Glenn

tobiasge commented 1 year ago

Do you have a leftover Docker volume from a previous installation? You can check with docker volume ls. With a clean install I can't reproduce this problem.

ArdeSeadis commented 8 months ago

I have the same issue with last release (https://github.com/netbox-community/netbox-docker/releases/tag/2.8.0 )

I have to set "trust" in /var/lib/postgresql/data/pg_hba.conf host all all all trust

fishooo0815 commented 8 months ago

I am facing the same issue.

netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (0s / 30s)
netbox-docker-netbox-1  | django.db.utils.OperationalError: connection failed: FATAL:  password authentication failed for user "netbox"
netbox-docker-netbox-1  | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1  | ā³ Waiting on DB... (3s / 30s)
Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256"
fishooo0815 commented 8 months ago

host all all all trust

@ArdeSeadis how did you set: host all all all trust

ArdeSeadis commented 8 months ago

host all all all trust

@ArdeSeadis how did you set: host all all all trust

docker exec -it _netbox-docker-postgres-1_ /bin/bash vi /var/lib/postgresql/data/pg_hba.conf