Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SCRAM secret error for user netbox. #1086

Open
stampeder opened this issue Sep 18, 2023 · 7 comments
Open

SCRAM secret error for user netbox. #1086

stampeder opened this issue Sep 18, 2023 · 7 comments

Comments

@stampeder
Copy link

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
Copy link
Member

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

@stampeder
Copy link
Author

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
Copy link
Member

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
Copy link

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
Copy link

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
Copy link

fishooo0815 commented Feb 1, 2024 •
edited

host all all all trust

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

@ArdeSeadis
Copy link

ArdeSeadis commented Feb 1, 2024 •
edited

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@tobiasge @stampeder @fishooo0815 @ArdeSeadis