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@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@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: [email protected] 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': '[email protected]', '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': '[email protected]', '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 ----- ----- _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
