[[PageOutline]]

= 2009-04-19 =

 * 由於把系統從 Etch 升級到 Lenny, Python 環境因而從 2.4 升級到 2.5, Trac 從 0.10 升級到 0.11, 不管是 trac 舊的設定檔以及 plugin 都不管用了。只好從頭把 Trac Plugin 重裝一次。
 * 設定檔的部分：先用 trac-admin testbed initenv 產生一個全新的範本目錄，然後用 vimdiff 比對有哪些新參數要加進去。
 * Plugin 部分：
   * 首先要注意的是 Trac 0.11 已經把 !TracAccountManager 跟 !TracWebAdmin 納入，因此不可以再裝，否則會有一堆錯誤。
   * [http://trac-hacks.org/wiki/GraphvizPlugin Graphviz Plugin] - 用 graphviz 語法畫圖的擴充套件
{{{
$ w3m "http://trac-hacks.org/changeset/latest/graphvizplugin/0.11-0.7.4?old_path=/&filename=graphvizplugin/0.11-0.7.4&format=zip"
$ unzip unzip graphvizplugin_0.11-0.7.4-r5537.zip
$ cd graphvizplugin/0.11-0.7.4
graphvizplugin/0.11-0.7.4$ sudo python setup.py bdist_egg
graphvizplugin/0.11-0.7.4$ sudo easy_install dist/graphviz-0.7.4-py2.5.egg
}}}
   * [http://trac-hacks.org/wiki/WikiIncludePlugin WikiInclude] - 讓用 ![[WikiInclude(WikiStart)]] 語法來包含其他 Wiki 頁面中的內容
{{{
$ wget "http://trac-hacks.org/attachment/wiki/WikiIncludePlugin/0.11.versions.tbz2?format=raw" -O wikiincludeplugin-0.11.tar.gz
$ tar jxvf wikiincludeplugin-0.11.tar.gz
$ cd 0.11
0.11$ cat > setup.py << EOF
from setuptools import setup

PACKAGE = 'WikiInclude'
VERSION = '0.2'
DESCRIPTION = 'Page include plugin for Trac Wiki'

setup(name=PACKAGE,
      version=VERSION,
      packages=['wikiinclude'],
      entry_points={'trac.plugins': ['wikiinclude.wikiinclude=wikiinclude.wikiinclude']})
EOF
0.11$ sudo python setup.py bdist_egg
0.11$ sudo easy_install dist/WikiInclude-0.2-py2.5.egg
}}}
   * [http://svn.ipd.uni-karlsruhe.de/trac/javaparty/wiki/TracRedirect TracRedirect] - 用 ![[redirect(網址)]] 語法來作頁面自動轉址
{{{
$ svn co http://svn.ipd.uka.de/repos/javaparty/JP/trac/plugins/redirect-0.11/
$ cd redirect-0.11/
redirect-0.11$ sudo python setup.py bdist_egg
redirect-0.11$ sudo easy_install dist/TracRedirect-0.11.3.dev_r3272-py2.5.egg
}}}
   * [http://trac-hacks.org/wiki/SvnAuthzAdminPlugin Svnauthz File Administration Plugin] - 用來管理誰有權限讀取 SVN 目錄的擴充套件
{{{
$ svn co http://trac-hacks.org/svn/svnauthzadminplugin/0.11/ svnauthzadminplugin-0.11
$ cd svnauthzadminplugin-0.11
svnauthzadminplugin-0.11$ sudo python setup.py bdist_egg
svnauthzadminplugin-0.11$ sudo easy_install dist/SvnAuthzAdminPlugin-0.1.2._Moved.to.Trac.0.11_-py2.5.egg
}}}
 * 過去習慣會修改的字型大小
{{{
#!diff
--- /usr/share/pyshared/trac/htdocs/css/trac.css.old        2009-04-19 19:38:06.000000000 +0800
+++ /usr/share/pyshared/trac/htdocs/css/trac.css    2009-04-19 19:37:47.000000000 +0800
@@ -1,6 +1,6 @@
 body { background: #fff; color: #000; margin: 10px; padding: 0; }
 body, th, td {
- font: normal 12px Verdana,Arial,'Bitstream Vera Sans',Helvetica,sans-serif;
+ font: normal 16px Verdana,Arial,'Bitstream Vera Sans',Helvetica,sans-serif;
 }
 h1, h2, h3, h4 {
  font-family: Arial,Verdana,'Bitstream Vera Sans',Helvetica,sans-serif;
}}}
 * 以前的 template 也失效了，要改用 site.html 重新定義 - 參考 [http://trac.edgewall.org/wiki/TracInterfaceCustomization#SiteAppearance Site Appearance]

= 2009-04-23 =

 * 把 /usr/share/pyshared/trac/wiki/default-pages 搬到 /usr/share/pyshared/trac/wiki/default-pages.dpkg，只留下 RecentChanges、TitleIndex、WikiStart 三個預設頁面。

 * 安裝 [http://trac-hacks.org/wiki/AccountManagerPlugin AccountManager] 擴充套件
{{{
$ svn co http://trac-hacks.org/svn/accountmanagerplugin/0.11 TracAccountManager-0.11
$ cd TracAccountManager-0.11/
TracAccountManager-0.11$ sudo python setup.py bdist_egg
TracAccountManager-0.11$ sudo easy_install dist/TracAccountManager-0.2.1dev_r5273-py2.5.egg
}}}

= 2009-05-05 =

 * 參考 [wiki:jazz/08-03-28 2008-03-28] 的紀錄，進行 Cloud 跟 Grid 兩個的 Ticket 攻擊清除。
{{{
~$ sudo sqlite3 /forge/trac_pool/cloud/db/trac.db
sqlite> delete from ticket where id >= 1;
sqlite> delete from ticket_change where time >= 1241185964;
sqlite> .quit
~$ sudo sqlite3 /forge/trac_pool/grid/db/trac.db
sqlite> delete from ticket where id=10;
sqlite> delete from ticket where id=11;
sqlite> delete from ticket where id=12;
sqlite> delete from ticket where id=27;
sqlite> delete from ticket_change where time=1240251436;
sqlite> delete from ticket_change where time=1240007219;
sqlite> delete from ticket_change where time=1240031903;
sqlite> .quit
}}}
 * 由於 0.11 版會把 Timeline 的日期用中文表示，因此如果要自訂 Timeline 顯示的話，會出現錯誤。可能程式邏輯還是衍用 2009-05-05 的格式，因此就在範本加入格式的字串，讓 Form 送出的日期字串可以符合程式邏輯。
{{{
#!sh
"2009年05月05日" is an invalid date, or the date format is not known. Try "YYYY年MM月DD日" instead.
}}} 
{{{
#!diff
--- timeline/templates/timeline.html.org        2009-05-05 12:00:39.000000000 +0800
+++ timeline/templates/timeline.html    2009-05-05 12:03:57.000000000 +0800
@@ -17,7 +17,7 @@

       <form id="prefs" method="get" action="">
        <div>
-        <label>View changes from <input type="text" size="10" name="from" value="${format_date(fromdate)}" /></label> <br />
+        <label>View changes from <input type="text" size="10" name="from" value="${format_date(fromdate,'%Y-%m-%d')}" /></label> <br />
         and <label><input type="text" size="3" name="daysback" value="$daysback" /> days back</label>.
        </div>
        <fieldset>
}}}

= 2009-06-09 =

 * 安裝 [http://piwik piwik] 來統計檔案下載次數
{{{
# apt-get install php5-mysql php5-gd libsparkline-php mysql-server phpmyadmin
# apache2ctl restart
# cd /var/www/
/var/www# wget http://piwik.org/latest.zip
/var/www# unzip latest.zip
/var/www# chown -R www-data:www-data piwik/
}}}
 * 完成設定後，系統會告知如何把像 Google Analytics 的 javascript 加到 HTML 裡
{{{
#!java
<!-- Piwik -->
<script type="text/javascript">
var pkBaseURL = (("https:" == document.location.protocol) ? "https://classcloud.org/piwik/" : "http://classcloud.org/piwik/");
document.write(unescape("%3Cscript src='" + pkBaseURL + "piwik.js' type='text/javascript'%3E%3C/script%3E"));
</script><script type="text/javascript">
try {
var piwikTracker = Piwik.getTracker(pkBaseURL + "piwik.php", 1);
piwikTracker.trackPageView();
piwikTracker.enableLinkTracking();
} catch( err ) {}
</script>
<!-- End Piwik Tag --> 
}}}
 * 安裝 awstats 統計 deb 下載次數
  * 把 /usr/share/doc/awstats/examples/apache.conf 的內容加入 /etc/apache2/sites-enabled/classcloud.conf
{{{
#!sh
<VirtualHost X.X.X.X:80>
  ServerName  www.classcloud.org
  ErrorLog    /var/log/classcloud-error_log
  CustomLog   /var/log/classcloud-access_log common
  DocumentRoot "/var/www/hadoop"
  <Directory "/var/www/hadoop">
    Order deny,allow
    Allow from all
  </Directory>
  <Directory /var/lib/awstats>
    Options None
    AllowOverride None
    Order allow,deny
    Allow from all
  </Directory>
  <Directory /usr/share/awstats/icon>
    Options None
    AllowOverride None
    Order allow,deny
    Allow from all
  </Directory>
  Alias /icon/ /usr/share/awstats/icon/
  ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
  <Directory "/usr/lib/cgi-bin">
    AllowOverride None
    Options ExecCGI -MultiViews +SymLinksIfOwnerMatch
    Order allow,deny
    Allow from all
  </Directory>
</VirtualHost>
}}}
{{{
$ cat > /etc/awstats/awstats.classcloud.org.conf << EOF
LogFile="/var/log/classcloud-access_log"
LogFormat=4
SiteDomain="classcloud.org"
AllowFullYearView=3
EOF
}}}
 * 執行 /usr/lib/cgi-bin/awstats.pl --config=classcloud.org
 * 觀察 http://classcloud.org/cgi-bin/awstats.pl 有沒有內容
 * 目前 hadoop 套件的下載量為 94 而已
  * [[Image(2009-06_hadoop.jpg,width=400)]]

= 2009-07-01 =

 * [備忘] 如果遇到 trac 啟動時出現 '''Database newer than Trac version''' 錯誤訊息，解決方法可參考以下步驟 - [http://trac.edgewall.org/ticket/6300 ticket #6300]
   * Reference: http://use.perl.org/~Beatnik/journal/35866
{{{
jazz@drbl-xen-srv:~$ sudo apt-get install sqlite3
jazz@drbl-xen-srv:~$ sudo sqlite3 /forge/trac_pool/grid/db/trac.db
SQLite version 3.3.8
Enter ".help" for instructions
sqlite> select * from system;
database_version|20
repository_dir|svn:164b2d09-da6f-4c29-9524-243417f19678:/forge/trac_pool/maicl/svnroot
youngest_rev|12
sqlite> update system set value = 19 where name = "database_version";
sqlite> .quit
}}}
 * 例行性安全升級 - [http://www.linux.org.tw/node/671 Debian GNU/Linux "lenny" 第二次穩定版本更新 5.0.2]
{{{
jazz@trac-pool:~$ sudo apt-get upgrade
正在讀取套件清單... 完成
正在重建相依關係
正在讀取狀態資料... 完成
下列套件將會被升級：
  apache2 apache2-mpm-prefork apache2-utils apache2.2-common base-files gnupg gpgv libaprutil1
  libglib2.0-0 libpango1.0-0 libpango1.0-common libxcb-render0 libxcb-xlib0 libxcb-xlib0-dev
  libxcb1 libxcb1-dev linux-image-2.6.26-2-686 phpmyadmin screen tzdata x11-common xutils
升級 22 個，新安裝 0 個，移除 0 個，有 0 個未被升級。
}}}

= 2009-09-06 =

 * 例行性安全升級
{{{
trac-pool:~# apt-get upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be upgraded:
  base-files devscripts dhcp3-client dhcp3-common libcurl3 libmysqlclient15off libperl5.10
  libssl0.9.8 libvolume-id0 linux-image-2.6.26-2-686 linux-libc-dev mysql-client-5.0
  mysql-common mysql-server mysql-server-5.0 openssl perl perl-base perl-modules python-support
  tzdata udev wordpress x11-common xutils
25 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 74.5MB of archives.
After this operation, 1382kB of additional disk space will be used.
Do you want to continue [Y/n]?
}}}

= 2009-11-30 =

 * 例行性安全升級
{{{
trac-pool:~# apt-get upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be upgraded:
  man-db libgnutls26 apache2-utils apache2.2-common apache2-mpm-prefork
  apache2 php5-common php5-cli libapache2-mod-php5 php5-mysql
  php5-mcrypt libgd2-xpm php5-gd libvorbis0a libvorbisenc2
  libvorbisfile3 libvorbis-dev php-pear
18 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
}}}

= 2009-12-04 =

 * 例行性安全升級
{{{
trac-pool:~# apt-get upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be upgraded:
  exim4-config man-db liblockfile1
3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
}}}

= 2010-02-08 =

 * 例行性安全升級
{{{
jazz@trac-pool:~$ sudo apt-get upgrade
正在讀取套件清單... 完成
正在重建相依關係
正在讀取狀態資料... 完成
下列套件將會被升級：
  acpid base-files dhcp3-client dhcp3-common dpkg dpkg-dev gzip libc6 libc6-dev
  libc6-i686 libdbd-mysql-perl libexpat1 libglib2.0-0 libkadm55 libkrb53 libldap-2.4-2
  libldap2-dev libltdl3 libltdl3-dev libmysqlclient15off libpq5 libssl0.9.8 libthai-data
  libthai0 linux-image-2.6.26-2-686 linux-libc-dev locales login mysql-client-5.0
  mysql-common mysql-server mysql-server-5.0 ntpdate openssl passwd python-docutils
  python-roman python2.4 python2.4-dev python2.4-minimal python2.5 python2.5-dev
  python2.5-minimal tzdata usbutils
升級 45 個，新安裝 0 個，移除 0 個，有 0 個未被升級。
需要下載 98.5MB 的套件檔。
此操作完成之後，會多佔用 532kB 的磁碟空間。
是否繼續進行 [Y/n]？
}}}
 * 安裝 minin 監控系統
{{{
jazz@trac-pool:~$ sudo apt-get install munin munin-node
}}}