<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;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr"> <div id="divtagdefaultwrapper" dir="ltr"> <p style="color: rgb(0, 0, 0); font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt;"> Avi,</p> <p style="color: rgb(0, 0, 0); font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt;"> <br> </p> <p style="color: rgb(0, 0, 0); font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt;"> You wrote those procedures? <span>Jan-Albert provided the link to the postgres steps and I followed them, on my test server. They are very clear and easy to use. </span></p> <p style="color: rgb(0, 0, 0); font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt;"> <span><br> </span></p> <p><font face="Calibri, Arial, Helvetica, sans-serif"><span style="font-size: 12pt;">Prior to my posting this question, I looked at other steps to moving to sqlite, they looked </span>challenging, and I didn't want to give it a try. I would do something wrong, and break my database. <span style="font-size: 12pt;"> Your steps for using sqlite are much easier, and clearer. I'll give them a try on my test system.</span></font></p> <p><font face="Calibri, Arial, Helvetica, sans-serif"><span style="font-size: 12pt;"><br> </span></font></p> <p><font face="Calibri, Arial, Helvetica, sans-serif"><span style="font-size: 12pt;">So, which is </span>preferred<span style="font-size: 12pt;"> by the community? sqlite, or postqres? </span></font></p> <br> Thanks</div> <div id="divtagdefaultwrapper" dir="ltr"><br> </div> <div id="divtagdefaultwrapper" dir="ltr">Daryl</div> <div id="divtagdefaultwrapper" dir="ltr"><br> <div style="color: rgb(0, 0, 0); font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt;"> <hr tabindex="-1" style="display:inline-block; width:98%"> <div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> spacewalk-list-bounces@redhat.com <spacewalk-list-bounces@redhat.com> on behalf of Avi Miller <avi.miller@oracle.com><br> <b>Sent:</b> Thursday, March 23, 2017 2:39 PM<br> <b>To:</b> spacewalk-list@redhat.com<br> <b>Subject:</b> Re: [Spacewalk-list] Replacing the Jabberd database</font> <div> </div> </div> <div>Hi, <div class=""><br class=""> <div> <blockquote type="cite" class=""> <div class="">On 23 Mar 2017, at 11:50 pm, Daryl Rose <<a href="mailto:darylrose@outlook.com" class="">darylrose@outlook.com</a>> wrote:</div> <br class="Apple-interchange-newline"> <div class=""> <div id="divtagdefaultwrapper" dir="ltr" class="" style="font-style:normal; font-weight:normal; letter-spacing:normal; orphans:auto; text-align:start; text-indent:0px; text-transform:none; white-space:normal; widows:auto; word-spacing:0px; font-size:12pt; font-family:Calibri,Arial,Helvetica,sans-serif"> I've always had issues with clients machines connecting to the SW server. In the past, others have suggested replacing the Jabberd database with something else, but I don't remember what that is. So, I am hoping that someone can pass on that information to me. What should I replace Jabbered DB with, and are there detailed steps out there? <div class=""><br class=""> </div> </div> </div> </blockquote> <br class=""> </div> <div>I wrote up two procedures, one to switch to SQLite and the other to switch to PostgreSQL:</div> <div><br class=""> </div> <div>SQLite: <a href="https://omg.dje.li/2017/02/configuring-spacewalks-jabberd-to-use-an-sqlite-backend/" class="">https://omg.dje.li/2017/02/configuring-spacewalks-jabberd-to-use-an-sqlite-backend/</a></div> <div>PostgreSQL: <a href="https://omg.dje.li/2017/03/configuring-spacewalks-jabberd-to-use-a-postgresql-backend/" class="">https://omg.dje.li/2017/03/configuring-spacewalks-jabberd-to-use-a-postgresql-backend/</a></div> <div><br class=""> </div> <div>Let me know if you have any questions or if the steps aren’t clear. :)</div> <div><br class=""> </div> <div>Cheers,</div> <div>Avi</div> <br class=""> <div class="">--<br class=""> Oracle <<a href="http://www.oracle.com" class="">http://www.oracle.com</a>><br class=""> Avi Miller | Product Management Director | +61 (3) 8616 3496<br class=""> Oracle Linux and Virtualization<br class=""> 417 St Kilda Road, Melbourne, Victoria 3004 Australia </div> <br class=""> </div> </div> </div> </div> </div> </body> </html>