configure jira with mysql

[Karim Belhadj]

Hello team , i try to migrate jira from the base h2 to mysql , so 

after specifing the connection information which exist in the deconfig.xml , it work fine but  before making the import file.zip witch i did the backup from the base H2 oups this error appear , 

mysql 5.7

jira 7.13

connector 5.1

<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>h2</database-type>
<schema-name>PUBLIC</schema-name>
<jdbc-datasource>
<url>jdbc:h2:file:C:\Program Files\Atlassian\Application Data\JIRA/database/h2db</url>
<driver-class>org.h2.Driver</driver-class>
<username>sa</username>
<password></password>
<pool-min-size>20</pool-min-size>
<pool-max-size>20</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
<pool-max-idle>20</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
<pool-test-on-borrow>false</pool-test-on-borrow>
<pool-test-while-idle>true</pool-test-while-idle>
</jdbc-datasource>
</jira-database-config>

this is the log:

URL du référent: http://localhost:8080/secure/errors.jsp

java.lang.RuntimeException: java.nio.file.AccessDeniedException: C:\Program Files\Atlassian\Application Data\JIRA\import\startupdatabase.xml

Détails techniques

Numéro de référence du log : f25caf4f-b6b8-42b8-868b-1baf2c8515ba

Cause

URL du référent: http://localhost:8080/secure/SetupDatabase!default.jspa

com.google.template.soy.tofu.SoyTofuException: When evaluating "length($globalErrors)": While computing function "length($globalErrors)": Argument to length() function is not a SoyList (found type com.google.template.soy.data.restricted.UndefinedData).

com.google.template.soy.tofu.SoyTofuException: When evaluating "length($globalErrors)": While computing function "length($globalErrors)": Argument to length() function is not a SoyList (found type com.google.template.soy.data.restricted.UndefinedD

i need help 

regards

[Nic Brough -Adaptavist-]

My guess is that yo've run Jira as a different user before, and that has taken ownership of some of the files.  Check the ownership and access to all the files in the installation and data directories.

[Karim Belhadj]

Hi @Nic Brough -Adaptavist-  maybe this is the problem , but how can I fix it please ? 

this is the log 

2019-04-29 10:57:16,571 JiraImportTaskExecutionThread-1 ERROR anonymous 657x39x1 15g89vv 0:0:0:0:0:0:0:1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Error parsing export file: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.
org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at com.atlassian.security.xml.RestrictedXMLReader.parse(RestrictedXMLReader.java:103)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.parseXmlAndValidateBackupData(DefaultDataImportService.java:390)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:290)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.unsafeCall(DataImportAsyncCommand.java:82)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:64)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:30)
at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:157)
at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:133)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Regards 

[Nic Brough -Adaptavist-]

That's a new error, I assume you fixed the permissions one.

This is telling you that the file you have tried to import is not XML

[Karim Belhadj]

but sure its xml file @Nic Brough -Adaptavist-  how can i fix it ?

[Nic Brough -Adaptavist-]

I'm afraid the file you have is not valid xml.  "org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog." is saying the SAX library has identified the very first line in your "xml" file is not xml.  So you need to check that it really  does look like xml and if it's valid.  Once you can work out that it iis (or might be) valid xml, the other errors should tell you what is wrong in the xml