Hipchat Access denied for user 'root'@'localhost'

Gerald Schneider
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 24, 2018

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

2 votes
Answer accepted
Moses Thomas
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 24, 2018
Gerald Schneider
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 24, 2018

Thanks, this solved the problem.

Moses Thomas
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 24, 2018

@Gerald SchneiderYou welcome!

0 votes
Moses Thomas
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 24, 2018

@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!

Gerald Schneider
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 24, 2018

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
AUG Leaders

Atlassian Community Events