Re: [Spacewalk-list] Spacewalk 2.2 crash when adding client (fedora 20)
Nothing useful in there. The directory has a zero size file for every day of the week. The initial log entry seems to indicate a problem connecting with the database, so I would not expect logs in there anyway since a connection was never actually made. I'm still supremely confused why I can connect from the command line, and the spacewalk website can connect, but only this join script fails -Original Message- From: Michael Mraka Sent: Friday, October 10, 2014 1:04 AM To: spacewalk-list@redhat.com Subject: Re: [Spacewalk-list] Spacewalk 2.2 crash when adding client (fedora 20) nat...@nathanpeters.com 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. Is there any related error in /var/lib/pgsql/data/pg_log/postgresql-*.log? ... % 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') ... Regards, -- Michael Mráka Satellite Engineering, Red Hat ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Spacewalk 2.2 crash when adding client (fedora 20)
nat...@nathanpeters.com 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. Is there any related error in /var/lib/pgsql/data/pg_log/postgresql-*.log? ... % 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') ... Regards, -- Michael Mráka Satellite Engineering, Red Hat ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Spacewalk 2.2 crash when adding client (fedora 20)
selinux/ iptables maybe? On 7 October 2014 19:06, nat...@nathanpeters.com 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: it...@corp.mydomain.com SERVER_NAME: spacewalk SERVER_PORT: 80 SERVER_PROTOCOL: HTTP/1.1 SERVER_SIGNATURE: SERVER_SOFTWARE: Apache UNIQUE_ID: VDQdNFMTAdNCBGg3RvA-7QE 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):
Re: [Spacewalk-list] Spacewalk 2.2 crash when adding client (fedora 20)
Highly unlikely. The first thing I did to test was put SElinux in permissive mode and checked firewall settings. [root@spacewalk /u/install]# getenforce Permissive [root@spacewalk /u/install]# firewall-cmd --list-all public (default, active) interfaces: ens32 sources: services: dhcpv6-client http https mdns ssh ports: 5222/tcp 5269/tcp masquerade: no forward-ports: icmp-blocks: rich rules: selinux/ iptables maybe? On 7 October 2014 19:06, nat...@nathanpeters.com 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: it...@corp.mydomain.com SERVER_NAME: spacewalk SERVER_PORT: 80 SERVER_PROTOCOL: HTTP/1.1 SERVER_SIGNATURE: SERVER_SOFTWARE: Apache UNIQUE_ID: VDQdNFMTAdNCBGg3RvA-7QE 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:
