Can't integrate Jira with TestRail plugin

[Chernov.IYu]

Hello.

I have Jira-software server and then, i install TestRail plugin from atlassian market, but when i try to configure TestRail with button  "Add new testrail connection", the button doesn't active. It says "All Jira projects currently have connections to TestRail". Then I go check my project -> TestRail and all i can see is message "Your TestRail integration is not yet configured...."

How can i configure connection with testrail plugin?
I tried find solutions in other sources, but doesn't find any.

[Diego Marinelli]

@Chernov.IYu Found this and worked for me. I uninstalled the addon, deleted the rows mentioned and reinstalled the plugin and I was able to reconfigure correctly.

https://discuss.gurock.com/t/jira-add-on-unable-to-configure-a-new-testrail-connection/17516/8

[Gregory Fein]

Diego, if this does in fact work, IOU one beer of your choice!

[Miguel Nanquil]

Mine's worked. Had a trouble on searching for the ids using the sqlquery:

select * from propertyentry where property_key like ‘testrail%’;

So I used:

select * from propertyentry where property_key like ‘%testrail%’;

instead.

[Oleksandr Tynetalo]

What were the rows? Link above doesn't work anymore
What should be deleted?

[Robert Frazine]

what database needs what rows removed?  The link to the gurock community no longer works, and I'm having this problem as well.

[Gregory Fein]

I have this exact same issue and have been trying to trouble shoot it for months to no avail, all I can think to do is to go into each project and remove and existing links to testrail and try again since uninstalling it does nothing.

[Danila Polevshchikov]

"I uninstalled the addon, deleted the rows mentioned and reinstalled the plugin and I was able to reconfigure correctly." this one works for me in 2022 and on-premise jira. Order of action is important, just deleting rows don't work.

DataBase Explorer | Atlassian Marketplace used this one to get access to DB

[Oleksandr Tynetalo]

@Danila Polevshchikov What were the rows? Link above doesn't work anymore
What should be deleted?