Red Hat Bugzilla – Bug 1187011
registering a client with nightly(katello+foreman) server raises: PGError: ERROR: column hosts.mac does not exist
Last modified: 2017-02-23 15:37:23 EST
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:
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