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.

[Oleksandr Tynetalo]

In my case issue was fixed by deleting rows from tables propertyentry and propertystring
Which I found by 

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

Checked in other tables

SELECT *
FROM propertyentry as pe
LEFT JOIN propertystring as pstr
ON pstr.id = pe.id
where pe.property_key like '%testrail%';

And deleted by manually pasting IDs

DELETE
-- FROM propertyentry
FROM propertystring
WHERE id in (id1, id2, ...)

[Oleksandr Tynetalo]

I suppose the issue is caused by bug when not propery entries are not updated/deleted properly

In my case issue was fixed by deleting rows from tables propertyentry and propertystring
Which I found by 

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

Checked in other tables

SELECT *
FROM propertyentry as pe
LEFT JOIN propertystring as pstr
ON pstr.id = pe.id
where pe.property_key like '%testrail%';

And deleted by manually pasting IDs

DELETE
-- FROM propertyentry
FROM propertystring
WHERE id in (id1, id2, ...)

[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?

[Marian Gebauer]

Hello @Danila Polevshchikov 

Is you JIRA server running as docker or do you have full installation on server? Were there any additional setting taken to connect? TestRail support suggested to whitelist some IPs that help me a bit but still getting unable to connect on some part of TestRail for example when i want to Push to referenced issue in JIRA before whitelisting IPs i got timeout now i got connection refused. But for example i am able to see testcase in my jira issue that i referenced and also i am able to see if anything changed.

Any suggestions would help as i am not getting anywhere.

Thank you