Uploaded image for project: 'Satellite'
  1. Satellite
  2. SAT-9665

[RFE] Support SCRAM based authentication for Postgresql

XMLWordPrintable

      Description of problem:

      Satellite 6.10 installation is failing with the below error:

      ===
      2022-03-14 10:17:28 [DEBUG ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/unless: psycopg2.OperationalError: SCRAM authentication requires libpq version 10 or above
      2022-03-14 10:17:28 [DEBUG ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/unless: django.db.utils.OperationalError: SCRAM authentication requires libpq version 10 or above
      ===

      pulp is relying on /usr/lib64/libpq.so.5 provided by postgresql-libs-9.2.24 but it's too old to support database authentication using SCRAM-SHA-256 (because MD5 is not supported on FIPS).

      Making a symlink from the software collection helps to make it work:

      ln -s /opt/rh/rh-postgresql12/root/usr/lib64/libpq.so.rh-postgresql12-5 /usr/lib64/libpq.so.5

      Version-Release number of selected component (if applicable):
      Satellite 6.10.3 FIPS, external PostgreSQL 12 (FIPS too)

      How reproducible:
      100%

            jira-bugzilla-migration RH Bugzilla Integration
            egolov@redhat.com Evgeni Golov
            RH Bugzilla Integration RH Bugzilla Integration
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: