Local admin account does not work for jira and confluence

[Sergey Savalyk]

The issue is the same for confluence and jira

Cannot login with the local admin account

main authentication is done by crowd directory, so i can can change the password for local admin

also i've done all form here:

https://confluence.atlassian.com/conf64/restore-passwords-to-recover-admin-user-rights-936511358.html

the admin account is not working and the capcha appears(i can reset it) so it seems that no matter what i do the password is considered wrong?

[dummy]

Hi Nic, thanks for your reply. In the meanwhile we have had some progress.

On Friday we have found a documentation, which says, that local accounts don‘t work, if the SSO authenticator is enabled.

We have been able to confirm this by switching the authenticator of Confluence from SSO to default and back in a config file.

The weird part is, that SSO and both directories have been working before. We will continue investigations.

Ralf

[dummy]

One further detail about this problem. We have changed the domain of all servers/services (myold.com to mynew.com). May be this detail gives some further ideas, what perhaps has messed up.

[Nic Brough -Adaptavist-]

Ok, so did you amend all the base urls and application links to match?

[dummy]

Yes and we have also updated the server.xml, as well as the Remote Directory Connection to Crowd.

[Nic Brough -Adaptavist-]

Ok, so I think we should try something more extreme.  The cwd_directory table should have an "enabled" flag.  Stop Jira, use SQL to flip the flag on the external directory so it becomes inactive and restart.

[Miroslav Denkov]

Can I ask if editing the 'T' and 'F' flags in active table would have an affect?

Our users cannot connect to confluence, but we don't have problems with JIRA after restoring backup to the same environment (using JIRA instance authentication).

[Fabio Racobaldo _Herzum_]

As said by Nic, you need to check if there's overlap of userame through local and crowd sources. BTW, you need to check what is the order of two different users sources in order to understand if you need to use local or crowd password.

Ciao,

Fabio

[Sergey Savalyk]

Hi Fabio and Nic, thank you for the quick response.

Regarding the order of the sources i have tried to change it, but it did not help as well.

  id   |        directory_name         | list_index  
--------+-------------------------------+------------
294913 | Confluence Internal Directory |          0
294914 | Crowd Server                  |          1

there is no admin record in the directory, each instance has its own local admin in the cwd_user table

[Nic Brough -Adaptavist-]

Does your Crowd system have another user with the same id as the local admin?