歡迎您光臨本站 註冊首頁

windows下jira confluence遷移到linux

←手機掃碼閱讀     火星人 @ 2014-03-09 , reply:0

1. 操作系統(CentOS 5.5)和mysql(源代碼)安裝

A:安裝系統

………..

B mysql 5.5.x安裝

mysql 5.5.x版本需要

cmake編譯安裝

#創建用戶和用戶組

groupadd -g 3306 mysql;useradd -u 3306 -g mysql -M -s /sbin/nologin mysql

#創建mysql安裝目錄

mkdir /usr/local/mysql/

#創建數據目錄與賦予數據存放目錄許可權

mkdir -p /data/mysql;chown mysql.mysql -R /data/mysql

#安裝

cmake

wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz

tar zxf cmake-2.8.4.tar.gz

cd cmake-2.8.4

./configure

make&make install

cd ..

tar zxf mysql-5.5.10.tar.gz

cd mysql-5.5.10

#預編譯

cmake .

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql/

-DMYSQL_DATADIR=/data/mysql

-DMYSQL_UNIX_ADDR=/data/mysql/mysqld.sock

-DWITH_INNOBASE_STORAGE_ENGINE=1

-DENABLED_LOCAL_INFILE=1

-DMYSQL_TCP_PORT=3306

-DEXTRA_CHARSETS=all

-DDEFAULT_CHARSET=utf8

-DDEFAULT_COLLATION=utf8_general_ci

-DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock

-DWITH_DEBUG=0

#編譯、安裝

make & make install

#複製配置文件

cp support-files/my-medium.cnf /etc/my.cnf

cp support-files/mysql.server /etc/init.d/mysqld

chmod 755 /etc/init.d/mysqld

chkconfig -add mysqld

chkconfig mysqld on

#初始化資料庫

/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql

#修改PATH

echo 'export PATH=$PATH:/usr/local/mysql/bin' >> /etc/profile

#修改密碼,附權

mysql>use mysql;

mysql>update user set password=PASSWORD("admin") where user='root';

mysql>grant all privileges on *.* to root@'%' identified by "admin"with grant option;

mysql>create database jiradb;

mysql>create database confluencedb;

mysql>grant all privileges on jiradb.* to jirauser@'%' identified by "admin"with grant option;

mysql>grant all privileges on confluencedb.* to jirauser@'%' identified by "admin"with grant option;

mysql>FLUSH PRIVILEGES;

mysql> select host,user,password from mysql.user;

------ ---------- -------------------------------------------

| host | user | password |

------ ---------- -------------------------------------------

| %

| root | *4ACFE3202A5FF5CF467898FC58AAB1D615029441 |

| % | jirauser | *4ACFE3202A5FF5CF467898FC58AAB1D615029441 |

------ ---------- -------------------------------------------

2 rows in set (0.00 sec)

2. 安裝配置jdk

chmod x jdk-6u25-linux-i586-rpm.bin

./jdk-6u25-linux-i586.rpm.bin

rpm -ivh jdk-6u25-linux-i586.rpm

'export JAVA_HOME=/usr/java/jdk1.6.0_25

export CLASSPATH=.:$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/dt.jar

export PATH=$JAVA_HOME/bin:$PATH'>> /etc/profile

3. JIRA CONFLUENCE安裝(遷移可不用安裝jira

confluence)

A 安裝JIRA的前提是java正確安裝配置,下載atlassian-jira-enterprise-4.0.2-

standalone.zip

cd /jira_confluence/jira
unzip ~/atlassian-jira-enterprise-4.0.2-standalone.zip

mv atlassian-jira-enterprise-

4.0.2-standalone jira

下載mysql連接jar包,mysql-connector-java-5.1.12.tar.gz

tar xzf mysql-connector-java-5.1.12.tar.gz

cp mysql-connector-java-5.1.12/mysql-connector-java-5.1.12-bin.jar /jira_confluence/jira/common/lib/

B confluence安裝

下載confluence-version.tar.gz 解壓,將目錄放入/jira_confluence/jira

4. 遷移準備

為保持數據一致性,關閉jiraconfluence

Ddevatlassian-jira-enterprise-4.0.2-standalone copylinux /jira_confluence/目錄下重命名為/jira_confluence/jira

mysql導出數據

mysql>commit;

mysqldump –uroot –padmin jiradb >jiradb.sql

mysqldump –uroot –padmin confluencedb >confluencedb.sql

5. 導入數據,修改配置文件

[root@test ~]# mysql -ujirauser -padmin

mysql> use jiradb;

mysql> source jiradb.sql;

mysql> use confluencedb;

mysql> source confluencedb.sql;

mysql> commit;

chmod x /jira_confluence/jira/bin/*

vi /jira_confluence/jira/conf/server.xml

23 password="jira" password="admin"

43 <Resource name="mail/GmailSmtpServer"^M

44 auth="Container"^M 刪除

44行到52 ^M

45 type="javax.mail.Session"^M

46 mail.smtp.host="smtp.gmail.com"^M

47 mail.smtp.port="465"^M

48 mail.smtp.auth="true"^M

49 mail.smtp.user="jira@xxx.com"^M

50 password="xxx"^M

51 mail.smtp.starttls.enable="true"^M

52 mail.smtp.socketFactory.class="javax.net.ssl.SSLSocketFactory"^M

vi /jira_confluence/jira/atlassian-jira/WEB-INF/classes/jira-application.properties

16 jira.home = D:/dev/atlassian-jira-enterprise-4.0.2-standalone

jira.home = /jira_confluence/jira

vi /jira_confluence/jira/conf/Catalina/localhost/confluence.xml

1 <Context path="/confluence" docBase=

"D:/dev/atlassian-jira-enterprise-4.0.2-standalone/confluence"

debug="0" reloadable="true"> 1 <Context path="/confluence" docBase="/jira_confluence/jira/confluence" debug="0" reloadable="true">

4 password="jira" password="admin"

10 password="jira" password="admin"

vi /jira_confluence/jira/confluence/WEB-INF/classes/

confluence-init.properties

34 confluence.home=D:/dev/atlassian-jira-enterprise-4.0.2-standalone

/confluence/confluence_data confluence.home=/jira_confluence/jira/confluence/confluence_data

vi /jira_confluence/jira/confluence/WEB-INF/web.xml

965 <resource-ref>^M

刪除965行到977 ^M

966 <description>Connection Pool</description>^M

967 <res-ref-name>jdbc/JiraDS</res-ref-name>^M

968 <res-type>javax.sql.DataSource</res-type>^M

969 <res-auth>Container</res-auth>^M

970 </resource-ref>

971 ^M

972 <resource-ref>^M

973 <description>Connection Pool</description>^M

974 <res-ref-name>jdbc/ConfluenceDS</res-ref-name>^M

975 <res-type>javax.sql.DataSource</res-type>^M

976 <res-auth>Container</res-auth>^M

977

</resource-ref>^M

6. 需注意問題

1. 數據一致性問題

2.

資料庫中表名大小寫問題,在my.cnf中加入參數lower_case_table_names = 1,忽略大小寫.

3. tail –f /jira_confluence/jira/logs/catalina.out

本文出自 「LOA」 博客,請務必保留此出處http://lj2007331.blog.51cto.com/979238/567248


[火星人 ] windows下jira confluence遷移到linux已經有697次圍觀

http://coctec.com/docs/linux/show-post-48645.html