Содержание

Confluence

Настройки хранятся в /var/atlassian/application-data/confluence/confluence.cfg.xml

Nginx

Конфигурация для nginx:

confluence.conf

confluence.conf

server {
    listen 80;
    server_name confluence confluence.domain.com;

    return 302 https://$host$request_uri;
}
server {
    listen 443 ssl;
    server_name  confluence confluence.domain.com;

    location / {
        gzip off;
        client_max_body_size 100m;
        proxy_set_header X-Forwarded-Host $host;
        proxy_set_header X-Forwarded-Server $host;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; 
        proxy_pass http://172.17.0.1:8090;
        proxy_http_version 1.1;
    }
    ssl_session_timeout  5m;
    ssl_protocols	SSLv3 TLSv1 TLSv1.1 TLSv1.2;
    ssl_certificate	/etc/nginx/ssl/selfsigned.crt;
    ssl_certificate_key	/etc/nginx/ssl/selfsigned.key;
    ssl_dhparam /etc/nginx/ssl/dhparam.pem;
}

https://confluence.atlassian.com/doc/running-confluence-behind-nginx-with-ssl-858772080.html

Docker

Пример запуска 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://hub.docker.com/r/atlassian/confluence-server

Ссылки

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 с кириллицей

Ошибки

Detected tables with non-default character encoding/collation

Проверяем кодировку базы:

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

после можно проверить кодировку базы.

http://onorua.livejournal.com/28443.html

Tomcat config is incorrect

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

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

Backup / Restore

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 ConfigurationScheduled Jobs (Основные настройки → Запланированные задания)

https://confluence.atlassian.com/display/DOC/Scheduled+Jobs