升級Roller 3.0到Roller 4.0
簡單的步驟如下:
1.下載檔案及解壓縮
cd ~/download
wget http://apache.ntu.edu.tw/roller/roller-4/v4.0.0/bin/apache-roller-4.0.zip
unzip apache-roller-4.0.zip
2.修改升級用的dbscripts
cd ~/download/apache-roller-4.0/webapp/roller/WEB-INF/classes/dbscripts/postgresql
vi 300-to-310-migration.sql
將底下這一行加在檔尾
update roller_properties set value='310' where name='roller.database.version';
vi 310-to-400-migration.sql
將第159行的
drop table if exists rollerconfig;
修改為
drop table rollerconfig;
然後一樣將底下這一行加在檔尾
update roller_properties set value='400' where name='roller.database.version';
3.關閉Application Server例如Tomcat
sudo /etc/init.d/tomcat stop
4.將現有的roller搬移(備份)到/tmp下
mv ~/www/roller /tmp/roller-3.0
5.複製新的程式到網站目錄下:
cp -rf ~/download/apache-roller-4.0/webapp/roller ~/www/roller
6.備份資料庫:
sudo pg_dump -U scott roller > /tmp/roller_300-2008-09-06.bak
7.手動升級資料庫到3.1
sudo psql -U scott roller -f /home/yoursite/www/roller/WEB-INF/classes/dbscripts/postgresql/300-to-310-migration.sql
8.編輯設定檔roller-custom.properties
vi ~/www/roller/WEB-INF/classes/roller-custom.properties
installation.type=auto
database.configurationType=jdbc
database.jdbc.driverClass=org.postgresql.Driver
database.jdbc.connectionURL=jdbc:postgresql://localhost:5432/roller
database.jdbc.username=scott
database.jdbc.password=tiger
mail.configurationType=properties
mail.hostname=smtp.yoursite.com
uploads.dir=/home/yoursite/www/data/roller_data/uploads
search.index.dir=/home/yoursite/www/data/roller_data/search-index
passwds.encryption.enabled=false
注意到Roller 4.0起使用者密碼預設為使用SHA加密,如果是升級上來的要將這個功能取消,否則將無法登入
9.變更檔案及目錄權限:
chown -R yoursite:tomcat ~/www/roller
chmod g+w ~/www/roller
10.刪除暫存檔案
rm -rf /var/robust/worker1/work/Catalina/www.yoursite.com/roller
11.啟動Application Server
sudo /etc/init.d/tomcat start
12.開啟網頁到http://www.yoursite.com/roller,會自動詢問是否要升級資料庫,選擇是
13.升級完成後,將設定檔roller-custom.properties裡面的installation.type改為manual
vi ~/www/roller/WEB-INF/classes/roller-custom.properties
installation.type=manual