centos7 搭建jira,confluence遇到的坑(无法连接mysql)

centos7 搭建jira,confluence遇到的坑(无法连接mysql)

2018年05月15日 16:14:01 wq3028 阅读数 3451

版权声明：本文为博主原创文章，未经博主允许不得转载。 https://blog.csdn.net/wq3028/article/details/80324505

这两周也是在服务器上面搭了好多的东西，我是个做BSP的，感觉这两周变成了运维了快，不过也挺有意思的
说下centos7下安装jira和confluence遇到的坑

1 如何拿到url安装

自己在服务器上搭建jira，但是从jira的官网上
https://www.atlassian.com/software/jira/download 这个地址下来的url是空的，下不下来
然后找到了中国的jira代理公司安迈，网址如下
http://www.unlimax.com/
然后找到下载试用，然后下载下来，可以下载，发现在centos上跑步起来，python报错，估计也是个坑
然后直接google 终于找到了url

wget http://downloads.atlassian.com/software/confluence/downloads/atlassian-confluence-6.8.1-x64.bin
wget http://downloads.atlassian.com/software/jira/downloads/atlassian-jira-software-7.9.0-x64.bin 
md5sum atlassian-*
04a95ebd8072785d41d41963ca32f559  atlassian-confluence-6.8.1-x64.bin
fab671df881062f057474c2ad5e8a139  atlassian-jira-software-7.9.0-x64.bin

• 1
• 2
• 3
• 4
• 5

好了终于拿到url了，然后就可以安装了

2 安装

直接加上可执行权限然后直接执行就可以

chmod +x atlassian*
./atlassian-jira-software-7.9.0-x64.bin
[root@localhost ~]# ./atlassian-jira-software-7.9.0-x64.bin 
Unpacking JRE ...
Starting Installer ...
May 15, 2018 3:03:17 PM java.util.prefs.FileSystemPreferences$1 run
INFO: Created user preferences directory.

This will install JIRA Software 7.9.0 on your computer.
OK [o, Enter], Cancel [c]
o
Choose the appropriate installation or upgrade option.
Please choose one of the following:
选择安装模式，1默认安装2高级安装3更新
Express Install (use default settings) [1], Custom Install (recommended for advanced users) [2, Enter], Upgrade an existing JIRA installation [3]
1
Details on where JIRA Software will be installed and the settings that will be used.
Installation Directory: /opt/atlassian/jira  安装目录
Home Directory: /var/atlassian/application-data/jira 数据目录
HTTP Port: 8080 web页面的端口，如果端口有冲突，可以输入e修改这几个都可以改
RMI Port: 8005 
Install as service: Yes 
Install [i, Enter], Exit [e]
i

Extracting files ...


Please wait a few moments while JIRA Software is configured.
Installation of JIRA Software 7.9.0 is complete
Start JIRA Software 7.9.0 now?
Yes [y, Enter], No [n]
y

Please wait a few moments while JIRA Software starts up.
Launching JIRA Software ...
Installation of JIRA Software 7.9.0 is complete
Your installation of JIRA Software 7.9.0 is now ready and can be accessed
via your browser.
JIRA Software 7.9.0 can be accessed at http://localhost:8080
Finishing installation ...
[root@localhost ~]# 

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42

安装Confluence同上

[root@localhost ~]# ./atlassian-confluence-6.8.1-x64.bin 
Unpacking JRE ...
Starting Installer ...

This will install Confluence 6.8.1 on your computer.
OK [o, Enter], Cancel [c]
o
Choose the appropriate installation or upgrade option.
Please choose one of the following:
Express Install (uses default settings) [1], 
Custom Install (recommended for advanced users) [2, Enter], 
Upgrade an existing Confluence installation [3]
1
See where Confluence will be installed and the settings that will be used.
Installation Directory: /opt/atlassian/confluence 
Home Directory: /var/atlassian/application-data/confluence 
HTTP Port: 8090 
RMI Port: 8000 
Install as service: Yes 
Install [i, Enter], Exit [e]
i

Extracting files ...


Please wait a few moments while we configure Confluence.
Installation of Confluence 6.8.1 is complete
Start Confluence now?
Yes [y, Enter], No [n]
y

Please wait a few moments while Confluence starts up.
Launching Confluence ...
Installation of Confluence 6.8.1 is complete
Your installation of Confluence 6.8.1 is now ready and can be accessed via
your browser.
Confluence 6.8.1 can be accessed at http://localhost:8090
Finishing installation ...

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38

3 配置mysql

修改mysql的配置文件，添加如下内容

[mysqld]
character-set-server=utf8
collation-server=utf8_bin
default-storage-engine=INNODB
max_allowed_packet=512M
innodb_log_file_size=1024M
transaction-isolation = READ-COMMITTED

• 1
• 2
• 3
• 4
• 5
• 6
• 7

Note：需要Restart MySQL上述参数才能生效

创建Jira数据库及用户
mysql>CREATE DATABASE jiradb CHARACTER SET utf8 COLLATE utf8_bin;
mysql>GRANT ALL PRIVILEGES ON jiradb.* TO 'jirauser'@'192.168.11.246'  IDENTIFIED BY 'Qazxsw3';

Note：上述Grant授权命令中的ip地址是JIRA Server的ip。
Confluence 同理
mysql>CREATE DATABASE Confluencedb CHARACTER SET utf8 COLLATE utf8_bin;
mysql>GRANT ALL PRIVILEGES ON Confluencedb.* TO 'Confluenceuser'@'192.168.11.246'  IDENTIFIED BY 'Qazxsw3';

mysql>FLUSH PRIVILEGES;
mysql>QUIT

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11

4 MySQL JDBC Driver

这里选择mysql，但是提示需要mysql的驱动程序，这里少了一个叫mysql_connector的jar
cp mysql-connector*-bin.jar /opt/atlassian/jira/lib

开始我下载的最新的mysql-connector-java-8.0.11.jar，但是死活链接不上，后来发邮件问了售后发现太新了，链接mysql会有问题
这里改用版本mysql-connector-java-5.1.35-bin.jar
cp mysql-connector-java-5.1.35-bin.jar /opt/atlassian/jira/lib 然后就可以了正常链接数据库了

5 修改jira使用内存

根据服务器物理内存情况，适当调整JIRA的JVM内存参数：
vi /opt/atlassian/jira/bin/setenv.sh

例如：
JVM_MINIMUM_MEMORY=”2048m”
JVM_MAXIMUM_MEMORY=”2048m”
服务器是128G内存的，我直接加到20G内存了，默认的好像只有1G不到内存，网页会很卡

6 安装成功

安装成功~