Some tricks for Jira and Confluence #3

As all know, we can connect Confluence . Well. In some cases there are some issues. Let me describe a specific situation I have to manage with Confluence and User Directory.

Scenario

I had to work with a Confluence with this configuration. Users are managed by Jira. Well, After pass Confluence and Jira in HTTPS, Confluence was not able to connect. User Directory cannot synchronize nothing. Well. How we can solve this situation?

Well, just use SQL and reference a specific table of Jira Scheme. Let me explain better. If we reference CWD_DIRECTORY_ATTRIBUTE table, where this information is stored, we can force the correct value. In this case I have a URL like this:

http://<domain>.<suffix>

I’ve changed with HTTPS:// and the problem was solved soon. Here the SQL code to use:

update cwd_directory_attribute set attribute_value = 'https://<domain>.<suffix>' where attribute_name = 'crowd.server.url';

By Artigiano Del Software