Latest topics for the forum "OLAT中文社群 OLAT Chinese Users Community"

OLAT 6.2.1->6.2.2升級筆記

andowson — GMT

OLAT 6.2.2出來了一陣子，昨天開始嘗試升級，除了壓縮檔解壓縮出來的目錄命名方式跟之前不同外，執行到ant build時還遇到了下面這樣的錯誤
[quote] [javac] The system is out of resources.
[javac] Consult the following stack trace for details.
[javac] java.lang.OutOfMemoryError: Java heap space[/quote]
後來查了一下OLAT mailing list裡面，有人也遇到了這樣的問題，解法就是加上一個
export ANT_OPTS=-Xmx128m
宣告再執行ant build就可以了，底下直接給整個執行的shell script，有需要的人請自行參考並修改。

[code]
# get OLAT source
cd ~/download
wget http://www.olat.org/downloads/stable/OLAT-6.2.2.zip
unzip OLAT-6.2.2.zip
mv olat3 OLAT-6.2.1
mv OLAT-6_2_2-PUBLIC-* olat3
cd olat3

# config build.properties
sed -e "s/\/usr\/local\/opt\/olat\/olat3/\/home\/andowson\/download\/olat3/g" \
-e "s/\/usr\/local\/opt\/olat\/olatdata/\/home\/andowson\/data\/olatdata/g" \
-e "s/\/usr\/local\/opt\/tomcat/\/var\/tomcat6/g" \
-e "1,$$s/www.myolat.com/www.andowson.com/g" \
-e "1,$$s/myolat.com/andowson.com/g" \
-e "1,$$s/myolat/andowson/g" \
-e "s/server.modjk.enabled=false/server.modjk.enabled=true/g" \
-e "55a\server.modjk.jvmRoute=worker1" \
-e "s/defaultcharset=ISO-8859-1/defaultcharset=UTF-8/g" \
-e "s/registration.enableNotificationEmail=false/registration.enableNotificationEmail=true/g" \
-e "s/smtp.host=smtp.andowson.com/smtp.host=smtp.other.com/g" \
-e "s/smtp.user=/smtp.user=username/g" \
-e "s/smtp.pwd=/smtp.pwd=password/g" \
-e "121,143d" \
-e "1,$$s/#db/db/g" \
-e "1,$$s/net.sf.hibernate/org.hibernate/g" \
-e "s/instantMessaging.server.name=jabber.andowson.com/instantMessaging.server.name=www.andowson.com/g" \
-e "s/instantMessaging.db.name=wildfire/instantMessaging.db.name=openfire/g" \
-e "s/instantMessaging.db.user=wildfire/instantMessaging.db.user=openfire/g" \
-e "s/instantMessaging.db.pass=wildfire/instantMessaging.db.pass=openfire/g" \
-e "s/cluster.catalinaport=8006/cluster.catalinaport=8105/" \
-e "s/cluster.ajpport=8009/cluster.ajpport=8109/" build.properties.default > build.properties

# adjust the original template config files
# enable zh_CN and zh_TW on the top right menu
sed -i -e "s/en,de,fr,it,es<\/enabledLanguages>/en,de,fr,it,es,zh_CN,zh_TW<\/enabledLanguages>/g" ~/download/olat3/webapp/WEB-INF/olat_config.xml.in
# change domain name in email address
sed -i -e "1,$$s/olat-newinstallation.org/andowson.com/g" ~/download/olat3/webapp/WEB-INF/olat_config.xml.in
# fix the commnet style in XML
sed -i -e "13c\ <\!-- default session timeout -->" ~/download/olat3/webapp/WEB-INF/web.xml.in

# remove findbugs setting
sed -i -e "1348,1361d" build.xml
ant config-all
# to avoid OutOfMemoryError
export ANT_OPTS=-Xmx128m
ant build

# stop Tomcat
sudo /etc/init.d/tomcat stop

# backup db
sudo -u postgres pg_dump olat > /tmp/olat.bak

