Bug 953284 - System registration to an organization via AK fails on Satellite 5.6 with PostgreSQL.
Summary: System registration to an organization via AK fails on Satellite 5.6 with Pos...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server
Version: 560
Hardware: Unspecified
OS: Unspecified
medium
high
Target Milestone: ---
Assignee: Tomas Lestach
QA Contact: Martin Minar
URL:
Whiteboard:
Depends On:
Blocks: sat560-blockers
TreeView+ depends on / blocked
 
Reported: 2013-04-17 20:37 UTC by Dimitar Yordanov
Modified: 2016-07-04 00:57 UTC (History)
6 users (show)

Fixed In Version: spacewalk-backend-1.9.46-6
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2013-10-01 21:56:14 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)

Description Dimitar Yordanov 2013-04-17 20:37:40 UTC 
Description of problem:
 System registration to an organization via AK fails on Satellite with PostgreSQL.

Version-Release number of selected component (if applicable):
Satellite 5.6 PostgreSQL

How reproducible:
Always

Steps to Reproduce:
1. Install SW Nightly with PostgreSQL EL6 ( or clone https://beaker.engineering.redhat.com/jobs/405750)
2. Register and activate against rhn.redhat.com
3. Create new organization "test_org" and give it 2 "Management" base entitlement
4. Create a custom channel "test_channel" for "test_org"
5. Create an activation key for "test_org" and associate it with "test_channel"
6. Try to register an EL6 system with this activation key
      #rhnreg_ks --activationkey=2-b98645b718b72251880f262f40824937 --force 
   The system is registered. 
         
7. # nohup satellite-sync  -c rhel-x86_64-server-6 --no-errata --no-kickstarts  --no-packages &
   # spacewalk-remove-channel -l
   rhel-x86_64-server-6
   test_channel

8. Try to register an EL6 system with this activation key
      #rhnreg_ks --activationkey=2-b98645b718b72251880f262f40824937 --force 
      Error communicating with server. The message was:
      Internal Server Error
 
Actual results:   
# tail -n 105 /var/log/httpd/error_log
[Wed Apr 17 06:46:35 2013] [error] Exception reported from dell-pe800-01.rhts.eng.bos.redhat.com
[Wed Apr 17 06:46:35 2013] [error] Time: Wed Apr 17 06:46:35 2013
[Wed Apr 17 06:46:35 2013] [error] Exception type <class 'psycopg2.InternalError'>
[Wed Apr 17 06:46:35 2013] [error] Exception while handling function registration.new_system
[Wed Apr 17 06:46:35 2013] [error] Request object information:
[Wed Apr 17 06:46:35 2013] [error] URI: /XMLRPC
[Wed Apr 17 06:46:35 2013] [error] Remote Host: dell-pe800-01.rhts.eng.bos.redhat.com
[Wed Apr 17 06:46:35 2013] [error] Server Name: dell-pe800-01.rhts.eng.bos.redhat.com:443
[Wed Apr 17 06:46:35 2013] [error] Headers passed in:
[Wed Apr 17 06:46:35 2013] [error] \tAccept-Encoding: identity
[Wed Apr 17 06:46:35 2013] [error] \tCONTENT_LENGTH: 1584
[Wed Apr 17 06:46:35 2013] [error] \tCONTENT_TYPE: text/xml
[Wed Apr 17 06:46:35 2013] [error] \tDOCUMENT_ROOT: /var/www/html
[Wed Apr 17 06:46:35 2013] [error] \tGATEWAY_INTERFACE: CGI/1.1
[Wed Apr 17 06:46:35 2013] [error] \tHTTPS: 1
[Wed Apr 17 06:46:35 2013] [error] \tHTTP_ACCEPT_ENCODING: identity
[Wed Apr 17 06:46:35 2013] [error] \tHTTP_HOST: dell-pe800-01.rhts.eng.bos.redhat.com
[Wed Apr 17 06:46:35 2013] [error] \tHTTP_USER_AGENT: rhn.rpclib.py/$Revision$
[Wed Apr 17 06:46:35 2013] [error] \tHTTP_X_CLIENT_VERSION: 1
[Wed Apr 17 06:46:35 2013] [error] \tHTTP_X_INFO: RPC Processor (C) Red Hat, Inc (version $Revision$)
[Wed Apr 17 06:46:35 2013] [error] \tHTTP_X_RHN_CLIENT_CAPABILITY: packages.verifyAll(1)=1,caneatCheese(1)=1,packages.extended_profile(2)=1,reboot.reboot(1)=1,packages.verify(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,packages.rollBack(1)=1
[Wed Apr 17 06:46:35 2013] [error] \tHTTP_X_RHN_TRANSPORT_CAPABILITY: follow-redirects=3
[Wed Apr 17 06:46:35 2013] [error] \tHTTP_X_TRANSPORT_INFO: Extended Capabilities Transport (C) Red Hat, Inc (version $Revision$)
[Wed Apr 17 06:46:35 2013] [error] \tHTTP_X_UP2DATE_VERSION: 1.0.0.1-4.el6
[Wed Apr 17 06:46:35 2013] [error] \tHost: dell-pe800-01.rhts.eng.bos.redhat.com
[Wed Apr 17 06:46:35 2013] [error] \tPATH_INFO: 
[Wed Apr 17 06:46:35 2013] [error] \tQUERY_STRING: 
[Wed Apr 17 06:46:35 2013] [error] \tREMOTE_ADDR: 10.16.64.57
[Wed Apr 17 06:46:35 2013] [error] \tREMOTE_PORT: 50425
[Wed Apr 17 06:46:35 2013] [error] \tREQUEST_METHOD: POST
[Wed Apr 17 06:46:35 2013] [error] \tREQUEST_URI: /XMLRPC
[Wed Apr 17 06:46:35 2013] [error] \tSCRIPT_FILENAME: /usr/share/rhn/wsgi/xmlrpc.py
[Wed Apr 17 06:46:35 2013] [error] \tSCRIPT_NAME: /XMLRPC
[Wed Apr 17 06:46:35 2013] [error] \tSCRIPT_URI: https://dell-pe800-01.rhts.eng.bos.redhat.com/XMLRPC
[Wed Apr 17 06:46:35 2013] [error] \tSCRIPT_URL: /XMLRPC
[Wed Apr 17 06:46:35 2013] [error] \tSERVER_ADDR: 10.16.64.57
[Wed Apr 17 06:46:35 2013] [error] \tSERVER_ADMIN: root@localhost
[Wed Apr 17 06:46:35 2013] [error] \tSERVER_NAME: dell-pe800-01.rhts.eng.bos.redhat.com
[Wed Apr 17 06:46:35 2013] [error] \tSERVER_PORT: 443
[Wed Apr 17 06:46:35 2013] [error] \tSERVER_PROTOCOL: HTTP/1.1
[Wed Apr 17 06:46:35 2013] [error] \tSERVER_SIGNATURE: <address>Apache Server at dell-pe800-01.rhts.eng.bos.redhat.com Port 443</address>
[Wed Apr 17 06:46:35 2013] [error] 
[Wed Apr 17 06:46:35 2013] [error] \tSERVER_SOFTWARE: Apache
[Wed Apr 17 06:46:35 2013] [error] \tUser-Agent: rhn.rpclib.py/$Revision$
[Wed Apr 17 06:46:35 2013] [error] \tX-Client-Version: 1
[Wed Apr 17 06:46:35 2013] [error] \tX-Info: RPC Processor (C) Red Hat, Inc (version $Revision$)
[Wed Apr 17 06:46:35 2013] [error] \tX-RHN-Client-Capability: packages.verifyAll(1)=1,caneatCheese(1)=1,packages.extended_profile(2)=1,reboot.reboot(1)=1,packages.verify(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,packages.rollBack(1)=1
[Wed Apr 17 06:46:35 2013] [error] \tX-RHN-Transport-Capability: follow-redirects=3
[Wed Apr 17 06:46:35 2013] [error] \tX-Transport-Info: Extended Capabilities Transport (C) Red Hat, Inc (version $Revision$)
[Wed Apr 17 06:46:35 2013] [error] \tX-Up2Date-Version: 1.0.0.1-4.el6
[Wed Apr 17 06:46:35 2013] [error] \tmod_ssl.is_https: <built-in method ssl_is_https of mod_wsgi.Adapter object at 0x7f2db976e468>
[Wed Apr 17 06:46:35 2013] [error] \tmod_ssl.var_lookup: <built-in method ssl_var_lookup of mod_wsgi.Adapter object at 0x7f2db976e468>
[Wed Apr 17 06:46:35 2013] [error] \tmod_wsgi.application_group: dell-pe800-01.rhts.eng.bos.redhat.com|/xmlrpc
[Wed Apr 17 06:46:35 2013] [error] \tmod_wsgi.callable_object: application
[Wed Apr 17 06:46:35 2013] [error] \tmod_wsgi.handler_script: 
[Wed Apr 17 06:46:35 2013] [error] \tmod_wsgi.input_chunked: 0
[Wed Apr 17 06:46:35 2013] [error] \tmod_wsgi.listener_host: 
[Wed Apr 17 06:46:35 2013] [error] \tmod_wsgi.listener_port: 443
[Wed Apr 17 06:46:35 2013] [error] \tmod_wsgi.process_group: 
[Wed Apr 17 06:46:35 2013] [error] \tmod_wsgi.request_handler: wsgi-script
[Wed Apr 17 06:46:35 2013] [error] \tmod_wsgi.script_reloading: 1
[Wed Apr 17 06:46:35 2013] [error] \tmod_wsgi.version: (3, 2)
[Wed Apr 17 06:46:35 2013] [error] \twsgi.errors: <mod_wsgi.Log object at 0x7f2db952b030>
[Wed Apr 17 06:46:35 2013] [error] \twsgi.file_wrapper: <built-in method file_wrapper of mod_wsgi.Adapter object at 0x7f2db976e468>
[Wed Apr 17 06:46:35 2013] [error] \twsgi.input: <mod_wsgi.Input object at 0x7f2db951bfb0>
[Wed Apr 17 06:46:35 2013] [error] \twsgi.multiprocess: True
[Wed Apr 17 06:46:35 2013] [error] \twsgi.multithread: False
[Wed Apr 17 06:46:35 2013] [error] \twsgi.run_once: False
[Wed Apr 17 06:46:35 2013] [error] \twsgi.url_scheme: https
[Wed Apr 17 06:46:35 2013] [error] \twsgi.version: (1, 1)
[Wed Apr 17 06:46:35 2013] [error] 
[Wed Apr 17 06:46:35 2013] [error] Exception Handler Information
[Wed Apr 17 06:46:35 2013] [error] Traceback (most recent call last):
[Wed Apr 17 06:46:35 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/apacheRequest.py", line 122, in call_function
[Wed Apr 17 06:46:35 2013] [error]     response = apply(func, params)
[Wed Apr 17 06:46:35 2013] [error]   File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 500, in new_system
[Wed Apr 17 06:46:35 2013] [error]     architecture, data)
[Wed Apr 17 06:46:35 2013] [error]   File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 427, in create_system
[Wed Apr 17 06:46:35 2013] [error]     newserv.save(1, channel)
[Wed Apr 17 06:46:35 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnServer/server_class.py", line 574, in save
[Wed Apr 17 06:46:35 2013] [error]     self.__save(channel)
[Wed Apr 17 06:46:35 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnServer/server_class.py", line 542, in __save
[Wed Apr 17 06:46:35 2013] [error]     user_id=user_id)
[Wed Apr 17 06:46:35 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 1610, in subscribe_server_channels
[Wed Apr 17 06:46:35 2013] [error]     raise_exceptions=1)
[Wed Apr 17 06:46:35 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 1565, in guess_channels_for_server
[Wed Apr 17 06:46:35 2013] [error]     server.org_id, user_id=user_id)
[Wed Apr 17 06:46:35 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 933, in channels_for_release_arch
[Wed Apr 17 06:46:35 2013] [error]     org_id=org_id, user_id=user_id)
[Wed Apr 17 06:46:35 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", line 726, in base_channel_for_rel_arch
[Wed Apr 17 06:46:35 2013] [error]     org_id=org_id, user_id=user_id)
[Wed Apr 17 06:46:35 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 163, in execute
[Wed Apr 17 06:46:35 2013] [error]     return apply(self._execute_wrapper, (self._execute, ) + p, kw)
[Wed Apr 17 06:46:35 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 273, in _execute_wrapper
[Wed Apr 17 06:46:35 2013] [error]     retval = apply(function, p, kw)
[Wed Apr 17 06:46:35 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 217, in _execute
[Wed Apr 17 06:46:35 2013] [error]     return self._execute_(args, kwargs)
[Wed Apr 17 06:46:35 2013] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 286, in _execute_
[Wed Apr 17 06:46:35 2013] [error]     self._real_cursor.execute(self.sql, params)
[Wed Apr 17 06:46:35 2013] [error] InternalError: -20263 : (no_subscribe_permissions) - Insufficient permissions for subscription
[Wed Apr 17 06:46:35 2013] [error] CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception('no_subscribe_permissions')"
[Wed Apr 17 06:46:35 2013] [error] PL/pgSQL function "base_channel_rel_archid" line 64 at PERFORM
[Wed Apr 17 06:46:35 2013] [error] PL/pgSQL function "base_channel_for_release_arch" line 14 at RETURN
[Wed Apr 17 06:46:35 2013] [error] 
[Wed Apr 17 06:46:35 2013] [error] 
  


Additional info:
Another approach how to get the same ISE is described in detail in bz924638 -> https://bugzilla.redhat.com/show_bug.cgi?id=924638
Comment 1 Tomas Lestach 2013-04-26 09:45:22 UTC 
Taking ...
Comment 2 Tomas Lestach 2013-04-26 14:38:38 UTC 
spacewalk.git: 79118fd580c50e4b9362f7e4fa2dc3e120132369
Comment 7 Clifford Perry 2013-10-01 21:56:14 UTC 
Satellite 5.6 has been released. This bug was tracked under the release.  

This bug was either VERIFIED or RELEASE_PENDING (re-verified prior shortly
before release). 

Moving to CLOSED CURRENT_RELEASE. 

Text from Upgrade Erratum follows:

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.

http://rhn.redhat.com/errata/RHEA-2013-1395.html
Note You need to log in before you can comment on or make changes to this bug.