user macros

https://confluence.atlassian.com/display/DISC/Shared+User+Macros

comment command for confluence

select a.creationdate,a.lastmoddate,b.username from content a ,user_mapping b where a.contenttype='COMMENT' and a.creator=b.user_key and a.creationdate between '2015/9/30' and '2015/10/1'

select count(*),b.username from content a ,user_mapping b where a.contenttype='COMMENT' and a.creator=b.user_key and a.creationdate between '2015/9/30' and '2015/10/1' group by b.username

confluence-comment by author

select a.creationdate,b.username from content a,user_mapping b where a.contenttype='COMMENT' and a.creator=b.user_key and a.creationdate between '2016/4/1' and '2016/4/20' order by creationdate desc

phpBB3

-1down votefavorite

"Sorry but this board is currently unavailable." on each link. What should I do now? -->Delete or rename your /install directory on the server. ldap setting

information

http://www.programmableweb.com/news/63-translation-apis-bing-google-translate-and-google-ajax-language/2013/01/15

https://ctrlq.org/code/19909-google-translate-api

http://www.oxforddictionaries.com/us/

http://www.macmillandictionaries.com/dictionary-online/

http://www.programmableweb.com/category/dictionary/api

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




Confluence-Hardware Spectiction

可參考這個網址的建議:https://confluence.atlassian.com/doc/server-hardware-requirements-guide-30736403.html

Confluence-隱藏footer資訊

Step1:

Step2:註解// 這段語法

Confluence-修改或隱藏Dashboard

Step1:

Step2:

文件類型轉檔

http://www.driveconverter.com/
線上說明可以參考: http://www.driveconverter.com/support/

Confluence-Dashboard調整layout方式EX1

Step1: Edit Site Layouts as shown as below

Step2:

修改下列程式碼

<div class="dashboard-group left">

                  

                    #dashboard_renderGlobalActions("dashboardActionsId", ["system.dashboard"] )

                    #foreach ($webPanel in $webInterfaceManager.getDisplayableWebPanels("atl.dashboard.left", {}))

                        <div class="dashboard-item">

                            $!webPanel.getHtml($req.getParameterMap())

                        </div>

                    #end

                </div>## left

<div class="dashboard-group right">

   $helper.renderConfluenceMacro("{recently-updated-dashboard:dashboard|showProfilePic=true}")

</div>## right

新的程式碼

<div>

$helper.renderConfluenceMacro("{include:DAS:dashboard}")

</div>## right

Confluence-與google analytics結合使用

Step1: 將google 的程式碼複製出來

Step2: 貼至 Custom HTML中的At beginning of the BODY選項，下圖為超連結的控制語法

Ubuntu-更改sources.list

參考下列文章說明 sourcelist
Step1:cp -a /etc/apt/sources.list /etc/apt/sources.list.bak
Step2:rm -rf /etc/apt/sources.list (或是直接改內容)
or
Step3: sudo vi /etc/apt/sources.list
#deb cdrom:[Ubuntu 10.04 LTS _Lucid Lynx_ - Release i386 (20100429)]/ lucid main restricted
# See http://help.ubuntu.com/community/UpgradeNotes for how to upgrade to
# newer versions of the distribution.

deb http://ubuntu.stu.edu.tw/ubuntu/ lucid main restricted
deb-src http://ubuntu.stu.edu.tw/ubuntu/ lucid main restricted

## Major bug fix updates produced after the final release of the
## distribution.
deb http://ubuntu.stu.edu.tw/ubuntu/ lucid-updates main restricted
deb-src http://ubuntu.stu.edu.tw/ubuntu/ lucid-updates main restricted

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team. Also, please note that software in universe WILL NOT receive any
## review or updates from the Ubuntu security team.
deb http://ubuntu.stu.edu.tw/ubuntu/ lucid universe
deb-src http://ubuntu.stu.edu.tw/ubuntu/ lucid universe
deb http://ubuntu.stu.edu.tw/ubuntu/ lucid-updates universe
deb-src http://ubuntu.stu.edu.tw/ubuntu/ lucid-updates universe

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team, and may not be under a free licence. Please satisfy yourself as to
## your rights to use the software. Also, please note that software in
## multiverse WILL NOT receive any review or updates from the Ubuntu
## security team.
deb http://ubuntu.stu.edu.tw/ubuntu/ lucid multiverse
deb-src http://ubuntu.stu.edu.tw/ubuntu/ lucid multiverse
deb http://ubuntu.stu.edu.tw/ubuntu/ lucid-updates multiverse
deb-src http://ubuntu.stu.edu.tw/ubuntu/ lucid-updates multiverse

## Uncomment the following two lines to add software from the ‘backports’
## repository.
## N.B. software from this repository may not have been tested as
## extensively as that contained in the main release, although it includes
## newer versions of some applications which may provide useful features.
## Also, please note that software in backports WILL NOT receive any review
## or updates from the Ubuntu security team.
# deb http://tw.archive.ubuntu.com/ubuntu/ lucid-backports main restricted universe multiverse
# deb-src http://tw.archive.ubuntu.com/ubuntu/ lucid-backports main restricted universe multiverse

## Uncomment the following two lines to add software from Canonical’s
## ‘partner’ repository.
## This software is not part of Ubuntu, but is offered by Canonical and the
## respective vendors as a service to Ubuntu users.
# deb http://archive.canonical.com/ubuntu lucid partner
# deb-src http://archive.canonical.com/ubuntu lucid partner

deb http://ubuntu.stu.edu.tw/ubuntu/ lucid-security main restricted
deb-src http://ubuntu.stu.edu.tw/ubuntu/ lucid-security main restricted
deb http://ubuntu.stu.edu.tw/ubuntu/ lucid-security universe
deb-src http://ubuntu.stu.edu.tw/ubuntu/ lucid-security universe
deb http://ubuntu.stu.edu.tw/ubuntu/ lucid-security multiverse
deb-src http://ubuntu.stu.edu.tw/ubuntu/ lucid-security multiverse

Confluence-如何製作DB備份(將資料匿名)

參考這篇文章說明: db ,依照您所使用的資料庫來調整方式
Step1: 將身分別切換到postgres，使用指令 su - postgres
Step2:pg_dump -U postgres confluenceDB > /tmp/outfile.dump
Step3:createdb -U postgres tempDB
Step4:psql -U username tempDB < outfile.dump
Step5:

update BODYCONTENT set BODY='a';

update CWD_USER set CREDENTIAL='{PKCS5S2}ymGp6ZB7V+CS6xORA4DEDNDnv+RHyLlZl43Rc25gJ+Vw7ZTUGpzxuDhJv7hAgruT';




Confluence-如何指定80 port啟動confluence服務

Step1: 新增confluence_user帳號 (useradd)
Step2: 將此帳號加入到 sudo 群組 : sudo confluence_user sudo
Step3: 切換到confluence_user帳號並執行下列指令啟用confluence 服務

Confluence-如何解決SPAM內容及清除

可參考下列文章說明，目前還沒有實際測試，待實際測試後再與大家分享
https://confluence.atlassian.com/doc/preventing-and-cleaning-up-spam-211651563.html