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

[Paul-Andre Panon]

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://omg.dje.li/2017/03/configuring-spacewalks-jabberd-to-use-a-postgre
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://www.motorolasolutions.com/en_us/about/privacy-policy.html#privacystatement>. 
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