nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Unable to login to local JIRA after onDemand Restore

Justin Hurley

I am currently trying to merge a few JIRA onDemand instances together. I saw that the best way to do this was to create a temporary local enviroment, restore a onDemand instance, use the project import tool for the rest, and restore into onDemand. However after I restore the first JIRA onDemand xml backup to my local JIRA, I can no longer log in. I have tried my onDemand username/password, sysadmin/sysadmin, and I have even changed the postgresql database entry to sysadmin/sphere. I still cannot log in?

Accepted answers

Justin Hurley

I ended up having to work with my old offline 4.2.1 backup and upgrade it by itself to 6.2. From there I was able to import the other onDemand instances via the project importer and fix the rest manually. Not the most ideal solution but I did not have to redo all of tickets.

All comments

Mauro Badii

Hi Justin,

This guide gives you the information you need: Cannot login as sysadmin after import backup from JIRA OnDemand to JIRA Standalone and provides another link to Retrieving the JIRA Administrator manually too.

Cheers,
Mauro

Justin Hurley

Thanks for the response!

I did read the document you linked and had set the database for credentials sysadmin/sphere to no avail. I opened up the logs and finding it trying to authenticate beyond my network? Does this have something to do with crowd?

atlassian-jira-security.log:

2013-12-16 22:41:59,739 http-bio-8080-exec-10 anonymous 1361x45x1 8stpk8 10.10.0.27 /rest/gadget/1.0/login login : 'sysadmin' tried to login but they do not have USE permission or weren't found. Deleting remember me cookie.

Mauro Badii

Justin,

That error seams like a noise error as reported on this improvement request: SER-184

I would say that the password was not correctly changed or maybe Jira wasn't restarted afterwards. I had to do that in the past and manually changing the password should always work as a last resource.

If it keeps failing, I would recommend starting again from scratch. New database.

Best of luck,
Mauro

Justin Hurley

Alright, I have done a bit of playing around with it. It seems to be specific to the export from onDemand. I can export another, smaller onDemand and do everything normally. However, when I import my larger onDemand instance I cannot log in no matter what I do, even with password database injection. Nor does the project importer reconcognize it as a a vaild xml backup.

Justin Hurley

Colin Goudie

In our case, the cwd_* tables had incorrect directory id.s

Basically you can fix it by running something like

delete from cwd_directory_attribute where directory_id <> 1;

delete from cwd_directory_operation where directory_id <> 1;

update cwd_group set directory_id=1;
update cwd_group_attributes set directory_id=1;

update cwd_user set directory_id=1;
update cwd_user_attributes set directory_id=1;
update cwd_membership set directory_id=1;

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-cloud

jira-administration