Details
-
Bug
-
Resolution: Fixed
-
Low
-
2.10.0, 4.3.0, 4.8.3, 4.11.2
-
27
-
Description
Summary
When the customer upgrades from the Stash ver2.10.0 to Bitbucket Server ver4.3.0, the old added access key at project and repository levels are not allowed to be deleted by the admin and thrown following error:
This access key no longer exists or you no longer have administrative rights to delete it.
The access key still still exist/visible at both project/repository settings and in the database as well.
Steps to Reproduce
- Begin with Stash ver2.10.0 with external database(MySQL).
- Added a LDAP (users and group) into User directory.
- Given the LDAP group access to the project.
- Create and add an users key access to project/repository
- Upgrade to Bitbucket Server ver4.3.0 (or higher - see Affected Versions)
- Use an System admin account to delete the access key.
Expected Result
Allow the System admin to delete the access key
Actual Result
When the System Admin tried to delete the access key, the System admin was thrown error message This access key no longer exists or you no longer have administrative rights to delete it. and the key not able to delete from the UI.
Workaround
If you have already upgraded an instance after Bitbucket Server 3.9, you can do a quick fix by removing the key from the database:
Always back up your data before performing any modifications to the database. If possible, test any insert, update, or delete SQL commands on a staging server first.
- Backup your instance using Bitbukcet Server backup client guide
- Stop Bitbucket Server
- Execute the following SQL query, where <user_email@mail.com> is the label of the key you cannot remove from the user interface:
DELETE FROM AO_FB71B4_SSH_PUBLIC_KEY WHERE LABEL = '<user_email@mail.com>';
4. Restart Bitbucket Server
Alternatively, if you have not upgraded yet from Bitbucket Server 3.9 and below, you can upgrade to Bitbucket Server 4.12 directly because the bug in had been fixed thus, the labels will be correctly set and the problem wouldn't appear to begin with.BSERV-9380
Attachments
Issue Links
- has a derivative of
-
BSERV-9380 Upgrade from Stash 2.11 and lower to 3.9 - 4.11 does not set correct service user label for migrated access keys
- Closed
- mentioned in
-
Page Loading...