Importing backup file caused log in error

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

3 answers

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)

Please, find my answer below

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;


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.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Tuesday in Uncategorized

Friday fun: how many celebrates Midsummer holiday or is this a Swedish tradition only?

Any other country that celebrates Midsummer holiday (this friday 22 June)?  

40 views 3 1
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you