selinux/ iptables maybe? On 7 October 2014 19:06, <[email protected]> wrote:
> 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 >
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
