Pulp user not able to auth in database

Support
#1

Hello everyone,

I have this error in my pulp database pod:

2025-02-17 14:46:05.743 UTC [42] DETAIL:  Connection matched pg_hba.conf line 99: "host all all all scram-sha-256"
2025-02-17 14:46:06.412 UTC [43] FATAL:  password authentication failed for user "pulp"

Has anyone encountered this before ?

My migration and reset admin password job fail with: django.db.utils.OperationalError: connection failed: connection to server at "IP", port 5432 failed: FATAL: password authentication failed for user "pulp"

I deployed the operator using OperatorHub.io | The registry for Kubernetes Operators.

k8s version: 1.26.5

Pulp file:

apiVersion: repo-manager.pulpproject.org/v1beta2
kind: Pulp
metadata:
  name: pulp
  namespace: pulp
  labels:
    app: pulp
spec:
  ldap:
    config: pulp-ldap-secret
  pvc: pulp
  cache:
    enabled: true
    pvc: pulp-redis
  database:
    pvc: pulp-database
  pulp_settings:
    api_root: "/pulp/"
    allowed_export_paths:
      - /tmp
    allowed_import_paths:
      - /tmp
    content_origin: '{{ pulp_domain }}'
    token_server: '{{ pulp_token_server }}'
  api:
    replicas: 1
  content:
    replicas: 2
    resource_requirements:
      requests:
        cpu: 150m
        memory: 256Mi
      limits:
        cpu: 800m
        memory: 1Gi
  worker:
    replicas: 2
    resource_requirements:
      requests:
        cpu: 150m
        memory: 256Mi
      limits:
        cpu: 800m
        memory: 1Gi
  web:
    replicas: 1
#2

Hi @AJJA,

Sorry for the delayed response, things are a little bit busy in here.
I could not investigate this issue yet, but did you try to reinstall Pulp using the same DB PVC?

I will try to reproduce this in my lab env:

  • install pulp
  • delete it, but keeping the db PVC
  • try to install again using the same db PVC and see if this reproduces the error
2 Likes
#3

Hi @hyagi

No worries, thank you for finding time to answer.

Apparently the database pvc is not deleted and it gets attached when one redeploys. That said it somehow gets the old admin user data and it fails to authenticate after.

I modified the PVC to have Delete Reclaim Policy so that it deletes data after deleting the resources.

Thank you again , very helpful

2 Likes