Jira SW Unattended DB Installation?

Question

I'm installing several instances of Jira SW 7.10 and would like to automate it fully.

Is there anyway to perform the database, license and first user etc configuration unattended? I've managed to install the application with the response.varfile-file but I still have to use the GUI to license settings etc and for the DB to become populated.

I'm running MS SQL Server as database server.

Mauricio Karas · Answer

Jira should recognize the dbconfig.xml on the first time you start up, it will try to connect to the database and if not possible the startup will fail. The dbconfig file should be inside your Jira home directory, which you can also manually set by editing the jira-application.properties file(inside <jira_installation>/atlassian-jira/WEB-INF/classes/) and set the value of the 'jira.home' property to the desired location.

If you are copying the dbconfig.xml from another running instance, keep in mind to change the information to not have two instances running on the same database.

About creating the admin user, I believe that's possible, we have a KB about retrieving the Admin user for cases where the password is lost, and I think you can use the queries mentioned on it.

Check the instructions under "If no users or groups exist in JIRA":

* Retrieving the JIRA Administrator

I understand you're doing this on freshly installed instances, but anyway, we recommend making backups before running queries on the database and also you should know that Atlassian advises against making changes directly to the database as they might cause other problems.

Kind regards,
Maurício Karas

Oskar_kuzaup · Answer

Thanks for your reply Mauricio,

I will look at setting the license through SQL query.

Also in the "first run web gui" a admin user is created, maybe this too can be done with SQL query?

However the issue with the dbconfig.xml approach is that I believe that the file does not exist until you have run through the first run web gui.

I think I tried creating this file manually (or copying from a running instance) and restarting the service, but I don't think this triggers the population of the database. I'm not sure what is programmatically causing the DB to be populated after running through the first run web gui, but if I knew this maybe it could be possible to trigger the DB population based on a custom/"manually" created dbconfig.xml file?

Kind Regards,

Nickey

Mauricio Karas · Answer

Hey, Nickey.

As far as database configurations go on Jira, you can manually set the DB with the "dbconfig.xml" inside your Jira home directory. I believe you could automate this in some sort of way.

Regarding setting up the license, other then the GUI, you can do it through the database. You can check this other Community question which has some SQL queries you can use to set the license.

Kind regards,
Maurício Karas