After deleting Applink connection, the username and password is shown in systemproperties
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Fisheye および Crucible は除く
問題
After deleting an applink connection, the username and password values for the deleted connection is shown in clear text under systemproperties.
診断
Diagnostic Steps
Run the following SQL in your database. You will need replace the value between the two wildcards (%) with whatever makes sense for your situation. In our example, we are searching for something to match "Confluence" by using '%onfluence%.
select * from propertyentry where property_key like '%onfluenc%';
Results will be returned as below with information similar to what was shown in systemproperties.
ID ENTITY_NAME ENTITY_ID PROPERTY_KEY propertytype 45509 jira.properties 1 confluence.applink 5 45511 jira.properties 1 confluence.password 5 45510 jira.properties 1 confluence.username 5
原因
Unknown at the moment
ソリューション
Delete the data from the database
- BACKUP YOUR DATABASE
- STOP JIRA
Run the following. Delete the data based on the ID from both propertystring and propertyentry table.
Delete from propertystring where ID in (45509,45511,45510); Delete from propertyentry where ID in (45509,45511,45510);
RESTART JIRA