SCRAM secret error for user netbox.
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
Does this happen with the default Docker compose setup or do you use your own database server?
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
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.
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
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"
host all all all trust
@ArdeSeadis
how did you set:
host all all all trust
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