Importing backup file caused log in error

[Leigh Lee]

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<br< a="">>
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]

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]

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;



[Ubisoft]

Hi Leigh,

Can you check the first row of your cwd_user table? You should have the 'admin' username, make sure that it's active? (set to 1 in the active column)

[Leigh Lee]

Please, find my answer below