confluence安装问题

confluence MySQL配置

#confluence
character-set-server=utf8mb4
collation-server=utf8mb4_bin
default-storage-engine=INNODB
max_allowed_packet=256M
transaction-isolation=READ-COMMITTED
binlog_format=row
log_bin_trust_function_creators = 1

创建数据库授权：

CREATE DATABASE confluence CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

create user 'confluenceuser'@'localhost' IDENTIFIED BY 'xxx';

grant all privileges on confluence.* TO 'confluenceuser'@'localhost' with grant option;

mysql配置报错：

You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

修改mysql参数：

[mysqld]
log_bin_trust_function_creators = 1

中文乱码

文档使用宏编辑并发布后，不能够正常显示中文格式。

#1.创建中文字体目录
mkdir /usr/share/fonts/chinese
#2上传本地windows的黑体字体 simhei.ttf 文件至/usr/share/fonts/chinese目录下即可
#3.修改目录的极跟
chmod -R 755 /usr/share/fonts/chinese
#4.修改/bin/setenv.sh:增加以下语甸
CATALINA OPTS="-Dfile.encoding=UTF-8 ${CATALINA_OPTS}"