Error Importing RHEL7/8 ISOs from RedHat Subscription

Support
1

Problem:
Selecting either the “Red Hat Enterprise Linux 7 (ISOs) → x86_64 +” or “Red Hat Enterprise Linux 8 for x86_64 - BaseOS (ISOs) → x86_64 8 +” in Content → Red Hat Repositories produces an error:

RHEL7: PG::NotNullViolation: ERROR: null value in column “root_id” violates not-null constraint DETAIL: Failing row contains (366, 0366939e-9fba-47ef-b79e-6702d4ab01ff, null, 1, RGA_IT_Ops/Library/content/dist/rhel8/8/x86_64/baseos/iso, 1, null, null, null, null, null, null, null, null, null, null, null, 1970-01-01 00:00:00, 1970-01-01 00:00:00, 1970-01-01 00:00:00).

RHEL8:
PG::NotNullViolation: ERROR: null value in column “root_id” violates not-null constraint DETAIL: Failing row contains (367, 5068a39f-0eba-425d-be01-326eb38c37e2, null, 1, RGA_IT_Ops/Library/content/dist/rhel/server/7/7Server/x86_64/iso, 1, null, null, null, null, null, null, null, null, null, null, null, 1970-01-01 00:00:00, 1970-01-01 00:00:00, 1970-01-01 00:00:00).

Expected outcome:
ISO Repository shows up on the Right Side of the screen under “Enabled Repositories”

Foreman and Proxy versions:
Foreman 3.1.1
Katello 4.3.0

Foreman and Proxy plugin versions:
foreman-tasks: 5.3.0
foreman_remote_execution: 5.0.1
foreman_virt_who_configure: 0.5.8
katello: 4.3.0

Distribution and version:
RHEL7 / RHEL8

Other relevant data:
Again, this is just going into the Red Hat Products, selecting the ISO products (in the filter dropdown make sure “Other” is selected) and trying to add them by hitting the “+” Button.

To back up a second, the larger intent is to provide a location where RHEL 7 / RHEL 8 ISO images reside within Katello so they are accessible through the Foreman/Katello server without having to manually download/move them somewhere.

2

I have no problem to enable rhel-7-server-isos repo locally.
Seems an issue related to your environment. Is there anything specific with yours?

3

Fresh install stood up mid/late last month to replace our existing Katello that is probably 5 years ago. The new install is on RHEL8 (from ISO from minimal package set) installed by a guy pretty massively familiar with Satellite 6. We do have “Capsule” servers associated with it, but I don’t know why that would be a problem.

Honestly i’m not sure what to look for here. The issue appears to be the onboarding of a database record for the ISO image, a record that is not properly formatted for inclusion (A Null in a Not Null Field). I don’t know how I would go about fixing that or even diagnosing it further.

4

Checking back in on this. No one’s seen this? This is just my installation?

5

I am seeing the same issue with a new install. Did you ever resolve this?

6

We have not resolved this either. Hoping for more community support.

7

Can you confirm the katello version of this. Is it 4.3 or have you upgraded since then?

8

It is 4.3 Katello. Was just informed by a co-worker that this is apparently fixed in Katello 4.5? Can we confirm this?

9

With Foreman 3.3 / Katello 4.5 on RHEL 8 minimal install and a proper subscription associated I was able to add Red Hat Enterprise Linux 8 for x86_64 - BaseOS ISOs 8 successfully.

10

I’ll go ahead and mark that as a solution. Apparently Katello 4.3 has problems with installing this particular package that 4.5 does not. We’ll mark it complete as: “Upgrade to 4.5 or beyond to get this working” as the answer.

Thanks all for your responses.

1 Like