Настройки хранятся в /var/atlassian/application-data/confluence/confluence.cfg.xml
Конфигурация для nginx:
https://confluence.atlassian.com/doc/running-confluence-behind-nginx-with-ssl-858772080.html
Пример запуска Confluence с mysql-connector-java для подключения к MySQL (с пропатченными atlassian-universal-plugin-manager-plugin-3.0.1.jar и atlassian-extras-decoder-v2-3.4.1.jar):
docker run -v /data/docker/confluence/mysql-connector-java-5.1.47-bin.jar:/opt/atlassian/confluence/lib/mysql-connector-java-5.1.39-bin.jar -v /data/docker/confluence/atlassian-universal-plugin-manager-plugin-3.0.1.jar:/opt/atlassian/confluence/confluence/WEB-INF/atlassian-bundled-plugins/atlassian-universal-plugin-manager-plugin-3.0.1.jar -v /data/docker/confluence/atlassian-extras-decoder-v2-3.4.1.jar:/opt/atlassian/confluence/confluence/WEB-INF/lib/atlassian-extras-decoder-v2-3.4.1.jar -v /data/docker/confluence/var/atlassian/application-data/confluence:/var/atlassian/application-data/confluence -e CATALINA_CONNECTOR_PROXYNAME=confluence.domain.com -e CATALINA_CONNECTOR_PROXYPORT=80 -e JVM_MAXIMUM_MEMORY=2048m --name="confluence" -d -p 8090:8090 atlassian/confluence-server:6.15.2
https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html - Настройка базы данных для MySQL
https://confluence.atlassian.com/confkb/how-to-use-nginx-to-proxy-requests-for-confluence-313459790.html - Настройка Nginx
https://confluence.atlassian.com/doc/create-a-pdf-in-another-language-175473.html - Экспорт в PDF с кириллицей
Проверяем кодировку базы:
mysql -e "SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = 'confluencedb';" confluencedb -u root -p
Пример:
+----------------------------+------------------------+ | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | +----------------------------+------------------------+ | utf8 | utf8_bin | +----------------------------+------------------------+
Проверяем кодировку таблиц:
mysql -e "SELECT t.TABLE_NAME, c.character_set_name, c.collation_name FROM information_schema.TABLES t, information_schema.COLLATION_CHARACTER_SET_APPLICABILITY c WHERE c.collation_name = t.table_collation AND t.table_schema = 'confluencedb';" confluencedb -u root -p
Пример:
+--------------------------------+--------------------+-----------------+ | table_name | character_set_name | collation_name | +--------------------------------+--------------------+-----------------+ | AO_187CCC_SIDEBAR_LINK | utf8 | utf8_general_ci | | AO_21D670_WHITELIST_RULES | utf8 | utf8_general_ci | | AO_38321B_CUSTOM_CONTENT_LINK | utf8 | utf8_general_ci | ....
Исправление:
Меняем кодировку базы:
mysql -e "ALTER DATABASE confluencedb CHARACTER SET utf8 COLLATE utf8_general_ci;" confluencedb -u root -p
после можно проверить кодировку базы.
scheme should be 'https' proxyName should be 'confluence.domain.com' proxyPort should be '443'
Для docker добавить переменные:
-e CATALINA_CONNECTOR_SCHEME=https -e CATALINA_CONNECTOR_PROXYNAME=confluence.domain.com -e CATALINA_CONNECTOR_PROXYPORT=443
tar czf confluencedata.tgz /var/atlassian/application-data/confluence/attachments /var/atlassian/application-data/confluence/confluence.cfg.xml
mysqldump confluencedb -u`grep username /var/atlassian/application-data/confluence/confluence.cfg.xml | awk -F'>|<' '{print $3}'` -p`grep password /var/atlassian/application-data/confluence/confluence.cfg.xml | awk -F'>|<' '{print $3}'` | gzip -c> confluencedb.sql.gz
Восстановление:
tar xzf confluencedata.tgz -C / gunzip <confluencedb.sql.gz| mysql -u`grep username /var/atlassian/application-data/confluence/confluence.cfg.xml | awk -F'>|<' '{print $3}'` -p`grep password /var/atlassian/application-data/confluence/confluence.cfg.xml | awk -F'>|<' '{print $3}'` confluencedb
Бэкапы хранится в /var/atlassian/application-data/confluence/backups (автоматически не удаляются!)
Отключить задание можно в: General Configuration → Scheduled Jobs (Основные настройки → Запланированные задания)