Cant login to restored Jira

Question

Hello,

our Jira was hosted by another provider as a cloud service, 
but they stopped hosting Jira so we stopped using it but we still want to access the 
jira backup they gave us (jira_export.tar).

i did a fresh jira 8.20.10 install on our windows server and installed postgresql 12.18, because the export was created with pg_dump 12.18.
I only was able to restore the database with the pg_dump sql file within the .tar and the psql command. 
Everytime i use pg_restore for restoring the .tar it says toc.dat doesnt exist. 
Looking manually in the .tar i cant find such file neither.

During the jira installation i chose auto setup and created a new empty db, that i restored later with the backup as mentioned above. i created a new admin account during that setup, but after editing the dbconfig.xml with the restored db i get the error in jira, 
that i am not authorized to login. I gave all permissions to this newly created account via a command to access the database already too.

When i try logging in as recovery_admin i got a technical error in jira saying: 
reference number of the protocol: aa813a2b-6ccd-44c4-9a5c-2957f91966f8

i edited the setenv.bat file and added this line:
set JVM_SUPPORT_RECOMMENDED_ARGS="-Datlassian.recovery.password=password"

When we used jira in the past through the external hosting provider, all users were authorized by our LDAP to login, and of course i cant login as these users anymore now neither.

Any idea how to login now or whatelse to try?

Thanks for any help!

Nic Brough -Adaptavist- · Accepted Answer

Welcome to the Atlassian Community!

A postgres database dump does not contain .dat files, so whatever file you have, it has not been created with pg_dump and it's not a backup or copy of a postgres database.  Even if it were a proper backup, it would not contain a table called "toc" - Jira does not have such a table in its database.

On the logins, you would need to set up your new server to connect to your LDAP to use it as a user account provider, but to do that, you'll need admin access.  The recovery password thing you have tried is the right way to do it, but you have not told us whether you have gone through the other things you need to do in order to get admin.  What parts of https://confluence.atlassian.com/jirakb/restore-passwords-to-recover-admin-user-rights-972329273.html have you skipped?