部署servicedesk服务台

【下载地址】

 

【环境部署】

安装MySQL 5.7版本，可参考 Yum安装MySQL 5.7版本 - 北纬99度9 - 博客园 (cnblogs.com)

创建数据库

CREATE DATABASE jiradb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
grant all on servicedesk.* to 'servicedesk'@'localhost' identified by 'password';

 

 

# vim my.cnf   增加蓝色字体部分

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
default-storage-engine=INNODB
character_set_server=utf8mb4
innodb_default_row_format=DYNAMIC
innodb_large_prefix=ON
innodb_file_format=Barracuda
innodb_log_file_size=2G
skip_ssl

　　

【常见问题1】

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet successfully received from the server was 0 milliseconds ago.  The last packet sent successfully to the server was 0 milliseconds ago.
Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)

这个问题是由于MySQL 5.7版本默认要使用SSL协议，可通过如下方式处理：

• Set the connection to use TLSv1.2. Edit my.cnf file including the following:

[mysqld]
tls_version=TLSv1.2

　　Edit JDBC connection URL, using enabledTLSProtocols property, like below:

jdbc:mysql://localhost:3306/servicedesk?enabledTLSProtocols=TLSv1.2

• Or disable the secure SSL on the database connection:

      Edit my.cnf file including the following:

[mysqld]
skip_ssl

　　Edit JDBC connection URL, using useSSL=false property

jdbc:mysql://localhost:3306/servicedesk?useSSL=false

 

【常见问题2】

2024-01-01 14:30:30,224+0800 JIRA-Bootstrap INFO      [c.a.jira.startup.JiraStartupLogger] Running Jira startup checks.
2024-01-01 14:30:30,225 JIRA-Bootstrap ERROR RollingFileManager (/home/application-data/log/atlassian-jira.log) java.io.FileNotFoundException: /home/application-data/log/atlassian-jira.log (Permission denied)

# chown -R jira:jira /home/application-data/log　

　　

【参考链接】

https://confluence.atlassian.com/adminjiraserver0901/connecting-jira-applications-to-mysql-5-7-1155490939.html

https://confluence.atlassian.com/jirakb/run-jira-as-a-systemd-service-on-linux-979411854.html