Details
-
Suggestion
-
Resolution: Fixed
Description
In the documentations regarding setting up JIRA on Tomcat on the following pages:
- for Tomcat 5.5 at http://www.atlassian.com/software/jira/docs/latest/servers/tomcat55.html
- for 6.x at http://www.atlassian.com/software/jira/docs/latest/servers/tomcat60.html
We give example of connecting JIRA to a MySQL database.
<Context path="/jira" docBase="path/to/atlassian-jira-3.12.2.war"> <Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource" username="jirauser" password="mypassword" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/jiradb?autoReconnect=true"/> <Resource name="UserTransaction" auth="Container" type="javax.transaction.UserTransaction" factory="org.objectweb.jotm.UserTransactionFactory" jotm.timeout="60"/> <Manager pathname=""/> </Context>
the URL parameter should be constructed
url="jdbc:mysql://localhost/jiradb?autoReconnect=true&useUnicode=true&characterEncoding=UTF8"
There is a significant number of the cases in SAC where customers have problems with encoding if the character encoding is not specified in the URL. Additionally, it would keep our documentation consistent across all pages referring to Mysql; e.g. http://www.atlassian.com/software/jira/docs/latest/databases/mysql.html
Basically, people don't intend to navigate to the MySQL configuration page since we provide the example on the Tomcat integration pages.