[Spacewalk-list] Spacewalk 2.2 crash when adding client (fedora 20)

nathan at nathanpeters.com nathan at nathanpeters.com
Tue Oct 7 18:06:19 UTC 2014


Hi,

I am new to spacewalk so I was hoping someone with some experience could
help me sort out an issue that I am having.  I have followed the
instructions on the spacewalk wiki for installing.  I current have
spacewalk 2.2 and postgresql 9.3 installed on a fresh fedora 20 install.

I can login to the spacewalk web page and created a channel
(spacewalk_channel) and repo (local_repo) with no problems.  I was able to
install the client packages onto a client with no errors also.  However,
when I attempt to add the client, on the main server, I receive and error
that it could not re-connect to the database.  I'm not sure why this is
happening since I can connect to the database fine from the command line,
and the local spacewalk site works fine, including the creation of the
channel and repo so it's obviously talking to the database.  I should also
note that this is the first client I have tried to add and I have
max_connections set to 600 so it should not be a connection limit issue.

----- connect to database from command line -----
[root at spacewalk ~]# psql -U spaceuser -d spaceschema
Password for user spaceuser:
psql (9.3.4, server 9.3.5)
Type "help" for help.

spaceschema=#
----- -----

----- Here is the command I am running on the client -----
[root at clientserver ~]#rhnreg_ks --serverUrl=http://spacewalk/XMLRPC
--activationkey=1-spacewalk-server-channel
An error has occurred:
Error communicating with server. The message was:
Internal Server Error
----- -----

Here is the body of the email I receive
----- traceback email -----

Exception reported from spacewalk.corp.mydomain.com
Time: Tue Oct  7 10:04:52 2014
Exception type <class 'spacewalk.server.rhnSQL.sql_base.SQLConnectError'>
Request object information:
URI: /XMLRPC
Remote Host: clientserver.corp.mydomain.com
Server Name: spacewalk:80
Headers passed in:
	Accept-Encoding: identity
	CONTENT_LENGTH: 122
	CONTENT_TYPE: text/xml
	CONTEXT_DOCUMENT_ROOT: /var/www/html
	CONTEXT_PREFIX:
	DOCUMENT_ROOT: /var/www/html
	GATEWAY_INTERFACE: CGI/1.1
	HTTP_ACCEPT_ENCODING: identity
	HTTP_HOST: spacewalk
	HTTP_USER_AGENT: rhn.rpclib.py/2.5.72-1.fc20
	HTTP_X_CLIENT_VERSION: 1
	HTTP_X_INFO: RPC Processor (C) Red Hat, Inc (version 2.5.72-1.fc20)
	HTTP_X_RHN_CLIENT_CAPABILITY:
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
	HTTP_X_RHN_TRANSPORT_CAPABILITY: follow-redirects=3
	HTTP_X_TRANSPORT_INFO: Extended Capabilities Transport (C) Red Hat, Inc
(version 2.5.72-1.fc20)
	HTTP_X_UP2DATE_VERSION: 2.2.7-1.fc20
	Host: spacewalk
	PATH_INFO:
	QUERY_STRING:
	REMOTE_ADDR: 10.1.4.7
	REMOTE_PORT: 52183
	REQUEST_METHOD: POST
	REQUEST_SCHEME: http
	REQUEST_URI: /XMLRPC
	SCRIPT_FILENAME: /usr/share/rhn/wsgi/xmlrpc.py
	SCRIPT_NAME: /XMLRPC
	SCRIPT_URI: http://spacewalk/XMLRPC
	SCRIPT_URL: /XMLRPC
	SERVER_ADDR: 10.1.0.9
	SERVER_ADMIN: itops at corp.mydomain.com
	SERVER_NAME: spacewalk
	SERVER_PORT: 80
	SERVER_PROTOCOL: HTTP/1.1
	SERVER_SIGNATURE:
	SERVER_SOFTWARE: Apache
	UNIQUE_ID: VDQdNFMTAdNCBGg3RvA-7QAAAAE
	User-Agent: rhn.rpclib.py/2.5.72-1.fc20
	X-Client-Version: 1
	X-Info: RPC Processor (C) Red Hat, Inc (version 2.5.72-1.fc20)
	X-RHN-Client-Capability:
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
	X-RHN-Transport-Capability: follow-redirects=3
	X-Transport-Info: Extended Capabilities Transport (C) Red Hat, Inc
