[Spacewalk-list] Osad errors on Spacewalk 2.2 Server

Mon Feb 9 20:44:32 UTC 2015

One issue turned out to be an SElinux issue with osa-dispatcher.

I’m still seeing this error when I attempt to do rhnpush:

[Mon Feb 09 15:31:47 2015] [error] Exception reported from ###spacewalkserver-redacted###
[Mon Feb 09 15:31:47 2015] [error] Time: Mon Feb  9 15:31:47 2015
[Mon Feb 09 15:31:47 2015] [error] Exception type <class 'spacewalk.server.rhnSQL.sql_base.SQLConnectError'>
[Mon Feb 09 15:31:47 2015] [error] Request object information:
[Mon Feb 09 15:31:47 2015] [error] URI: /APP
[Mon Feb 09 15:31:47 2015] [error] Remote Host: localhost.localdomain
[Mon Feb 09 15:31:47 2015] [error] Server Name: localhost:80
[Mon Feb 09 15:31:47 2015] [error] Headers passed in:
[Mon Feb 09 15:31:47 2015] [error] \tAccept-Encoding: identity
[Mon Feb 09 15:31:47 2015] [error] \tCONTENT_LENGTH: 152
[Mon Feb 09 15:31:47 2015] [error] \tCONTENT_TYPE: application/binary
[Mon Feb 09 15:31:47 2015] [error] \tContent-Encoding: x-gzip
[Mon Feb 09 15:31:47 2015] [error] \tContent-Transfer-Encoding: binary
[Mon Feb 09 15:31:47 2015] [error] \tDOCUMENT_ROOT: /var/www/html
[Mon Feb 09 15:31:47 2015] [error] \tGATEWAY_INTERFACE: CGI/1.1
[Mon Feb 09 15:31:47 2015] [error] \tHTTP_ACCEPT_ENCODING: identity
[Mon Feb 09 15:31:47 2015] [error] \tHTTP_CONTENT_ENCODING: x-gzip
[Mon Feb 09 15:31:47 2015] [error] \tHTTP_CONTENT_TRANSFER_ENCODING: binary
[Mon Feb 09 15:31:47 2015] [error] \tHTTP_HOST: localhost
[Mon Feb 09 15:31:47 2015] [error] \tHTTP_USER_AGENT: rhn.rpclib.py/2.5.72-1.el6
[Mon Feb 09 15:31:47 2015] [error] \tHTTP_X_CLIENT_VERSION: 1
[Mon Feb 09 15:31:47 2015] [error] \tHTTP_X_INFO: RPC Processor (C) Red Hat, Inc (version 2.5.72-1.el6)
[Mon Feb 09 15:31:47 2015] [error] \tHTTP_X_RHN_TRANSPORT_CAPABILITY: follow-redirects=3
[Mon Feb 09 15:31:47 2015] [error] \tHTTP_X_TRANSPORT_INFO: Extended Capabilities Transport (C) Red Hat, Inc (version 2.5.72-1.el6)
[Mon Feb 09 15:31:47 2015] [error] \tHost: localhost
[Mon Feb 09 15:31:47 2015] [error] \tPATH_INFO:
[Mon Feb 09 15:31:47 2015] [error] \tQUERY_STRING:
[Mon Feb 09 15:31:47 2015] [error] \tREMOTE_ADDR: ::1
[Mon Feb 09 15:31:47 2015] [error] \tREMOTE_PORT: 54880
[Mon Feb 09 15:31:47 2015] [error] \tREQUEST_METHOD: POST
[Mon Feb 09 15:31:47 2015] [error] \tREQUEST_URI: /APP
[Mon Feb 09 15:31:47 2015] [error] \tSCRIPT_FILENAME: /usr/share/rhn/wsgi/app.py
[Mon Feb 09 15:31:47 2015] [error] \tSCRIPT_NAME: /APP
[Mon Feb 09 15:31:47 2015] [error] \tSCRIPT_URI: http://localhost/APP
[Mon Feb 09 15:31:47 2015] [error] \tSCRIPT_URL: /APP
[Mon Feb 09 15:31:47 2015] [error] \tSERVER_ADDR: ::1
[Mon Feb 09 15:31:47 2015] [error] \tSERVER_ADMIN: root at localhost
[Mon Feb 09 15:31:47 2015] [error] \tSERVER_NAME: localhost
[Mon Feb 09 15:31:47 2015] [error] \tSERVER_PORT: 80
[Mon Feb 09 15:31:47 2015] [error] \tSERVER_PROTOCOL: HTTP/1.1
[Mon Feb 09 15:31:47 2015] [error] \tSERVER_SIGNATURE: <address>Apache Server at localhost Port 80</address>
[Mon Feb 09 15:31:47 2015] [error]
[Mon Feb 09 15:31:47 2015] [error] \tSERVER_SOFTWARE: Apache
[Mon Feb 09 15:31:47 2015] [error] \tUser-Agent: rhn.rpclib.py/2.5.72-1.el6
[Mon Feb 09 15:31:47 2015] [error] \tX-Client-Version: 1
[Mon Feb 09 15:31:47 2015] [error] \tX-Info: RPC Processor (C) Red Hat, Inc (version 2.5.72-1.el6)
[Mon Feb 09 15:31:47 2015] [error] \tX-RHN-Transport-Capability: follow-redirects=3
[Mon Feb 09 15:31:47 2015] [error] \tX-Transport-Info: Extended Capabilities Transport (C) Red Hat, Inc (version 2.5.72-1.el6)
[Mon Feb 09 15:31:47 2015] [error] \tmod_ssl.is_https: <built-in method ssl_is_https of mod_wsgi.Adapter object at 0x7fdc66dcc030>
[Mon Feb 09 15:31:47 2015] [error] \tmod_ssl.var_lookup: <built-in method ssl_var_lookup of mod_wsgi.Adapter object at 0x7fdc66dcc030>
[Mon Feb 09 15:31:47 2015] [error] \tmod_wsgi.application_group<##spacewalkserver redacted##>|/app
[Mon Feb 09 15:31:47 2015] [error] \tmod_wsgi.callable_object: application
[Mon Feb 09 15:31:47 2015] [error] \tmod_wsgi.handler_script:
[Mon Feb 09 15:31:47 2015] [error] \tmod_wsgi.input_chunked: 0
[Mon Feb 09 15:31:47 2015] [error] \tmod_wsgi.listener_host:
[Mon Feb 09 15:31:47 2015] [error] \tmod_wsgi.listener_port: 80
[Mon Feb 09 15:31:47 2015] [error] \tmod_wsgi.process_group:
[Mon Feb 09 15:31:47 2015] [error] \tmod_wsgi.request_handler: wsgi-script
[Mon Feb 09 15:31:47 2015] [error] \tmod_wsgi.script_reloading: 1
[Mon Feb 09 15:31:47 2015] [error] \tmod_wsgi.version: (3, 2)
[Mon Feb 09 15:31:47 2015] [error] \twsgi.errors: <mod_wsgi.Log object at 0x7fdc66e840b0>
[Mon Feb 09 15:31:47 2015] [error] \twsgi.file_wrapper: <built-in method file_wrapper of mod_wsgi.Adapter object at 0x7fdc66dcc030>
[Mon Feb 09 15:31:47 2015] [error] \twsgi.input: <mod_wsgi.Input object at 0x7fdc66e84070>
[Mon Feb 09 15:31:47 2015] [error] \twsgi.multiprocess: True
[Mon Feb 09 15:31:47 2015] [error] \twsgi.multithread: False
[Mon Feb 09 15:31:47 2015] [error] \twsgi.run_once: False
[Mon Feb 09 15:31:47 2015] [error] \twsgi.url_scheme: http
[Mon Feb 09 15:31:47 2015] [error] \twsgi.version: (1, 1)
[Mon Feb 09 15:31:47 2015] [error]
[Mon Feb 09 15:31:47 2015] [error] Exception Handler Information
[Mon Feb 09 15:31:47 2015] [error] Traceback (most recent call last):
[Mon Feb 09 15:31:47 2015] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/apacheHandler.py", line 80, in headerParserHandler
[Mon Feb 09 15:31:47 2015] [error]     rhnSQL.initDB()
[Mon Feb 09 15:31:47 2015] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 117, in initDB
[Mon Feb 09 15:31:47 2015] [error]     raise e
[Mon Feb 09 15:31:47 2015] [error] SQLConnectError: (None, None, 'spaceschema', 'Attempting Re-Connect to the database failed')
[Mon Feb 09 15:31:47 2015] [error]

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. Robert.Boyd at PeopleFluent.com<mailto:robert.boyd at peoplefluent.com>

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]<http://www.peoplefluent.com/>
Click here<http://www.peoplefluent.com/> to experience the power of the new PeopleFluent Mirror Suite ™
Visit: www.peoplefluent.com<http://www.peoplefluent.com/> | Read: PeopleFluent Blog<http://peoplefluent.com/resources/peoplefluent-blog> | Follow: @PeopleFluent<http://twitter.com/peoplefluent>

