[Spacewalk-list] Ongoing Jabberd issues on SW 2.9/Centos7 Servers

[Wilkinson, Matthew]

I've been using Spacewalk since 2013 and I cannot recommend anything to fix jabber as much as I can switching to the postgresdb. Just do it. You'll thank yourself later.

-----Original Message-----
From: spacewalk-list-bounces at redhat.com <spacewalk-list-bounces at redhat.com> On Behalf Of Paul-Andre Panon
Sent: Friday, October 04, 2019 12:29
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Ongoing Jabberd issues on SW 2.9/Centos7 Servers

[This is an external email. Be cautious with links, attachments and responses.]

**********************************************************************
On Fri, 4 Oct 2019 09:30:44 -0700, Larry Clegg <lclegg at kyriba.com> wrote:

>Hello Spacewalkers,

>I am continuing to have issues on all my Centos7/Spacewalk 2.9 servers
with Jabberd failing.  It is failing consistently on every server.  I have verified that all >the /etc/jabberd/*.xml files have the same FQDN and same passwords.  The /etc/pki/spacewalk/jabberd/server.pem includes the same FQDN.

>I just don't know where else to look and trouble-shoot.

There's been a bunch of posts about Jabberd being unreliable when working with a Berkeley db. See the second paragraph in this post https://urldefense.proofpoint.com/v2/url?u=https-3A__omg.dje.li_2017_03_configuring-2Dspacewalks-2Djabberd-2Dto-2Duse-2Da-2Dpostgre&d=DwIGaQ&c=GUDVeAVg1gjs_GJkmwL1m3gEzDND7NeJG5BIAX_2yRE&r=zxSMv3Yyn0u8GiLjBm805qsHQ-PQnlWklaJFaNwJsRdou0Rx32Ld6bt57-Tq1kdA&m=mDx9E5vnCsYQA2XEtNnrzs8jVGrsaofB51I-HHITTeY&s=iaUEN0Sr0l95ZhHSZQk4pXXPEH0fxKUE128LYpk5R_o&e=
sql-backend/

 I had similar problems until I switched to use postgres. It looks from your extracts that you're using sqlite or BerkeleyDB

>[root at us3-inf-lu-s01 jabberd]# pwd
>/var/lib/jabberd
>[root at us3-inf-lu-s01 jabberd]# ls -lR
...
>./db:
>total 8096
>-rw-r--r-- 1 jabber jabber  131072 Oct  4 11:53 sqlite.db
>-rw-r--r-- 1 jabber jabber   32768 Oct  4 12:26 sqlite.db-shm
>-rw-r--r-- 1 jabber jabber 4103552 Oct  4 12:26 sqlite.db-wal
...

Therefore I would suggest that you follow the instructions in that link and migrate your jabber database to the same postgres server as your Spacewalk db. My jabberd problems went away when I did that.

Cheers,

Paul-Andre

-- 


Your privacy is important to us. That is why we have taken appropriate measures to ensure the data you provide to us is kept secure. To learn more about how we process your personal information, how we comply with applicable data protection laws, and care for the security and privacy of your personal data, please review our Privacy Policy <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.motorolasolutions.com_en-5Fus_about_privacy-2Dpolicy.html-23privacystatement&d=DwIGaQ&c=GUDVeAVg1gjs_GJkmwL1m3gEzDND7NeJG5BIAX_2yRE&r=zxSMv3Yyn0u8GiLjBm805qsHQ-PQnlWklaJFaNwJsRdou0Rx32Ld6bt57-Tq1kdA&m=mDx9E5vnCsYQA2XEtNnrzs8jVGrsaofB51I-HHITTeY&s=Kx_K-zRIBSEuQbnAjxQXNIRVMpdsWArELNLhoB-S-RE&e= >. 
If you have any questions related to data protection and compliance with applicable laws, please contact us at our Security Operations Center at
1-302-444-9838 or mail us at: 

Attention: Privacy Compliance Program, P.O. 
Box 59263, Schaumburg, IL USA, 60159-0263

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