Ok thanks Avi. I read your blog post and was able to successfully configure jabberd to use postgres on my OL 6 box. However, I wasn't able to get it to work on an OL 7 box. I keep getting this in my syslog:
May 31 15:36:34 <hostnameredacted> jabberd/sm[21956]: pgsql: connection to database failed: could not connect to server: Permission denied#012#011Is the server running locally and accepting#012#011connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? Mind you, I can indeed connect using jabberd2 user via the psql command just fine. No matter what I do to ensure the jabberd2 user has rights/grants and no matter what I do to allow the user to connect via the pg_hba.conf I can't get jabberd to start on OL 7 after configuring it for pgsql. Did you get it working on OL 7? --Matthew Wilkinson -----Original Message----- From: spacewalk-list-boun...@redhat.com [mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Avi Miller Sent: Wednesday, May 31, 2017 15:02 To: spacewalk-list@redhat.com Subject: Re: [Spacewalk-list] Error connecting to jabber [This is an external email. Be cautious with links, attachments and responses.] ********************************************************************** Hi, > On 1 Jun 2017, at 3:58 am, Wilkinson, Matthew > <matthewwilkin...@alliantenergy.com> wrote: > > Awesome thank you so much! I'm going to look into this. Does this cause any > problems with upgrades from one minor version of Spacewalk to another? Or do > the configs remain persistent and work after updates/upgrades? It does cause very minor problems: during the upgrade, when you re-run spacewalk-setup --upgrade, it’ll reset the config back to “db” (or “sqlite” in 2.7). It doesn’t retain the current setting, but it does retain the db-specific configuration. You’ll need to re-edit the two files and switch them back to pgsql before starting the Spacewalk services. I keep meaning to either log an issue or fix this, but I always seem to have something else on my plate. Cheers, Avi -- Oracle <http://www.oracle.com> Avi Miller | Product Management Director | +61 (3) 8616 3496 Oracle Linux and Virtualization 417 St Kilda Road, Melbourne, Victoria 3004 Australia _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
