上一次剪頭髮，是在十四個月前，既然夏季到了，馬尾巴，再見。
- Jun 07 Wed 2006 19:43
-
短髮
- Jun 03 Sat 2006 19:43
-
MySQL latin1 to UTF-8
在MySQL用latin1儲存big5中文，想改用UTF-8時，可以用 mysqldump備份，再透過iconv轉成UTF-8。但是，如果有用BINARY、VARBINARY、BLOB等資料類型，iconv遇到這些 binary資料會發生錯誤，所以還要用--hex-blob參數，將binary資料輸出成hex格式，再用iconv轉換就不會有問題。
備份：
mysqldump --default-character-set=latin1 --hex-blob dbname > big5.db
轉換：
iconv -f big5 -t utf-8 < big5.db > utf8.db
還原：
mysql dbname < utf8.db
備份：
mysqldump --default-character-set=latin1 --hex-blob dbname > big5.db
轉換：
iconv -f big5 -t utf-8 < big5.db > utf8.db
還原：
mysql dbname < utf8.db
- Dec 04 Sun 2005 19:41
-
鎮西堡、霞喀羅古道
往鎮西堡巨木區登山口的路太難走了，車開進去可能會卡住，放棄。往霞喀羅古道的路況也很差，不過，至少車輪不會空轉，從22km走到16.5km處約兩小時。
- Sep 07 Wed 2005 19:40
-
在Jetty安裝JIRA
下載JIRA：
http://downloads.atlassian.com/software/jira//downloads/atlassian-jira-enterprise-3.3.1.zip
下載程式庫：
http://downloads.atlassian.com/software/jira//downloads/atlassian-jira-enterprise-3.3.1.zip
下載程式庫：
- Jul 29 Fri 2005 19:39
-
Canon EF-S17-85mm F4-5.6入手
鏡頭花了18,700元，保護鏡還是用Marumi，不過這次是67mm防水，一片1,100元。
- Jul 26 Tue 2005 19:38
-
Canon EF24-70mm F2.8L入手
這顆真是好鏡頭，連Marumi 77mm保護鏡一共是40,500元。
- Apr 13 Wed 2005 19:37
-
Minimal Tomcat server.xml
<Server port="8005" shutdown="SHUTDOWN">
<Service name="Catalina">
<Connector port="8080" />
<Engine name="Catalina" defaultHost="localhost">
<Host name="localhost" debug="0" appBase="webapps" >
<Server port="8005" shutdown="SHUTDOWN">
<Context path="/myapp" reloadable="true"
reload="true"
docBase="c:Path_To_My_Application_Web_Base"
workDir="c:Path_To_My_Application_Work_Folder"
debug="0"/>
</Host>
</Engine>
</Service>
</Server>
<Service name="Catalina">
<Connector port="8080" />
<Engine name="Catalina" defaultHost="localhost">
<Host name="localhost" debug="0" appBase="webapps" >
<Server port="8005" shutdown="SHUTDOWN">
<Context path="/myapp" reloadable="true"
reload="true"
docBase="c:Path_To_My_Application_Web_Base"
workDir="c:Path_To_My_Application_Work_Folder"
debug="0"/>
</Host>
</Engine>
</Service>
</Server>
- Feb 25 Fri 2005 19:35
-
OpenSSL憑證製作
mkdir demoCA
mkdir demoCA/certs
mkdir demoCA/crls
mkdir demoCA/newcerts
mkdir demoCA/private
touch demoCA/index.txt
echo 01 > demoCA/serial
# generate private key
openssl genrsa -out demoCA/private/cakey.pem 2048
# generate certificate signing request
openssl req -new -key demoCA/private/cakey.pem -out cacsr.pem
# generate self-signed certificate
openssl req -in cacsr.pem -out cacert.pem -key demoCA/private/cakey.pem -x509 -days 3652
# generate certificate revocation list
openssl ca -gencrl -out demoCA/crl.pem
# convert certificate to DER format
openssl x509 -in demoCA/cacert.pem -inform PEM -out emoCA/cacert.der -outform DER
# convert to pkcs12 format
openssl pkcs12 -export -in demoCA/cacert.pem -inkey emoCA/private/cakey.pem -out cert.p12 -name "Forth Root CA"
# generate certificate signing request
openssl req -new -key mykey.pem -out mycsr.pem
# generate cretificate
openssl ca -in mycsr.pem -out mycert.pem -days 3652 -policy policy_anything
mkdir demoCA/certs
mkdir demoCA/crls
mkdir demoCA/newcerts
mkdir demoCA/private
touch demoCA/index.txt
echo 01 > demoCA/serial
# generate private key
openssl genrsa -out demoCA/private/cakey.pem 2048
# generate certificate signing request
openssl req -new -key demoCA/private/cakey.pem -out cacsr.pem
# generate self-signed certificate
openssl req -in cacsr.pem -out cacert.pem -key demoCA/private/cakey.pem -x509 -days 3652
# generate certificate revocation list
openssl ca -gencrl -out demoCA/crl.pem
# convert certificate to DER format
openssl x509 -in demoCA/cacert.pem -inform PEM -out emoCA/cacert.der -outform DER
# convert to pkcs12 format
openssl pkcs12 -export -in demoCA/cacert.pem -inkey emoCA/private/cakey.pem -out cert.p12 -name "Forth Root CA"
# generate certificate signing request
openssl req -new -key mykey.pem -out mycsr.pem
# generate cretificate
openssl ca -in mycsr.pem -out mycert.pem -days 3652 -policy policy_anything
- Jan 15 Sat 2005 19:34
-
安裝mod_auth_pam2和FreeRADIUS
首先，安裝mod_auth_pam和FreeRADIUS：
cd /usr/ports/www/mod_auth_pam2; make install clean
cd /usr/ports/net/freeradius; make install clean
/etc/rc.conf：
radiusd_enable="YES"
/etc/radius.conf：
auth localhost testing123
cd /usr/ports/www/mod_auth_pam2; make install clean
cd /usr/ports/net/freeradius; make install clean
/etc/rc.conf：
radiusd_enable="YES"
/etc/radius.conf：
auth localhost testing123