安道生練功房 - 分享經驗，累積智慧

OLAT學習管理系統可以跟Openfire整合, 提供遵循Jabber XMPP協定的即時訊息功能, 安裝文件及內附的方法主要是針對MySQL的安裝方法, 我在PostgreSQL上試著安裝看看,發現也可以看得到那顆黃色星星,底下是安裝的步驟

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

接下來我們要先開放防火牆, 讓下面幾個通訊埠可以被存取到:
sudo setup
防火牆設定 -> 執行工具 -> 安全等級： (*) 啟用->自訂
其他連接埠=>9090:tcp 9091:tcp 5222:tcp 5269:tcp 7777:tcp 8080:tcp 8483:tcp 3478:tcp 3479:tcp
確定->確定

開啟瀏覽器連到http://www.andowson.com:9090
用帳號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

./openfire stop

./openfire start

tail -5 ~/openfire/logs/info.log

如果可以看到下面的訊息時,就表示啟動完成,可以重新啟動OLAT了

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

sudo /etc/init.d/tomcat restart

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