wiki办公软件confluence本地mac环境安装(其他环境方法一致)-详细安装过程与破解方式以及问题排除_atlassian-extras-3.4.6.jar

说明

• 包含如何下载confluence；
• 如何正确的安装confluence；
• 如何破解confluence；
• 如何完全的做完所有步骤，以及排完所有的坑；

安装过程

环境

• Mac OS Big Sur

1. 官网下载Confluence

1. 官网

   https://www.atlassian.com/software/confluence/download-archives

2. 在下面View all versions随意选择自己需要的版本进行下载

   • linux等环境用户直接wget url即可；

   

   • 下载过程中打开安装指南，准备安装；

2. Mac环境安装Confluence

1. 打开官网：所有内容官网一页就可以解决

   https://confluence.atlassian.com/doc/installing-confluence-on-linux-from-archive-file-255362363.html

2. 为下载的confluence创建目录并解压以及赋予权限

   

3. 为confluence安装创建一个数据目录，赋予权限并且在配置文件中修改数据目录（后期恢复数据等工作都从这里）

4. 准备启动，检查一下端口

  - 我的配置，服务端口不变，连接端口改为35001
1

5. 启动confluence（此处根据当前用户的权限来，我没有切用户，直接启动就行），注意看【问题注意：q1：Confluence启动失败】

   • 启动：./bin/start-confluence.sh
   • 停止：./bin/stop-confluence.sh

   

3. 破解Confluence

1. 下载破解软件做准备

   链接: https://pan.baidu.com/s/1wrqMTuNuEC8Xfc1EFk7QOw 密码: 0qlt

2. 打开confluence web界面进行操作（这边就不重新截图了，操作都比较简单，我装过5.x~7.x的版本都是一样的）

   http://localhost:35001/

3. 选择语言中文

4. 选择产品安装→下一步

5. 两个插件全部勾选→下一步

6. 授权码页面进行破解

   【问题注意：q2：破解Confluence】破解过程

7. 此时如果本地环境或者其他pre环境有MySQL那么不用管直接下一步，如果没有可以先装MySQL，可以看【问题注意：q3：Mac环境MySQL安装】

8. 将mysql jdbc的驱动包放入lib下；【各版本已经在问题注意中提到了】

   • 【问题注意：q4：下载mysql-connector-java】
   • 放入：/confluence/atlassian-confluence-6.5.0/confluence/WEB-INF/lib

9. 提前注意一下【问题注意：q5：Confluence中文乱码，以及q6】

10. 此时关闭confluence再启动

    • 停止：./bin/stop-confluence.sh
    • 启动：./bin/start-confluence.sh

11. 然后进行连接MySQL进行初始化，安装破解完毕；

问题注意

q1：Confluence启动失败

• 当前环境变量一定要有JDK；

q2：破解Confluence

1. 运行下载好的破解工具（直接双击打开）

   

2. 准备要破解的jar

   • 从刚才安装confluence的部分拷贝出jar包

     /confluence/atlassian-confluence-6.5.0/confluence/WEB-INF/lib
     
     atlassian-extras-decoder-v2-3.2.jar
     1
     2
     3

   • 将jar包换名

     mv ./atlassian-extras-decoder-v2-3.2.jar ./atlassian-extras.jar
     1

   

3. 进行破解

   • 从上往下依次：第一处随便填
   • 第二处填confluence页面的服务器ID
   • 第三处选择导入的jar（atlassian-extras.jar）

   

   • 最后点击.gen!获取破解码【！！！此时别急着操作】

   • 将刚才的jar包更名回去并覆盖到之前的目录

     mv ./atlassian-extras.jar ./atlassian-extras-decoder-v2-3.2.jar
     
     放回此目录
     /confluence/atlassian-confluence-6.5.0/confluence/WEB-INF/lib
     1
     2
     3
     4

q3：Mac环境MySQL安装

• 直接到MySQL官网，下载，社区下载，选择自己的版本进行下载；连接与版本之间一定要注意，不然会不适配报错；

  https://dev.mysql.com/downloads/mysql/

  我这里的版本是：5.7.31

q4：下载mysql-connector-java

• 直接官网，下载，mysqlj，选择自己的版本下载

  https://dev.mysql.com/downloads/connector/j/

  我这里的版本是：5.1.49

q5：Confluence中文乱码

1. mac用户在/etc下创建my.cnf

