Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

Setup failed with a backup database

Dear all,

I have a Data Center instance hosted in Azure on which I have a backup SQL server database.

Then I install a fresh local copy of Jira DataCenter 8.15 on my local machine using the Windows installer.

During installation it ask me to ceate a new SQl Server database ( I named it Test-Db). good all goes fine until the end. Then I stop my instance

Then I restore my previous backup on my local SQL server into an other database named jira-db.
Then I open the dbconfig.xml file and change the DB name to be jira-db
Server ID are different in that backup Db.

Then I restart my Jia instance, and follow instaruction as creating new trial licence as Server ID is different.
Then installer next step prompt me to define an Admin account ( even if I have already admin account in my Jira-Db)
Then at the time of saving, it says that it cannot add user because directory is in read only.

"No error in log file, and I log in to SQL server db with same user as in initial stage

In fact when the instance started, it does not take in account, information stored in different config files, it start to ask again hostname even if it has it and all other remaining.

Any idea why I get that error ?

regards

ekYGli4qXp.pngmsedge_eQE65ncsoz.png

2 answers

0 votes

Hi,

It sounds like you are trying to provision a Jira instance with an existing DB. Please see the doc below on utilising an exiting DB for a Jira deployment:

Running Jira on an Azure cluster

 

particularly this section:

Running Jira on an Azure cluster _ Atlassian Support _ Atlassian Documentation 2021-03-09 09-14-09.png

 

As described in the document, for existing DB's you need to use the Azure CLI.

hello @Dylan Rathbone ,

What I simply trying to do is to installl a test jira instance locally to my own PC.

For that I have a install a DataCenter version of Jira single node( equal to server) as we cannot have anymore server trial version

Then I have a local SQL server where I have an existing DB backup I need jira to point to.

So even if I provide the proper path to the db, Jira setup still asking me for Admin user to be added and get read only message I mentioned above

Just for your information, I have made the same test with my existing azure db backup which contains data. :

I simply open configdb.xml of my local jira and point it to new db

Even that it is still asking to provide an admin account to be created and cannot create it due to read only error mention

*Once again, I simply would like to run a single local Jira server instance connected to my existing prod db backup, is that simple thing not possible ?*

regards

Hi @serge calderara

The "read only" error may suggest that the permissions assigned to your local Jira home and Jira install directories are not correct. As a result these cannot be read by the Jira user on start which may explain your problem. Please see this knowledge based article on how to fix directory permissions for Jira. Another thing to confirm is if your Jira home directory is correctly configured

 

Regards.

Hi @Dylan Rathbone ,

For installing Jira DataCenter I have used the Windows Installer and I am administrator of my Laptop.

I have used default setting for installing Jira and jira home folder is properly create under :

C:\Users\<myuser profile>\Atlassian

I have even run from windows command prompt and start config.bat in order to verify 

So I do not know what I can do more.

Please not that my error message is not related to "Cannot create Jira home directory" 

Hi @serge calderara

I'm going to raise this with our official product support team to assist in root causing the issue you're having.

We should have more information for you shortly.

Appreciate your patience on this.

Regards.

0 votes

Hi @serge calderara 


If Active Directories, under User Management > User Directories, had been configured on the Azure instance from which the DB backup was made, then you may be hitting an issue as described in this article. The article includes an explanation and workaround.

Can you also confirm whether or not you have a support contract with Atlassian? This allows us to appropriately field your issue going forward.

Regards.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Data Center

Architect your Atlassian Data Center Application (Jira, Confluence, Bitbucket) in Azure

Hello folks! To the member of organizations who are still running their Atlassian applications on the server, we are on the side of the bridge, and if we need to sail the boat with confidence either...

180 views 0 8
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