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

How do I access the database of Hipchat?

Hi, 

I have a question.

I installed the HipChat server using the ova file.

Then occurred several problems.(some configuration problem)

So, I need to access the database of HipChat to solve it.

How can I access the database of Hipchat?

Please tell me how to access the database.

Thank you.

2 answers

1 vote
David Maye Atlassian Team Oct 12, 2016

Hi Jingoo,

Before you start editing files in HipChat Server, please be aware that any direct configuration outside of the 'hipchat' commands may be overwritten with default values upon reboot/upgrade. For a list of commands that will persist, simply type in 'hipchat' and hit enter.

Also, please be aware any modifications made with root are not supported:

sudo dont-blame-hipchat

Lastly, check out the deployment guide to help with setup: https://confluence.atlassian.com/hc/deploying-hipchat-server-609944387.html

Cheers,
-David
HipChat Server Support Engineer | Atlassian

Too bad this result comes up first and successfully skirts answering the question (eyeroll).

Like Nathanael_Motz likes this
Like Steven_Behnke likes this
Steven_Behnke Community Leader Jun 06, 2019

@Nathanael_Motz You're an absolute treasure and I miss you greatly

Thanks @Steven_Behnke, your comment made my day. The feeling is mutual.

0 votes
David Maye Atlassian Team Jun 07, 2019

Hi again,

For those trying to get into the database (HCS MariaDB), you can use the following to get in the _hipchat_ db:

DBPASS=$(awk '/"pass"/ {gsub(/[",]/,"");print $2}' /hipchat/config/site.json) && mysql -uroot -p$DBPASS hipchat

You can use exit to get back to the CLI. Only three years too late here (coneofshame), I misread the question.

Cheers,
-David
HipChat Server/Data Center Premier Support Engineer II | Atlassian

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