<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:"Courier New";
panose-1:2 7 3 9 2 2 5 2 4 4;}
@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;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:Courier;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Courier;}
span.EmailStyle19
{mso-style-type:personal;
font-family:Calibri;
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal-reply;
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-size:10.0pt;}
@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:10.5pt;color:black">Hoping for some assistance here, as I’ve been banging my head against the wall on this issue.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black">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.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="text-indent:.5in"><span style="font-size:10.5pt;color:black">LOG at Debug level 7:</span><o:p></o:p></p>
<p class="MsoNormal" style="text-indent:.5in"><span style="font-size:10.5pt;color:black"> 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',)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black">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',)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black">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}',)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black">2017/09/18 11:33:25 -06:00 12686 0.0.0.0: osad/jabber_lib.main('ERROR', 'Error caught:')</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> service osa-dispatcher status</span><o:p></o:p></p>
<p class="MsoNormal" style="text-indent:.5in"><span style="font-size:10.5pt;color:black">osa-dispatcher dead but pid file exists</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black">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.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> /etc/jabberd/sm.xml</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"><sm></span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> <!-- Our ID on the network (default: sm) --></span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> <id>SPACEWALKSERVERNAME</id></span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"><!-- Local network configuration --></span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> <local></span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> <id>SPACEWALKSERVERNAME </id></span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> <!-- Who we identify ourselves as.</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> Users will have this as the domain part of their JID.</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> If you want your server to be accessible from other</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> Jabber servers, this IDs must be FQDN resolvable by DNSes.</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> If not set, the SM id is used. --></span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> <id>localhost.localdomain</id></span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> <!--</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> <id>vhost1.localdomain</id></span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> <id>vhost2.localdomain</id></span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> --></span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> grep jabber /etc/rhn/rhn.conf</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> server.jabber_server = SPACEWALKSERVERNAME</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> osa-dispatcher.jabber_server = SPACEWALKSERVERNAME</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> ll /etc/jabberd/*.xml</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.5pt;color:black">-rw-r-----. 1 jabber jabber 25K Sep 17 20:20 /etc/jabberd/c2s.xml</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.5pt;color:black">-rw-r-----. 1 jabber jabber 2.0K Jul 14 02:10 /etc/jabberd/router-filter.xml</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.5pt;color:black">-rw-r-----. 1 jabber jabber 258 Jul 14 02:10 /etc/jabberd/router-users.xml</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.5pt;color:black">-rw-r-----. 1 jabber jabber 6.9K Sep 17 20:20 /etc/jabberd/router.xml</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.5pt;color:black">-rw-r-----. 1 jabber jabber 12K Sep 17 20:20 /etc/jabberd/s2s.xml</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.5pt;color:black">-rw-r-----. 1 jabber jabber 31K Sep 18 11:20 /etc/jabberd/sm.xml</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black">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.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black">md5sum /etc/pki/spacewalk/jabberd/server.pem /root/ssl-build/ SPACEWALKSERVERNAME server.pem</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black">eda16d799aefba2acc5a5b4b278227ac /etc/pki/ SPACEWALKSERVERNAME jabberd/server.pem</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black">eda16d799aefba2acc5a5b4b278227ac /root/ssl-build/ SPACEWALKSERVERNAME server.pem</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black">ll /etc/pki/spacewalk/jabberd/</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black">-rw-------. 1 jabber jabber 7.2K Mar 4 2014 server.pem</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black">md5sum /root/ssl-build/RHN-ORG-TRUSTED-SSL-CERT /var/www/html/pub/RHN-ORG-TRUSTED-SSL-CERT</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black">4a3fa3d648a87aee70151dd6ee030c9b /root/ssl-build/RHN-ORG-TRUSTED-SSL-CERT</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black">4a3fa3d648a87aee70151dd6ee030c9b /var/www/html/pub/RHN-ORG-TRUSTED-SSL-CERT</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black">grep CN= $(grep spacewalk.crt /etc/httpd/conf.d/ssl.conf | cut -f 2 -d' ') | grep Subject</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black"> OU= SPACEWALKSERVERNAME, CN= SPACEWALKSERVERNAME</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black">grep require-starttls /etc/jabberd/c2s.xml | grep pemfile</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black"> <id require-starttls="false" pemfile="/etc/pki/spacewalk/jabberd/server.pem" realm="" register-enable="true">SPACEWALKSERVERNAME</id></span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black">grep CN= /etc/pki/spacewalk/jabberd/server.pem | grep Subject</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black"> OU= SPACEWALKSERVERNAME, CN= SPACEWALKSERVERNAME</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black">grep "osa-dispatcher.osa_ssl_cert" /etc/rhn/rhn.conf</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:10.5pt;color:black">osa-dispatcher.osa_ssl_cert = /var/www/html/pub/RHN-ORG-TRUSTED-SSL-CERT</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> grep C2S_AS_ROOT /etc/sysconfig/jabberd </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.5pt;color:black"># set C2S_AS_ROOT to "yes" to start c2s as root</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.5pt;color:black">C2S_AS_ROOT="no"</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black">I tried deleting the jabberd database and tables, but to no avail.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> rm -f /var/lib/jabberd/db/*</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span>
<o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> spacewalk-sql -i</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black"> delete from rhnPushDispatcher;</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black"> delete from rhnPushClient;</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black"> \quit</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black">I also tried re-configuring the jabberd service, to see if that would fix it, but it didn’t:</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> service osa-dispatcher stop</span><o:p></o:p></p>
<p class="MsoNormal" style="text-indent:.5in"><span style="font-size:10.5pt;color:black">service jabberd stop</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="text-indent:.5in"><span style="font-size:10.5pt;color:black">cp -arv /etc/jabberd /etc/jabberd.bak</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black">cp -arv /var/lib/jabberd/ /var/lib/jabberd.bak</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black">rm -rf /etc/jabberd/* /var/lib/jabberd/*
</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black">yum reinstall jabberd -y</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black">spacewalk-setup-jabberd</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black">grep $(hostname) /etc/jabberd/*xml</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black">service jabberd start</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.5pt;color:black">service osa-dispatcher start</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black">I verified that ports are open:</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> nmap -sT -p 5200-5400 localhost</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.5pt;color:black">Nmap scan report for localhost (127.0.0.1)</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.5pt;color:black">PORT STATE SERVICE</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.5pt;color:black">5222/tcp open xmpp-client</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.5pt;color:black">5269/tcp open xmpp-server</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.5pt;color:black">5347/tcp open unknown</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:black">I’ve run out of things to look at at this point. Any ideas?</span><o:p></o:p></p>
</div>
</body>
</html>