Is there an aws cloudformation jira template for mysql database?

Question

Customer Support · Answer

Hey @Daniel Eads @Andy Heinzer  Can someone from Atlassian suggest what to change in Atlassians Data Center template to make this work with MySQL, MS SQL and Oracle?

I had to guess that the changes and the stack won't build. Trial and error isn't really working.

While trying to certify a Data Center app, I tested on Postgres like the instructions say. But after passing all the tests, they want me to test on 3 more databases.

I need to know what to change in the yaml template so that it will work.

I changed the 'DBEngine', 'DBEngineVersion'. That wasn't enough apparently as the stack fails to build.

Lars Olav Velle · Answer

Hi!

I stumbled upon the same. Figured out that <schema> was written to the dbconfig.xml using ATL_JDBC*. Removing schema resolved the issue and jira was pupulated successfully.

Cheers,

Lars

Timothy Johnson_c7prms · Answer

Thanks for the response. I made changes to the driver and to ATL_JDBC_DRIVER and ATL_JDBC_URL section in the template, however i do not not get the jira url site to import the database nor the path to the dbconfig "/var/atlassian/application-data/jira" in the ec2. Unlike the orginal Jira postgresql cloudformation template for aws i do get a site url to import the our mysql datebase and also the path to the dbconfig "/var/atlassian/application-data/jira" in the ec2. Below are the changes i make to the template before creating the stack. "ATL_JDBC_DRIVER=com.mysql.cj.jdbc.Driver" ATL_JDBC_URL"jdbc:mysql://dbserver:3306/jiradb?useUnicode=true&characterEncoding=UTF8&sessionVariables=default_storage_engine=InnoDB" Thanks