Automate jira install with ansible with database schema creation

[Stéphane PINARD]

Translator

I need to install a Jira instance via Ansible, but I cannot fully automate the process because, to create the tables in the database, I apparently need to use the Jira configuration assistant. Is there a way to create the entire Jira database schema with Ansible?

[Philipp Sendek]

Hi @Stéphane PINARD ,

I personally haven't done it and am not working with configuration management systems. But the most straightforward point would be to deploy Jira once, run the installation wizard and then backup the resulting database schema and use that as template.
Besides the schema itself it will only have very few data in it and you could work with variables to adjust that (such as the site name, the site URL and other global configurations).

But the safest way would be to use an established Ansible template where you can be sure that it's tested properly.

Greetings
Philipp

[Matt Doar _Adaptavist_]

You should be able to use Ansible to create the database and then let Jira create the tables when it is started for the first time