In my job experience I saw several problems and strange situation. In this post we examine some of this situations and how we  solve them .  In this post we discover some interesting tricks 😉

Using Jira as user management in Confluence

As shown in this documentation, we can use Jira Server as user management in Confluence Server. In this case, we have no problem in several situations. Only one set of user to manage, no problem with permission in using Confluence as KB repository in Jira Service Desk. As usually said: S P E T T A C O L O (I know. I’m Italian). 😛

Risultato immagini per Gioia

But what happen if we cannot do login in Confluence? This is he scenario: We can do login in Jira but not in Confluence. I’ve experience this situation during an update of Confluence. Very Sad 😦

How restore the normal situation? Well. Let me explain what we can do.

LOG

First check is: take a look to log file of Confluence and see if there are some errors. This helps us to understand which strategy use in solve the problem.

Risultato immagini per Atlassian log file trace

Recover admin mode

We can use a recovery admin user, as show in this community article . In this case in Confluence is available a special admin user we can use to login and check what happen. Following the article, we can define the password.

Risultato immagini per confluence recovery admin

Just add a configuration in Tomcat (setenv.sh file) and we can do a login with recovery_admin. So we can examine configurations and modify them. Only a note: use only for a small time. Some features are limited and better disable this after the problem is solved.

Database

In some case, we have to access directly to Confluence database, because we have to change the configuration of User directory. Thanks this article, If we need change the User Directory attributes, just check and update data inside this table: cwd_directory_attribute;

In my experience, my need was: change User Directory URL;  I used this SQL instruction:

 

update cwd_directory_attribute set attribute_value = https://<domain&gt;.com’ where attribute_name = ‘crowd.server.url’;

to change information and, after a service restart …. User Directory will reference the correct URL and I was able to to login without any problem.

 

Main suggestion

I know this is expensive, but I suggest to all administrator: CREATE A INTERNAL ADMIN USER (Both for Confluence and Jira) we can use in this situation.

 

By Artigiano Del Software

Posted by:artigianodelsoftware

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s