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 Access denied for user 'root'@'localhost'

After upgrading Hipchat from 2.2.9 to 2.4.0 the Web UI hangs with 

Something went wrong

Try again later

Command line output:

admin@hipchat:~$ hipchat upgrade --check
The current channel for upgrades is: production
Current Version is: Atlassian HipChat 2.2.9 (2018.01.23.110010)
An upgrade is available: 2.4.0 (2018.05.10.074812)
admin@hipchat:~$ hipchat upgrade --upgrade
Expected sha512sum and filename: e86b4eff1824b3dac6b0b90c9af1a4ea5cdd265a06980f16ee35247cffd12105752b23d71bd166c013d9706150d34b7ed0c8654f030af590efe88f59f2ab4fa8 hcs-2.4.0-2018.05.10.074812.tar.gz
Downloading the update, this may take a few minutes depending on your network speeds
Calculated sha512sum: e86b4eff1824b3dac6b0b90c9af1a4ea5cdd265a06980f16ee35247cffd12105752b23d71bd166c013d9706150d34b7ed0c8654f030af590efe88f59f2ab4fa8 hcs-2.4.0-2018.05.10.074812.tar.gz
Updating system configuration, this may take a few minutes...
Upgrade Completed Successfully (awyeah)
Current Version is: Atlassian HipChat 2.4.0 (2018.05.10.074812)

Log excerpt:

2018-07-24T09:06:09.106912+00:00 hipchat web[2833]: users/sign_in#REQD0EB0B uid-anon 185ms [alert] Uncaught Kohana_Database_Exception: There was an error connecting to the database: Access denied for user 'root'@'localhost' (using password: YES) in file /hipchat-scm/web/system/libraries/Database.php on line 218

How can I reset the MySQL root password with the limited access of the admin user?

2 answers

1 accepted

Thanks, this solved the problem.

@Gerald SchneiderI would  verify root password and try again connect to  database but if  you  insist  on  changing  root password  the  see here Change root password Mysql

 

GoodLuck!

I don't insist on changing it. I just want to fix it, I don't really care how. Further, I know how to change the root password on a MySQL server, but I can't do that with the limited admin account of the HipChat appliance.

Thanks anyway.

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