Trying to change admin password of Crowd instance

[clementinebuschtetz]

Hi, 

I am trying to follow the instructions from this page: https://confluence.atlassian.com/crowdkb/restoring-passwords-to-recover-admin-user-rights-283642653.html

I cannot remember our Crowd admin password, we are using Postgresql, but when I run the database query:

select u.id, u.user_name, u.directory_id from cwd_user u
 join cwd_membership m on u.id=m.child_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 = 'crowd-administrators' and d.directory_type='INTERNAL';

 I get the following error: 

ERROR: relation "cwd_user" does not exist
LINE 1: select * from cwd_user;

Thank you for your help, 

Clementine

[jira guy]

Did you try step 4 form the documentation? May be there are no users in our instance. 

https://confluence.atlassian.com/crowdkb/restoring-passwords-to-recover-admin-user-rights-283642653.html?_ga=2.86186136.1639996058.1565615014-1093201125.1565211006&_gac=1.11718272.1565875548.EAIaIQobChMI8fba-fyE5AIVzlqGCh1TDAP0EAAYAiAAEgI-U_D_BwE