(version 2.5.72-1.fc20)
	X-Up2Date-Version: 2.2.7-1.fc20
	mod_wsgi.application_group: spacewalk.corp.mydomain.com|/xmlrpc
	mod_wsgi.callable_object: application
	mod_wsgi.enable_sendfile: 0
	mod_wsgi.handler_script:
	mod_wsgi.input_chunked: 0
	mod_wsgi.listener_host:
	mod_wsgi.listener_port: 80
	mod_wsgi.process_group:
	mod_wsgi.queue_start: 1412701492768031
	mod_wsgi.request_handler: wsgi-script
	mod_wsgi.script_reloading: 1
	mod_wsgi.version: (3, 5)
	wsgi.errors: <mod_wsgi.Log object at 0x7f575c6786f0>
	wsgi.file_wrapper: <built-in method file_wrapper of mod_wsgi.Adapter
object at 0x7f575c77c4e0>
	wsgi.input: <mod_wsgi.Input object at 0x7f575c678030>
	wsgi.multiprocess: True
	wsgi.multithread: False
	wsgi.run_once: False
	wsgi.url_scheme: http
	wsgi.version: (1, 0)

Exception Handler Information
Traceback (most recent call last):
  File
"/usr/lib/python2.7/site-packages/spacewalk/server/apacheHandler.py",
line 80, in headerParserHandler
    rhnSQL.initDB()
  File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/__init__.py",
line 117, in initDB
    raise e
