Bug 1187011
| Summary: | registering a client with nightly(katello+foreman) server raises: PGError: ERROR: column hosts.mac does not exist | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Sachin Ghai <sghai> | ||||
| Component: | Registration | Assignee: | Stephen Benjamin <stbenjam> | ||||
| Status: | CLOSED ERRATA | QA Contact: | Kedar Bidarkar <kbidarka> | ||||
| Severity: | high | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | Nightly | CC: | bbuckingham, kbidarka | ||||
| Target Milestone: | Unspecified | Keywords: | Regression, Triaged | ||||
| Target Release: | Unused | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| URL: | http://projects.theforeman.org/issues/9158 | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2015-08-12 05:22:32 UTC | Type: | Bug | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Attachments: |
|
||||||
redmine issue: http://projects.theforeman.org/issues/9158 Moving to POST since upstream bug http://projects.theforeman.org/issues/9158 has been closed ------------- Anonymous Applied in changeset commit:katello|8e90541ed394e40f5cb47f4a33339aa9921306f8. VERIFIED with Beta-Snap2 [root@yyyyy ~]# subscription-manager register --org="Default_Organization" --activationkey="rhel66_ak" The system has been registered with ID: be342f08-1622-43a4-93c2-4465a391d9e6 This bug is slated to be released with Satellite 6.1. Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHSA-2015:1592 |
Created attachment 985449 [details] on registering a client with server, production.log raises error Description of problem: On registering a rhel6 client with nightly server, subscription-manager throwing this error: -- failed to register client:: PGError: ERROR: column hosts.mac does not exist LINE 1: ...55218576' AND "hosts"."organization_id" = 256 AND "hosts"."m... ^ : SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."name" = '55218576' AND "hosts"."organization_id" = 256 AND "hosts"."mac" IN ('52:54:00:50:16:f5') LIMIT 1 -- Version-Release number of selected component (if applicable): nightly * apr-util-ldap-1.3.9-3.el6_0.1.x86_64 * candlepin-0.9.38-1.el6.noarch * candlepin-common-1.0.18-1.el6.noarch * candlepin-selinux-0.9.38-1.el6.noarch * candlepin-tomcat6-0.9.38-1.el6.noarch * elasticsearch-0.90.10-7.el6.noarch * foreman-1.8.0-0.develop.201501281301gitf8a56f5.el6.noarch * foreman-compute-1.8.0-0.develop.201501281301gitf8a56f5.el6.noarch * foreman-gce-1.8.0-0.develop.201501281301gitf8a56f5.el6.noarch * foreman-libvirt-1.8.0-0.develop.201501281301gitf8a56f5.el6.noarch * foreman-ovirt-1.8.0-0.develop.201501281301gitf8a56f5.el6.noarch * foreman-postgresql-1.8.0-0.develop.201501281301gitf8a56f5.el6.noarch * foreman-proxy-1.8.0-0.develop.201501280951gite1bc928.el6.noarch * foreman-release-1.8.0-0.develop.201501281301gitf8a56f5.el6.noarch * foreman-selinux-1.8.0-0.develop.201412151103gite2863e4.el6.noarch * foreman-vmware-1.8.0-0.develop.201501281301gitf8a56f5.el6.noarch * katello-2.1.0-1.201411061509gitb0b8f43.el6.noarch * katello-certs-tools-2.0.1-1.el6.noarch * katello-default-ca-1.0-1.noarch * katello-installer-2.2.0-1.201501272021gitf707d62.el6.noarch * katello-installer-base-2.2.0-1.201501272021gitf707d62.el6.noarch * katello-repos-2.1.1-1.el6.noarch * katello-server-ca-1.0-1.noarch * openldap-2.4.39-8.el6.x86_64 * pulp-docker-plugins-0.2.1-0.2.beta.el6.noarch * pulp-katello-0.3-3.el6.noarch * pulp-nodes-common-2.5.1-1.el6.noarch * pulp-nodes-parent-2.5.1-1.el6.noarch * pulp-puppet-plugins-2.5.1-1.el6.noarch * pulp-puppet-tools-2.5.1-1.el6.noarch * pulp-rpm-plugins-2.5.1-1.el6.noarch * pulp-selinux-2.5.1-1.el6.noarch * pulp-server-2.5.1-1.el6.noarch * python-ldap-2.3.10-1.el6.x86_64 * ruby193-rubygem-ldap_fluff-0.3.3-1.el6.noarch * ruby193-rubygem-net-ldap-0.10.0-1.el6.noarch * ruby193-rubygem-runcible-1.3.0-1.el6.noarch * rubygem-hammer_cli-0.1.4-1.201501260908gitf44b8c5.el6.noarch * rubygem-hammer_cli_foreman-0.1.4-1.201501221305git706b057.el6.noarch * rubygem-hammer_cli_foreman_bootdisk-0.1.2-1.el6.noarch * rubygem-hammer_cli_foreman_tasks-0.0.3-2.201409091410gitc96619d.git.0.37f3704.el6.noarch * rubygem-hammer_cli_import-0.10.4-1.el6.noarch * rubygem-hammer_cli_katello-0.0.7-1.201501281312git793226f.git.0.8e37bfd.el6.noarch How reproducible: always Steps to Reproduce: 1. register a system(rhel6) using subscription-manager with katello+foreman nightly server 2. subscription-manager register --activationkey NfvlzxrgYN --org dff94f38-2e3d-4a5a-b532-ce88f3bb2eea --force Actual results: -- failed to register client:: PGError: ERROR: column hosts.mac does not exist LINE 1: ...55218576' AND "hosts"."organization_id" = 256 AND "hosts"."m... ^ : SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."name" = '55218576' AND "hosts"."organization_id" = 256 AND "hosts"."mac" IN ('52:54:00:50:16:f5') LIMIT 1 -- Expected results: registration should succeed Additional info: