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
Community showcase
Posted Tuesday in United States

Topic Tuesday: What's your favorite topic?

Good morning All, Our goal is to get you into the habit of while enjoying your favorite morning drink you are checking the NOVA "space" for topics and comments. Your input is really needed and...

62 views 4 0
View post

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