Plugins » Katello

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1725244

Description of problem:

Foreman-debug collecting repos data through below command and displays that output in katello_repositories file.

1. echo "select id, name, checksum_type, updated_at from katello_repositories" | su postgres -c 'psql foreman'

But this command does not work in satellite 6.5

Version-Release number of selected component (if applicable):
satellite-6.5.0-11.el7sat.noarch

How reproducible:

Reproducible on 6.5 only

Actual results:

1. echo "select id, name, checksum_type, updated_at from katello_repositories" | su postgres -c 'psql foreman'
   could not change directory to "/root"
   ERROR: column "name" does not exist
   LINE 1: select id, name, checksum_type, updated_at from katello_repo...

Expected results:

Foreman-debug should collect the repos data in all version.

Additional info:

This works in satellite 6.5

1. echo "select id, name, checksum_type, updated_at from katello_root_repositories" | su postgres -c 'psql foreman'