{{tag>atlassian confluence troubleshooting}}

====== Confluence troubleshooting ======
===== Database "Incorrect isolation level" =====
{{ :wiki:incorrect_isolation_level.png?200|}}
To resolve "Incorrect isolation level" when trying to test connection to database upon installing add this:

  [mysqld]
  ...
  transaction-isolation=READ-COMMITTED
  ...

to

///etc/mysql/mysql.conf.d/mysqld.cnf
//

  systemctl restart mysql.service

===== Avatar picture =====

If you can't upload avatar picture try a different browser (e.g. Chrome). Possible something to do with the cache
Tomcat config reported as incorrect
{{ :wiki:tomcat_config_incorrect.png?200|}}

https://confluence.atlassian.com/confkb/can-t-check-base-url-warning-in-confluence-6-6-or-later-939718433.html

change in ///opt/atlassian/jira/conf/server.xml// file listen port to 8091 and not to 8090 e.g.

<code>
<Connector port="8091" connectionTimeout="20000" redirectPort="8443"
                   maxThreads="48" minSpareThreads="10"
                   enableLookups="false" acceptCount="10" debug="0" URIEncoding="UTF-8"
                   protocol="org.apache.coyote.http11.Http11NioProtocol"
                   scheme="https" proxyName="confluence.example.com" proxyPort="443" />
</code>

===== čćšđćž characters =====

If čćšđćž characters show as "?", add this line below other CATALINA_OPTS lines in ///opt/atlassian/confluence/bin/setenv.sh//

  CATALINA_OPTS="-Dfile.encoding=utf-8"

===== Creating pages =====

If Creating pages takes to long (error "This page is taking longer to load than usual ..."), disable collaborative editing Confluence administration > General Configuration > Under 'Administration' > Collaborative Editing
References


====== References ======
      * https://confluence.atlassian.com/jirakb/characters-not-supported-by-ascii-are-being-displayed-as-question-marks-120521793.html
  *     https://confluence.atlassian.com/confkb/confluence-fails-to-start-and-throws-mysql-session-isolation-level-repeatable-read-is-no-longer-supported-error-241568536.html
  *     https://community.atlassian.com/t5/Confluence-questions/Getting-error-quot-Unable-to-communicate-with-server-Saving-is/qaq-p/27058