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

"Failed to create the Hipchat schema." error while setting up HipChat Data Center

I am trying to setup Hipchat Data Center.  The OVA has been deployed successfully, and I've installed PostgreSQL 9.5 on another RHEL 7 server following the instructions found on https://confluence.atlassian.com/hipchatkb/how-to-set-up-a-basic-postgresql-database-for-hipchat-data-center-939920908.html, including granting the following db accesses per the documentation:

# create hipchat_postgres database
sudo -u postgres psql postgres -c "CREATE DATABASE hipchat_postgres"

# create dedicated user, set $PASSWORD (replace the variable with the desired password)
sudo -u postgres psql postgres -c "CREATE USER hipchat_user"
sudo -u postgres psql postgres -c "ALTER USER hipchat_user PASSWORD '$PASSWORD';"

# give hipchat_user access to database
sudo -u postgres psql postgres -c "ALTER ROLE hipchat_user WITH LOGIN;"
sudo -u postgres psql postgres -c "GRANT ALL ON DATABASE hipchat_postgres TO hipchat_user;"

 

 When I enter the PostgreSQL configuration information on the new "Set up HipChat Data Center" page, I continue to receive the error "Failed to create the Hipchat schema."  The "hipchat_user" should have full permissions to the "hipchat_postgres" db. 

 

The 5432 port is open and the Hipchat VM has access to the PostgreSQL system.  What am I missing?

1 answer

Disregard...it turns out that the password was the problem.

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,188 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