1. 操作系統(CentOS 5.5)和mysql(源代碼)安裝
A:安裝系統
………..
B: mysql 5.5.x安裝
mysql 5.5.x版本需要
#創建用戶和用戶組
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
#安裝
wget http://www.cmake.org/files/v2.8/cmake-
tar zxf cmake-
cd cmake-
./configure
make&make install
cd ..
tar zxf mysql-
cd mysql-
#預編譯
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>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 |
------ ---------- -------------------------------------------
| %
| % | jirauser | *4ACFE
------ ---------- -------------------------------------------
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 CLASSPATH=.:$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/dt.jar
export PATH=$JAVA_HOME/bin:$PATH'>> /etc/profile
3. JIRA CONFLUENCE安裝(遷移可不用安裝jira和
A 安裝JIRA的前提是java正確安裝配置,下載atlassian-jira-enterprise-
standalone.zip
cd /jira_confluence/jira
unzip ~/atlassian-jira-enterprise-
mv atlassian-jira-enterprise-
下載mysql連接jar包,mysql-connector-java-
tar xzf mysql-connector-java-
cp mysql-connector-java-
B confluence安裝
下載confluence-version.tar.gz 解壓,將目錄放入/jira_confluence/jira下
4. 遷移準備
為保持數據一致性,關閉jira、confluence
將D:dev下atlassian-jira-enterprise-
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> 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 刪除
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
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-
jira.home = /jira_confluence/jira
▲ vi /jira_confluence/jira/conf/Catalina/localhost/confluence.xml
1 <Context path="/confluence" docBase=
"D:/dev/atlassian-jira-enterprise-
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"
▲
confluence-init.properties
34 confluence.home=D:/dev/atlassian-jira-enterprise-
/confluence/confluence_data → confluence.home=/jira_confluence/jira/confluence/confluence_data
▲ vi /jira_confluence/jira/confluence/WEB-INF/web.xml
965 <resource-ref>^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
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
6. 需注意問題
1. 數據一致性問題
2.
3. tail –f /jira_confluence/jira/logs/catalina.out
本文出自 「LOA」 博客,請務必保留此出處http://lj2007331.blog.51cto.com/979238/567248
[火星人 ] windows下jira confluence遷移到linux已經有699次圍觀