<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Title" content="">
<meta name="Keywords" content="">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Calibri;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Calibri;
color:windowtext;}
span.msoIns
{mso-style-type:export-only;
mso-style-name:"";
text-decoration:underline;
color:teal;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:Calibri;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body bgcolor="white" lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt">Hoping for some assistance here, as I’ve been banging my head against the wall on this issue.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">I just upgraded from Spacewalk 2.2 to 2.6, and now osa-dispatcher is dying with no information on the error, and the status just saying the process is dead but the pid file still exists.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">LOG at Debug level 7:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> 2017/09/18 11:33:25 -06:00 12686 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('Converting query for PostgreSQL: select * from rhnPushClient where jabber_id = :p1',)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">2017/09/18 11:33:25 -06:00 12686 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('New query: select * from rhnPushClient where jabber_id = %(p1)s',)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">2017/09/18 11:33:25 -06:00 12686 0.0.0.0: rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "select * from rhnPushClient where jabber_id = %(p1)s" with bind params: {p1: osad-6d4dfeb426@SPACEWALKSERVERNAME/osad}',)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">2017/09/18 11:33:25 -06:00 12686 0.0.0.0: osad/jabber_lib.main('ERROR', 'Error caught:')<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> service osa-dispatcher status<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">osa-dispatcher dead but pid file exists<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">I have checked my jabberd xml files, and they appear to be setup correctly. One thing I found odd is that the server name shows up twice in the sm.xml. I changed the <id> under <sm> back to the default of
sm, but that didnt' fix the issue.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> /etc/jabberd/sm.xml<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><sm><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <!-- Our ID on the network (default: sm) --><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <id>SPACEWALKSERVERNAME</id><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><!-- Local network configuration --><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <local><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <id>SPACEWALKSERVERNAME </id><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <!-- Who we identify ourselves as.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> Users will have this as the domain part of their JID.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> If you want your server to be accessible from other<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> Jabber servers, this IDs must be FQDN resolvable by DNSes.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> If not set, the SM id is used. --><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <id>localhost.localdomain</id><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <!--<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <id>vhost1.localdomain</id><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <id>vhost2.localdomain</id><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> --><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> grep jabber /etc/rhn/rhn.conf<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> server.jabber_server = SPACEWALKSERVERNAME<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> osa-dispatcher.jabber_server = SPACEWALKSERVERNAME<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> ll /etc/jabberd/*.xml<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">-rw-r-----. 1 jabber jabber 25K Sep 17 20:20 /etc/jabberd/c2s.xml<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">-rw-r-----. 1 jabber jabber 2.0K Jul 14 02:10 /etc/jabberd/router-filter.xml<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">-rw-r-----. 1 jabber jabber 258 Jul 14 02:10 /etc/jabberd/router-users.xml<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">-rw-r-----. 1 jabber jabber 6.9K Sep 17 20:20 /etc/jabberd/router.xml<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">-rw-r-----. 1 jabber jabber 12K Sep 17 20:20 /etc/jabberd/s2s.xml<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">-rw-r-----. 1 jabber jabber 31K Sep 18 11:20 /etc/jabberd/sm.xml<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">I also checked the SSL certs to verify that they are correct and that the certificate matches the hostname in /etc/jabberd/c2s.xml. I have verified permissions, as well. Hostname is in the hosts file.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">md5sum /etc/pki/spacewalk/jabberd/server.pem /root/ssl-build/ SPACEWALKSERVERNAME server.pem<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">eda16d799aefba2acc5a5b4b278227ac /etc/pki/ SPACEWALKSERVERNAME jabberd/server.pem<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">eda16d799aefba2acc5a5b4b278227ac /root/ssl-build/ SPACEWALKSERVERNAME server.pem<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">ll /etc/pki/spacewalk/jabberd/<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">-rw-------. 1 jabber jabber 7.2K Mar 4 2014 server.pem<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">md5sum /root/ssl-build/RHN-ORG-TRUSTED-SSL-CERT /var/www/html/pub/RHN-ORG-TRUSTED-SSL-CERT<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">4a3fa3d648a87aee70151dd6ee030c9b /root/ssl-build/RHN-ORG-TRUSTED-SSL-CERT<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">4a3fa3d648a87aee70151dd6ee030c9b /var/www/html/pub/RHN-ORG-TRUSTED-SSL-CERT<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">grep CN= $(grep spacewalk.crt /etc/httpd/conf.d/ssl.conf | cut -f 2 -d' ') | grep Subject<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> OU= SPACEWALKSERVERNAME, CN= SPACEWALKSERVERNAME<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">grep require-starttls /etc/jabberd/c2s.xml | grep pemfile<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <id require-starttls="false" pemfile="/etc/pki/spacewalk/jabberd/server.pem" realm="" register-enable="true">SPACEWALKSERVERNAME</id><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">grep CN= /etc/pki/spacewalk/jabberd/server.pem | grep Subject<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> OU= SPACEWALKSERVERNAME, CN= SPACEWALKSERVERNAME<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">grep "osa-dispatcher.osa_ssl_cert" /etc/rhn/rhn.conf<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">osa-dispatcher.osa_ssl_cert = /var/www/html/pub/RHN-ORG-TRUSTED-SSL-CERT<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> grep C2S_AS_ROOT /etc/sysconfig/jabberd <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"># set C2S_AS_ROOT to "yes" to start c2s as root<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">C2S_AS_ROOT="no"<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">I tried deleting the jabberd database and tables, but to no avail.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> rm -f /var/lib/jabberd/db/*<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> spacewalk-sql -i<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> delete from rhnPushDispatcher;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> delete from rhnPushClient;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> \quit<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">I also tried re-configuring the jabberd service, to see if that would fix it, but it didn’t:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> service osa-dispatcher stop<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">service jabberd stop<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">cp -arv /etc/jabberd /etc/jabberd.bak<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">cp -arv /var/lib/jabberd/ /var/lib/jabberd.bak<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">rm -rf /etc/jabberd/* /var/lib/jabberd/*<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">yum reinstall jabberd -y<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">spacewalk-setup-jabberd<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">grep $(hostname) /etc/jabberd/*xml<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">service jabberd start<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">service osa-dispatcher start<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">I verified that ports are open:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> nmap -sT -p 5200-5400 localhost<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Nmap scan report for localhost (127.0.0.1)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">PORT STATE SERVICE<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">5222/tcp open xmpp-client<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">5269/tcp open xmpp-server<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">5347/tcp open unknown<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">I’ve run out of things to look at at this point. Any ideas?<o:p></o:p></span></p>
</div>
</body>
</html>