# copy to the target directory
sudo mv ~/www/olat /tmp/olat-6.2.1
cp -rf ~/download/olat3/webapp ~/www/olat
cp -rf ~/download/olat3/htdocs/* ~/www/olat
sudo chmod 775 ~/www/olat/static
sudo chmod 775 ~/www/olat/WEB-INF
sudo chmod 775 -R ~/data/olatdata

# start Tomcat
sudo /etc/init.d/tomcat start
[/code]

徵求有興趣參與共同翻譯OLAT繁體中文的使用者

Matthew — GMT

Hi Andowson：
是啊！之前是一家西安的科技公司在做，后来他们放弃了。不过他们在教育方面知之甚少，而且又有很多错误，可能后期还要重新调整。如果这边进展顺利，我就会用剩余的时间帮助您进行中文繁体的翻译工作。希望大陆能和台湾同一天发布语言包。
期待合作！

OLAT 6.1.1->6.2.1升級筆記

andowson — GMT

步驟如下:
1.切換到下載目錄
[code]cd ~/download[/code]
2.下載原始碼壓縮檔
[code]wget http://www.olat.org/downloads/stable/OLAT-6.2.1.zip[/code]
3.解壓縮
[code]unzip OLAT-6.2.1.zip[/code]
4.將舊版程式目錄更名
[code]mv olat3 OLAT-6.1.1[/code]
5.將解縮壓後的目錄更名為olat3
[code]mv OLAT-6.2.1-PUBLIC-* olat3[/code]
6.切換到olat3目錄
[code]cd olat3[/code]
7.開啟build.properties.default，輸入:set nu，搜尋mysql，找到mysql的起始和結尾行號
[code]vi build.properties.default[/code]
8.產生build.properties，先不啟用instantMessaging
[code]
sed -e "s/\/usr\/local\/opt\/olat\/olat3/\/home\/andowson\/download\/olat3/g" \
-e "s/\/usr\/local\/opt\/olat\/olatdata/\/home\/andowson\/data\/olatdata/g" \
-e "s/\/usr\/local\/opt\/tomcat/\/var\/tomcat6/g" \
-e "1,$$s/www.myolat.com/www.andowson.com/g" \
-e "1,$$s/myolat.com/andowson.com/g" \
-e "1,$$s/myolat/andowson/g" \
-e "s/server.modjk.enabled=false/server.modjk.enabled=true/g" \
-e "55a\server.modjk.jvmRoute=worker1" \
-e "s/defaultcharset=ISO-8859-1/defaultcharset=UTF-8/g" \
-e "s/registration.enableNotificationEmail=false/registration.enableNotificationEmail=true/g" \
-e "s/smtp.host=smtp.andowson.com/smtp.host=smtp.other.com/g" \
-e "s/smtp.user=/smtp.user=username/g" \
-e "s/smtp.pwd=/smtp.pwd=password/g" \
-e "121,143d" \
-e "1,$$s/#db/db/g" \
-e "1,$$s/net.sf.hibernate/org.hibernate/g" \
-e "s/instantMessaging.server.name=jabber.andowson.com/instantMessaging.server.name=www.andowson.com/g" \
-e "s/instantMessaging.db.name=wildfire/instantMessaging.db.name=openfire/g" \
-e "s/instantMessaging.db.user=wildfire/instantMessaging.db.user=openfire/g" \
-e "s/instantMessaging.db.pass=wildfire/instantMessaging.db.pass=openfire/g" \
-e "s/cluster.catalinaport=8006/cluster.catalinaport=8105/" \
-e "s/cluster.ajpport=8009/cluster.ajpport=8109/" build.properties.default > build.properties
[/code]
9.調整螢幕右上方語言選單，加入簡體中文(zh_CN)和正體中文(zh_TW)
[code]sed -i -e "s/en,de,fr,it,es<\/enabledLanguages>/en,de,fr,it,es,zh_CN,zh_TW<\/enabledLanguages>/g" ~/download/olat3/webapp/WEB-INF/olat_config.xml.in[/code]
10.修改系統自動產生之使用者預設的電子郵件網域名稱
[code]sed -i -e "1,$$s/olat-newinstallation.org/andowson.com/g" ~/download/olat3/webapp/WEB-INF/olat_config.xml.in[/code]
11.修正web.xml中註解
[code]sed -i -e "13c\ <\!-- default session timeout -->" ~/download/olat3/webapp/WEB-INF/web.xml.in[/code]
12.修正無法編譯的錯誤：刪除build.xml中findbugs區段，行號可由build.xml中找出
[code]sed -i -e "1351,1364d" build.xml[/code]
13.開始編譯
[code]ant config-all
ant build[/code]
14.關閉Tomcat
[code]sudo /etc/init.d/tomcat stop[/code]
15.備份資料庫
[code]sudo -u postgres pg_dump olat > /tmp/olat.bak[/code]
16.檢查是否有需要做資料庫更新
[code]ls ~/download/olat3/database/postgresql[/code]
17.找到檔案alter_6_1_1_to_6_2_0.sql，執行更新
[code]sudo psql -U olat olat -f ~/download/olat3/database/postgresql/alter_6_1_1_to_6_2_0.sql[/code]
18.將舊版程式搬到暫存區
[code]sudo mv ~/www/olat /tmp/olat-6.1.1[/code]
19.將檔案複製到~/www/olat目錄
[code]cp -rf ~/download/olat3/webapp ~/www/olat
cp -rf ~/download/olat3/htdocs/* ~/www/olat[/code]
20.設定目錄寫入權限
[code]sudo chmod 775 ~/www/olat/static
sudo chmod 775 ~/www/olat/WEB-INF
sudo chmod 775 -R ~/data/olatdata[/code]
21.啟動Tomcat
[code]sudo /etc/init.d/tomcat start[/code]
22.開啟瀏覽器測試網站是否可以正常顯示首頁，檢查一下~/data/olatdata/logs/olat.log有無ERROR的訊息。
如果一切正常則可以接下做，將openfire加上去
23.啟用openfire設定
[code]sed -i -e "s/instantMessaging.enable=false/instantMessaging.enable=true/g" build.properties[/code]
24.重新編譯
[code]ant config-all
ant build[/code]
25.關閉Tomcat
[code]sudo /etc/init.d/tomcat stop[/code]
26.將檔案複製到目錄中
[code]cp -rf ~/download/olat3/webapp/WEB-INF/classes/* ~/www/olat/WEB-INF/classes/.
cp -rf ~/download/olat3/webapp/WEB-INF/src/serviceconfig/* ~/www/olat/WEB-INF/src/serviceconfig/.[/code]
27.啟動Tomcat
[code]sudo /etc/init.d/tomcat start[/code]
28.開啟瀏覽器測試網站是否可以正常顯示首頁，檢查一下~/data/olatdata/logs/olat.log有無ERROR的訊息。
29.加上jsMath
[code]ant jsmath
ant build[/code]
30.關閉Tomcat
[code]sudo /etc/init.d/tomcat stop[/code]
31.將檔案複製到目錄中
[code]cp -rf ~/download/olat3/webapp/static/js/jsMath/* ~/www/olat/static/js/jsMath/.
cp -rf ~/download/olat3/webapp/WEB-INF/classes/serviceconfig/* ~/www/olat/WEB-INF/classes/serviceconfig/.
cp -rf ~/download/olat3/webapp/WEB-INF/src/serviceconfig/* ~/www/olat/WEB-INF/src/serviceconfig/.[/code]
32.啟動Tomcat
[code]sudo /etc/init.d/tomcat start[/code]
如此就大功告成囉。
以下附上所有的shell script寫法，只要將它先複製到記事本，再依您實際環境修改一下，然後開個[url=http://www.chiark.greenend.org.uk/~sgtatham/putty/]PuTTY[/url]或[url=http://www.csie.ntu.edu.tw/~piaip/pietty/]PieTTY[/url]視窗貼上即可。
[code]
# get OLAT source
cd ~/download
wget http://www.olat.org/downloads/stable/OLAT-6.2.1.zip
unzip OLAT-6.2.1.zip
mv olat3 OLAT-6.1.1
mv OLAT-6.2.1-PUBLIC-* olat3
cd olat3

# config build.properties
sed -e "s/\/usr\/local\/opt\/olat\/olat3/\/home\/andowson\/download\/olat3/g" \
-e "s/\/usr\/local\/opt\/olat\/olatdata/\/home\/andowson\/data\/olatdata/g" \
-e "s/\/usr\/local\/opt\/tomcat/\/var\/tomcat6/g" \
-e "1,$$s/www.myolat.com/www.andowson.com/g" \
-e "1,$$s/myolat.com/andowson.com/g" \
-e "1,$$s/myolat/andowson/g" \
-e "s/server.modjk.enabled=false/server.modjk.enabled=true/g" \
-e "55a\server.modjk.jvmRoute=worker1" \
-e "s/defaultcharset=ISO-8859-1/defaultcharset=UTF-8/g" \
-e "s/registration.enableNotificationEmail=false/registration.enableNotificationEmail=true/g" \
-e "s/smtp.host=smtp.andowson.com/smtp.host=smtp.other.com/g" \
-e "s/smtp.user=/smtp.user=username/g" \
-e "s/smtp.pwd=/smtp.pwd=password/g" \
-e "121,143d" \
-e "1,$$s/#db/db/g" \
-e "1,$$s/net.sf.hibernate/org.hibernate/g" \
-e "s/instantMessaging.server.name=jabber.andowson.com/instantMessaging.server.name=www.andowson.com/g" \
-e "s/instantMessaging.db.name=wildfire/instantMessaging.db.name=openfire/g" \
-e "s/instantMessaging.db.user=wildfire/instantMessaging.db.user=openfire/g" \
-e "s/instantMessaging.db.pass=wildfire/instantMessaging.db.pass=openfire/g" \
-e "s/cluster.catalinaport=8006/cluster.catalinaport=8105/" \
-e "s/cluster.ajpport=8009/cluster.ajpport=8109/" build.properties.default > build.properties

# adjust the original template config files
# enable zh_CN and zh_TW on the top right menu
sed -i -e "s/en,de,fr,it,es<\/enabledLanguages>/en,de,fr,it,es,zh_CN,zh_TW<\/enabledLanguages>/g" ~/download/olat3/webapp/WEB-INF/olat_config.xml.in
# change domain name in email address
sed -i -e "1,$$s/olat-newinstallation.org/andowson.com/g" ~/download/olat3/webapp/WEB-INF/olat_config.xml.in
# fix the commnet style in XML
sed -i -e "13c\ <\!-- default session timeout -->" ~/download/olat3/webapp/WEB-INF/web.xml.in

# remove findbugs setting
sed -i -e "1351,1364d" build.xml
ant config-all
ant build

# stop Tomcat
sudo /etc/init.d/tomcat stop

# backup db
sudo -u postgres pg_dump olat > /tmp/olat.bak

# apply db upgrade script
sudo psql -U olat olat -f ~/download/olat3/database/postgresql/alter_6_1_1_to_6_2_0.sql

# copy to the target directory
sudo mv ~/www/olat /tmp/olat-6.1.1
cp -rf ~/download/olat3/webapp ~/www/olat
cp -rf ~/download/olat3/htdocs/* ~/www/olat
sudo chmod 775 ~/www/olat/static
sudo chmod 775 ~/www/olat/WEB-INF
sudo chmod 775 -R ~/data/olatdata

# start Tomcat
sudo /etc/init.d/tomcat start[/code]
[code]# endable OpenFire
sed -i -e "s/instantMessaging.enable=false/instantMessaging.enable=true/g" build.properties
ant config-all
ant build

# stop Tomcat
sudo /etc/init.d/tomcat stop

# copy to the target directory
cp -rf ~/download/olat3/webapp/WEB-INF/classes/* ~/www/olat/WEB-INF/classes/.
cp -rf ~/download/olat3/webapp/WEB-INF/src/serviceconfig/* ~/www/olat/WEB-INF/src/serviceconfig/.

# start Tomcat
sudo /etc/init.d/tomcat start[/code]

[code]# enable jsMath
ant jsmath
ant build

# stop Tomcat
sudo /etc/init.d/tomcat stop

# copy to the target directory
cp -rf ~/download/olat3/webapp/static/js/jsMath/* ~/www/olat/static/js/jsMath/.
cp -rf ~/download/olat3/webapp/WEB-INF/classes/serviceconfig/* ~/www/olat/WEB-INF/classes/serviceconfig/.
cp -rf ~/download/olat3/webapp/WEB-INF/src/serviceconfig/* ~/www/olat/WEB-INF/src/serviceconfig/.

# start Tomcat
sudo /etc/init.d/tomcat start
[/code]

OLAT 6.1.1安裝筆記(CentOS 5.3 + PostgreSQL 8.1.11 + Tomcat 6.0.18 + Openfire 3.6.4)

andowson — GMT

OLAT 自6.1.0版起開始支援Cluster架構和更容易引進多國語言的翻譯工具，最近更新的6.1.1版，修正了很多新版剛發行時的bug，如修正了一些正體中文註冊連結的問題，因此，我比較推薦安裝這個版本。底下是整個全新安裝的步驟。

一、設計理念
OLAT是一個網頁應用系統，可以在Tomcat上安裝及執行，後端可以接MySQL或PostgreSQL或其他Hibernate支援的資料庫，如果要執行聊天室功能，我們還需要安裝Openfire，如果要支援Cluster，還要安裝JMS Server(如ActiveMQ)。由於設備有限，我以全部安裝在單部主機(CentOS 5.3 Linux)方式介紹，不考慮Cluster的模式。

我們預計安裝OLAT的目錄是/home/andowson/www/olat，底下如未特別聲明，均是以andowson身份執行（[url=http://www.andowson.com/posts/list/166.page]具有sudo權限[/url]）。

我們預計安裝下列元素：
1. JDK+Apache+Tomcat+mod_jk
2. PostgreSQL
3. Ant
4. Openfire
5. OLAT

二、實作步驟
1.可以參考這篇文章完成：[url]http://www.andowson.com/posts/list/315.page[/url]，並參考這篇[url]http://www.andowson.com/posts/list/309.page[/url]建立一個Virtual Host，在此就不浪費篇幅。
2.PostgreSQL的安裝及啟動可以透過下列的指令來完成(以root身份執行)：
[code]
yum -y install postgresql-server
sed -i -e "s/#listen_addresses = 'localhost'/listen_addresses = '*'/g" /var/lib/pgsql/data/postgresql.conf

sed -i -e "s/local all all ident sameuser/local all all trust/g" /var/lib/pgsql/data/pg_hba.conf
sed -i -e "s/host all all 127.0.0.1\/32 ident sameuser/host all all 127.0.0.1\/32 md5/g" /var/lib/pgsql/data/pg_hba.conf
sed -i -e "69a\host all all 192.168.1.0\/24 md5" /var/lib/pgsql/data/pg_hba.conf

chkconfig --level 235 postgresql on
service postgresql start
[/code]
3.Ant安裝也很簡單，只需要下載並解壓縮即可，這裡我們以安裝1.7.1版為例
[code]
cd ~/download
wget http://apache.ntu.edu.tw/ant/binaries/apache-ant-1.7.1-bin.tar.gz
sudo tar zxvf apache-ant-1.7.1-bin.tar.gz -C /usr/local
[/code]
接著設定環境變數ANT_HOME
vi ~/.bash_profile
[code]
ANT_HOME=/usr/local/apache-ant-1.7.1
JAVA_HOME=/usr/java/latest
PATH=$PATH:$HOME/bin:$ANT_HOME/bin:$JAVA_HOME/bin

export PATH ANT_HOME JAVA_HOME
[/code]
執行source將設定載入
source ~/.bash_profile

4.安裝Openfire(以root身份執行)：
[code]
cd /root/setup
wget http://www.igniterealtime.org/downloadServlet?filename=openfire/openfire-3.6.4-1.i386.rpm
rpm -ivh openfire-3.6.4-1.i386.rpm
chmod 755 /opt/openfire
[/code]
建立資料庫openfire
[code]
sudo -u postgres psql -c "CREATE USER openfire WITH ENCRYPTED PASSWORD 'openfire' VALID UNTIL 'infinity' CREATEDB;" template1
sudo -u postgres psql -c "CREATE DATABASE openfire WITH ENCODING 'UNICODE';" -U openfire template1
sudo -u postgres psql -c "ALTER USER openfire NOCREATEDB;" template1
sudo -u postgres psql openfire openfire -f /opt/openfire/resources/database/openfire_postgresql.sql
[/code]
手動設定設定檔openfire.xml，將下列設定貼在之前
vi /opt/openfire/conf/openfire.xml
[code]

org.jivesoftware.database.DefaultConnectionProvider

org.postgresql.Driver
jdbc:postgresql://localhost:5432/openfire
openfire
openfire
select 1
true
true
1
25
1.0

true
[/code]
調整openfire在系統開機時自動啟動的順序（要在PostgreSQL之後，Tomcat之前）
sed -i -e "s/99 1/80 20/g" /etc/init.d/openfire
調整openfire啟動時的JVM參數
sed -i -e "s/-server/-server -Xss256k/g" /etc/init.d/openfire
設定開機自動啟動openfire
chkconfig openfire on
啟動openfire
service openfire start

啟動之後，開啟瀏覽器到http://:9090/，以admin/admin登入
調整一些系統設定，如mail server，不允許使用者建立帳號跟修改密碼等
接著下載OLAT plugin
http://www.olat.org/downloads/stable/olatUserAndGroupService.jar
然後切換到Plugin頁面，將這個jar檔匯入即可。

注意：如果您有設定iptables或其他防火牆，建議先關閉，等測試沒問題後再打開，並增加Openfire所需要的port。

5.終於到了主菜了，安裝OLAT，我們需要先下載OLAT原始碼的壓縮檔，解壓縮，建立build.properties，然後再執行ant config-all, ant build來編譯。
[code]
# get OLAT source
cd ~/download
wget http://www.olat.org/downloads/stable/OLAT-6.1.1.zip
unzip OLAT-6.1.1.zip
mv OLAT-6.1.1-PUBLIC-* olat3
cd olat3
# config build.properties
sed -e "s/\/usr\/local\/opt\/olat\/olat3/\/home\/andowson\/download\/olat3/g" \
-e "s/\/usr\/local\/opt\/olat\/olatdata/\/home\/andowson\/data\/olatdata/g" \
-e "s/\/usr\/local\/opt\/tomcat/\/var\/tomcat6/g" \
-e "1,$$s/www.myolat.com/www.andowson.com/g" \
-e "1,$$s/myolat.com/andowson.com/g" \
-e "1,$$s/myolat/andowson/g" \
-e "s/server.modjk.enabled=false/server.modjk.enabled=true/g" \
-e "55a\server.modjk.jvmRoute=worker1" \
-e "s/defaultcharset=ISO-8859-1/defaultcharset=UTF-8/g" \
-e "s/registration.enableNotificationEmail=false/registration.enableNotificationEmail=true/g" \
-e "s/smtp.host=smtp.andowson.com/smtp.host=smtp.yourcompany.com/g" \
-e "s/smtp.user=/smtp.user=username/g" \
-e "s/smtp.pwd=/smtp.pwd=password/g" \
-e "120,142d" \
-e "1,$$s/#db/db/g" \
-e "1,$$s/net.sf.hibernate/org.hibernate/g" \
-e "s/instantMessaging.enable=false/instantMessaging.enable=true/g" \
-e "s/instantMessaging.server.name=jabber.andowson.com/instantMessaging.server.name=www.andowson.com/g" \
-e "s/instantMessaging.db.name=wildfire/instantMessaging.db.name=openfire/g" \
-e "s/instantMessaging.db.user=wildfire/instantMessaging.db.user=openfire/g" \
-e "s/instantMessaging.db.pass=wildfire/instantMessaging.db.pass=openfire/g" \
-e "s/cluster.catalinaport=8006/cluster.catalinaport=8105/" \
-e "s/cluster.ajpport=8009/cluster.ajpport=8109/" build.properties.default > build.properties
# adjust the original template config files
sed -i -e "s/en,de,fr,it,es<\/enabledLanguages>/en,de,fr,it,es,zh_CN,zh_TW<\/enabledLanguages>/g" ~/download/olat3/webapp/WEB-INF/olat_config.xml.in
sed -i -e "1,$$s/olat-newinstallation.org/andowson.com/g" ~/download/olat3/webapp/WEB-INF/olat_config.xml.in
sed -i -e "13c\ <\!-- default session timeout -->" ~/download/olat3/webapp/WEB-INF/web.xml.in
ant config-all
ant build
[/code]
接著我們需要先建立一個olat的資料庫再來執行ant dbsetup_postgreSQL。
[code]# create database olat and testdb
sudo -u postgres psql -c "CREATE USER olat WITH ENCRYPTED PASSWORD 'olat' VALID UNTIL 'infinity' CREATEDB;" template1
sudo -u postgres psql -c "CREATE DATABASE olat WITH ENCODING 'UNICODE';" -U olat template1
sudo -u postgres psql -c "CREATE DATABASE testdb WITH ENCODING 'UNICODE';" -U olat template1
sudo -u postgres psql -c "ALTER USER olat NOCREATEDB;" template1[/code]
這裡要注意的是PostgreSQL 8.2之前的版本尚未支援drop table if exists這種語法，因在CentOS 5.3發行的是PostgreSQL 8.1.11的版本，由於執行dbsetup_postgreSQL時會先執行deleteDatabase.sql，第一次安裝時由於資料庫是空的，會失敗，故我們需要修正一下deleteDatabase.sql裡面的語法。我們可以先將deleteDatabase.sql換成一個空檔，等第一次建立好table後再換回來。另外第一次啟動時也會執行alter_6_0_x_to_6_1_0.sql，故我們也要同步修正這邊的drop table if exists語法。
[code]
# PostgreSQL 8.1 doesn't support if exists
sed -i -e "1,$$s/if exists //g" ~/download/olat3/database/postgresql/deleteDatabase.sql
sed -i -e "1,$$s/if exists //g" ~/download/olat3/database/postgresql/alter_6_0_x_to_6_1_0.sql

# First time install, drop table will fail, use an empty file instead
mv ~/download/olat3/database/postgresql/deleteDatabase.sql ~/download/olat3/database/postgresql/deleteDatabase.sql.bak
touch ~/download/olat3/database/postgresql/deleteDatabase.sql
ant dbsetup_postgreSQL
mv ~/download/olat3/database/postgresql/deleteDatabase.sql.bak ~/download/olat3/database/postgresql/deleteDatabase.sql[/code]

接著就可以把編譯好的程式及網頁部署到我們的目的資料夾~/www/olat了，另外OLAT是把程式跟資料分開存放的，這樣子將來要升級新版只要換掉程式碼的目錄即可，我們選定~/data/olatdata作為這個目錄。由於OLAT會將一些檔案解壓縮到static和WEB-INF下，所以記得變更目錄的寫入權限。
[code]
# deploy to web directory
cp -rf ~/download/olat3/webapp ~/www/olat
cp -rf ~/download/olat3/htdocs/* ~/www/olat
sudo chgrp -R tomcat ~/www
sudo chgrp -R tomcat ~/data/olatdata
sudo chmod 775 ~/www/olat/static
sudo chmod 775 ~/www/olat/WEB-INF
sudo chmod 775 -R ~/data/olatdata
[/code]
最後，我們要設定讓Apache將/olat開頭的網址交給Tomcat處理，然後重新啟動Tomcat和Apache。
[code]
# add httpd handle setting
echo '/olat/*=loadbalancer' >> /etc/httpd/conf/uriworkermap.properties
sudo /etc/init.d/tomcat stop
sudo killall -9 /usr/java/latest/bin/java
sudo /etc/init.d/tomcat start
sudo /etc/init.d/httpd restart
[/code]

到此，差不多大功告成了，用administrator/olat登入http:///olat/dmz/吧！如果可以的話，建議先修改一下密碼再往下進行新的任務囉！

回覆:OLAT 6.0.4->6.0.6升級筆記

andowson — GMT

OLAT是用Java語言開發的LMS，支援UTF-8編碼，因此您可以輸入中文課程名稱，並能正常顯示。需要注意的是，教材內容如果有中文字元需要用UTF-8編碼才能正常顯示。

[轉載]OLAT Framework

andowson — GMT

這些我在網路上找到由JGS goodsolutions GmbH對OLAT的Framework所做的說明，如果萬一原來的連結無法下載時可以下載本站的附檔。

http://www.jugs.ch/html/events/slides/051208_olat.ppt
http://www.goodsolutions.ch/shared/resources/framework.pdf

OLAT 6.0.0->6.0.4升級筆記

andowson — GMT

[code]cd ~/download
mv olat3 olat-6.0.0
wget http://www.olat.org/downloads/stable/OLAT-6.0.4.zip
unzip OLAT-6.0.4.zip
mv OLAT-6.0.4-FINAL-* olat3
cd olat3
sed -e "s/\/usr\/local\/opt\/olat\/olat3/\/home\/andowson\/download\/olat3/g" \
-e "s/\/usr\/local\/opt\/olat\/olatdata/\/home\/andowson\/www\/data\/olatdata/g" \
-e "1,$$s/myolat/andowson/g" \
-e "s/smtp.host=smtp.andowson.com/smtp.host=mail.andowson.com/" \
-e "s/\/usr\/local\/opt\/tomcat/\/var\/tomcat5/g" \
-e "1,$$s/net.sf.hibernate/org.hibernate/g" \
-e "48c\server.modjk.enabled=true" \
-e "95,117d" \
-e "1,$$s/#db/db/g" \
-e "s/instantMessaging.enable=false/instantMessaging.enable=true/" \
-e "s/instantMessaging.server.name=jabber.andowson.com/instantMessaging.server.name=www.andowson.com/" \
-e "s/instantMessaging.generateTestUsers=false/instantMessaging.generateTestUsers=true/" \
-e "s/instantMessaging.db.name=wildfire/instantMessaging.db.name=openfire/" \
-e "s/instantMessaging.db.user=wildfire/instantMessaging.db.user=olat/" \
-e "s/instantMessaging.db.pass=wildfire/instantMessaging.db.pass=olat/" build.properties.default > build.properties
ant install
ant jsmath
sudo /etc/init.d/tomcat stop
mv ~/www/olat /tmp/olat-6.0.0
cp -rf ~/download/olat3/webapp ~/www/olat
cp -rf ~/download/olat3/htdocs/* ~/www/olat
sed -i -e "13c\ <\!-- default session timeout -->" ~/www/olat/WEB-INF/web.xml
rm -rf ~/www/olat/WEB-INF/src
rm -rf ~/www/olat/WEB-INF/patchesSrc
rm -rf ~/www/olat/WEB-INF/test
cp /tmp/olat-6.0.0/WEB-INF/classes/hibernate.properties ~/www/olat/WEB-INF/classes/.
chgrp -R tomcat ~/www/olat
chgrp -R tomcat ~/www/data/olatdata
chmod 775 ~/www/olat/static
chmod 775 ~/www/olat/WEB-INF
sudo -u postgres pg_dump olat > /tmp/olat.bak
sudo psql -U olat olat -f /home/andowson/download/olat3/database/postgresql/alter_6_0_0_to_6_0_3.sql
sudo psql -U olat olat -f ~/download/olat3/database/postgresql/alter_6_0_0_to_6_0_3.sql
sudo /etc/init.d/tomcat start[/code]

OLAT 5.2.3->6.0.0升級筆記

andowson — GMT

這個週末花了兩天終於把現有的OLAT由5.2.3升級至6.0.0, 步驟如下:
[code]
cd ~/download
mv olat3 olat-5.2.3
wget http://www.olat.org/downloads/stable/OLAT-6.0.0.zip
unzip OLAT-6.0.0.zip
mv OLAT-6.0.0-PUBLIC-* olat3
cd olat3
sed -e "s/\/usr\/local\/opt\/olat\/olat3/\/home\/andowson\/download\/olat3/g" \
-e "s/\/usr\/local\/opt\/olat\/olatdata/\/home\/andowson\/www\/data\/olatdata/g" \
-e "1,$$s/myolat/andowson/g" \
-e "s/smtp.host=smtp.andowson.com/smtp.host=mail.andowson.com/" \
-e "s/\/usr\/local\/opt\/tomcat/\/var\/tomcat5/g" \
-e "1,$$s/net.sf.hibernate/org.hibernate/g" \
-e "48c\server.modjk.enabled=true" \
-e "95,117d" \
-e "1,$$s/#db/db/g" \
-e "s/instantMessaging.enable=false/instantMessaging.enable=true/" \
-e "s/instantMessaging.server.name=jabber.andowson.com/instantMessaging.server.name=www.andowson.com/" \
-e "s/instantMessaging.generateTestUsers=false/instantMessaging.generateTestUsers=true/" \
-e "s/instantMessaging.db.name=wildfire/instantMessaging.db.name=openfire/" \
-e "s/instantMessaging.db.user=wildfire/instantMessaging.db.user=olat/" \
-e "s/instantMessaging.db.pass=wildfire/instantMessaging.db.pass=olat/" build.properties.default > build.properties
ant install
ant jsmath
sudo /etc/init.d/tomcat stop
mv ~/www/olat /tmp/olat-5.2.3
cp -rf ~/download/olat3/webapp ~/www/olat
cp -rf ~/download/olat3/htdocs/* ~/www/olat
sed -i -e "13c\ <\!-- default session timeout -->" ~/www/olat/WEB-INF/web.xml
rm -rf ~/www/olat/WEB-INF/src
rm -rf ~/www/olat/WEB-INF/patchesSrc
rm -rf ~/www/olat/WEB-INF/test
cp /tmp/olat-5.2.3/WEB-INF/classes/hibernate.properties ~/www/olat/WEB-INF/classes/.
chgrp -R tomcat ~/www/olat
chgrp -R tomcat ~/www/data/olatdata
chmod 775 ~/www/olat/static
sudo -u postgres pg_dump olat > /tmp/olat.bak
sudo psql -U olat olat -f /home/andowson/download/olat3/database/postgresql/alter_5_2_x_to_6_0_0.sql
sudo /etc/init.d/tomcat start
[/code]
要注意的地方是原始碼內附的PostgreSQL升級SQL script有問題，字串應該用單引號來括起來，而不是用雙引號，另外有些欄位名稱也不對，必須調整後才能正常執行。好在我有先執行資料庫備份，再執行那條upgrade的SQL，不然這個SQL script只能執行一次，並且會把o_user裡面的一些欄位drop掉（這樣子你連執行第二次的機會都沒有了）。所以記住：要做任何系統升級之前，備份！備份！備份！
以下是我修改後的alter_5_2_x_to_6_0_0.sql:
[code=sql]
--
-- new talbe to store the users properties
create table o_userproperty (
fk_user_id int8 not null,
propname varchar(255) not null,
propvalue varchar(255),
primary key (fk_user_id, propname)
);
create index propvalue_idx on o_userproperty (propvalue);
alter table o_userproperty add constraint FK4B04D83FD1A80C95 foreign key (fk_user_id) references o_user;

--
-- migrate data from old user table to new userproperty table
-- make sure you get this right the first time, you can not run this twice!
insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'firstName', firstname from o_user where firstname IS NOT NULL AND firstname!='';
alter table o_user drop firstname;

insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'lastName', lastname from o_user where lastname IS NOT NULL AND lastname!='';
alter table o_user drop lastname;

insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'email', email from o_user where email IS NOT NULL AND email!='';
alter table o_user drop email;

insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'birthDay', birthday from o_user where birthday IS NOT NULL;
alter table o_user drop birthday;

insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'gender', gender from o_user where gender IS NOT NULL AND gender!='';
alter table o_user drop gender;

insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'telMobile', telmobile from o_user where telmobile IS NOT NULL AND telmobile!='';
alter table o_user drop telmobile;

insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'telOffice', teloffice from o_user where teloffice IS NOT NULL AND teloffice!='';
alter table o_user drop teloffice;

insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'telPrivate', telprivate from o_user where telprivate IS NOT NULL AND telprivate!='';
alter table o_user drop telprivate;

insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'institutionalUserIdentifier', institutionaluseridentifier from o_user where institutionaluseridentifier IS NOT NULL AND institutionaluseridentifier!='';
alter table o_user drop institutionaluseridentifier;

insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'institutionalName', institutionalname from o_user where institutionalname IS NOT NULL AND institutionalname!='';
alter table o_user drop institutionalname;

insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'institutionalEmail', institutionalemail from o_user where institutionalemail IS NOT NULL AND institutionalemail!='';
alter table o_user drop institutionalemail;

insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'street', street from o_user where street IS NOT NULL AND street!='';
alter table o_user drop street;

insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'extendedAddress', extendedaddress from o_user where extendedaddress IS NOT NULL AND extendedaddress!='';
alter table o_user drop extendedaddress;

insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'poBox', pobox from o_user where pobox IS NOT NULL AND pobox!='';
alter table o_user drop pobox;

insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'zipCode', zipcode from o_user where zipcode IS NOT NULL AND zipcode!='';
alter table o_user drop zipcode;

insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'region', region from o_user where region IS NOT NULL AND region!='';
alter table o_user drop region;

insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'city', city from o_user where city IS NOT NULL AND city!='';
alter table o_user drop city;

insert into o_userproperty (fk_user_id, propname, propvalue) select user_id, 'country', country from o_user where country IS NOT NULL AND country!='';
alter table o_user drop country;
--
-- end user properties migration

-- new table to store the read messages, migrate the read messages from the o_property to the new table
create table o_readmessage (
id int8 not null,
lastmodified timestamp not null,
creationdate timestamp,
identity_id int8 not null,
forum_id int8 not null,
message_id int8 not null,
primary key (id));
create index identity_forum_idx on o_readmessage(identity_id, forum_id);

insert into o_readmessage (id, lastmodified, creationdate, identity_id, forum_id, message_id) select id, lastmodified, creationdate, identity, resourcetypeid, longvalue from o_property where category='rvst';
delete from o_property where category='rvst';

-- end read messages

-- update fontsize to new relative style
update o_user set fontsize = '110' where fontsize = 'large';
update o_user set fontsize = '100' where fontsize = 'normal';
update o_user set fontsize = '90' where fontsize = 'small';
-- end fontsize update
[/code]

OLAT和Moodle的比較

andowson — GMT

今天找到了JGS [i][color=red]good[/color][/i]solutions GmbH一篇比較OLAT和Moodle的文章，[url=http://www.frentix.com/de/olat/docu/OLAT-MOODLE-en.pdf]OLAT-Moodle comparison[/url]，對於想要找Open Source e-Learning Platform的人可以做個參考。

OLAT 5.2.2->5.2.3升級筆記

andowson — GMT

今天花了一整天終於把現有的OLAT由5.2.2升級至5.2.3, 步驟如下:
[code]
cd ~/download
mv olat3 olat-5.2.2
wget http://www.olat.org/downloads/stable/OLAT-5.2.3.zip
unzip OLAT-5.2.3.zip
mv OLAT-5.2.3-PUBLIC-* olat3
cd olat3
sed -e "s/\/usr\/local\/opt\/olat\/olat3/\/home\/andowson\/download\/olat3/g" \
-e "s/\/usr\/local\/opt\/olat\/olatdata/\/home\/andowson\/www\/olatdata/g" \
-e "1,$$s/myolat/andowson/g" \
-e "s/smtp.host=smtp.andowson.com/smtp.host=mail.andowson.com/" \
-e "s/\/usr\/local\/opt\/tomcat/\/var\/tomcat5/g" \
-e "1,$$s/net.sf.hibernate/org.hibernate/g" \
-e "48c\server.modjk.enabled=true" \
-e "86,108d" \
-e "1,$$s/#db/db/g" \
-e "s/instantMessaging.enable=false/instantMessaging.enable=true/" \
-e "s/instantMessaging.server.name=jabber.andowson.com/instantMessaging.server.name=www.andowson.com/" \
-e "s/instantMessaging.generateTestUsers=false/instantMessaging.generateTestUsers=true/" \
-e "s/instantMessaging.db.name=wildfire/instantMessaging.db.name=openfire/" \
-e "s/instantMessaging.db.user=wildfire/instantMessaging.db.user=olat/" \
-e "s/instantMessaging.db.pass=wildfire/instantMessaging.db.pass=olat/" build.properties.default > build.properties
ant install
ant jsmath
sudo /etc/init.d/tomcat stop
mv ~/www/olat /tmp/olat-5.2.2
cp -rf ~/download/olat3/webapp ~/www/olat
cp -rf ~/download/olat3/htdocs/* ~/www/olat
sed -i -e "13c\ <\!-- default session timeout -->" ~/www/olat/WEB-INF/web.xml
rm -rf ~/www/olat/WEB-INF/src
rm -rf ~/www/olat/WEB-INF/patchesSrc
chgrp -R tomcat ~/www/olat
chgrp -R tomcat ~/www/olatdata
chmod 775 ~/www/olat/static
sudo /etc/init.d/tomcat start
[/code]

OLAT 5.2.2 Wiki: exception while rendering component

andowson — GMT

今天試著熟悉一下OLAT的功能, Demo course一個一個去try, 到了Demo course wiki的時候發現無法用Search去新增wiki, 出現下面的錯誤訊息:
[quote]
2007-10-15 00:00:39,911 [TP-Processor17] ERROR Window - OLAT::ERROR ^%^ E1 ^%^ org.olat.core.gui.components ^%^ administrator ^%^ 220.139.220.139 ^%^ http://www.andowson.com/olat/auth/1%3A-1%3A0%3A0%3A0/ ^%^ Mozilla/5.0 (Windows; U; Windows NT 6.0; zh-TW; rv:1.8.1.7) Gecko/20070914 Firefox/2.0.0.7 ^%^ **RedScreen** exception while rendering component 'wikiarticle' (org.olat.core.gui.components.velocity.VelocityContainer) listener:[org.olat.modules.wiki.WikiMainController@14cd198 [cListener:-]]
Message of exception: MethodInvocationException occured while merging template: methName:render, refName:r ::_:: ::_:: ^%^ >>>stack of 1.cause::org.olat.core.logging.OLATRuntimeException: exception while rendering component 'wikiarticle' (org.olat.core.gui.components.velocity.VelocityContainer) listener:[org.olat.modules.wiki.WikiMainController@14cd198 [cListener:-]]
Message of exception: MethodInvocationException occured while merging template: methName:render, refName:r -> at org.olat.core.gui.components.Window.dispatchRequest(Window.java:533) at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:153) at org.olat.core.gui.components.Component.dispatchRequest(Component.java:119) at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:202) at org.olat.core.dispatcher.DispatcherAction.execute(DispatcherAction.java:182) at org.olat.core.servlets.OLATServlet.doPost(OLATServlet.java:137) at org.olat.core.servlets.OLATServlet.doGet(OLATServlet.java:121) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)>>>stack of 2.cause::org.olat.core.logging.OLATRuntimeException: MethodInvocationException occured while merging template: methName:render, refName:r -> at org.olat.core.gui.render.velocity.VelocityHelper.merge(VelocityHelper.java:108) at org.olat.core.gui.render.velocity.VelocityHelper.mergeContent(VelocityHelper.java:124) at org.olat.core.gui.components.velocity.VelocityContainerRenderer.render(VelocityContainerRenderer.java:102) at org.olat.core.gui.render.Renderer.render(Renderer.java:311) at org.olat.core.gui.components.tabbedpane.TabbedPaneRenderer.render(TabbedPaneRenderer.java:138) at org.olat.core.gui.render.Renderer.render(Renderer.java:311) at org.olat.core.gui.render.Renderer.render(Renderer.java:211) at org.olat.core.gui.render.velocity.VelocityRenderDecorator.doRender(VelocityRenderDecorator.java:483) at org.olat.core.gui.render.velocity.VelocityRenderDecorator.render(VelocityRenderDecorator.java:327) at sun.reflect.GeneratedMethodAccessor1419.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)>>>stack of 3.cause::java.lang.StackOverflowError: null -> at java.util.regex.Pattern.isSurrogate(Pattern.java:2850) at java.util.regex.Pattern.isSupplementary(Pattern.java:1733) at java.util.regex.Pattern.newSingle(Pattern.java:2949) at java.util.regex.Pattern.atom(Pattern.java:1985) at java.util.regex.Pattern.sequence(Pattern.java:1885) at java.util.regex.Pattern.expr(Pattern.java:1752) at java.util.regex.Pattern.compile(Pattern.java:1460) at java.util.regex.Pattern.(Pattern.java:1133) at java.util.regex.Pattern.compile(Pattern.java:823) at java.lang.String.replaceAll(String.java:2190) at org.olat.modules.wiki.gui.components.wikiToHtml.FilterUtil.normalizeWikiLink(FilterUtil.java:52)
2007-10-15 00:00:56,075 [TP-Processor10] ERROR syslog - Method render threw exception for reference $r in template org/olat/modules/wiki/_content/article.html at [75,25]
[/quote]
不過在[olat_developers]的mailing-list上已經有發布解決方案了, 就是把附檔下載後解開來, 將五個檔案上傳到OLAT安裝目錄下的/WEB-INF/classes目錄下, 再重新啟動Tomcat即可.

OLAT 5.2.2啟用Instant Messaging功能筆記

andowson — GMT

OLAT學習管理系統可以跟[url=http://www.igniterealtime.org/downloads/index.jsp]Openfire[/url]整合, 提供遵循[url=http://www.jabber.org/]Jabber XMPP[/url]協定的即時訊息功能, 安裝文件及內附的方法主要是針對MySQL的安裝方法, 我在PostgreSQL上試著安裝看看,發現也可以看得到那顆黃色星星,底下是安裝的步驟
[code]
cd ~/download/olat3
sed -i -e "s/instantMessaging.enable=false/instantMessaging.enable=true/" build.properties
sed -i -e "s/instantMessaging.server.name=jabber.andowson.com/instantMessaging.server.name=www.andowson.com/" build.properties
sed -i -e "s/instantMessaging.generateTestUsers=false/instantMessaging.generateTestUsers=ture/" build.properties
sed -i -e "s/instantMessaging.db.name=wildfire/instantMessaging.db.name=openfire/" build.properties
sed -i -e "s/instantMessaging.db.user=wildfire/instantMessaging.db.user=olat/" build.properties
sed -i -e "s/instantMessaging.db.pass=wildfire/instantMessaging.db.pass=olat/" build.properties
ant config-all
cp -rf ~/download/olat3/webapp/WEB-INF/olat_config.xml ~/www/olat/WEB-INF
cd ~/download
wget http://www.igniterealtime.org/downloadServlet?filename=openfire/openfire_3_3_3.tar.gz -O openfire_3_3_3.tar.gz
tar zxvf openfire_3_3_3.tar.gz -C ~
sudo -u postgres psql -c "ALTER USER olat CREATEDB;" template1
sudo -u postgres psql -c "CREATE DATABASE openfire WITH ENCODING 'UNICODE';" -U olat template1
sudo -u postgres psql -c "ALTER USER olat NOCREATEDB;" template1
sudo -u postgres psql openfire olat -f ~/openfire/resources/database/openfire_postgresql.sql
cp ~/download/olat3/conf/openfire.xml ~/openfire/conf
sed -i -e "s/com.mysql.jdbc.Driver/org.postgresql.Driver/" ~/openfire/conf/openfire.xml
sed -i -e "s/mysql/postgresql/g" ~/openfire/conf/openfire.xml
cd ~/openfire/bin
./openfire start
[/code]
接下來我們要先開放防火牆, 讓下面幾個通訊埠可以被存取到:
sudo setup
防火牆設定 -> 執行工具 -> 安全等級： (*) 啟用->自訂
其他連接埠=>9090:tcp 9091:tcp 5222:tcp 5269:tcp 7777:tcp 8080:tcp 8483:tcp 3478:tcp 3479:tcp
確定->確定

開啟瀏覽器連到[url]http://www.andowson.com:9090[/url]
用帳號admin密碼admin登入,修改以下幾項設定
Server Manager -> Server Setting -> Server Name : 127.0.0.1=>www.andowson.com
Registration & Login -> Inband Account Registration -> Disabled
Registration & Login -> Change Password -> Disabled
將~/openfire/bin/openfire中的啟動參數在-server之後加上-Xss256k
重新啟動一次openfire
[code]
./openfire stop
./openfire start
tail -5 ~/openfire/logs/info.log
[/code]
如果可以看到下面的訊息時,就表示啟動完成,可以重新啟動OLAT了
[quote]2007.09.22 12:36:25 Publish-Subscribe domain: pubsub.www.andowson.com
2007.09.22 12:36:25 Started server (unencrypted) socket on port: 5269
2007.09.22 12:36:25 Started plain (unencrypted) socket on port: 5222
2007.09.22 12:36:36 Openfire 3.3.2 [Sep 22, 2007 12:36:36 PM]
2007.09.22 12:36:41 Admin console listening at http://www.andowson.com:9090
[/quote]
[code]
sudo /etc/init.d/tomcat restart
[/code]

參考資料:
http://www.olat.org/docu/install/EnablingTheInstantMessagingComponent.html

OLAT 5.1.3->5.2.2升級筆記

andowson — GMT

今天花了一整天終於把現有的OLAT由5.1.3升級至5.2.2, 步驟如下:
[code]
cd ~/download
mv olat3 olat-5.1.3
wget http://www.olat.org/downloads/stable/OLAT-5.2.2.zip
unzip OLAT-5.2.2.zip
mv OLAT-5.2.2-PUBLIC-* olat3
cd olat3
sed -e "s/\/usr\/local\/opt\/olat\/olat3/\/home\/andowson\/download\/olat3/g" \
-e "s/\/usr\/local\/opt\/olat\/olatdata/\/home\/andowson\/www\/olatdata/g" \
-e "1,$$s/myolat/andowson/g" \
-e "s/smtp.host=smtp.andowson.com/smtp.host=mail.andowson.com/" \
-e "s/\/usr\/local\/opt\/tomcat5/\/var\/tomcat5/g" \
-e "1,$$s/net.sf.hibernate/org.hibernate/g" \
-e "48c\server.modjk.enabled=true" \
-e "86,108d" \
-e "1,$$s/#db/db/g" build.properties.default > build.properties
ant install
ant jsmath
sudo /etc/init.d/tomcat stop
tomcatpid=`ps -ef|grep tomcat|grep java|awk '{print $2}'`
sudo kill -9 $tomcatpid
mv ~/www/olat /tmp/olat-5.1.3
cp -rf ~/download/olat3/webapp ~/www/olat
cp -rf ~/download/olat3/htdocs/* ~/www/olat
sed -i -e "13c\ <\!-- default session timeout -->" ~/www/olat/WEB-INF/web.xml
rm -rf ~/www/olat/WEB-INF/src
rm -rf ~/www/olat/WEB-INF/patchesSrc
chgrp -R tomcat ~/www/olat
chgrp -R tomcat ~/www/olatdata
chmod 775 ~/www/olat/static
cp ~/download/olat3/database/postgresql/alter_5_1_0_to_5_2_0.sql /tmp
sudo psql -U olat olat -f /tmp/alter_5_1_0_to_5_2_0.sql
sudo /etc/init.d/tomcat start
[/code]
參考資料:
http://www.olat.org/docu/install/Upgrading-from-5.1.x-to-5.2.x.html

該選Sakai還是OLAT?

andowson — GMT

edutools.info提供了一個比較一些常見LMS/CMS的工具
[url]http://www.edutools.info/item_list.jsp?pj=4[/url]
可以比較一下[url=http://www.sakaiproject.org]Sakai[/url]和[url=http://www.olat.org]OLAT[/url]

回覆:OLAT安裝筆記

ofather — GMT

這篇文章是google繁體中文中關於OLAT唯一的文章，真是太神奇囉