<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=Windows-1252"> <style type="text/css" style="display:none;"></style> </head> <body dir="ltr"> <div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;"> <p>I've posted here issues that I've had with jabberd and osad, as have others. But I haven't gotten things resolved, so I am posting additional information.</p> <p><br> </p> <p>I put SW into production about a year ago. After a period of time, I noticed issues with the WUI and servers not reporting correctly and other issues. Google searches show that I need to shutdown spacewalk and remove all the contents in /var/lib/jabberd/db. This seemed to work, but a<span style="font-size: 12pt;">fter a few months, I realized that osad was no longer communicating with osa-dispatcher. </span></p> <p><span style="font-size: 12pt;"><br> </span></p> <p><span style="font-size: 12pt;">I started doing some additional research and learned that was not a good way to resolve this issue. According to the official Spacewalk documentation, I should create a checkpoint and then clean up log files keeping the database and auth database files. </span></p> <p><span style="font-size: 12pt;"><br> </span></p> <p><span style="font-size: 12pt;"><a href="https://fedorahosted.org/spacewalk/wiki/JabberDatabase" class="OWAAutoLink" id="LPlnk857704">https://fedorahosted.org/spacewalk/wiki/JabberDatabase</a></p> <div id="LPBorder_GT_14714581103010.5447606482849334" style="margin-bottom: 20px; overflow: auto; width: 100%; text-indent: 0px;"> <table id="LPContainer_14714581102980.5203138000799807" cellspacing="0" style="width: 90%; position: relative; overflow: auto; padding-top: 20px; padding-bottom: 20px; margin-top: 20px; border-top: 1px dotted rgb(200, 200, 200); border-bottom: 1px dotted rgb(200, 200, 200); background-color: rgb(255, 255, 255);"> <tbody> <tr valign="top" style="border-spacing: 0px;"> <td id="TextCell_14714581102990.273446366752113" colspan="2" style="vertical-align: top; position: relative; padding: 0px; display: table-cell;"> <div id="LPRemovePreviewContainer_14714581102990.22446614324122272"></div> <div id="LPTitle_14714581102990.32801063407794606" style="top: 0px; color: rgb(0, 120, 215); font-weight: normal; font-size: 21px; font-family: wf_segoe-ui_light, "Segoe UI Light", "Segoe WP Light", "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; line-height: 21px;"> <a id="LPUrlAnchor_14714581103000.13917923731122261" href="https://fedorahosted.org/spacewalk/wiki/JabberDatabase" target="_blank" style="text-decoration: none;">JabberDatabase – spacewalk - Fedora Hosted</a></div> <div id="LPMetadata_14714581103000.23656434473017063" style="margin: 10px 0px 16px; color: rgb(102, 102, 102); font-weight: normal; font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 14px; line-height: 14px;"> fedorahosted.org</div> <div id="LPDescription_14714581103000.27343562914630315" style="display: block; color: rgb(102, 102, 102); font-weight: normal; font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 14px; line-height: 20px; max-height: 100px; overflow: hidden;"> Jabber Database. Spacewalk utilizes Jabber to facilitate communications between the server and the clients for osa-dispatcher/osad. The Jabber program uses the ...</div> </td> </tr> </tbody> </table> </div> These are the steps that I followed:</span> <p></p> <p><br> </p> <p><span style="font-size: 12pt;"></p> <div> <div><span style="font-size: 12pt;">/usr/bin/db_checkpoint -1 -h /var/lib/jabberd/db/ ## mark logs for deletion</span></div> </div> <div>/usr/bin/db_archive -d -h /var/lib/jabberd/db/ ## delete logs</div> <div> <div>service jabberd restart</div> <div><br> </div> </div> However, this also causes problems with jabberd and osad. If I use the commands as the documentation instructs, then osa-dispatcher will start, but die, and I get errors in the log that there is an invalid password. </span> <p></p> <p><span style="font-size: 12pt;"><br> </span></p> <p>So to help explain my issue, I ran a test and tried to capture everything that I could and I'll post it here.</p> <p><br> </p> <p>1. Listing of /var/lib/jabberd/db</p> <p></p> <div>[root@<spwalk-server> db]# ls </div> <div>__db.001 __db.006 log.0000000004 log.0000000009 log.0000000014 log.0000000019 log.0000000024 sm.db</div> <div>__db.002 authreg.db log.0000000005 log.0000000010 log.0000000015 log.0000000020 log.0000000025</div> <div>__db.003 log.0000000001 log.0000000006 log.0000000011 log.0000000016 log.0000000021 log.0000000026</div> <div>__db.004 log.0000000002 log.0000000007 log.0000000012 log.0000000017 log.0000000022 log.0000000027</div> <div>__db.005 log.0000000003 log.0000000008 log.0000000013 log.0000000018 log.0000000023 log.0000000028</div> <br> <p></p> <p>2. Spacewalk Server Status</p> <p></p> <div>[root@<spwalk-server> db]# spacewalk-service status</div> <div>postmaster (pid 1175) is running...</div> <div>router (pid 21431) is running...</div> <div>sm (pid 21441) is running...</div> <div>c2s (pid 21451) is running...</div> <div>s2s (pid 21461) is running...</div> <div>tomcat6 (pid 1304) is running... [ OK ]</div> <div>httpd (pid 1385) is running...</div> <div>osa-dispatcher (pid 21479) is running...</div> <div>rhn-search is running (1441).</div> <div>cobblerd (pid 1491) is running...</div> <div>RHN Taskomatic is running (1515).</div> <br> <p></p> <p>3. Most recent log file entry:</p> <p></p> <div>2016/08/17 07:44:13 -05:00 21476 0.0.0.0: osad/jabber_lib.__init__</div> <div>2016/08/17 07:44:13 -05:00 21476 0.0.0.0: osad/jabber_lib.setup_connection('Connected to jabber server', '<spwalk-server>.com')</div> <div>2016/08/17 07:44:13 -05:00 21476 0.0.0.0: osad/osa_dispatcher.fix_connection('Upstream notification server started on port', 1290)</div> <div>2016/08/17 07:44:14 -05:00 21476 0.0.0.0: osad/jabber_lib.process_forever</div> <br> <p></p> <p>4. Ran the commands as instructed in the jabberd documentation.</p> <p></p> <div><span style="font-size: 12pt;">/usr/bin/db_checkpoint -1 -h /var/lib/jabberd/db/ ## mark logs for deletion</span></div> <div>/usr/bin/db_archive -d -h /var/lib/jabberd/db/ ## delete logs</div> <div> <div style="font-family: Calibri, Arial, Helvetica, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;"> service jabberd restart</div> </div> <div><br> </div> 5. Log file entry: <p></p> <p></p> <div>2016/08/17 13:28:19 -05:00 21476 0.0.0.0: osad/jabber_lib.main('ERROR', 'Traceback (most recent call last):\n File "/usr/share/rhn/osad/jabber_lib.py", line 121, in main\n self.process_forever(c)\n File "/usr/share/rhn/osad/jabber_lib.py", line 179, in process_forever\n self.process_once(client)\n File "/usr/share/rhn/osad/osa_dispatcher.py", line 187, in process_once\n client.retrieve_roster()\n File "/usr/share/rhn/osad/jabber_lib.py", line 729, in retrieve_roster\n stanza = self.get_one_stanza()\n File "/usr/share/rhn/osad/jabber_lib.py", line 801, in get_one_stanza\n self.process(timeout=tm)\n File "/usr/share/rhn/osad/jabber_lib.py", line 1055, in process\n data = self._read(self.BLOCK_SIZE)\nSSLError: (\'OpenSSL error; will retry\', "(-1, \'Unexpected EOF\')")\n')</div> <div>2016/08/17 13:28:29 -05:00 21476 0.0.0.0: osad/jabber_lib.__init__</div> <div>2016/08/17 13:28:29 -05:00 21476 0.0.0.0: osad/jabber_lib.setup_connection('Connected to jabber server', '<spwalk-server>.com')</div> <div>2016/08/17 13:28:29 -05:00 21476 0.0.0.0: osad/jabber_lib.register('ERROR', 'Invalid password')</div> <br> <p></p> <p>6. Spacewalk server status</p> <p></p> <div>[root@<spwalk-server> db]# spacewalk-service status</div> <div>postmaster (pid 1175) is running...</div> <div>router (pid 27119) is running...</div> <div>sm (pid 27129) is running...</div> <div>c2s (pid 27139) is running...</div> <div>s2s (pid 27149) is running...</div> <div>tomcat6 (pid 1304) is running... [ OK ]</div> <div>httpd (pid 1385) is running...</div> <div>osa-dispatcher dead but pid file exists</div> <div>rhn-search is running (1441).</div> <div>cobblerd (pid 1491) is running...</div> <div>RHN Taskomatic is running (1515).</div> <br> <p></p> <p>7. Long listing of /var/lib/jabberd/db</p> <p></p> <div>[root@<spwalk-server> db]# ls -l</div> <div>total 7536</div> <div>-rw-r-----. 1 jabber jabber 24576 Aug 17 13:28 __db.001</div> <div>-rw-r-----. 1 jabber jabber 204800 Aug 17 13:29 __db.002</div> <div>-rw-r-----. 1 jabber jabber 270336 Aug 17 13:29 __db.003</div> <div>-rw-r-----. 1 jabber jabber 98304 Aug 17 13:29 __db.004</div> <div>-rw-r-----. 1 jabber jabber 753664 Aug 17 13:29 __db.005</div> <div>-rw-r-----. 1 jabber jabber 57344 Aug 17 13:29 __db.006</div> <div>-rw-r-----. 1 jabber jabber 368640 Aug 17 07:46 authreg.db</div> <div>-rw-r-----. 1 jabber jabber 10485760 Aug 17 13:29 log.0000000031</div> <div>-rw-r-----. 1 jabber jabber 487424 Aug 17 13:29 sm.db</div> <br> <p></p> <p><span style="font-size: 12pt;">So, neither completely cleaning out jabberd database/log files works, and creating a checkpoint and removing log files that need to be cleaned out doesn't' work, so what can I do to get jabberd and osad to work, and to push out updates when I need to push them out?</span><br> </p> <p><br> </p> <p>Thank you.</p> <p><br> </p> <p>Daryl</p> <p><br> </p> <p><br> </p> <p><br> </p> <p><br> </p> <p><br> </p> <p><span style="font-size: 12pt;"></span></p> <p><span style="font-size: 12pt;"><br> </span></p> <p><span style="font-size: 12pt;"><br> </span></p> <p><span style="font-size: 12pt;"><br> </span></p> <p><span style="font-size: 12pt;"><br> </span></p> <p><span style="font-size: 12pt;"><br> </span></p> <p><br> </p> <p><br> </p> </div> </body> </html>