Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 947502

Summary:	rhnreg_ks returns ISE registering to an org w/o software channel entitlements
Product:	[Community] Spacewalk	Reporter:	wes hayutin <whayutin>
Component:	Server	Assignee:	Michael Mráka <mmraka>
Status:	CLOSED DUPLICATE	QA Contact:	Red Hat Satellite QA List <satqe-list>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	1.9	CC:	msuchy
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2014-12-16 10:09:00 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:
Bug Depends On:
Bug Blocks:	1484117

Description wes hayutin 2013-04-02 15:28:10 UTC

Description of problem:

[root@ip-10-151-75-87 2ndSat]# rhnreg_ks --username org2 --password passw0rd --serverUrl https://wipe/XMLRPC --sslCACert=RHN-ORG-TRUSTED-SSL-CERT --force -vvv --systemorgid=3
D: rpcServer: Calling XMLRPC registration.welcome_message
D: opening  db environment /var/lib/rpm cdb:mpool:joinenv
D: opening  db index       /var/lib/rpm/Packages rdonly mode=0x0
D: locked   db index       /var/lib/rpm/Packages
D: loading keyring from pubkeys in /var/lib/rpm/pubkeys/*.key
D: couldn't find any keys in /var/lib/rpm/pubkeys/*.key
D: loading keyring from rpmdb
D: opening  db index       /var/lib/rpm/Name rdonly mode=0x0
D: added key gpg-pubkey-fd431d51-4ae0493b to keyring
D: added key gpg-pubkey-2fa658e0-45700c69 to keyring
D: Using legacy gpg-pubkey(s) from rpmdb
D: opening  db index       /var/lib/rpm/Providename rdonly mode=0x0
D: rpcServer: Calling XMLRPC registration.new_system
A protocol error occurred: Internal Server Error , attempt #1,
Error communicating with server. The message was:
Internal Server Error
D: closed   db index       /var/lib/rpm/Providename
D: closed   db index       /var/lib/rpm/Name
D: closed   db index       /var/lib/rpm/Packages
D: closed   db environment /var/lib/rpm


[Tue Apr 02 10:38:47 2013] [error] Exception Handler Information
[Tue Apr 02 10:38:47 2013] [error] Traceback (most recent call last):
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/apacheRequest.py", line 122, in call_function
[Tue Apr 02 10:38:47 2013] [error]     response = apply(func, params)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 501, in new_system
[Tue Apr 02 10:38:47 2013] [error]     architecture, data)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 428, in create_system
[Tue Apr 02 10:38:47 2013] [error]     newserv.save(1, channel)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnServer/server_class.py", line 574, in save
[Tue Apr 02 10:38:47 2013] [error]     self.__save(channel)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnServer/server_class.py", line 542, in __save
[Tue Apr 02 10:38:47 2013] [error]     user_id=user_id)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 1610, in subscribe_server_channels
[Tue Apr 02 10:38:47 2013] [error]     raise_exceptions=1)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 1565, in guess_channels_for_server
[Tue Apr 02 10:38:47 2013] [error]     server.org_id, user_id=user_id)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 933, in channels_for_release_arch
[Tue Apr 02 10:38:47 2013] [error]     org_id=org_id, user_id=user_id)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 726, in base_channel_for_rel_arch
[Tue Apr 02 10:38:47 2013] [error]     org_id=org_id, user_id=user_id)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 163, in execute
[Tue Apr 02 10:38:47 2013] [error]     return apply(self._execute_wrapper, (self._execute, ) + p, kw)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 282, in _execute_wrapper
[Tue Apr 02 10:38:47 2013] [error]     retval = apply(function, p, kw)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 217, in _execute
[Tue Apr 02 10:38:47 2013] [error]     return self._execute_(args, kwargs)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 295, in _execute_
[Tue Apr 02 10:38:47 2013] [error]     self._real_cursor.execute(self.sql, params)
[Tue Apr 02 10:38:47 2013] [error] InternalError: -20263 : (no_subscribe_permissions) - Insufficient permissions for subscription
[Tue Apr 02 10:38:47 2013] [error] CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception('no_subscribe_permissions')"
[Tue Apr 02 10:38:47 2013] [error] PL/pgSQL function "base_channel_rel_archid" line 64 at PERFORM
[Tue Apr 02 10:38:47 2013] [error] PL/pgSQL function "base_channel_for_release_arch" line 14 at RETURN
[Tue Apr 02 10:38:47 2013] [error] 
[Tue Apr 02 10:38:47 2013] [error] 
[root@ec2-184-72-181-68 ~]# [Tue Apr 02 10:38:47 2013] [error] Exception Handler Information
[Tue Apr 02 10:38:47 2013] [error] Traceback (most recent call last):
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/apacheRequest.py", line 122, in call_function
[Tue Apr 02 10:38:47 2013] [error]     response = apply(func, params)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 501, in new_system
[Tue Apr 02 10:38:47 2013] [error]     architecture, data)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 428, in create_system
[Tue Apr 02 10:38:47 2013] [error]     newserv.save(1, channel)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnServer/server_class.py", line 574, in save
[Tue Apr 02 10:38:47 2013] [error]     self.__save(channel)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnServer/server_class.py", line 542, in __save
[Tue Apr 02 10:38:47 2013] [error]     user_id=user_id)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 1610, in subscribe_server_channels
[Tue Apr 02 10:38:47 2013] [error]     raise_exceptions=1)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 1565, in guess_channels_for_server
[Tue Apr 02 10:38:47 2013] [error]     server.org_id, user_id=user_id)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 933, in channels_for_release_arch
[Tue Apr 02 10:38:47 2013] [error]     org_id=org_id, user_id=user_id)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 726, in base_channel_for_rel_arch
[Tue Apr 02 10:38:47 2013] [error]     org_id=org_id, user_id=user_id)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 163, in execute
[Tue Apr 02 10:38:47 2013] [error]     return apply(self._execute_wrapper, (self._execute, ) + p, kw)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 282, in _execute_wrapper
[Tue Apr 02 10:38:47 2013] [error]     retval = apply(function, p, kw)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 217, in _execute
[Tue Apr 02 10:38:47 2013] [error]     return self._execute_(args, kwargs)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 295, in _execute_
[Tue Apr 02 10:38:47 2013] [error]     self._real_cursor.execute(self.sql, params)
[Tue Apr 02 10:38:47 2013] [error] InternalError: -20263 : (no_subscribe_permissions) - Insufficient permissions for subscription
[Tue Apr 02 10:38:47 2013] [error] CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception('no_subscribe_permissions')"
[Tue Apr 02 10:38:47 2013] [error] PL/pgSQL function "base_channel_rel_archid" line 64 at PERFORM
[Tue Apr 02 10:38:47 2013] [error] PL/pgSQL function "base_channel_for_release_arch" line 14 at RETURN
[Tue Apr 02 10:38:47 2013] [error] 
[Tue Apr 02 10:38:47 2013] [error] 
[root@ec2-184-72-181-68 ~]# 
[root@ip-10-151-75-87 2ndSat]# rhnreg_ks --username org2 --password passw0rd --serverUrl https://ec2-184-72-181-68.compute-1.amazonaws.com/XMLRPC --sslCACert=RHN-ORG-TRUSTED-SSL-CERT --force -vvv --systemorgid=3
D: rpcServer: Calling XMLRPC registration.welcome_message
D: opening  db environment /var/lib/rpm cdb:mpool:joinenv
D: opening  db index       /var/lib/rpm/Packages rdonly mode=0x0
D: locked   db index       /var/lib/rpm/Packages
D: loading keyring from pubkeys in /var/lib/rpm/pubkeys/*.key
D: couldn't find any keys in /var/lib/rpm/pubkeys/*.key
D: loading keyring from rpmdb
D: opening  db index       /var/lib/rpm/Name rdonly mode=0x0
D: added key gpg-pubkey-fd431d51-4ae0493b to keyring
D: added key gpg-pubkey-2fa658e0-45700c69 to keyring
D: Using legacy gpg-pubkey(s) from rpmdb
D: opening  db index       /var/lib/rpm/Providename rdonly mode=0x0
D: rpcServer: Calling XMLRPC registration.new_system
A protocol error occurred: Internal Server Error , attempt #1,
Error communicating with server. The message was:
Internal Server Error
D: closed   db index       /var/lib/rpm/Providename
D: closed   db index       /var/lib/rpm/Name
D: closed   db index       /var/lib/rpm/Packages
D: closed   db environment /var/lib/rpm


[Tue Apr 02 10:38:47 2013] [error] Exception Handler Information
[Tue Apr 02 10:38:47 2013] [error] Traceback (most recent call last):
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/apacheRequest.py", line 122, in call_function
[Tue Apr 02 10:38:47 2013] [error]     response = apply(func, params)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 501, in new_system
[Tue Apr 02 10:38:47 2013] [error]     architecture, data)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 428, in create_system
[Tue Apr 02 10:38:47 2013] [error]     newserv.save(1, channel)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnServer/server_class.py", line 574, in save
[Tue Apr 02 10:38:47 2013] [error]     self.__save(channel)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnServer/server_class.py", line 542, in __save
[Tue Apr 02 10:38:47 2013] [error]     user_id=user_id)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 1610, in subscribe_server_channels
[Tue Apr 02 10:38:47 2013] [error]     raise_exceptions=1)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 1565, in guess_channels_for_server
[Tue Apr 02 10:38:47 2013] [error]     server.org_id, user_id=user_id)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 933, in channels_for_release_arch
[Tue Apr 02 10:38:47 2013] [error]     org_id=org_id, user_id=user_id)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 726, in base_channel_for_rel_arch
[Tue Apr 02 10:38:47 2013] [error]     org_id=org_id, user_id=user_id)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 163, in execute
[Tue Apr 02 10:38:47 2013] [error]     return apply(self._execute_wrapper, (self._execute, ) + p, kw)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 282, in _execute_wrapper
[Tue Apr 02 10:38:47 2013] [error]     retval = apply(function, p, kw)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 217, in _execute
[Tue Apr 02 10:38:47 2013] [error]     return self._execute_(args, kwargs)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 295, in _execute_
[Tue Apr 02 10:38:47 2013] [error]     self._real_cursor.execute(self.sql, params)
[Tue Apr 02 10:38:47 2013] [error] InternalError: -20263 : (no_subscribe_permissions) - Insufficient permissions for subscription
[Tue Apr 02 10:38:47 2013] [error] CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception('no_subscribe_permissions')"
[Tue Apr 02 10:38:47 2013] [error] PL/pgSQL function "base_channel_rel_archid" line 64 at PERFORM
[Tue Apr 02 10:38:47 2013] [error] PL/pgSQL function "base_channel_for_release_arch" line 14 at RETURN
[Tue Apr 02 10:38:47 2013] [error] 
[Tue Apr 02 10:38:47 2013] [error] 
[root@ec2-184-72-181-68 ~]# [Tue Apr 02 10:38:47 2013] [error] Exception Handler Information
[Tue Apr 02 10:38:47 2013] [error] Traceback (most recent call last):
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/apacheRequest.py", line 122, in call_function
[Tue Apr 02 10:38:47 2013] [error]     response = apply(func, params)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 501, in new_system
[Tue Apr 02 10:38:47 2013] [error]     architecture, data)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 428, in create_system
[Tue Apr 02 10:38:47 2013] [error]     newserv.save(1, channel)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnServer/server_class.py", line 574, in save
[Tue Apr 02 10:38:47 2013] [error]     self.__save(channel)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnServer/server_class.py", line 542, in __save
[Tue Apr 02 10:38:47 2013] [error]     user_id=user_id)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 1610, in subscribe_server_channels
[Tue Apr 02 10:38:47 2013] [error]     raise_exceptions=1)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 1565, in guess_channels_for_server
[Tue Apr 02 10:38:47 2013] [error]     server.org_id, user_id=user_id)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 933, in channels_for_release_arch
[Tue Apr 02 10:38:47 2013] [error]     org_id=org_id, user_id=user_id)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 726, in base_channel_for_rel_arch
[Tue Apr 02 10:38:47 2013] [error]     org_id=org_id, user_id=user_id)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 163, in execute
[Tue Apr 02 10:38:47 2013] [error]     return apply(self._execute_wrapper, (self._execute, ) + p, kw)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 282, in _execute_wrapper
[Tue Apr 02 10:38:47 2013] [error]     retval = apply(function, p, kw)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 217, in _execute
[Tue Apr 02 10:38:47 2013] [error]     return self._execute_(args, kwargs)
[Tue Apr 02 10:38:47 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 295, in _execute_
[Tue Apr 02 10:38:47 2013] [error]     self._real_cursor.execute(self.sql, params)
[Tue Apr 02 10:38:47 2013] [error] InternalError: -20263 : (no_subscribe_permissions) - Insufficient permissions for subscription
[Tue Apr 02 10:38:47 2013] [error] CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception('no_subscribe_permissions')"
[Tue Apr 02 10:38:47 2013] [error] PL/pgSQL function "base_channel_rel_archid" line 64 at PERFORM
[Tue Apr 02 10:38:47 2013] [error] PL/pgSQL function "base_channel_for_release_arch" line 14 at RETURN
[Tue Apr 02 10:38:47 2013] [error] 
[Tue Apr 02 10:38:47 2013] [error] 
[root@ec2-184-72-181-68 ~]#

Comment 1 Miroslav Suchý 2013-04-02 15:43:43 UTC

Wes? Which version of rhn-client-tools do you have?

Comment 2 wes hayutin 2013-04-04 13:27:56 UTC

[root@ip-10-151-75-87 ~]# rpm -qa | grep rhn
rhn-setup-1.0.0-87.el6.noarch
rhnlib-2.5.22-12.el6.noarch
yum-rhn-plugin-0.9.1-40.el6.noarch
rhnsd-4.9.3-2.el6.x86_64
rhn-client-tools-1.0.0-87.el6.noarch
rhn-check-1.0.0-87.el6.noarch

Comment 3 Miroslav Suchý 2013-04-04 14:25:16 UTC

So you are running on El6 (as suggested in #2) or on Fedora (as suggested in Product of this report, but then #2 does not match) or you are using Centos with oudated packages from Spacewalk upstream?

Comment 4 wes hayutin 2013-04-05 13:28:05 UTC

RHEL 6.4 guest client registering to spacewalk running on fedora

FYI.. adding software channel channel entitlements for RHEL to the org resolves the issue. AFAICT its a minor bug, but a bug.  ISE's should not bubble up through rhnreg_ks

Comment 5 Miroslav Suchý 2013-04-05 16:00:16 UTC

Forwarding to upstream.

Comment 6 Michael Mráka 2014-12-16 10:09:00 UTC


*** This bug has been marked as a duplicate of bug 947507 ***

Comment 7 Eric Herget 2017-09-28 18:08:39 UTC

This BZ closed some time during 2.5, 2.6 or 2.7.  Adding to 2.7 tracking bug.