Description of problem:

A long-awaited feature has landed in the pulp of satellite 6.12 i.e. https://github.com/pulp/pulpcore/pull/2149.

Using "pulpcore-manager analyze-publication" we are now able to see filename, artifact location and pulp href of the artifact for any given publication id or distribution path.

But EVEn if it works, it displays a WARNING and it's not possible to use "--tabular" option as well.

Version-Release number of selected component (if applicable):

Satellite 6.12
python39-pulpcore-3.18.6-2.el8pc.noarch

How reproducible:

Always

Steps to Reproduce:
1. Install a Satellite 6.12 with Organization name RedHat

2. Enable RHEL 7.9 Kickstart repo and sync it with immediate download policy.

3. Find out it's distribution_path:

1. echo "select relative_path from katello_repositories where relative_path like '%7.9/x86_64/kickstart%' ;" | su - postgres -c "psql foreman"

4. Run "pulpcore-manager analyze-publication" against the same with and without --tabular option.

Actual results:

1. echo "select relative_path from katello_repositories where relative_path like '%7.9/x86_64/kickstart%' ;" | su - postgres -c "psql foreman"
   relative_path
   ---------------------------------------------------------------------------------------------
   RedHat/Library/content/dist/rhel/server/7/7.9/x86_64/kickstart

1. PULP_SETTINGS=/etc/pulp/settings.py pulpcore-manager analyze-publication --distribution-base-path 'RedHat/Library/content/dist/rhel/server/7/7.9/x86_64/kickstart' | grep vmlinuz -A2
   System check identified some issues:

WARNINGS:
?: (guardian.W001) Guardian authentication backend is not hooked. You can add this in settings as eg: `AUTHENTICATION_BACKENDS = ('django.contrib.auth.backends.ModelBackend', 'guardian.backends.ObjectPermissionBackend')`.
images/pxeboot/vmlinuz
└─ Storage path: /var/lib/pulp/media/artifact/9f/67343147f945a5e75f14e9012315d8300d78fb67b1a35db1e561b0b261c06c
└─ Artifact href: /pulp/api/v3/artifacts/6a5c1151-ebd2-485e-a718-66c119f17a10

1. PULP_SETTINGS=/etc/pulp/settings.py pulpcore-manager analyze-publication --distribution-base-path 'RedHat/Library/content/dist/rhel/server/7/7.9/x86_64/kickstart' --tabular
   System check identified some issues:

WARNINGS:
?: (guardian.W001) Guardian authentication backend is not hooked. You can add this in settings as eg: `AUTHENTICATION_BACKENDS = ('django.contrib.auth.backends.ModelBackend', 'guardian.backends.ObjectPermissionBackend')`.
CommandError: 'prettytable' package must be installed.

Expected results:

• No such WARNINGS about AUTHENTICATION_BACKENDS

• --tabular should work on RHEL 8.6 as well ( as it's the latest baseos of satellite 6.12 )

Additional info:

• This is the default config that comes with Sat 6.12 and it indeed does not have those AUTHENTICATION_BACKENDS that pulp is asking:

1. grep AUTHENTICATION_BACKENDS /etc/pulp/settings.py
   AUTHENTICATION_BACKENDS = ['pulpcore.app.authentication.PulpNoCreateRemoteUserBackend']

• RHEL 8 ships python3-prettytable-0.7.2-14.el8.noarch but the prettytable module that comes along with it is for python 3.6 and pulp uses python 3.9. That's why the error.