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?
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.
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;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There could be one or several factors causing the problem so I would suggest creating a Support request for Jira and see if the Jira Support team can assist you better.
You can do that at support.atlassian.com
Cheers!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.