Importing backup file caused log in error

Question

Hi, all I was restoring our JIRA staging server from JIRA production backup file. At some point ( 20% ) the system just stoped importing and the green line didn't go any further. I restarted ( stop-jira.sh/start-jira.sh ) the staging JIRA server. Now I cannot enter it, cannot authenficate through the log in page as administrator. The following in the jira-security.log: 'admin' tried to login but they do not have USE permission or weren't found. I followed sugestions from here to retrieve admin access: https://confluence.atlassian.com/display/JIRA/Retrieving+the+JIRA+Administrator#RetrievingtheJIRAAdministrator-2.Setthepassworddirectlyinthedatabase> But: select id, directory_name, active from cwd_directory;

after update cwd_directory set active = 1 where id = 1;

provides nothing and still no access Could you please advise ? My JIRA details: Version 5.0.4 Linux DB Oracle 10g Thank you

Kevin Ferguson · Answer

You should not kill/restart your restore when it is at 20%.  The first 19% of the restore is merely parsing.  No data is actually restored.  Certain data is flagged for deletion while others are preserved at 20% so this step takes a while.  Be patient.  Similarly at 90% post steps are determined. Again, be patient as this will take a while.

Leigh Lee · Answer

Please, find my answer below

Leigh Lee · Answer

Hi, thank you for such a prompt answer. select * from cwd_user where user_name = 'admin' active = 1 ( screenshot ) Why CWD_DIRECTORY is empty ? select id, directory_name, active from cwd_directory; shows that there are no active directories the same after update cwd_directory set active = 1 where id = 1;