SQLConnectError: (None, None, 'spaceschema', 'Attempting Re-Connect to the
database failed')

Local variables by frame
Frame initDB in
/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/__init__.py at
line 117
	            username = <type 'str'> spaceuser
	                   e = <class
'spacewalk.server.rhnSQL.sql_base.SQLConnectError'>
(None, None, 'spaceschema', 'Attempting Re-Connect to
the database failed')
	            database = <type 'str'> spaceschema
	         sslrootcert = <type 'NoneType'> None
	                host = <type 'NoneType'> None
	             sslmode = <type 'NoneType'> None
	            password = <type 'str'> <CENSORED!>
	                port = <type 'NoneType'> None
	             backend = <type 'str'> postgresql

Frame headerParserHandler in
/usr/lib/python2.7/site-packages/spacewalk/server/apacheHandler.py at line
82
	                self = <type 'instance'>
<spacewalk.server.apacheHandler.apacheHandler instance at
0x7f575c9e1a70>
	                 req = <type 'instance'> <wsgi.wsgiRequest.WsgiRequest
instance at 0x7f575c5f3290>
	             options = <type 'dict'> {'RHNComponentType':
'server.xmlrpc', 'SERVER': 'xmlrpc'}
	                 ret = <type 'int'> 0

Frame handle in /usr/share/rhn/wsgi/wsgiHandler.py at line 37
	        replacements = <type 'dict'> {'Xml': 'XML', 'Actualuri':
'ActualURI', 'Md5Sum': 'MD5sum', '_': '-', 'Rhn': 'RHN'}
	      component_type = <type 'str'> server.xmlrpc
	      start_response = <type 'builtin_function_or_method'> <built-in
method start_response of mod_wsgi.Adapter object at 0x7f575c77c4e0>
	                   k = <type 'str'> Rhn
	                 req = <type 'instance'> <wsgi.wsgiRequest.WsgiRequest
instance at 0x7f575c5f3290>
	           parseServ = <type 'instancemethod'> <bound method
apacheHandler.headerParserHandler of
<spacewalk.server.apacheHandler.apacheHandler instance at
0x7f575c9e1a70>>
	              server = <type 'str'> xmlrpc
	             environ = <type 'dict'> {'mod_wsgi.listener_port': '80',
'X-RHN-Client-Capability':
'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',
'CONTEXT_DOCUMENT_ROOT': '/var/www/html', 'SERVER_SOFTWARE':
'Apache', 'SCRIPT_NAME': '/XMLRPC', 'HTTP_X_TRANSPORT_INFO':
'Extended Capabilities Transport (C) Red Hat, Inc (version
2.5.72-1.fc20)', 'mod_wsgi.handler_script': '',
'SERVER_SIGNATURE': '', 'REQUEST_METHOD': 'POST',
'PATH_INFO': '', 'SERVER_PROTOCOL': 'HTTP/1.1',
'QUERY_STRING': '', 'X-Info': 'RPC Processor (C) Red Hat,
Inc (version 2.5.72-1.fc20)', 'User-Agent':
'rhn.rpclib.py/2.5.72-1.fc20', 'CONTENT_LENGTH': '122',
'HTTP_USER_AGENT': 'rhn.rpclib.py/2.5.72-1.fc20',
'HTTP_X_UP2DATE_VERSION': '2.2.7-1.fc20', 'SERVER_NAME':
'spacewalk', 'REMOTE_ADDR': '10.1.4.7',
'mod_wsgi.queue_start': '1412701492768031',
'mod_wsgi.request_handler': 'wsgi-script',
'mod_wsgi.version': (3, 5), 'wsgi.url_scheme': 'http',
'Host': 'spacewalk', 'X-RHN-Transport-Capability':
'follow-redirects=3', 'mod_wsgi.callable_object':
'application', 'SERVER_PORT': '80', 'wsgi.multiprocess':
True, 'mod_wsgi.input_chunked': '0', 'SERVER_ADDR':
'10.1.0.9', 'DOCUMENT_ROOT': '/var/www/html',
'mod_wsgi.process_group': '', 'Accept-Encoding': 'identity',
'HTTP_X_RHN_CLIENT_CAPABILITY':
'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',
'SCRIPT_FILENAME': '/usr/share/rhn/wsgi/xmlrpc.py',
'SERVER_ADMIN': 'itops at corp.mydomain.com',
'X-Up2Date-Version': '2.2.7-1.fc20', 'X-Transport-Info':
'Extended Capabilities Transport (C) Red Hat, Inc (version
2.5.72-1.fc20)', 'SCRIPT_URI': 'http://spacewalk/XMLRPC',
'HTTP_X_CLIENT_VERSION': '1', 'wsgi.input': <mod_wsgi.Input
object at 0x7f575c678030>, 'HTTP_HOST': 'spacewalk',
'SCRIPT_URL': '/XMLRPC', 'wsgi.multithread': False,
'mod_wsgi.enable_sendfile': '0', 'REQUEST_URI': '/XMLRPC!
 ', 'X-Client-Version': '1', 'wsgi.version': (1, 0), 'GATEWAY_INTERFACE':
'CGI/1.1', 'wsgi.run_once': False, 'wsgi.errors': <mod_wsgi.Log object at
0x7f575c6786f0>, 'REMOTE_PORT': '52183', 'mod_wsgi.listener_host': '',
'REQUEST_SCHEME': 'http', 'CONTEXT_PREFIX': '',
'HTTP_X_RHN_TRANSPORT_CAPABILITY': 'follow-redirects=3', 'CONTENT_TYPE':
'text/xml', 'mod_wsgi.application_group':
'spacewalk.corp.mydomain.com|/xmlrpc', 'mod_wsgi.script_reloading': '1',
'wsgi.file_wrapper': <built-in method file_wrapper of mod_wsgi.Adapter
object at 0x7f575c77c4e0>, 'HTTP_ACCEPT_ENCODING': 'identity',
'UNIQUE_ID': 'VDQdNFMTAdNCBGg3RvA-7QAAAAE', 'HTTP_X_INFO': 'RPC Processor
(C) Red Hat, Inc (version 2.5.72-1.fc20)'}
	                 key = <type 'str'> HTTP_X_INFO
	                   v = <type 'str'> RHN
	          servertype = <type 'str'> spacewalk.server.apacheServer
	             new_key = <type 'str'> X-Info

Frame application in /usr/share/rhn/wsgi/xmlrpc.py at line 22
	      start_response = <type 'builtin_function_or_method'> <built-in
method start_response of mod_wsgi.Adapter object at 0x7f575c77c4e0>
	             environ = <type 'dict'> {'mod_wsgi.listener_port': '80',
'X-RHN-Client-Capability':
'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',
'CONTEXT_DOCUMENT_ROOT': '/var/www/html', 'SERVER_SOFTWARE':
'Apache', 'SCRIPT_NAME': '/XMLRPC', 'HTTP_X_TRANSPORT_INFO':
'Extended Capabilities Transport (C) Red Hat, Inc (version
2.5.72-1.fc20)', 'mod_wsgi.handler_script': '',
'SERVER_SIGNATURE': '', 'REQUEST_METHOD': 'POST',
'PATH_INFO': '', 'SERVER_PROTOCOL': 'HTTP/1.1',
'QUERY_STRING': '', 'X-Info': 'RPC Processor (C) Red Hat,
Inc (version 2.5.72-1.fc20)', 'User-Agent':
'rhn.rpclib.py/2.5.72-1.fc20', 'CONTENT_LENGTH': '122',
'HTTP_USER_AGENT': 'rhn.rpclib.py/2.5.72-1.fc20',
'HTTP_X_UP2DATE_VERSION': '2.2.7-1.fc20', 'SERVER_NAME':
'spacewalk', 'REMOTE_ADDR': '10.1.4.7',
'mod_wsgi.queue_start': '1412701492768031',
'mod_wsgi.request_handler': 'wsgi-script',
'mod_wsgi.version': (3, 5), 'wsgi.url_scheme': 'http',
'Host': 'spacewalk', 'X-RHN-Transport-Capability':
'follow-redirects=3', 'mod_wsgi.callable_object':
'application', 'SERVER_PORT': '80', 'wsgi.multiprocess':
True, 'mod_wsgi.input_chunked': '0', 'SERVER_ADDR':
'10.1.0.9', 'DOCUMENT_ROOT': '/var/www/html',
'mod_wsgi.process_group': '', 'Accept-Encoding': 'identity',
'HTTP_X_RHN_CLIENT_CAPABILITY':
'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',
'SCRIPT_FILENAME': '/usr/share/rhn/wsgi/xmlrpc.py',
'SERVER_ADMIN': 'itops at corp.mydomain.com',
'X-Up2Date-Version': '2.2.7-1.fc20', 'X-Transport-Info':
'Extended Capabilities Transport (C) Red Hat, Inc (version
2.5.72-1.fc20)', 'SCRIPT_URI': 'http://spacewalk/XMLRPC',
'HTTP_X_CLIENT_VERSION': '1', 'wsgi.input': <mod_wsgi.Input
object at 0x7f575c678030>, 'HTTP_HOST': 'spacewalk',
'SCRIPT_URL': '/XMLRPC', 'wsgi.multithread': False,
'mod_wsgi.enable_sendfile': '0', 'REQUEST_URI': '/XMLRPC!
 ', 'X-Client-Version': '1', 'wsgi.version': (1, 0), 'GATEWAY_INTERFACE':
'CGI/1.1', 'wsgi.run_once': False, 'wsgi.errors': <mod_wsgi.Log object at
0x7f575c6786f0>, 'REMOTE_PORT': '52183', 'mod_wsgi.listener_host': '',
'REQUEST_SCHEME': 'http', 'CONTEXT_PREFIX': '',
'HTTP_X_RHN_TRANSPORT_CAPABILITY': 'follow-redirects=3', 'CONTENT_TYPE':
'text/xml', 'mod_wsgi.application_group':
'spacewalk.corp.mydomain.com|/xmlrpc', 'mod_wsgi.script_reloading': '1',
'wsgi.file_wrapper': <built-in method file_wrapper of mod_wsgi.Adapter
object at 0x7f575c77c4e0>, 'HTTP_ACCEPT_ENCODING': 'identity',
'UNIQUE_ID': 'VDQdNFMTAdNCBGg3RvA-7QAAAAE', 'HTTP_X_INFO': 'RPC Processor
(C) Red Hat, Inc (version 2.5.72-1.fc20)'}


Environment for PID=21621 on exception:
LANG = C
NOTIFY_SOCKET = @/org/freedesktop/systemd1/notify
PATH = /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin


----- -----





More information about the Spacewalk-list mailing list