edit crowd.server.url on confluence to access jira directory (crowd)

Question

We have Jira and Confluence hosted external (no direct server access) behind an Apache. Our confluence uses the Jira logins via Atlassian crowd. We wanted to secure our production Jira with SSL. As soon as we add a forward rule so all http-request will be forwarded to https, we are no longer able to login to confluence. So we temporarily let this forwarding be disabled again.

We found that in confluence-administration at user-directories there is an overview showing "crowd.server.url": "http://<our-jira-url>", so we guessed this is the culprit. But we found nowhere a posibility to edit this value. Neither in confluence-administration nor is there a crowd.properties file found in the server-paths (installation and application-data) we have access to.

Can someone please tell what and how should I configure confluence to being able to access our jira-user-directory via https?

Answer 1

Found it. You must change the value for internal Crowd (or JIRA) server URL:

mysql> use confluence;
mysql> update cwd_directory_attribute
    set attribute_value = 'https://your.new.jira.tld/'
    where attribute_name = 'crowd.server.url';

After updating, restart Confluence.