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.
@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
Diego, if this does in fact work, IOU one beer of your choice!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What were the rows? Link above doesn't work anymore
What should be deleted?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
what database needs what rows removed? The link to the gurock community no longer works, and I'm having this problem as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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, ...)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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, ...)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
"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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.