[Spacewalk-list] Error connecting to jabber

[Wilkinson, Matthew]

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-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Avi Miller
Sent: Wednesday, May 31, 2017 15:02
To: spacewalk-list at 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 <MatthewWilkinson at 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 at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list