After deleting Applink connection, the username and password is shown in systemproperties

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

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.

*Except Fisheye and Crucible

Problem

After deleting an applink connection, the username and password values for the deleted connection is shown in clear text under systemproperties.

Diagnosis

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

Cause

Unknown at the moment

Resolution

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

Last modified on Mar 28, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.