Installation preparation

  • Install JDK1.8
  • Install Mysql5.7

Jira and Confluence download: pan.baidu.com/s/13b_Ei0wb… Extraction code: NFPK

Library building script and authorization

CREATE DATABASE jira DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
CREATE DATABASE confluence DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
GRANT ALL ON confluence.* TO 'confluence'@The '%' IDENTIFIED BY 'confluence';
GRANT ALL ON jira.* TO 'jira'@The '%' IDENTIFIED BY 'jira';
FLUSH PRIVILEGES;
Copy the code

1. Jira installation

1.1 Jira installation

  • The installation resource directory is displayed

[root@localhost ~]# cd /home/tools/confluence/

  • Grant executable permission to the installation package

[root@localhost confluence]# chmod +x *.bin

  • Execute the Jira file

[root @ localhost confluence was] #. / atlassian jira - software - 7.4.1 - x64. Bin

  • For details on installation steps, see the following figure:

  • Placing the MySQL database connection driver (optional)

This step is required only when the MySQL database is used, because the Jira installation package does not have the MySQL connection driver, and other databases have the MySQL connection driver. Skip this step if you are using a non-mysql database.

  • Stop the Jira service first

[root@localhost confluence]# service jira stop

  • Place the mysql driver JAR package in the Jira installation directory

[Root @ localhost confluence was] # cp mysql connector - Java - 5.1.39 - bin. The jar /home/application/server/atlassian/jira/atlassian-jira/WEB-INF/lib

1.2 Jira crack

  • Overwrite the Atlassian-extras-3.2. jar package to the jira/WEB-INF/lib/ directory

[root@localhost confluence]# cp atlassian-extras-3.2.jar jira/ web-INF /lib

  • Overlay atlassian-universal-plugin-manager-plugin-2.22.jar to jira/ web-INF /atlassian-bundled-plugins/

[root @ localhost confluence was] # cp atlassian - universal - the plugin - the manager - the plugin - 2.22. The jar /home/application/server/atlassian/jira/atlassian-jira/WEB-INF/atlassian-bundled-plugins/

  • Start the Jira service

[root@localhost confluence]# service jira start

  • Jira Settings select the second option

  • Jira configures database links

  • Set application properties

  • Generate a Jira trial license

  • After a few moments, this box will pop up

  • Go back to this page and click “Next”.

  • Setting an Administrator Account

  • Set the email

  • Set the language

  • Set head

  • Congratulations on completing the installation and you are ready to create a new project and start trying out JIRA

2. Confluence installation, crack

2.1 Confluence was installed

  • The installation resource directory is displayed

[root@localhost ~]# cd /home/tools/confluence/

  • Execute confluence file

[root @ localhost confluence was] #. / atlassian confluence was - 6.3.1 - x64. Bin

  • For details on installation steps, see the following figure:

  • Placing the MySQL database connection driver (optional)

Note This step is required only when using the MySQL database. The Confluence installation package does not provide the MySQL connection driver. Skip this step if you are using a non-mysql database.

  • Stop Confluence service first

[root@localhost confluence]# service confluence stop

  • Insert the mysql driver JAR packages into the confluence installation directory

[Root @ localhost confluence was] # cp mysql connector - Java - 5.0.8 - bin. The jar /home/application/server/atlassian/confluence/confluence/WEB-INF/lib/

  • Start Confluence service

[root@localhost confluence]# service confluence start

2.2 Confluence was cracking

A. the browser to access confluence was: http://192.168.1.100:8090/

B. Select “Product Installation” and click “Next”.

C. Do not select these two items and directly click “Next”.

D. Remember this [server ID]

E. Disable confluence service [root@localhost confluence]# service confluence stop

F. Atlassian-extras-decoder-v2-3.2. jar package to confluence installation directory [root@localhost confluence]# cp Atlassian – extras – decoder – v2-3.2. Jar/home/application/server/atlassian confluence was/confluence was/WEB – INF/lib/cp: Whether to cover “/ home/application/server/atlassian confluence was/confluence was/WEB – INF/lib/atlassian – extras – decoder – v2-3.2. The jar”? y

Atlassian-universal-plugin-manager-plugin-2.22.1. jar [root@localhost confluence]# CD / confluence was/confluence was/WEB – INF/atlassian – bundled – plugins backup source file [root @ localhost confluence was] # mv Atlassian-universal-plugin-manager-plugin-2.22.1. jar Atlassian-universal-plugin-manager-plugin-2.22.1.jar replace the file [root @ localhost confluence was] # cp atlassian – universal – the plugin – the manager – the plugin – 2.22. The jar /home/application/server/atlassian/confluence/confluence/WEB-INF/atlassian-bundled-plugins

H. start confluence service [root@localhost confluence]# service confluence start

I. Continue operations on the web page and click to obtain trial authorization

J. Select Confluence (Server) from this page. Then click Generate License.

K. Wait for a while in the new page, a box will pop up, click [Yes]. See below

L. Then it will jump back to the authorization code page and click “Next”.

M. Select the database Settings page

Select the Mysql TAB and click the External Database button.

N. Configure the database page.

Click the “JDBC” button and fill in the database user name and password

O. Select corresponding items as required. Here I select blank sites

P. Configure the user management page

Q. Configure the system administrator account

R. Congratulations, configuration complete!

Problem solving

SQL > alter database character set jira and confluence alter database character set a Alter DATABASE jIRA character set UTF8 COLLate UTF8_bin;

B. Generate statements that modify the collation rules of all tables

SELECT CONCAT('ALTER TABLE ',TABLE_SCHEMA,'. ', TABLE_NAME, ' COLLATE=utf8_bin; ') 'SQL'
FROM information_schema.TABLES
WHERE TABLE_COLLATION <> 'utf8_bin' and TABLE_SCHEMA ='jira'; ` ` `Copy the code

C. Generate statements that modify the collation rules for all string type fields

SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA,'. ',TABLE_NAME, ' MODIFY COLUMN ',COLUMN_NAME,' ',COLUMN_TYPE,' >CHARACTER SET utf8 COLLATE utf8_bin; ') 'SQL'
FROM information_schema.COLUMNS
WHERE DATA_TYPE='varchar' AND COLLATION_NAME <> 'utf8_bin' and TABLE_SCHEMA ='jira'; ` ` `Copy the code

Execute the statement generated in batches. The modification is complete. Restart the Jira service.