How do I access the database of Hipchat?

[Jingoo Kim]

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.

[David Maye]

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

[Steven Behnke]

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

[Nathanael Motz]

Perhaps useful: https://community.atlassian.com/t5/Hipchat-questions/HipChat-database-user-and-password-readable/qaq-p/701704

[Steven F Behnke]

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

[Nathanael Motz]

Thanks @Steven F Behnke, your comment made my day. The feeling is mutual.

[David Maye]

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