sql全文檢索的使用說明

--移除全文檢索
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'drop';
GO

--建立全文檢索資訊
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'create', 'tmp', 'PK_100and10';

--Add some columns
EXEC sp_fulltext_column 'tmp','MsgText','add';
-- Activate the full-text index
EXEC sp_fulltext_table 'tmp','activate';
GO
--重建索引資料匣
USE ServerLog;
GO
EXEC sp_fulltext_catalog 'full28', 'rebuild';
GO

--索引狀態確認
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'Start_change_tracking';
EXEC sp_fulltext_table 'tmp', 'Start_background_updateindex';
GO

confluence proxy setting for server url

refer to the document of https://confluence.atlassian.com/doc/configuring-the-server-base-url-148592.html

gradebook setting of quiz

Step1:

Step2:

Step3:設定分數顯示方式

Step4:

Step5:

Step6:

Step7:

Step8: hidden assignment

centos with 80 port confluence setting

refer document : https://confluence.atlassian.com/doc/using-apache-with-mod_proxy-173669.html

apache conf setting

moodle - feedback預覽功能停用

Step1: vi /var/www/html/moodle/mod/feedback/view.php
Step2: 把preview拿掉

moodle-backup and restore

透過下列的工具來備份MOODLE 資料庫

把原本的mooddata資料匣複製到新的電腦，並執行下列指令

ubuntu confluence port change

refer to the document of https://confluence.atlassian.com/doc/using-apache-with-mod_proxy-173669.html
Attached is my example file setting of confluence and apache, please refer to it.
example file

server.xml

ubuntu-remove postgresql and install new version

Step1:將原本confluence資料庫DUMP 出來

(or pg_dump -Fc confluence > /tmp/confluence.backup)

Step2:確認目前安裝那些postgresql

Step3:移除POSTGRESQL

Step4:移除postgresql8.3

Step5: 刪除postgresql 資料匣

Step6:

sudo apt-get install postgresql-9.3

Step7:delete database and create new empty database

Additional information:

$ psql -U postgres 
psql (9.4.4)
Type "help" for help.

postgres=# CREATE ROLE confluence with password 'confluence' LOGIN CREATEDB CREATEROLE VALID UNTIL 'infinity';
postgres=# CREATE DATABASE confluence WITH ENCODING 'utf8' OWNER confluence;
postgres=# \q

改postgres密碼:alter user postgres password 'apassword';

Step8:設定的過程會出現下列錯誤訊息

Step9:修改下列設定檔

Step10:

https://stackoverflow.com/questions/18664074/getting-error-peer-authentication-failed-for-user-postgres-when-trying-to-ge

https://www.liquidweb.com/kb/what-is-the-default-password-for-postgresql/

https://medium.com/@tk512/upgrading-postgresql-from-9-3-to-9-4-on-ubuntu-14-04-lts-2b4ddcd26535

https://askubuntu.com/questions/633919/how-install-postgresql-9-4

https://stackoverflow.com/questions/18664074/getting-error-peer-authentication-failed-for-user-postgres-when-trying-to-ge