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

Bug 947507

Summary:	rhnreg_ks returns ISE registering to an org w/o software channel entitlements
Product:	[Community] Spacewalk	Reporter:	wes hayutin <whayutin>
Component:	Server	Assignee:	Tomas Lestach <tlestach>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Red Hat Satellite QA List <satqe-list>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	1.9	CC:	jdobes, msuchy
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-02-15 10:47:50 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:38:17 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-07-02 15:50:29 UTC

This is not client problem.
This is bug in server component, which is not yet in Fedora.
Forwarding to upstream.

Comment 2 Jan Dobes 2013-08-01 06:25:55 UTC

This is probably same bug as in bz953284 and it's already fixed by commit 79118fd580c50e4b9362f7e4fa2dc3e120132369.

Comment 3 Michael Mráka 2014-12-16 10:09:01 UTC

*** Bug 947502 has been marked as a duplicate of this bug. ***

Comment 5 Eric Herget 2017-09-28 18:10:35 UTC

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