2. 拷贝此段代码进去即可

   # Example MySQL config file for medium systems.  
     #  
     # This is for a system with little memory (32M - 64M) where MySQL plays  
     # an important part, or systems up to 128M where MySQL is used together with  
     # other programs (such as a web server)  
     #  
     # MySQL programs look for option files in a set of  
     # locations which depend on the deployment platform.  
     # You can copy this option file to one of those  
     # locations. For information about these locations, see:  
     # http://dev.mysql.com/doc/mysql/en/option-files.html  
     #  
     # In this file, you can use all long options that a program supports.  
     # If you want to know which options a program supports, run the program  
     # with the "--help" option.  
     # The following options will be passed to all MySQL clients  
     [client]
     default-character-set=utf8
     #password   = your_password  
     port        = 3306  
     socket      = /tmp/mysql.sock   
     # Here follows entries for some specific programs  
     # The MySQL server  
     [mysqld]
     character-set-server=utf8
     collation-server=utf8_bin
     init_connect='SET NAMES utf8
     port        = 3306  
     socket      = /tmp/mysql.sock  
     skip-external-locking  
     key_buffer_size = 16M  
     max_allowed_packet = 1M  
     table_open_cache = 64  
     sort_buffer_size = 512K  
     net_buffer_length = 8K  
     read_buffer_size = 256K  
     read_rnd_buffer_size = 512K  
     myisam_sort_buffer_size = 8M  
     character-set-server=utf8  
     init_connect='SET NAMES utf8' 
   # Don't listen on a TCP/IP port at all. This can be a security enhancement,  
   # if all processes that need to connect to mysqld run on the same host.  
   # All interaction with mysqld must be made via Unix sockets or named pipes.  
   # Note that using this option without enabling named pipes on Windows  
   # (via the "enable-named-pipe" option) will render mysqld useless!  
   #   
   #skip-networking  
    
     # Replication Master Server (default)  
     # binary logging is required for replication  
     log-bin=mysql-bin  
    
       # binary logging format - mixed recommended  
       binlog_format=mixed  
    
         # required unique id between 1 and 2^32 - 1  
         # defaults to 1 if master-host is not set  
         # but will not function as a master if omitted  
         server-id   = 1  
    
       # Replication Slave (comment out master section to use this)  
       #  
       # To configure this host as a replication slave, you can choose between  
       # two methods :  
       #  
       # 1) Use the CHANGE MASTER TO command (fully described in our manual) -  
       #    the syntax is:  
       #  
       #    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,  
       #    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;  
       #  
       #    where you replace <host>, <user>, <password> by quoted strings and  
       #    <port> by the master's port number (3306 by default).  
       #  
       #    Example:  
       #  
       #    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,  
       #    MASTER_USER='joe', MASTER_PASSWORD='secret';  
       #  
       # OR  
       #  
       # 2) Set the variables below. However, in case you choose this method, then  
       #    start replication for the first time (even unsuccessfully, for example  
       #    if you mistyped the password in master-password and the slave fails to  
       #    connect), the slave will create a master.info file, and any later  
       #    change in this file to the variables' values below will be ignored and  
       #    overridden by the content of the master.info file, unless you shutdown  
       #    the slave server, delete master.info and restart the slaver server.  
       #    For that reason, you may want to leave the lines below untouched  
       #    (commented) and instead use CHANGE MASTER TO (see above)  
       #  
       # required unique id between 2 and 2^32 - 1  
       # (and different from the master)  
       # defaults to 2 if master-host is set  
       # but will not function as a slave if omitted  
       #server-id       = 2  
       #  
       # The replication master for this slave - required  
       #master-host     =   <hostname>  
       #  
       # The username the slave will use for authentication when connecting  
       # to the master - required  
       #master-user     =   <username>  
       #  
       # The password the slave will authenticate with when connecting to  
       # the master - required  
       #master-password =   <password>  
       #  
       # The port the master is listening on.  
       # optional - defaults to 3306  
       #master-port     =  <port>  
       #  
       # binary logging - not required for slaves, but recommended  
       #log-bin=mysql-bin  
    
         # Uncomment the following if you are using InnoDB tables  
         #innodb_data_home_dir = /usr/local/mysql/data  
         #innodb_data_file_path = ibdata1:10M:autoextend  
         #innodb_log_group_home_dir = /usr/local/mysql/data  
         # You can set .._buffer_pool_size up to 50 - 80 %  
         # of RAM but beware of setting memory usage too high  
         #innodb_buffer_pool_size = 16M  
         #innodb_additional_mem_pool_size = 2M  
         # Set .._log_file_size to 25 % of buffer pool size  
         #innodb_log_file_size = 5M  
         #innodb_log_buffer_size = 8M  
         #innodb_flush_log_at_trx_commit = 1  
         #innodb_lock_wait_timeout = 50  
    
           [mysqldump]  
           quick  
           max_allowed_packet = 16M  
    
             [mysql]  
             no-auto-rehash  
             # Remove the next comment character if you are not familiar with SQL  
             #safe-updates  
             default-character-set=utf8   
    
           [myisamchk]  
           key_buffer_size = 20M  
           sort_buffer_size = 20M  
           read_buffer = 2M  
           write_buffer = 2M  
    
             [mysqlhotcopy]  
             interactive-timeout
   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
   43
   44
   45
   46
   47
   48
   49
   50
   51
   52
   53
   54
   55
   56
   57
   58
   59
   60
   61
   62
   63
   64
   65
   66
   67
   68
   69
   70
   71
   72
   73
   74
   75
   76
   77
   78
   79
   80
   81
   82
   83
   84
   85
   86
   87
   88
   89
   90
   91
   92
   93
   94
   95
   96
   97
   98
   99
   100
   101
   102
   103
   104
   105
   106
   107
   108
   109
   110
   111
   112
   113
   114
   115
   116
   117
   118
   119
   120
   121
   122
   123
   124
   125
   126
   127
   128
   129
   130
   131
   132
   133
   134
   135
   136
   137
   138
   139
   140
   141
   142
   143
   144
   145
   146
   147

3. 主要问题是默认字符集有问题、顺带调整默认引擎【上段代码中已经调整】

   [mysqld]
   ...
   character-set-server=utf8
   collation-server=utf8_bin
   default-storage-engine=INNODB
   ...
   1
   2
   3
   4
   5
   6

q6：Confluence设置MySQL数据库报错：必须使用’READ-COMMITTED’作为默认隔离级别

• 进行MySQL命令行，执行一下操作即可

  SET GLOBAL tx_isolation='READ-COMMITTED';
  1

q7：MySQL与mysql-connector-java引发的问题

• 经测试都是MySQL与连接驱动的版本不一致造成的；

Confluence - error setting up mysql database : Illegal operation on empty result set.