Confluence use of Jira for user management broken

[John Holdzkom]

Some time ago I installed self-hosted JIRA (v7.3.8) and Confluence (v6.2.3) and set up Confluence to use JIRA for user management.  That was working fine until there was a change to the IP address of the machine, and now I am locked out of Confluence.

Unfortunately everything I've found for resetting Confluence to use JIRA for user management starts with the step of logging into Confluence as Admin, but my problem is that I can't log into Confluence.

Any ideas where I can reconfigure the connection between Confluence and JIRA and/or break the dependency so I can at least access Confluence?  (is it stored in a config file, or a database entry?)

Thanks in advance for any responses.

[Thomas Deiler]

Dear @John Holdzkom,

bad to hear but probably good for others who read this question:

Always have a local (internal) admin login as fall-back.

This won't help you right now, but for your situation you can follow this article

So long

Thomas

[John Holdzkom]

Thanks. I have followed that page and the database query (step 1) indicates my username is a local admin, but my login attempts to Confluence fail.  The same user/pass works for JIRA. I'm hesitant to reset the password since it works for JIRA.

[Thomas Deiler]

But if its local, it would not change for Jira, or? Or do you modify the Jira DB?

[John Holdzkom]

I have two DB's, one for JIRA and one for Confluence.  I was hoping to find where the confluence table points to jira DB for user management.  I suppose I can try to edit the password in the confluence DB (after backing everything up!).

(edited: I previously incorrectly stated all was in one DB)

[Thomas Deiler]

Ok, but you have shutdown both apps before, or?