It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

HipChat Data Center not able to connect to PostgreSQL

I am doing a test deployment of HipChat Datacenter on Virtual Machines and am unable to get the HipChat server to connect to the PostgreSQL server.  I built the HipChat server using the OVA.  I manually built a PostgreSQL server from the CentOS 7 (1708) ISO.  I created a HipChat database on the PostgreSQL server as well as a user for it an gave the user perms to the database.

I can open a browser from my workstation and connect to the setup UI of the HipChat server.  From my workstation, I can ping the PostgreSQL server and the port it is listening on (5432).  I can SSH into the HipChat server and also ping the PostgreSQL server and the port it is listening on ( image below):

postgreSQL.jpg

In the HipChat setup UI, I have tried using the IP address and the FQDN of the PostgreSQL server.  Below is what I get when I try the IP address:

hcui-ip.jpg

Below is what I get when I use the FQDN (which is resolvable from my workstation):

hcui-hostname.jpg

1 answer

0 votes
AhmadDanial Atlassian Team Jun 17, 2018

Hi, Byron.

Since you are running into issues while setting up the database through the HipChat Data Center wizard, can you please try to configure manually using configuration.json instead with reference to the Configure Hipchat Data Center using a config file documentation?

The error suggests that the wizard was unable to reach to the PostgreSQL though there was no issue using netcat. 

That will give us a rough idea on where to start troubleshooting this issue. Thanks.

I got this working and the only change I made was to install PostgreSQL 9.5 post OS install versus installing 9.2 as part of the OS install.

Hi, Byron.

Thank you for notifying me on the fix you implemented on your end. The requirement of deploying the specific version of PostgreSQL is highlighted in the following pages:

Deploy a Postgres instance using version 9.5. Use the the official Postgres installation guides found here.

Meanwhile, please let me know if the instance is fully running and operational as of now or if you happen to run into any issues along the way, do share it here.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Hipchat

Hipchat Cloud and Stride have reached End of Life (updated)

All good things come to an end - thanks to all our customers and partners who have been along the Hipchat and Stride journey with us.  As of Feb 15th 2019, Hipchat Cloud and Stride have reached ...

35,504 views 9 8
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you