From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Waldirio Manhães Pinheiro
Sent: Saturday, February 07, 2015 9:38 PM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Osad errors on Spacewalk 2.2 Server

Boyd, good morning

Fixed ?!!?

Take Care

______________
Atenciosamente
Waldirio
msn: waldirio at gmail.com<mailto:waldirio at gmail.com>
Skype: waldirio
Site: www.waldirio.com.br<http://www.waldirio.com.br>
Blog: blog.waldirio.com.br<http://blog.waldirio.com.br>
LinkedIn: http://br.linkedin.com/pub/waldirio-pinheiro/22/b21/646
PGP: www.waldirio.com.br/public.html<http://www.waldirio.com.br/public.html>

On Mon, Feb 2, 2015 at 2:01 PM, Paul Robert Marino <prmarino1 at gmail.com<mailto:prmarino1 at gmail.com>> wrote:
check the database the logs should be in
/var/lib/pgsql/data/pg_log/postgresql-<3 character acronym for day of
the week>.log

On Fri, Jan 30, 2015 at 12:33 PM, Boyd, Robert
<Robert.Boyd at peoplefluent.com<mailto:Robert.Boyd at peoplefluent.com>> wrote:
> I'm getting these error messages every several times a minute -- looks like at 10 second intervals.
>
> 2015/01/30 12:30:28 -04:00 3011 0.0.0.0<http://0.0.0.0>: osad/jabber_lib.main('ERROR', 'Error caught:')
> 2015/01/30 12:30:28 -04:00 3011 0.0.0.0<http://0.0.0.0>: osad/jabber_lib.main('ERROR', 'Traceback (most recent call last):\n  File "/usr/share/rhn/osad/jabber_lib.py", line 118, in main\n    self.setup_config(config)\n  File "/usr/share/rhn/osad/osa_dispatcher.py", line 112, in setup_config\n    rhnSQL.initDB()\n  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 117, in initDB\n    raise e\nSQLConnectError: (None, None, \'spaceschema\', \'Attempting Re-Connect to the database failed\')\n')
>
> What does this mean and what can I do about it?
>
> Robert Boyd
> Sr. Systems Engineer
> PeopleFluent
> p. 919-645-2972<tel:919-645-2972> | c. 919-306-4681<tel:919-306-4681>
> e. Robert.Boyd at PeopleFluent.com<mailto:Robert.Boyd at PeopleFluent.com>
>
>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com<mailto:Spacewalk-list at redhat.com>
> https://www.redhat.com/mailman/listinfo/spacewalk-list

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com<mailto:Spacewalk-list at redhat.com>
https://www.redhat.com/mailman/listinfo/spacewalk-list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20150209/2f4dff27/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 5805 bytes
Desc: image001.png
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20150209/2f4dff27/attachment.png>