Tomcat is misconfigured

[Meir Georgi]

Hi,

I tried to configure Jira to work with https like the procedure but I am getting two errors.

(I add the pics  also I deleted some sentences for security reasons)

1.Setup: Tomcat is misconfigured

The server.xml file is missing parameters needed by Jira to handle requests that contain special characters.

I didnt understand where to add this sentence  - relaxedPathChars="[]|" relaxedQueryChars="[]|{}^\`"<>

Because I did it by adding to this line number 109

<Connector relaxedPathChars="[]|" relaxedQueryChars="[]|{}^&#x5c;&#x60;&quot;&lt;&gt; SSLEnabled="true" ..... 

 It didn't work. 

2  Database: Your database is using an unsupported collation 

Your mysql database is currently using an unsupported collation: latin1_swedish_ci. You should change this to a supported collation:

utf8_bin

Any idea how to solve it also?

Many Thanks,

Shai

[Edwin Kyalangalilwa]

Hi @Meir Georgi ,

These would be added within a Connector. e.g.

<Connector port="8080" relaxedPathChars="[]|" relaxedQueryChars="[]|{}^&#x5c;&#x60;&quot;&lt;&gt;" maxThreads="150" minSpareThreads="25" connectionTimeout="20000" enableLookups="false" maxHttpHeaderSize="8192" protocol="HTTP/1.1" useBodyEncodingForURI="true" redirectPort="8443" acceptCount="100" disableUploadTimeout="true" bindOnInit="false"/>

Collation is set when a database is created. An option would be to create a DB with the correct collation and migrate data.

Database Setup For MySQL