Login Issue- Assume User Directory Issue

[Matt Paskus]

During the installation process I modified the Confluence box to authenticate off our jira server. All worked fine.

Restored from backup and I assume it overwrote jira connection in the 'user directoies' configuartion.

I cannot login. :-(

Is there a way to modify the user directories configuration manually from the linux command line?

Thanks.

[Tiago Comasseto]

Hi Matt,

You can edit it directly via database. You may try this:

1. Identify the internal administrator:

   select u.id, u.user_name from cwd_user u
   join cwd_membership m on u.id=m.child_user_id join cwd_group g on m.parent_id=g.id join cwd_directory d on d.id=g.directory_id
   where g.group_name = 'confluence-administrators' and d.directory_name='Confluence Internal Directory';

2. Resert internal administrator password:

   update cwd_user set credential =
   'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A=='
   where id=<id from Stage 1>;

3. Put internal directory on the top position.
4. Restart Confluence.

I hope this helps

Cheers