2016年2月8日 星期一

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








2016年1月7日 星期四

文件類型轉檔

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

2016年1月5日 星期二

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