It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
TAGS
Community showcase
Published in Jira Align

Best Practices in Jira Align

Hello Jira Align customers! In order to better serve you on your journey with Jira Align, the Community team has worked with the Jira Align team to curate the content in this collection to better s...

67 views 0 2
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you