<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-8800113</id><updated>2024-10-05T11:58:49.348+08:00</updated><category term="java"/><category term="Windows"/><category term="軟體"/><category term="網路"/><category term="ios"/><category term="Linux"/><category term="mac"/><category term="程式"/><category term="Javascript"/><category term="Database"/><category term="android"/><category term="eclipse"/><category term="單車"/><category term="Cloud"/><category term="Oracle"/><category term="USB、病毒"/><category term="adblock"/><category term="css"/><category term="dot net"/><category term="git"/><category term="groovy"/><category term="html"/><category term="ipad"/><category term="iphone"/><category term="jquery"/><category term="network"/><category term="safari"/><category term="svn"/><category term="test"/><category term="titanium"/><category term="virtualbox"/><category term="vnc"/><category term="vpn"/><category term="web"/><category term="xcode"/><category term="xp"/><category term="環島"/><title type='text'>小虫玩電腦</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default?start-index=26&amp;max-results=25&amp;redirect=false'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>100</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-8800113.post-6671433311212182899</id><published>2022-04-06T06:47:00.005+08:00</published><updated>2022-04-06T06:48:05.512+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ios"/><category scheme="http://www.blogger.com/atom/ns#" term="mac"/><category scheme="http://www.blogger.com/atom/ns#" term="safari"/><title type='text'>Safari 繁簡轉換 Extension</title><content type='html'>&lt;p&gt;最近研究了一下如何開發 Safari Extension，順便實作了 Safari 的繁簡轉換外掛(MacOS/iOS 通用)，並上架到 App Store。&lt;/p&gt;&lt;p&gt;下載位置：https://apps.apple.com/us/app/繁簡通/id1616740784&lt;/p&gt;&lt;p&gt;因為開發者帳號一年要三千四，所以就定價 33 塊錢，看能不能把帳號費賺回來。如果賺不回來，明年可能就不再花錢上架了，哈。不過程式碼也是 Opensource ，有需要的也可以自己 build。&lt;/p&gt;&lt;p&gt;原始碼：https://github.com/scott0228/ZHTranslate&lt;/p&gt;&lt;p&gt;目前是上架&amp;nbsp;SwiftOpenCC 的 branch&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/6671433311212182899/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/6671433311212182899' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/6671433311212182899'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/6671433311212182899'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2022/04/safari-extension.html' title='Safari 繁簡轉換 Extension'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-3314516672520468368</id><published>2022-03-02T20:08:00.002+08:00</published><updated>2022-03-02T20:13:11.291+08:00</updated><title type='text'>iPhone 6 Plus iOS 12.5.5 jailbreak</title><content type='html'>&lt;p&gt;最近因為家裡換了遠x 4G當家用網路，而遠x 會在尖峰時刻鎖網路速度，只對 speedtest 不鎖，因此想說利用舊的 iPhone 6 Plus /iOS 12.5.5 來定時去連線一下 speedtest 讓他解鎖速度。&lt;/p&gt;&lt;p&gt;使用的軟體如下：&lt;/p&gt;&lt;p&gt;&lt;/p&gt;&lt;ul style=&quot;text-align: left;&quot;&gt;&lt;li&gt;xcode：用來產生 provision&amp;nbsp;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;https://dantheman827.github.io/ios-app-signer/&quot; target=&quot;_blank&quot;&gt;ios-app-signer&lt;/a&gt;：重簽 unc0ver.ipa 的工具&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;https://unc0ver.dev/&quot; target=&quot;_blank&quot;&gt;unc0ver&lt;/a&gt;：jailbreak 的工具，我是用 &lt;a href=&quot;https://unc0ver.dev/downloads/7.0.0/48073ecf35dcf43d0607ec779079e8a4d69e90c2/unc0ver_Release_7.0.0.ipa&quot;&gt;7.0.0&lt;/a&gt; 版本。&lt;br /&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;https://github.com/libimobiledevice/ideviceinstaller&quot;&gt;ideviceinstaller&lt;/a&gt;：將 ipa 安裝到手機上的工具。&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;https://cydia.hbang.ws&quot;&gt;NewTerm 2&lt;/a&gt;：iOS 上的終端機工具介面&lt;/li&gt;&lt;li&gt;curl：命令模式下的 web client&lt;/li&gt;&lt;/ul&gt;&lt;div&gt;詳細怎麼 JB 我就不細說了，不過要注意的是如果 jb 失敗，可以重開機後再試。&lt;/div&gt;&lt;div&gt;另外，curl/wget 不知道為什麼在 iOS 上會預設使用 IPv6 的協定，造成卡住無法使用。&lt;/div&gt;&lt;div&gt;強制使用 IPv4 就沒問題了.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;下面是我把 curl 做成服務，讓它每兩個小時執行一次&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;p&gt;&lt;/p&gt;&lt;p&gt;&lt;/p&gt;
&lt;script src=&quot;https://gist.github.com/scott0228/8c8ab519f28bcc07f9b138f97137d7c0.js&quot;&gt;&lt;/script&gt;

啟動服務：
&lt;br /&gt;launchctl unload /Library/LaunchDaemons/idv.scott.speedtest.plist
&lt;br /&gt;launchctl load /Library/LaunchDaemons/idv.scott.speedtest.plist&amp;nbsp;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;查看狀態：
&lt;br /&gt;launchctl print system/idv.scott.speedtest.plist
&lt;br /&gt;launchctl list|grep idv.scott.speedtest.plist&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/3314516672520468368/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/3314516672520468368' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/3314516672520468368'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/3314516672520468368'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2022/03/iphone-6-plus-ios-1255-jailbreak.html' title='iPhone 6 Plus iOS 12.5.5 jailbreak'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-6441103228567447397</id><published>2022-01-26T08:45:00.001+08:00</published><updated>2022-02-11T11:43:22.941+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ios"/><category scheme="http://www.blogger.com/atom/ns#" term="iphone"/><category scheme="http://www.blogger.com/atom/ns#" term="軟體"/><title type='text'>Mobile Safari 簡繁轉換</title><content type='html'>&lt;p&gt;iOS 15 後，Safari 支援 Extension，而最近發現&amp;nbsp;&lt;a href=&quot;https://apps.apple.com/us/app/userscripts/id1463298887&quot;&gt;Userscripts&lt;/a&gt; 支援 iOS 的 safari，立馬裝來試試。&lt;/p&gt;&lt;p&gt;之前同文堂有提供繁簡轉換的 js ，但是對於動態的內容不會自動即時轉換，因此我就調整了一下，針對動態插入畫面的內容也進行轉換。&lt;/p&gt;&lt;p&gt;主要是加上：document.addEventListener(&quot;DOMNodeInserted&quot;, convert_trad, true); 來處理動態內容。&amp;nbsp;&amp;nbsp;&lt;/p&gt;&lt;p&gt;設定後，就不用再去看殘體字了，這個 script 沒有對用詞進行轉換，不過對我來說已經夠用了。&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;a href=&quot;https://apps.apple.com/us/app/userscripts/id1463298887&quot;&gt;Userscripts&lt;/a&gt; 可以使用 icloud 當放 js 的目錄，因此可以利用 icloud 來同步電腦上的 script。 &lt;/p&gt;&lt;p&gt;2022/02/11 Update&amp;nbsp;&lt;/p&gt;&lt;p&gt;優化動態內容轉換處理方式，改用 MutationObserver 來處理，避免造成 Google docs 操作異常。&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;

&lt;script src=&quot;https://gist.github.com/scott0228/c7d1c41a7aa39a981336700cc6028f84.js&quot;&gt;&lt;/script&gt;</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/6441103228567447397/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/6441103228567447397' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/6441103228567447397'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/6441103228567447397'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2022/01/mobile-safari.html' title='Mobile Safari 簡繁轉換'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-7267661538087797697</id><published>2022-01-22T13:24:00.002+08:00</published><updated>2022-01-22T13:24:13.588+08:00</updated><title type='text'>設定 iPhone 假的 GPS 位置</title><content type='html'>&lt;p&gt;&amp;nbsp;&lt;code&gt;libimobiledevice 是一個與 iDevice 溝通的工具包，裡面包含了不少好用的工具，而今天我要用的是設定 iDevice GPS 的工具：idevicesetlocation&lt;/code&gt;&lt;/p&gt;&lt;p&gt;&lt;code&gt;&lt;br /&gt;&lt;/code&gt;&lt;/p&gt;&lt;p&gt;&lt;code&gt;安裝方式：&lt;/code&gt;&lt;/p&gt;&lt;p&gt;&lt;code&gt;&lt;span&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;&lt;/span&gt;brew install libimobiledevice&lt;br /&gt;&lt;/code&gt;&lt;/p&gt;&lt;p&gt;&lt;code&gt;使用方式：&lt;/code&gt;&lt;/p&gt;&lt;p&gt;&lt;code&gt;iPhone 接上電腦後，執行：&lt;/code&gt;&lt;/p&gt;&lt;p&gt;&lt;code&gt;&lt;span&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;&lt;/span&gt;idevicesetlocation -- 24.986901945818218 121.53703021237283&lt;br /&gt;&lt;/code&gt;&lt;/p&gt;&lt;pre class=&quot;highlight&quot;&gt;&lt;code&gt;&lt;span class=&quot;c&quot;&gt;後面的兩個數字，前面是緯度(Latitude)，後面是經度(Longitude)，執行完後，裝置上的位置就會移到該地方。&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;&lt;pre class=&quot;highlight&quot;&gt;&lt;code&gt;&lt;span class=&quot;c&quot;&gt;重置方式：&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;&lt;pre class=&quot;highlight&quot;&gt;&lt;code&gt;&lt;span class=&quot;c&quot;&gt;&lt;code class=&quot;hljs css&quot;&gt;&lt;span class=&quot;hljs-selector-tag&quot;&gt;&lt;span&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;&lt;/span&gt;idevicesetlocation&lt;/span&gt; &lt;span class=&quot;hljs-selector-tag&quot;&gt;reset&lt;/span&gt;&lt;/code&gt;&amp;nbsp;&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;&lt;pre class=&quot;highlight&quot;&gt;&lt;code&gt;&lt;span class=&quot;c&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;&lt;pre class=&quot;highlight&quot;&gt;&lt;code&gt;&lt;span class=&quot;c&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;&lt;p&gt;&lt;code&gt;&lt;/code&gt;&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/7267661538087797697/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/7267661538087797697' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/7267661538087797697'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/7267661538087797697'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2022/01/iphone-gps.html' title='設定 iPhone 假的 GPS 位置'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-4446644723810921360</id><published>2020-03-29T10:05:00.001+08:00</published><updated>2020-04-18T11:27:09.024+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="adblock"/><category scheme="http://www.blogger.com/atom/ns#" term="Cloud"/><category scheme="http://www.blogger.com/atom/ns#" term="ios"/><title type='text'>利用免費資源 Oracle Cloud / AdGuard Home / Surge 在手機上擋廣告</title><content type='html'>&lt;br /&gt;
&lt;br /&gt;
最近看到 AdGuard Home 可以架 DNS Server 來擋廣告，又發現 Surge 可以改 iOS 行動網路連線的 DNS，因此想到利用 Oracle Cloud 的免費 vpc 來搭建相關服務來擋手機上的廣告。&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
環境準備：　&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;&lt;a href=&quot;https://www.oracle.com/index.html&quot; target=&quot;_blank&quot;&gt;Oracle Cloud&lt;/a&gt;&amp;nbsp;: 建立免費的虛擬主機&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://github.com/AdguardTeam/AdGuardHome&quot; target=&quot;_blank&quot;&gt;AdGuard Home&lt;/a&gt;&amp;nbsp;: 搭邁擋廣告的 DNS Server &lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://apps.apple.com/tw/app/surge-4/id1442620678&quot; rel=&quot;nofollow&quot; target=&quot;_blank&quot;&gt;Surge&lt;/a&gt;&amp;nbsp;: 調整 iOS 的網路 DNS 設定&lt;/li&gt;
&lt;/ul&gt;
&lt;h2&gt;
Oracle Cloud&lt;/h2&gt;
我是採用 ubuntu 的 image, 建立完用，可以利用 ubuntu 帳號 ssh 登入去操作。&lt;br /&gt;
&lt;script src=&quot;https://gist.github.com/scott0228/66fb196fd3c523d9a02fe2fc797d03b8.js?file=設定.sh&quot;&gt;&lt;/script&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;h2&gt;
AdGuard Home&lt;/h2&gt;
可參考『&lt;a href=&quot;https://www.jkg.tw/p2158/&quot; target=&quot;_blank&quot;&gt;是時候裝一套 AdGuard Home 全局擋廣告神器了！&lt;/a&gt;』 進行設定&lt;br /&gt;
我的設定檔如下：　
&lt;script src=&quot;https://gist.github.com/scott0228/66fb196fd3c523d9a02fe2fc797d03b8.js?file=AdGuardHome.yaml&quot;&gt;&lt;/script&gt;&lt;br /&gt;
&lt;h2&gt;
Surge&lt;/h2&gt;
&lt;ol&gt;
&lt;li&gt;設定 DNS ，指到 ubuntu 的 ip&lt;br /&gt;&lt;span id=&quot;goog_835377895&quot;&gt;&lt;/span&gt;&lt;span id=&quot;goog_835377896&quot;&gt;&lt;/span&gt;

&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgD8y6FBVfT9v-IMl516H5htciOuywganKQ_7AxaO1XtSeipfmrCGNT42Z2lNMv5-eYuPnd4n9Hz3BGgL90iqzxLLR7Y1uuNvHBgW0djjr9L31uCvZWLQnpvu1EzFhY7tMyTxMV/s1600/IMG_8642.PNG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;1600&quot; data-original-width=&quot;739&quot; height=&quot;320&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgD8y6FBVfT9v-IMl516H5htciOuywganKQ_7AxaO1XtSeipfmrCGNT42Z2lNMv5-eYuPnd4n9Hz3BGgL90iqzxLLR7Y1uuNvHBgW0djjr9L31uCvZWLQnpvu1EzFhY7tMyTxMV/s320/IMG_8642.PNG&quot; width=&quot;147&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;啟動 Surge&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6IKaEZZMVNhKlIlgGJ5Jw4TgfAufpUXgO0509JTLD6MWe8XvqCsR2Xfs05zqZRLC9q7Mj-mV5C38kG85-b2bf7gJX0piq2pbLyiKn0Fb12Lpl4dkwCoJWsi6TZ7wP5phNVZ92/s1600/%25E5%2595%259F%25E5%258B%2595.jpeg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;1600&quot; data-original-width=&quot;739&quot; height=&quot;320&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6IKaEZZMVNhKlIlgGJ5Jw4TgfAufpUXgO0509JTLD6MWe8XvqCsR2Xfs05zqZRLC9q7Mj-mV5C38kG85-b2bf7gJX0piq2pbLyiKn0Fb12Lpl4dkwCoJWsi6TZ7wP5phNVZ92/s320/%25E5%2595%259F%25E5%258B%2595.jpeg&quot; width=&quot;147&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/li&gt;
&lt;/ol&gt;
&lt;h2&gt;
設定完的成果&lt;/h2&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiju-ax1un7cDQQnLnLiPAlzPF45qsPjZeg2pET6fVugc3HBTYP6UA0jMWdUSOfAvzJ3z4tKXIwRIUSbYPqpy7H7GCIjvkR3ytcZ79lwa7CttaD8JGC9ut0ArhrQlQrvvi8I_E5/s1600/%25E5%258E%25BB%25E5%25BB%25A3%25E5%2591%258A.PNG&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;1600&quot; data-original-width=&quot;739&quot; height=&quot;320&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiju-ax1un7cDQQnLnLiPAlzPF45qsPjZeg2pET6fVugc3HBTYP6UA0jMWdUSOfAvzJ3z4tKXIwRIUSbYPqpy7H7GCIjvkR3ytcZ79lwa7CttaD8JGC9ut0ArhrQlQrvvi8I_E5/s320/%25E5%258E%25BB%25E5%25BB%25A3%25E5%2591%258A.PNG&quot; width=&quot;147&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;h2&gt;
&amp;nbsp;&lt;/h2&gt;
&lt;h2&gt;
&amp;nbsp;&lt;/h2&gt;
&lt;h2&gt;
&amp;nbsp;&lt;/h2&gt;
&lt;h2&gt;
&amp;nbsp;&lt;/h2&gt;
&lt;h2&gt;
&amp;nbsp;&lt;/h2&gt;
&lt;h2&gt;
&amp;nbsp;&lt;/h2&gt;
&lt;h2&gt;
&amp;nbsp;&lt;/h2&gt;
&lt;h2&gt;
&amp;nbsp;&lt;/h2&gt;
各國的 IP CIDR 格式可以參考：&lt;br /&gt;https://github.com/herrbischoff/country-ip-blocks </content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/4446644723810921360/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/4446644723810921360' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/4446644723810921360'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/4446644723810921360'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2020/03/oracle-cloud-adguard-home-surge.html' title='利用免費資源 Oracle Cloud / AdGuard Home / Surge 在手機上擋廣告'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgD8y6FBVfT9v-IMl516H5htciOuywganKQ_7AxaO1XtSeipfmrCGNT42Z2lNMv5-eYuPnd4n9Hz3BGgL90iqzxLLR7Y1uuNvHBgW0djjr9L31uCvZWLQnpvu1EzFhY7tMyTxMV/s72-c/IMG_8642.PNG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-5449306296287234383</id><published>2019-06-09T09:12:00.002+08:00</published><updated>2019-06-09T09:12:29.282+08:00</updated><title type='text'>遠端連線相關工具</title><content type='html'>&lt;ol&gt;
&lt;/ol&gt;
因為偶而需要當工具人幫忙修電腦，因此需要一些連線工具，集中起來以免不時之需。 &lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;&lt;a class=&quot;external-link&quot; href=&quot;http://anydesk.com/remote-desktop&quot; rel=&quot;nofollow&quot;&gt;anydesk&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a class=&quot;external-link&quot; href=&quot;https://wayk.devolutions.net/&quot; rel=&quot;nofollow&quot;&gt;WaykNow&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a class=&quot;external-link&quot; href=&quot;https://sunlogin.oray.com/zh_CN/download&quot; rel=&quot;nofollow&quot;&gt;向日葵遠端&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://www.teamviewer.com/&quot; target=&quot;_blank&quot;&gt;TeamViewer&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a class=&quot;external-link&quot; href=&quot;https://chrome.google.com/webstore/detail/chrome-remote-desktop/gbchcmhmhahfdphkhkmpfmihenigjmpp?hl=zh-TW&quot; rel=&quot;nofollow&quot;&gt;Chrome 遠端桌面&lt;/a&gt; &lt;/li&gt;
&lt;li&gt;&lt;a class=&quot;external-link&quot; href=&quot;http://www.gbridge.com/&quot; rel=&quot;nofollow&quot;&gt;gbridge&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a class=&quot;external-link&quot; href=&quot;http://www.uvnc.com/downloads/ultravnc.html&quot; rel=&quot;nofollow&quot;&gt;Ultra VNC&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;PCAnywhere&lt;/li&gt;
&lt;li&gt;&lt;a class=&quot;external-link&quot; href=&quot;http://www.radmin.tw/download/&quot; rel=&quot;nofollow&quot;&gt;Radmin VIewer&lt;/a&gt;&amp;nbsp;&lt;/li&gt;
&lt;/ol&gt;
SSH &lt;br /&gt;&lt;ol&gt;
&lt;li&gt;&lt;a href=&quot;https://mobaxterm.mobatek.net/&quot; target=&quot;_blank&quot;&gt;mobatek&amp;nbsp;&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a class=&quot;external-link&quot; href=&quot;http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html&quot; rel=&quot;nofollow&quot;&gt;putty&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;br /&gt;&lt;/li&gt;
&lt;/ol&gt;
</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/5449306296287234383/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/5449306296287234383' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/5449306296287234383'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/5449306296287234383'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2019/06/blog-post.html' title='遠端連線相關工具'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-5020478817398977410</id><published>2018-10-07T12:04:00.001+08:00</published><updated>2018-10-10T21:04:45.678+08:00</updated><title type='text'>一些投資相關的網站</title><content type='html'>股票 &lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;&lt;a href=&quot;http://norway.twsthr.info/index.aspx&quot; target=&quot;_blank&quot;&gt;神秘金字塔&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://goodinfo.tw/&quot; target=&quot;_blank&quot;&gt;Goodinfo&lt;/a&gt;&amp;nbsp;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;http://invest.wessiorfinance.com/stockholders.html&quot; target=&quot;_blank&quot;&gt;Alpha168&lt;/a&gt;&amp;nbsp;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://www.wantgoo.com/&quot; target=&quot;_blank&quot;&gt;玩股網&lt;/a&gt;&amp;nbsp;&lt;/li&gt;
&lt;/ul&gt;
基金&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;&lt;a href=&quot;https://www.fundrich.com.tw/&quot; target=&quot;_blank&quot;&gt;基富通&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
買房&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;&lt;a href=&quot;https://www.leju.com.tw/&quot; target=&quot;_blank&quot;&gt;樂居網&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://www.houseplus.tw/&quot; target=&quot;_blank&quot;&gt;好時價&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://pip.moi.gov.tw/V2/Default.aspx&quot; target=&quot;_blank&quot;&gt;內政部不動產資訊平台&lt;/a&gt;&amp;nbsp;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;http://easymap.land.moi.gov.tw/&quot; target=&quot;_blank&quot;&gt;地籍圖資網路便民服務系統&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;/ul&gt;
</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/5020478817398977410/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/5020478817398977410' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/5020478817398977410'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/5020478817398977410'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2018/10/blog-post.html' title='一些投資相關的網站'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-3915268391050234962</id><published>2018-01-27T20:54:00.001+08:00</published><updated>2018-01-27T20:54:50.812+08:00</updated><title type='text'>VSCode 有用的 Extension</title><content type='html'>Visual Studio Code 最近拿來開發 React Native， 記錄一下目前用的 Extension&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;&lt;a href=&quot;https://marketplace.visualstudio.com/items?itemName=formulahendry.auto-complete-tag&quot;&gt;Auto Complete Tag&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;整併了&amp;nbsp; &lt;a href=&quot;https://marketplace.visualstudio.com/items?itemName=formulahendry.auto-close-tag&quot; rel=&quot;noreferrer noopener&quot;&gt;Auto Close Tag&lt;/a&gt; 和 &lt;a href=&quot;https://marketplace.visualstudio.com/items?itemName=formulahendry.auto-rename-tag&quot; rel=&quot;noreferrer noopener&quot;&gt;Auto Rename Tag&lt;/a&gt; &lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://marketplace.visualstudio.com/items?itemName=dzannotti.vscode-babel-coloring&quot;&gt;Babel ES6/ES7&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://marketplace.visualstudio.com/items?itemName=streetsidesoftware.code-spell-checker&quot;&gt;Code Spell Checker&lt;/a&gt;&lt;br /&gt;檢查程式碼是否有拼錯單字&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://marketplace.visualstudio.com/items?itemName=naumovs.color-highlight&quot;&gt;Color Highlight&lt;/a&gt;&lt;br /&gt;色碼顯示出顏色&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://marketplace.visualstudio.com/items?itemName=dbaeumer.vscode-eslint&quot;&gt;ESLint&lt;/a&gt;&amp;nbsp;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://marketplace.visualstudio.com/items?itemName=flowtype.flow-for-vscode&quot;&gt;Flow Language Support&lt;/a&gt;&lt;br /&gt;支援 flow 的程式碼檢查&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://marketplace.visualstudio.com/items?itemName=eamodio.gitlens&quot;&gt;Git Lens&lt;/a&gt;&lt;br /&gt;看目前的程式碼是由誰寫出來的&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://marketplace.visualstudio.com/items?itemName=esbenp.prettier-vscode&quot;&gt;Prettier - Code formatter &lt;/a&gt;&lt;br /&gt;程式碼美化&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://marketplace.visualstudio.com/items?itemName=vsmobile.vscode-react-native&quot;&gt;React Native Tools&lt;/a&gt;&lt;br /&gt;微軟開發的 React Native 開發工具&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://marketplace.visualstudio.com/items?itemName=Shan.code-settings-sync&quot;&gt;Settings Sync&lt;/a&gt;&lt;br /&gt;利用 github 的 Gist 來同步設定&lt;/li&gt;
&lt;/ul&gt;
</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/3915268391050234962/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/3915268391050234962' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/3915268391050234962'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/3915268391050234962'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2018/01/vscode-extension.html' title='VSCode 有用的 Extension'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-3143289237910170780</id><published>2014-09-21T11:02:00.003+08:00</published><updated>2014-09-21T11:02:58.864+08:00</updated><title type='text'>PDF 簡轉繁</title><content type='html'>現在一些技術文件，簡體中文比正體中文多很多，因為實在看不慣簡體字，因此通常會將簡體字轉正體字再看。在瀏灠器上可以使用同文堂， PDF 就沒有可以在瀏灠時直接做繁簡轉換的程式，因此找了一個工具，先把 PDF 內容轉成正體字，再放到 PDF Reader 裡開啟。&lt;br /&gt;
&lt;h1 id=&quot;使用工具環境&quot;&gt;
使用工具環境：&lt;/h1&gt;
&lt;ul&gt;
&lt;li&gt;Mac OSX&lt;/li&gt;
&lt;li&gt;python 2&lt;/li&gt;
&lt;li&gt;easy_install&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;http://brew.sh/&quot;&gt;brew&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://github.com/tjwei/translatePDF&quot;&gt;translatePDF&lt;/a&gt; &lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;&lt;a href=&quot;http://pdfrw.googlecode.com/svn/trunk/&quot;&gt;pdfrw&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;http://sourceforge.net/projects/fonttools/&quot;&gt;fonttools&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://github.com/chardet/chardet&quot;&gt;chardet&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://code.google.com/p/opencc/wiki/Install&quot;&gt;opencc&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://github.com/android/platform_frameworks_base/raw/master/data/fonts/DroidSansFallbackFull.ttf&quot;&gt;DroidSansFallbackFull.ttf&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;h1 id=&quot;安裝步驟&quot;&gt;
安裝步驟&lt;/h1&gt;
&lt;pre class=&quot;prettyprint&quot;&gt;&lt;code class=&quot; hljs bash&quot;&gt;&lt;span class=&quot;hljs-built_in&quot;&gt;sudo&lt;/span&gt; easy_install pdfrw
&lt;span class=&quot;hljs-built_in&quot;&gt;sudo&lt;/span&gt; easy_install fonttools
&lt;span class=&quot;hljs-built_in&quot;&gt;sudo&lt;/span&gt; easy_install chardet
brew install opencc

ruby &lt;span class=&quot;hljs-operator&quot;&gt;-e&lt;/span&gt; &lt;span class=&quot;hljs-string&quot;&gt;&quot;&lt;span class=&quot;hljs-variable&quot;&gt;$(curl -fsSL https://raw.github.com/Homebrew/homebrew/go/install)&lt;/span&gt;”
brew install opencc
sudo mkdir -p /usr/share/fonts/truetype/droid/
sudo curl https://raw.githubusercontent.com/android/platform_frameworks_base/master/data/fonts/DroidSansFallbackFull.ttf -o /usr/share/fonts/truetype/droid/DroidSansFallbackFull.ttf
git clone https://github.com/tjwei/translatePDF.git
cd translatePDF&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;
&lt;h2 id=&quot;在-translatepdf-目錄下執行以下指令即可轉換-pdf-的內容了&quot;&gt;
在 translatePDF 目錄下，執行以下指令即可轉換 pdf 的內容了：&lt;/h2&gt;
&lt;pre class=&quot;prettyprint&quot;&gt;&lt;code class=&quot; hljs avrasm&quot;&gt;python2&lt;span class=&quot;hljs-number&quot;&gt;.7&lt;/span&gt; tpdfrw&lt;span class=&quot;hljs-preprocessor&quot;&gt;.py&lt;/span&gt; /Users/scott/Downloads/Architect&lt;span class=&quot;hljs-preprocessor&quot;&gt;.pdf&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;
&lt;pre class=&quot;prettyprint&quot;&gt;&lt;code class=&quot; hljs avrasm&quot;&gt;&lt;span class=&quot;hljs-preprocessor&quot;&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;
註： &lt;br /&gt;
如 pdf 檔被鎖定的話，是無法轉換的。</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/3143289237910170780/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/3143289237910170780' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/3143289237910170780'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/3143289237910170780'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2014/09/pdf.html' title='PDF 簡轉繁'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-7125866231519020765</id><published>2014-09-05T14:05:00.000+08:00</published><updated>2014-09-05T14:05:00.588+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Database"/><title type='text'>如何追查 SQL Server 的 Deadlock</title><content type='html'>&lt;div&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;/div&gt;
&lt;div class=&quot;markdown-here-wrapper&quot; data-md-url=&quot;https://www.blogger.com/blogger.g?blogID=8800113#editor/target=post;postID=7125866231519020765;onPublishedMenu=posts;onClosedMenu=posts;postNum=0;src=link&quot;&gt;
&lt;div style=&quot;margin: 1.2em 0px !important;&quot;&gt;
最近有個客戶常遇到 SQL Server 的 Deadlock 問題，查了一下，追踨 Deadlock 有兩個做法（實際應該是一樣的）：&lt;/div&gt;
&lt;ol style=&quot;margin: 1.2em 0px; padding-left: 2em;&quot;&gt;
&lt;li style=&quot;margin: 0.5em 0px;&quot;&gt;使用 SQL Server Profiler 去記錄&lt;/li&gt;
&lt;li style=&quot;margin: 0.5em 0px;&quot;&gt;直接下 SQL 新增追踨 &lt;/li&gt;
&lt;/ol&gt;
&lt;h2 id=&quot;-sql-&quot; style=&quot;border-bottom-color: rgb(238, 238, 238); border-bottom-style: solid; border-bottom-width: 1px; font-size: 1.4em; font-weight: bold; margin: 1.3em 0px 1em; padding: 0px;&quot;&gt;
以下是使用 SQL 指令追踨的方法：&lt;/h2&gt;
&lt;ol style=&quot;margin: 1.2em 0px; padding-left: 2em;&quot;&gt;
&lt;li style=&quot;margin: 0.5em 0px;&quot;&gt;建立追踨 Deadlock (假定追踨檔是要存在 D:\DbLog\ 下) &lt;pre style=&quot;font-family: Consolas, Inconsolata, Courier, monospace; font-size: 0.85em; font-size: 1em; line-height: 1.2em; margin: 1.2em 0px;&quot;&gt;&lt;code style=&quot;background-color: #f8f8f8; background: rgb(248, 248, 255); border-bottom-left-radius: 3px; border-bottom-left-radius: 3px; border-bottom-right-radius: 3px; border-bottom-right-radius: 3px; border-top-left-radius: 3px; border-top-left-radius: 3px; border-top-right-radius: 3px; border-top-right-radius: 3px; border: 1px solid rgb(204, 204, 204); border: 1px solid rgb(234, 234, 234); color: #333333; display: block !important; display: block; display: inline; font-family: Consolas, Inconsolata, Courier, monospace; font-size: 0.85em; margin: 0px 0.15em; overflow: auto; padding: 0.5em 0.7em; padding: 0.5em; padding: 0px 0.3em; white-space: pre-wrap; white-space: pre;&quot;&gt; -- 運行下述語句後，每當SQL Server中發生死鎖事件，都會自動往文件e:\DbLog\deadlockdetect.trc 中插入一條記錄。
 -- 定義參數 
 declare @rc int
 declare @TraceID int
 declare @maxfilesize bigint
 set @maxfilesize = 5
 -- 初始化跟蹤 
 exec @rc = sp_trace_create @TraceID output, 0, N&#39;E:\DbLog\deadlockdetect&#39;, @maxfilesize, NULL
 --    此處的e:\dblog\deadlockdetect是文件名（可自行修改），SQL會自動在後面加上.trc的擴展名 
 if (@rc != 0) goto error 
 -- 設置跟蹤事件 
 declare @on bit
 set @on = 1
 --下述語句中的148指的是locks:deadlock graph事件(參見sys.trace_events),12指的是spid列(參見    sys.trace_columns) 
 exec sp_trace_setevent @TraceID, 148, 1, @on
 exec sp_trace_setevent @TraceID, 148, 4, @on
 exec sp_trace_setevent @TraceID, 148, 11, @on
 exec sp_trace_setevent @TraceID, 148, 12, @on
 exec sp_trace_setevent @TraceID, 148, 14, @on
 exec sp_trace_setevent @TraceID, 148, 26, @on
 exec sp_trace_setevent @TraceID, 148, 41, @on
 exec sp_trace_setevent @TraceID, 148, 51, @on
 exec sp_trace_setevent @TraceID, 148, 60, @on
 exec sp_trace_setevent @TraceID, 148, 64, @on
 -- 啟動跟蹤 
 exec sp_trace_setstatus @TraceID, 1
 -- 記錄下跟蹤ID，以備後面使用 
 select TraceID = @TraceID
 goto finish 
 error: 
 select ErrorCode=@rc
 finish: 
 go
&lt;/code&gt;&lt;/pre&gt;
&lt;/li&gt;
&lt;li style=&quot;margin: 0.5em 0px;&quot;&gt;&lt;div style=&quot;margin: 0.5em 0px !important; margin: 1.2em 0px !important;&quot;&gt;
當發生 Deadlock 後，去查看 deadlockdetect.trc 是哪些 SQL 有問題 (結果中的TextData列即以XML的形式返回死鎖的詳細信息。 )  &lt;/div&gt;
&lt;pre style=&quot;font-family: Consolas, Inconsolata, Courier, monospace; font-size: 0.85em; font-size: 1em; line-height: 1.2em; margin: 1.2em 0px;&quot;&gt;&lt;code style=&quot;background-color: #f8f8f8; background: rgb(248, 248, 255); border-bottom-left-radius: 3px; border-bottom-left-radius: 3px; border-bottom-right-radius: 3px; border-bottom-right-radius: 3px; border-top-left-radius: 3px; border-top-left-radius: 3px; border-top-right-radius: 3px; border-top-right-radius: 3px; border: 1px solid rgb(204, 204, 204); border: 1px solid rgb(234, 234, 234); color: #333333; display: block !important; display: block; display: inline; font-family: Consolas, Inconsolata, Courier, monospace; font-size: 0.85em; margin: 0px 0.15em; overflow: auto; padding: 0.5em 0.7em; padding: 0.5em; padding: 0px 0.3em; white-space: pre-wrap; white-space: pre;&quot;&gt; select fn_trace_gettable(&#39;e:\DbLog\deadlockdetect.trc&#39;, 1)
&lt;/code&gt;&lt;/pre&gt;
&lt;/li&gt;
&lt;li style=&quot;margin: 0.5em 0px;&quot;&gt;&lt;div style=&quot;margin: 0.5em 0px !important; margin: 1.2em 0px !important;&quot;&gt;
查詢、暫停和停止服務器端跟蹤&lt;br /&gt;查詢目前有哪些 Traces 正在執行&lt;/div&gt;
&lt;pre style=&quot;font-family: Consolas, Inconsolata, Courier, monospace; font-size: 0.85em; font-size: 1em; line-height: 1.2em; margin: 1.2em 0px;&quot;&gt;&lt;code style=&quot;background-color: #f8f8f8; background: rgb(248, 248, 255); border-bottom-left-radius: 3px; border-bottom-left-radius: 3px; border-bottom-right-radius: 3px; border-bottom-right-radius: 3px; border-top-left-radius: 3px; border-top-left-radius: 3px; border-top-right-radius: 3px; border-top-right-radius: 3px; border: 1px solid rgb(204, 204, 204); border: 1px solid rgb(234, 234, 234); color: #333333; display: block !important; display: block; display: inline; font-family: Consolas, Inconsolata, Courier, monospace; font-size: 0.85em; margin: 0px 0.15em; overflow: auto; padding: 0.5em 0.7em; padding: 0.5em; padding: 0px 0.3em; white-space: pre-wrap; white-space: pre;&quot;&gt; SELECT * FROM sys.traces
&lt;/code&gt;&lt;/pre&gt;
&lt;div style=&quot;margin: 0.5em 0px !important; margin: 1.2em 0px !important;&quot;&gt;
暫停某個 Trace&lt;/div&gt;
&lt;pre style=&quot;font-family: Consolas, Inconsolata, Courier, monospace; font-size: 0.85em; font-size: 1em; line-height: 1.2em; margin: 1.2em 0px;&quot;&gt;&lt;code style=&quot;background-color: #f8f8f8; background: rgb(248, 248, 255); border-bottom-left-radius: 3px; border-bottom-left-radius: 3px; border-bottom-right-radius: 3px; border-bottom-right-radius: 3px; border-top-left-radius: 3px; border-top-left-radius: 3px; border-top-right-radius: 3px; border-top-right-radius: 3px; border: 1px solid rgb(204, 204, 204); border: 1px solid rgb(234, 234, 234); color: #333333; display: block !important; display: block; display: inline; font-family: Consolas, Inconsolata, Courier, monospace; font-size: 0.85em; margin: 0px 0.15em; overflow: auto; padding: 0.5em 0.7em; padding: 0.5em; padding: 0px 0.3em; white-space: pre-wrap; white-space: pre;&quot;&gt; -- 第一個參數表示TraceID,即步驟1中的輸出參數(或是從 sys.traces 查詢得到)。第二個參數表示將狀態改為0，即暫停
 exec sp_trace_setstatus 2, 0
&lt;/code&gt;&lt;/pre&gt;
&lt;div style=&quot;margin: 0.5em 0px !important; margin: 1.2em 0px !important;&quot;&gt;
中止某個 Trace&lt;/div&gt;
&lt;pre style=&quot;font-family: Consolas, Inconsolata, Courier, monospace; font-size: 0.85em; font-size: 1em; line-height: 1.2em; margin: 1.2em 0px;&quot;&gt;&lt;code style=&quot;background-color: #f8f8f8; background: rgb(248, 248, 255); border-bottom-left-radius: 3px; border-bottom-left-radius: 3px; border-bottom-right-radius: 3px; border-bottom-right-radius: 3px; border-top-left-radius: 3px; border-top-left-radius: 3px; border-top-right-radius: 3px; border-top-right-radius: 3px; border: 1px solid rgb(204, 204, 204); border: 1px solid rgb(234, 234, 234); color: #333333; display: block !important; display: block; display: inline; font-family: Consolas, Inconsolata, Courier, monospace; font-size: 0.85em; margin: 0px 0.15em; overflow: auto; padding: 0.5em 0.7em; padding: 0.5em; padding: 0px 0.3em; white-space: pre-wrap; white-space: pre;&quot;&gt; -- 第一個參數表示TraceID,即步驟1中的輸出參數(或是從 sys.traces 查詢得到)。第二個參數表示將狀態改為2，即停止
 exec sp_trace_setstatus 2, 2
&lt;/code&gt;&lt;/pre&gt;
&lt;/li&gt;
&lt;li style=&quot;margin: 0.5em 0px;&quot;&gt;&lt;div style=&quot;margin: 0.5em 0px !important; margin: 1.2em 0px !important;&quot;&gt;
在 Deadlock 的情況下，也可以直接查詢目前正在執行的 SQL&lt;/div&gt;
&lt;pre style=&quot;font-family: Consolas, Inconsolata, Courier, monospace; font-size: 0.85em; font-size: 1em; line-height: 1.2em; margin: 1.2em 0px;&quot;&gt;&lt;code style=&quot;background-color: #f8f8f8; background: rgb(248, 248, 255); border-bottom-left-radius: 3px; border-bottom-left-radius: 3px; border-bottom-right-radius: 3px; border-bottom-right-radius: 3px; border-top-left-radius: 3px; border-top-left-radius: 3px; border-top-right-radius: 3px; border-top-right-radius: 3px; border: 1px solid rgb(204, 204, 204); border: 1px solid rgb(234, 234, 234); color: #333333; display: block !important; display: block; display: inline; font-family: Consolas, Inconsolata, Courier, monospace; font-size: 0.85em; margin: 0px 0.15em; overflow: auto; padding: 0.5em 0.7em; padding: 0.5em; padding: 0px 0.3em; white-space: pre-wrap; white-space: pre;&quot;&gt;SELECT sqltext.TEXT,req.session_id,
 req.status,
 req.command,
 req.cpu_time,
 req.total_elapsed_time,
 s.host_name,
 s.login_time,
 s.login_name
FROM sys.dm_exec_requests req
 CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext
 INNER JOIN sys.dm_exec_sessions s ON req.session_id = s.session_id
where DB_NAME(req.database_id) = &#39;資料庫名稱&#39;
&lt;/code&gt;&lt;/pre&gt;
&lt;/li&gt;
&lt;/ol&gt;
&lt;div style=&quot;font-size: 0em; height: 0; margin: 0; padding: 0;&quot; title=&quot;MDH:PGRpdj7mnIDov5HmnInlgIvlrqLmiLbluLjpgYfliLAgU1FMIFNlcnZlciDnmoQgRGVhZGxvY2sg
5ZWP6aGM77yM5p+l5LqG5LiA5LiL77yM6L+96LioIERlYWRsb2NrIOacieWFqeWAi+WBmuazle+8
iOWvpumam+aHieipsuaYr+S4gOaoo+eahO+8ie+8mjwvZGl2PjxkaXY+MS4g5L2/55SoIFNRTCBT
ZXJ2ZXIgUHJvZmlsZXIg5Y676KiY6YyEPC9kaXY+PGRpdj4yLiDnm7TmjqXkuIsgU1FMIOaWsOWi
nui/vei4qCZuYnNwOzwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+IyMg5Lul5LiL5piv5L2/55So
IFNRTCDmjIfku6Tov73ouKjnmoTmlrnms5XvvJo8L2Rpdj48ZGl2PjEuIOW7uueri+i/vei4qCBE
ZWFkbG9jayAo5YGH5a6a6L+96Lio5qqU5piv6KaB5a2Y5ZyoIEQ6XERiTG9nXCDkuIspJm5ic3A7
PC9kaXY+PGRpdj5gYGA8L2Rpdj48ZGl2PiZuYnNwOyAmbmJzcDsgLS0g6YGL6KGM5LiL6L+w6Kqe
5Y+l5b6M77yM5q+P55W2U1FMIFNlcnZlcuS4reeZvOeUn+atu+mOluS6i+S7tu+8jOmDveacg+iH
quWLleW+gOaWh+S7tmU6XERiTG9nXGRlYWRsb2NrZGV0ZWN0LnRyYyDkuK3mj5LlhaXkuIDmop3o
qJjpjITjgII8L2Rpdj48ZGl2PiZuYnNwOyAmbmJzcDsgLS0g5a6a576p5Y+D5pW4Jm5ic3A7PC9k
aXY+PGRpdj48c3BhbiBjbGFzcz0iQXBwbGUtdGFiLXNwYW4iIHN0eWxlPSJ3aGl0ZS1zcGFjZTpw
cmUiPgk8L3NwYW4+ZGVjbGFyZSBAcmMgaW50PC9kaXY+PGRpdj48c3BhbiBjbGFzcz0iQXBwbGUt
dGFiLXNwYW4iIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUiPgk8L3NwYW4+ZGVjbGFyZSBAVHJhY2VJ
RCBpbnQ8L2Rpdj48ZGl2PjxzcGFuIGNsYXNzPSJBcHBsZS10YWItc3BhbiIgc3R5bGU9IndoaXRl
LXNwYWNlOnByZSI+CTwvc3Bhbj5kZWNsYXJlIEBtYXhmaWxlc2l6ZSBiaWdpbnQ8L2Rpdj48ZGl2
PjxzcGFuIGNsYXNzPSJBcHBsZS10YWItc3BhbiIgc3R5bGU9IndoaXRlLXNwYWNlOnByZSI+CTwv
c3Bhbj5zZXQgQG1heGZpbGVzaXplID0gNTwvZGl2PjxkaXY+PHNwYW4gY2xhc3M9IkFwcGxlLXRh
Yi1zcGFuIiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlIj4JPC9zcGFuPi0tIOWIneWni+WMlui3n+i5
pCZuYnNwOzwvZGl2PjxkaXY+PHNwYW4gY2xhc3M9IkFwcGxlLXRhYi1zcGFuIiBzdHlsZT0id2hp
dGUtc3BhY2U6cHJlIj4JPC9zcGFuPmV4ZWMgQHJjID0gc3BfdHJhY2VfY3JlYXRlIEBUcmFjZUlE
IG91dHB1dCwgMCwgTidFOlxEYkxvZ1xkZWFkbG9ja2RldGVjdCcsIEBtYXhmaWxlc2l6ZSwgTlVM
TDwvZGl2PjxkaXY+PHNwYW4gY2xhc3M9IkFwcGxlLXRhYi1zcGFuIiBzdHlsZT0id2hpdGUtc3Bh
Y2U6cHJlIj4JPC9zcGFuPi0tPHNwYW4gY2xhc3M9IkFwcGxlLXRhYi1zcGFuIiBzdHlsZT0id2hp
dGUtc3BhY2U6cHJlIj4JPC9zcGFuPuatpOiZleeahGU6XGRibG9nXGRlYWRsb2NrZGV0ZWN05piv
5paH5Lu25ZCN77yI5Y+v6Ieq6KGM5L+u5pS577yJ77yMU1FM5pyD6Ieq5YuV5Zyo5b6M6Z2i5Yqg
5LiKLnRyY+eahOaTtOWxleWQjSZuYnNwOzwvZGl2PjxkaXY+PHNwYW4gY2xhc3M9IkFwcGxlLXRh
Yi1zcGFuIiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlIj4JPC9zcGFuPmlmIChAcmMgIT0gMCkgZ290
byBlcnJvciZuYnNwOzwvZGl2PjxkaXY+PHNwYW4gY2xhc3M9IkFwcGxlLXRhYi1zcGFuIiBzdHls
ZT0id2hpdGUtc3BhY2U6cHJlIj4JPC9zcGFuPi0tIOioree9rui3n+i5pOS6i+S7tiZuYnNwOzwv
ZGl2PjxkaXY+PHNwYW4gY2xhc3M9IkFwcGxlLXRhYi1zcGFuIiBzdHlsZT0id2hpdGUtc3BhY2U6
cHJlIj4JPC9zcGFuPmRlY2xhcmUgQG9uIGJpdDwvZGl2PjxkaXY+PHNwYW4gY2xhc3M9IkFwcGxl
LXRhYi1zcGFuIiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlIj4JPC9zcGFuPnNldCBAb24gPSAxPC9k
aXY+PGRpdj48c3BhbiBjbGFzcz0iQXBwbGUtdGFiLXNwYW4iIHN0eWxlPSJ3aGl0ZS1zcGFjZTpw
cmUiPgk8L3NwYW4+LS3kuIvov7Doqp7lj6XkuK3nmoQxNDjmjIfnmoTmmK9sb2NrczpkZWFkbG9j
ayBncmFwaOS6i+S7tijlj4PopotzeXMudHJhY2VfZXZlbnRzKSwxMuaMh+eahOaYr3NwaWTliJco
5Y+D6KaLPHNwYW4gY2xhc3M9IkFwcGxlLXRhYi1zcGFuIiBzdHlsZT0id2hpdGUtc3BhY2U6cHJl
Ij4JPC9zcGFuPnN5cy50cmFjZV9jb2x1bW5zKSZuYnNwOzwvZGl2PjxkaXY+PHNwYW4gY2xhc3M9
IkFwcGxlLXRhYi1zcGFuIiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlIj4JPC9zcGFuPmV4ZWMgc3Bf
dHJhY2Vfc2V0ZXZlbnQgQFRyYWNlSUQsIDE0OCwgMSwgQG9uPC9kaXY+PGRpdj48c3BhbiBjbGFz
cz0iQXBwbGUtdGFiLXNwYW4iIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUiPgk8L3NwYW4+ZXhlYyBz
cF90cmFjZV9zZXRldmVudCBAVHJhY2VJRCwgMTQ4LCA0LCBAb248L2Rpdj48ZGl2PjxzcGFuIGNs
YXNzPSJBcHBsZS10YWItc3BhbiIgc3R5bGU9IndoaXRlLXNwYWNlOnByZSI+CTwvc3Bhbj5leGVj
IHNwX3RyYWNlX3NldGV2ZW50IEBUcmFjZUlELCAxNDgsIDExLCBAb248L2Rpdj48ZGl2PjxzcGFu
IGNsYXNzPSJBcHBsZS10YWItc3BhbiIgc3R5bGU9IndoaXRlLXNwYWNlOnByZSI+CTwvc3Bhbj5l
eGVjIHNwX3RyYWNlX3NldGV2ZW50IEBUcmFjZUlELCAxNDgsIDEyLCBAb248L2Rpdj48ZGl2Pjxz
cGFuIGNsYXNzPSJBcHBsZS10YWItc3BhbiIgc3R5bGU9IndoaXRlLXNwYWNlOnByZSI+CTwvc3Bh
bj5leGVjIHNwX3RyYWNlX3NldGV2ZW50IEBUcmFjZUlELCAxNDgsIDE0LCBAb248L2Rpdj48ZGl2
PjxzcGFuIGNsYXNzPSJBcHBsZS10YWItc3BhbiIgc3R5bGU9IndoaXRlLXNwYWNlOnByZSI+CTwv
c3Bhbj5leGVjIHNwX3RyYWNlX3NldGV2ZW50IEBUcmFjZUlELCAxNDgsIDI2LCBAb248L2Rpdj48
ZGl2PjxzcGFuIGNsYXNzPSJBcHBsZS10YWItc3BhbiIgc3R5bGU9IndoaXRlLXNwYWNlOnByZSI+
CTwvc3Bhbj5leGVjIHNwX3RyYWNlX3NldGV2ZW50IEBUcmFjZUlELCAxNDgsIDQxLCBAb248L2Rp
dj48ZGl2PjxzcGFuIGNsYXNzPSJBcHBsZS10YWItc3BhbiIgc3R5bGU9IndoaXRlLXNwYWNlOnBy
ZSI+CTwvc3Bhbj5leGVjIHNwX3RyYWNlX3NldGV2ZW50IEBUcmFjZUlELCAxNDgsIDUxLCBAb248
L2Rpdj48ZGl2PjxzcGFuIGNsYXNzPSJBcHBsZS10YWItc3BhbiIgc3R5bGU9IndoaXRlLXNwYWNl
OnByZSI+CTwvc3Bhbj5leGVjIHNwX3RyYWNlX3NldGV2ZW50IEBUcmFjZUlELCAxNDgsIDYwLCBA
b248L2Rpdj48ZGl2PjxzcGFuIGNsYXNzPSJBcHBsZS10YWItc3BhbiIgc3R5bGU9IndoaXRlLXNw
YWNlOnByZSI+CTwvc3Bhbj5leGVjIHNwX3RyYWNlX3NldGV2ZW50IEBUcmFjZUlELCAxNDgsIDY0
LCBAb248L2Rpdj48ZGl2PjxzcGFuIGNsYXNzPSJBcHBsZS10YWItc3BhbiIgc3R5bGU9IndoaXRl
LXNwYWNlOnByZSI+CTwvc3Bhbj4tLSDllZ/li5Xot5/ouaQmbmJzcDs8L2Rpdj48ZGl2PjxzcGFu
IGNsYXNzPSJBcHBsZS10YWItc3BhbiIgc3R5bGU9IndoaXRlLXNwYWNlOnByZSI+CTwvc3Bhbj5l
eGVjIHNwX3RyYWNlX3NldHN0YXR1cyBAVHJhY2VJRCwgMTwvZGl2PjxkaXY+PHNwYW4gY2xhc3M9
IkFwcGxlLXRhYi1zcGFuIiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlIj4JPC9zcGFuPi0tIOiomOmM
hOS4i+i3n+i5pElE77yM5Lul5YKZ5b6M6Z2i5L2/55SoJm5ic3A7PC9kaXY+PGRpdj48c3BhbiBj
bGFzcz0iQXBwbGUtdGFiLXNwYW4iIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUiPgk8L3NwYW4+c2Vs
ZWN0IFRyYWNlSUQgPSBAVHJhY2VJRDwvZGl2PjxkaXY+PHNwYW4gY2xhc3M9IkFwcGxlLXRhYi1z
cGFuIiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlIj4JPC9zcGFuPmdvdG8gZmluaXNoJm5ic3A7PC9k
aXY+PGRpdj48c3BhbiBjbGFzcz0iQXBwbGUtdGFiLXNwYW4iIHN0eWxlPSJ3aGl0ZS1zcGFjZTpw
cmUiPgk8L3NwYW4+ZXJyb3I6Jm5ic3A7PC9kaXY+PGRpdj48c3BhbiBjbGFzcz0iQXBwbGUtdGFi
LXNwYW4iIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUiPgk8L3NwYW4+c2VsZWN0IEVycm9yQ29kZT1A
cmM8L2Rpdj48ZGl2PjxzcGFuIGNsYXNzPSJBcHBsZS10YWItc3BhbiIgc3R5bGU9IndoaXRlLXNw
YWNlOnByZSI+CTwvc3Bhbj5maW5pc2g6Jm5ic3A7PC9kaXY+PGRpdj48c3BhbiBjbGFzcz0iQXBw
bGUtdGFiLXNwYW4iIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUiPgk8L3NwYW4+Z288L2Rpdj48ZGl2
PmBgYDwvZGl2PjxkaXY+Mi4g55W255m855SfIERlYWRsb2NrIOW+jO+8jOWOu+afpeeciyBkZWFk
bG9ja2RldGVjdC50cmMg5piv5ZOq5LqbIFNRTCDmnInllY/poYwgKOe1kOaenOS4reeahFRleHRE
YXRh5YiX5Y2z5LulWE1M55qE5b2i5byP6L+U5Zue5q276Y6W55qE6Kmz57Sw5L+h5oGv44CCICkg
Jm5ic3A7PC9kaXY+PGRpdj5gYGA8L2Rpdj48ZGl2PjxzcGFuIGNsYXNzPSJBcHBsZS10YWItc3Bh
biIgc3R5bGU9IndoaXRlLXNwYWNlOnByZSI+CTwvc3Bhbj5zZWxlY3QgZm5fdHJhY2VfZ2V0dGFi
bGUoJ2U6XERiTG9nXGRlYWRsb2NrZGV0ZWN0LnRyYycsIDEpPC9kaXY+PGRpdj5gYGAgJm5ic3A7
ICZuYnNwOzxzcGFuIGNsYXNzPSJBcHBsZS10YWItc3BhbiIgc3R5bGU9IndoaXRlLXNwYWNlOnBy
ZSI+CTwvc3Bhbj48L2Rpdj48ZGl2PjxzcGFuIGNsYXNzPSJBcHBsZS10YWItc3BhbiIgc3R5bGU9
IndoaXRlLXNwYWNlOnByZSI+CTwvc3Bhbj48L2Rpdj48ZGl2PjMuIOafpeipouOAgeaaq+WBnOWS
jOWBnOatouacjeWLmeWZqOerr+i3n+i5pDwvZGl2PjxkaXY+5p+l6Kmi55uu5YmN5pyJ5ZOq5Lqb
IFRyYWNlcyDmraPlnKjln7fooYw8L2Rpdj48ZGl2PmBgYDwvZGl2PjxkaXY+PHNwYW4gY2xhc3M9
IkFwcGxlLXRhYi1zcGFuIiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlIj4JPC9zcGFuPlNFTEVDVCAq
IEZST00gc3lzLnRyYWNlcyZuYnNwOzwvZGl2PjxkaXY+YGBgPC9kaXY+PGRpdj7mmqvlgZzmn5Dl
gIsgVHJhY2U8L2Rpdj48ZGl2PmBgYDwvZGl2PjxkaXY+PHNwYW4gY2xhc3M9IkFwcGxlLXRhYi1z
cGFuIiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlIj4JPC9zcGFuPi0tIOesrOS4gOWAi+WPg+aVuOih
qOekulRyYWNlSUQs5Y2z5q2l6amfMeS4reeahOi8uOWHuuWPg+aVuCjmiJbmmK/lvp4gc3lzLnRy
YWNlcyDmn6XoqaLlvpfliLAp44CC56ys5LqM5YCL5Y+D5pW46KGo56S65bCH54uA5oWL5pS554K6
MO+8jOWNs+aaq+WBnDwvZGl2PjxkaXY+PHNwYW4gY2xhc3M9IkFwcGxlLXRhYi1zcGFuIiBzdHls
ZT0id2hpdGUtc3BhY2U6cHJlIj4JPC9zcGFuPmV4ZWMgc3BfdHJhY2Vfc2V0c3RhdHVzIDIsIDA8
L2Rpdj48ZGl2PmBgYDwvZGl2PjxkaXY+5Lit5q2i5p+Q5YCLIFRyYWNlPC9kaXY+PGRpdj5gYGA8
L2Rpdj48ZGl2PjxzcGFuIGNsYXNzPSJBcHBsZS10YWItc3BhbiIgc3R5bGU9IndoaXRlLXNwYWNl
OnByZSI+CTwvc3Bhbj4tLSDnrKzkuIDlgIvlj4PmlbjooajnpLpUcmFjZUlELOWNs+atpempnzHk
uK3nmoTovLjlh7rlj4Pmlbgo5oiW5piv5b6eIHN5cy50cmFjZXMg5p+l6Kmi5b6X5YiwKeOAgues
rOS6jOWAi+WPg+aVuOihqOekuuWwh+eLgOaFi+aUueeCujLvvIzljbPlgZzmraI8L2Rpdj48ZGl2
PjxzcGFuIGNsYXNzPSJBcHBsZS10YWItc3BhbiIgc3R5bGU9IndoaXRlLXNwYWNlOnByZSI+CTwv
c3Bhbj5leGVjIHNwX3RyYWNlX3NldHN0YXR1cyAyLCAyPC9kaXY+PGRpdj5gYGA8L2Rpdj48ZGl2
Pjxicj48L2Rpdj48ZGl2PjQuIOWcqCBEZWFkbG9jayDnmoTmg4Xms4HkuIvvvIzkuZ/lj6/ku6Xn
m7TmjqXmn6XoqaLnm67liY3mraPlnKjln7fooYznmoQgU1FMPC9kaXY+PGRpdj5gYGA8L2Rpdj48
ZGl2PlNFTEVDVCBzcWx0ZXh0LlRFWFQscmVxLnNlc3Npb25faWQsPC9kaXY+PGRpdj4mbmJzcDsg
Jm5ic3A7IHJlcS5zdGF0dXMsPC9kaXY+PGRpdj4mbmJzcDsgJm5ic3A7IHJlcS5jb21tYW5kLDwv
ZGl2PjxkaXY+Jm5ic3A7ICZuYnNwOyByZXEuY3B1X3RpbWUsPC9kaXY+PGRpdj4mbmJzcDsgJm5i
c3A7IHJlcS50b3RhbF9lbGFwc2VkX3RpbWUsPC9kaXY+PGRpdj4mbmJzcDsgJm5ic3A7IHMuaG9z
dF9uYW1lLDwvZGl2PjxkaXY+Jm5ic3A7ICZuYnNwOyBzLmxvZ2luX3RpbWUsPC9kaXY+PGRpdj4m
bmJzcDsgJm5ic3A7IHMubG9naW5fbmFtZTwvZGl2PjxkaXY+RlJPTSBzeXMuZG1fZXhlY19yZXF1
ZXN0cyByZXE8L2Rpdj48ZGl2PiZuYnNwOyAmbmJzcDsgQ1JPU1MgQVBQTFkgc3lzLmRtX2V4ZWNf
c3FsX3RleHQoc3FsX2hhbmRsZSkgQVMgc3FsdGV4dDwvZGl2PjxkaXY+Jm5ic3A7ICZuYnNwOyBJ
Tk5FUiBKT0lOIHN5cy5kbV9leGVjX3Nlc3Npb25zIHMgT04gcmVxLnNlc3Npb25faWQgPSBzLnNl
c3Npb25faWQ8L2Rpdj48ZGl2PndoZXJlIERCX05BTUUocmVxLmRhdGFiYXNlX2lkKSA9ICfos4fm
lpnluqvlkI3nqLEnPC9kaXY+PGRpdj5gYGA8L2Rpdj48ZGl2PjwvZGl2PjxkaXY+PC9kaXY+&quot;&gt;
​&lt;/div&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/7125866231519020765/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/7125866231519020765' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/7125866231519020765'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/7125866231519020765'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2014/09/sql-server-deadlock.html' title='如何追查 SQL Server 的 Deadlock'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-7483959773310110544</id><published>2014-07-24T21:11:00.001+08:00</published><updated>2014-07-24T21:11:58.220+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="vpn"/><category scheme="http://www.blogger.com/atom/ns#" term="Windows"/><title type='text'>Windows 2008 單一網卡架 VPN Server</title><content type='html'>因為偶而需要去大陸出差，需要一個跳板可以突破 GFW ，之前都是利用 SSH Tunnel ，不過在 ipad 上無法使用，因此找了台主機來架 VPN Server。網路上找到的範例教學大多是利用兩張網卡，研究了好久才知道 Windows 2008 是要怎樣設定，步驟如下：&lt;br /&gt;
&lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;新增路由及遠端存取&lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfVjANQ6mqqoga6czV1tDHCrXl5C0cvvHw0-G2bBrt2p4g9ai-P-cBN-cWRhMT5bVE1iuwSf6j9RyGc8H4BC14fQhXDlkvO6G0inBe3Q802b4d-ia9zxrEJSL2KPa819TOOILW/s1600/2013-12-23_130215.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfVjANQ6mqqoga6czV1tDHCrXl5C0cvvHw0-G2bBrt2p4g9ai-P-cBN-cWRhMT5bVE1iuwSf6j9RyGc8H4BC14fQhXDlkvO6G0inBe3Q802b4d-ia9zxrEJSL2KPa819TOOILW/s1600/2013-12-23_130215.png&quot; height=&quot;474&quot; width=&quot;640&quot; /&gt;&amp;nbsp;&lt;/a&gt; &lt;/li&gt;
&lt;li&gt;選擇自定設定 &lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipeSWZmttA9-_Z4V6vWGWoHAwe2TilVKZasancEYW1wQWk_yr6FnengSMSHpWqt-8uWJHDU-MjxRMcFmneArFQrOekZm1IbM8ETTPLqPbIk7NNL7wWRO_RupAplLoGjv4oMZG2/s1600/2013-12-23_130231.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipeSWZmttA9-_Z4V6vWGWoHAwe2TilVKZasancEYW1wQWk_yr6FnengSMSHpWqt-8uWJHDU-MjxRMcFmneArFQrOekZm1IbM8ETTPLqPbIk7NNL7wWRO_RupAplLoGjv4oMZG2/s1600/2013-12-23_130231.png&quot; height=&quot;474&quot; width=&quot;640&quot; /&gt;&amp;nbsp;&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;選取『VPN存取』及『NAT』&lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjogKneCDkYeggAntOoD1mIGochCJNMVey0_5VQf6rj311iabany86CQxvZ31NxJcTPGYdzK1TGOENqKOa5QasKr6_rOzzkmbVxPJNU14OuniDBGdsHuNuSGohT4cjB-nKgACc8/s1600/2013-12-23_130254.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjogKneCDkYeggAntOoD1mIGochCJNMVey0_5VQf6rj311iabany86CQxvZ31NxJcTPGYdzK1TGOENqKOa5QasKr6_rOzzkmbVxPJNU14OuniDBGdsHuNuSGohT4cjB-nKgACc8/s1600/2013-12-23_130254.png&quot; height=&quot;474&quot; width=&quot;640&quot; /&gt;&amp;nbsp;&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;完成新增&lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWJHz_2jTms-sIgJvPb4TJSfOlmzGJq4uGobQoaZK_mkyXHpQ7PJXWFePt0lh1Twf8_YMIujbWOinXiuYJCX5rQ_lHfAQIel1elWjvOk4HtkIZ3BTAG8W7aGHKLCd3fvaFtFY6/s1600/2013-12-23_130304.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWJHz_2jTms-sIgJvPb4TJSfOlmzGJq4uGobQoaZK_mkyXHpQ7PJXWFePt0lh1Twf8_YMIujbWOinXiuYJCX5rQ_lHfAQIel1elWjvOk4HtkIZ3BTAG8W7aGHKLCd3fvaFtFY6/s1600/2013-12-23_130304.png&quot; height=&quot;474&quot; width=&quot;640&quot; /&gt;&amp;nbsp;&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;設定&amp;nbsp; DHCP 發送位址範圍&lt;br /&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0WQTM4jK8ERhWR0K1HuNT8-AMdSjzuSV_CndGCkITi4RiqB1G0loH1Z4pGfOSQim2cHLktKbDHHObBofPfLvajIdMhDmkDHoZVybp1aAiwuayNkGltQZQWBeShVosFjRCcGEX/s1600/2013-12-23_130425.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0WQTM4jK8ERhWR0K1HuNT8-AMdSjzuSV_CndGCkITi4RiqB1G0loH1Z4pGfOSQim2cHLktKbDHHObBofPfLvajIdMhDmkDHoZVybp1aAiwuayNkGltQZQWBeShVosFjRCcGEX/s1600/2013-12-23_130425.png&quot; height=&quot;474&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;設定 NAT，選取區域連線 &lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJcWZQfKC_91bbfaVTGpStj9LUYTCcAHsBbDTcz1ry5ZwT711ZW9dkoUW1nYt3RtZQne1tMSS72Cl2Uhbl3F6i0QpUv2_36rQXBDy2vzhacJg3q5IJV6V0kjSN3Yw-L7Hmdwxd/s1600/2013-12-23_130450.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJcWZQfKC_91bbfaVTGpStj9LUYTCcAHsBbDTcz1ry5ZwT711ZW9dkoUW1nYt3RtZQne1tMSS72Cl2Uhbl3F6i0QpUv2_36rQXBDy2vzhacJg3q5IJV6V0kjSN3Yw-L7Hmdwxd/s1600/2013-12-23_130450.png&quot; height=&quot;474&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;選取『連線到網際網路的公用介面』及『在這個介面上啟用NAT』&lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqXZRhZSJUIMI5SxAuL_a4kWSNSij_zWLfL_FuqoD8VmPjX5doDIu3-jAnOav5-GVjga7U33kHqxSYxY4C_b-Mn5W3WyVYfzktnR3mZb9YI3ay3hNcWZ0iK1CvdRbGO32pUdXS/s1600/2013-12-23_130512.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqXZRhZSJUIMI5SxAuL_a4kWSNSij_zWLfL_FuqoD8VmPjX5doDIu3-jAnOav5-GVjga7U33kHqxSYxY4C_b-Mn5W3WyVYfzktnR3mZb9YI3ay3hNcWZ0iK1CvdRbGO32pUdXS/s1600/2013-12-23_130512.png&quot; height=&quot;474&quot; width=&quot;640&quot; /&gt;&amp;nbsp;&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;完成後，即可利用 PPTP 的方式 VPN 連線到此台電腦，利用此電腦的網路上網了 &amp;nbsp;
&lt;/li&gt;
&lt;/ol&gt;
</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/7483959773310110544/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/7483959773310110544' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/7483959773310110544'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/7483959773310110544'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2014/07/windows-2008-vpn-server.html' title='Windows 2008 單一網卡架 VPN Server'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfVjANQ6mqqoga6czV1tDHCrXl5C0cvvHw0-G2bBrt2p4g9ai-P-cBN-cWRhMT5bVE1iuwSf6j9RyGc8H4BC14fQhXDlkvO6G0inBe3Q802b4d-ia9zxrEJSL2KPa819TOOILW/s72-c/2013-12-23_130215.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-6631202608377230175</id><published>2014-03-18T21:34:00.002+08:00</published><updated>2014-03-18T21:34:26.040+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ios"/><category scheme="http://www.blogger.com/atom/ns#" term="xcode"/><title type='text'>iOS 7.1 無法利用 http 佈署企業 app</title><content type='html'>目前開發企業內部使用之 app ，iOS 7 之前，用企業 provision 可以將程式打包成 ipa 檔，利用&amp;nbsp;itms-services:// 開頭的網址搭配一個描述檔 (plist) 來安裝 ipa 檔，如&lt;br /&gt;
&lt;span style=&quot;color: #666666;&quot;&gt;itms-services://?action=download-manifest&amp;amp;url=http://www.test.com/app.plist&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
可是到了 iOS 7.1 之後，就會發生：無法安裝應用程式，因為「www.test.com」的憑證無效。&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://stackoverflow.com/questions/20276907/enterprise-app-deployment-doesnt-work-on-ios-7-1&quot;&gt;上網查了一下&lt;/a&gt;，才發現原來 iOS 7.1 之後 plist 檔一定要在認可的 https 協定下載，目前可行的方法有：&lt;br /&gt;
&lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;為網站購買 SSL 憑證，改走 https 的方式進行安裝&lt;/li&gt;
&lt;li&gt;使用 openssl 自簽憑證，iDevice 上要先匯入自簽根憑證才可使用&lt;/li&gt;
&lt;li&gt;將 plist 檔放在別人提供的 https 空間(如 dropbox)，再利用此種模式下載安裝&lt;/li&gt;
&lt;/ol&gt;
&lt;div&gt;
第一種方式就不用講了，第二種方式的處理方式如下：&lt;/div&gt;
&lt;div&gt;
&lt;ol&gt;
&lt;li&gt;產生自簽根金鑰&lt;br /&gt;&lt;span style=&quot;color: #999999;&quot;&gt;openssl genrsa -out myCA.key 2048&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;產生自簽根憑證&lt;br /&gt;&lt;span style=&quot;color: #666666;&quot;&gt;openssl req -x509 -new -key myCA.key -out myCA.cer -days 3650 -subj /CN=&quot;小虫CA&quot;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;產生網站金鑰&lt;br /&gt;&lt;span style=&quot;color: #666666;&quot;&gt;openssl genrsa -out mycert1.key 2048&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;產生 CSR&lt;br /&gt;&lt;span style=&quot;color: #666666;&quot;&gt;openssl req -new -out mycert1.req -key mycert1.key -subj /CN=www.test.com&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;利用自簽根金鑰&lt;br /&gt;&lt;span style=&quot;color: #666666;&quot;&gt;openssl x509 -req -in mycert1.req -out mycert1.cer -CAkey myCA.key -CA myCA.cer -days 365 -CAcreateserial -CAserial serial&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;網站使用 mycert1.key 及 mycert1.cer 來加密，iDevice 先匯入&amp;nbsp;myCA.cer 即可利用 https 連線到網站上了&lt;/li&gt;
&lt;li&gt;再利用以下網址即可進行網路安裝 ipa&lt;br /&gt;&lt;span style=&quot;color: #666666;&quot;&gt;itms-services://?action=download-manifest&amp;amp;url=&lt;/span&gt;&lt;span style=&quot;color: red;&quot;&gt;https&lt;/span&gt;&lt;span style=&quot;color: #666666;&quot;&gt;://www.test.com/app.plist&lt;/span&gt;&lt;/li&gt;
&lt;/ol&gt;
&lt;div&gt;
第三種方式，可以將 plist 放置 Dropbox 上，步驟如下：&lt;/div&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;ol&gt;
&lt;li&gt;將 plist 檔放置 dropbox 下&lt;/li&gt;
&lt;li&gt;取得 plist 檔的分享路徑，如&lt;span style=&quot;color: #666666;&quot;&gt;&lt;br /&gt;https://www.dropbox.com/s/jwwu4p1kctqenva/app.plist&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;將&amp;nbsp;&lt;span style=&quot;color: #666666;&quot;&gt;www.dropbox.com &lt;/span&gt;改為 &lt;span style=&quot;color: #666666;&quot;&gt;dl.dropboxusercontent.com&lt;/span&gt;，如&lt;br /&gt;&lt;span style=&quot;color: #666666;&quot;&gt;https://dl.dropboxusercontent.com/s/jwwu4p1kctqenva/app.plist&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;將 app 安裝的網址改為使用第三點的 link 即可，如：&lt;br /&gt;&lt;span style=&quot;color: #666666;&quot;&gt;itms-services://?action=download-manifest&amp;amp;url=&lt;/span&gt;&lt;span style=&quot;color: red;&quot;&gt;https://dl.dropboxusercontent.com/s/jwwu4p1kctqenva/app.plist&lt;/span&gt;&lt;br /&gt;&lt;/li&gt;
&lt;/ol&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/6631202608377230175/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/6631202608377230175' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/6631202608377230175'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/6631202608377230175'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2014/03/ios-71-http-app.html' title='iOS 7.1 無法利用 http 佈署企業 app'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-8748782780754784338</id><published>2014-01-23T22:01:00.004+08:00</published><updated>2014-01-23T22:01:40.476+08:00</updated><title type='text'>如何在 Genymotion 模擬器上新增 Google Framework</title><content type='html'>新版的 Genymotion 因為版權問題，android 模擬器中不含 Google Framework ，目前有兩種做法：&lt;br /&gt;
Genymotion&amp;nbsp;&amp;nbsp;2.0.0 版後因正式營利，所以 2.0.0 版後的 ova 內不包括有版權的 gapps 及 ARM library，目前的做法有兩種：&lt;br /&gt;
&lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;使用舊版含 gapps 的 ova : 官方載點似乎已經找不到了，要各憑本事找&lt;/li&gt;
&lt;li&gt;在新的 ova vm 中安裝 gapps 及 ARM library&lt;/li&gt;
&lt;/ol&gt;
&lt;div&gt;
安裝步驟如下：&lt;/div&gt;
&lt;div&gt;
&lt;ol&gt;
&lt;li&gt;下載相關檔案：&lt;br /&gt;&lt;a href=&quot;http://goo.gl/JBQmPa&quot;&gt;ARM Translation Installer v1.1&lt;/a&gt;&lt;br /&gt;&lt;a href=&quot;http://goo.im/gapps/gapps-jb-20130813-signed.zip&quot;&gt;Google Apps for Android 4.3&lt;/a&gt;&lt;br /&gt;&lt;a href=&quot;http://goo.im/gapps/gapps-jb-20130812-signed.zip&quot;&gt;Google Apps for Android 4.2&lt;/a&gt;&lt;br /&gt;&lt;a href=&quot;http://goo.im/gapps/gapps-jb-20121011-signed.zip&quot;&gt;Google Apps for Android 4.1&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;開啟 Genymotion 模擬器，解鎖到 home screen&lt;/li&gt;
&lt;li&gt;將 Genymotion-ARM-Translation.zip 拖拉進 vm 的視窗中，進行安裝，裝完後將 vm 重新開機&lt;/li&gt;
&lt;li&gt;將對應的 Gapp檔案拖拉進 vm 中，進行安裝，裝完後再次重開機，就會有 Google play Store 可以使用了。&lt;/li&gt;
&lt;/ol&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
參考：&lt;/div&gt;
&lt;div&gt;
http://forum.gamer.com.tw/C.php?bsn=23805&amp;amp;snA=165002&lt;/div&gt;
&lt;div&gt;
http://stackoverflow.com/questions/17831990/how-do-you-install-google-frameworks-play-accounts-etc-on-a-genymotion-virtu&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/8748782780754784338/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/8748782780754784338' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/8748782780754784338'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/8748782780754784338'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2014/01/genymotion-google-framework.html' title='如何在 Genymotion 模擬器上新增 Google Framework'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-6093658379405734518</id><published>2013-02-03T11:33:00.000+08:00</published><updated>2013-02-03T11:33:12.694+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="android"/><category scheme="http://www.blogger.com/atom/ns#" term="java"/><category scheme="http://www.blogger.com/atom/ns#" term="titanium"/><title type='text'>Titanium sdk 如何利用 andriodvm 來加速測試開發</title><content type='html'>最近利用 Titanium studio 來開發 android app ，發現 android 模擬器真是非常的慢，上網找了一下資料發現 &lt;a href=&quot;http://androvm.org/&quot;&gt;AndroidVM&lt;/a&gt;&amp;nbsp;這個好物，它利用 &lt;a href=&quot;https://www.virtualbox.org/&quot;&gt;VirtualBox&lt;/a&gt; 來執行，整個速度真是快的不得了。&lt;br /&gt;
&lt;br /&gt;
安裝檔案：&lt;br /&gt;
&lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;&lt;a href=&quot;https://www.virtualbox.org/wiki/Downloads&quot;&gt;VirtualBox&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;http://androvm.org/blog/download/&quot;&gt;AndroidVM&lt;/a&gt;&lt;br /&gt;vbox86p : 手機版, 預設解析度 480×800 &lt;br /&gt;vbox86t : Tablet 版，預設解析度 1024×600 &lt;br /&gt;vbox86tp : Tablet 版，但有電話的功能，預設解析度 1024×600 &lt;br /&gt;gapps : 代表包含 Google 相關服務 (有 Google Play) &lt;br /&gt;houdini: 代表包含 Arm emulation (AndroidVM 是跑在 x86 上，所以反過來需要去模擬 Arm)&lt;/li&gt;
&lt;/ol&gt;
&lt;div&gt;
安裝步驟可參考：&lt;a href=&quot;http://www.javaworld.com.tw/roller/ingramchen/entry/android_development_with_androvm&quot;&gt;Android Development with AndroVM&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
那在 Titanium Studio 中要如何直接部署它並且在上面 Debug 呢？&lt;/div&gt;
&lt;div&gt;
首先，連結 androidVM&lt;br /&gt;
&lt;br /&gt;
要修改 Titanium SDK 的 source code：&lt;/div&gt;
&lt;div&gt;
&lt;b style=&quot;color: #333333; font-family: Arial, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 13.328125px;&quot;&gt;~/Library/Application Support/Titanium/mobilesdk/osx/&lt;/b&gt;&lt;b style=&quot;font-family: Arial, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 13.328125px;&quot;&gt;&lt;span style=&quot;color: red;&quot;&gt;2.1.4.GA&lt;/span&gt;&lt;/b&gt;&lt;b style=&quot;color: #333333; font-family: Arial, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 13.328125px;&quot;&gt;/android/builder.py&lt;/b&gt;&lt;/div&gt;
&lt;script src=&quot;https://gist.github.com/cacbce9e96357dc5b4f6.js&quot;&gt;&lt;/script&gt;
將 run_adb(self, *args) 的第三行&amp;nbsp;&lt;span style=&quot;background-color: ghostwhite; color: #999988; font-family: Consolas, &#39;Liberation Mono&#39;, Courier, monospace; font-size: 13px; font-style: italic; line-height: 22px; text-indent: 10px; white-space: pre;&quot;&gt;command.extend(self.device_args) &lt;/span&gt;註解掉，即可利用 Titanium Studio 的 Android Device 功能直接佈署到 device 中進行測試及除錯了。&lt;br /&gt;
如果要查看 AndroidVM 中 Titanium 的 log，可以在 Console 環境下執行：&lt;br /&gt;&lt;span style=&quot;font-family: Consolas, Bitstream Vera Sans Mono, Courier New, Courier, monospace; font-size: x-small;&quot;&gt;&lt;span style=&quot;line-height: 15.1875px; white-space: pre-wrap;&quot;&gt;adb logcat | grep -G &#39;\(TiAPI\)\|\(TiApp\)&#39;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQs1Xox-Qlg0GH96aynKX-i5bn339v1gBxZgAU9KgNQSfOcH49YhkkyVERatoaLebw1gK7oF758XMOHW4lrx7L00W8fppQXti1h98RpUHFhsNj2eVXhFQOyIYKL-IwBBEJkKe2/s1600/2013-02-03_1130.png&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQs1Xox-Qlg0GH96aynKX-i5bn339v1gBxZgAU9KgNQSfOcH49YhkkyVERatoaLebw1gK7oF758XMOHW4lrx7L00W8fppQXti1h98RpUHFhsNj2eVXhFQOyIYKL-IwBBEJkKe2/s1600/2013-02-03_1130.png&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;code class=&quot;bash string&quot; style=&quot;background-image: none !important; border-bottom-left-radius: 0px !important; border-bottom-right-radius: 0px !important; border-top-left-radius: 0px !important; border-top-right-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: rgb(0, 51, 102) !important; float: none !important; font-family: Consolas, &#39;Bitstream Vera Sans Mono&#39;, &#39;Courier New&#39;, Courier, monospace !important; font-size: 13px; height: auto !important; left: auto !important; line-height: 15.1875px; margin: 0px !important; min-height: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre-wrap; width: auto !important;&quot;&gt;&lt;br /&gt;&lt;/code&gt;</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/6093658379405734518/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/6093658379405734518' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/6093658379405734518'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/6093658379405734518'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2013/02/titanium-sdk-andriodvm.html' title='Titanium sdk 如何利用 andriodvm 來加速測試開發'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQs1Xox-Qlg0GH96aynKX-i5bn339v1gBxZgAU9KgNQSfOcH49YhkkyVERatoaLebw1gK7oF758XMOHW4lrx7L00W8fppQXti1h98RpUHFhsNj2eVXhFQOyIYKL-IwBBEJkKe2/s72-c/2013-02-03_1130.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-1559564623356151095</id><published>2013-01-04T23:03:00.000+08:00</published><updated>2013-01-04T23:03:13.476+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="groovy"/><category scheme="http://www.blogger.com/atom/ns#" term="java"/><title type='text'>利用 Groovy + jsoup 來擷取網頁內容</title><content type='html'>今天一位朋有希望我幫它把某人在 yahoo 拍賣上的物品清單抓下來，剛好讓我試試利用 Groovy 及 &lt;a href=&quot;http://jsoup.org/&quot;&gt;jsoup&lt;/a&gt; 來處理：&lt;br /&gt;
&lt;br /&gt;
&lt;script src=&quot;https://gist.github.com/8509315763d8f1ef0d1c.js&quot;&gt;&lt;/script&gt;
參考：&lt;br /&gt;
http://blog.lyhdev.com/2012/12/groovy-jsoup-java-html-parser.html</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/1559564623356151095/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/1559564623356151095' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/1559564623356151095'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/1559564623356151095'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2013/01/groovy-jsoup.html' title='利用 Groovy + jsoup 來擷取網頁內容'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-3927164203889847071</id><published>2012-11-19T08:34:00.000+08:00</published><updated>2012-11-19T08:34:08.551+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="eclipse"/><category scheme="http://www.blogger.com/atom/ns#" term="java"/><category scheme="http://www.blogger.com/atom/ns#" term="mac"/><title type='text'>如何在 OSX 中開啟多個  Eclipse</title><content type='html'>&lt;br /&gt;
在 OSX 環境中，預設 Eclipse 只能開啟一個，當我們需要同時間開啟兩個 workspace 時，就需要以指令的方式去開啟另外一個 Eclipse instance：&lt;br /&gt;
&lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;開啟 Terminal&amp;nbsp;&lt;/li&gt;
&lt;li&gt;切換到 Eclipse 安裝路徑&lt;br /&gt;cd /Application/eclipse&lt;br /&gt;&lt;/li&gt;
&lt;li&gt;下指令開啟 Eclipse&lt;br /&gt;./eclipse &amp;amp;&lt;br /&gt;或是&lt;br /&gt;open -n Eclipse.app&lt;/li&gt;
&lt;/ol&gt;
&lt;br /&gt;
參考：&lt;br /&gt;
http://stackoverflow.com/questions/118243/open-multiple-eclipse-workspaces-on-the-mac</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/3927164203889847071/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/3927164203889847071' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/3927164203889847071'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/3927164203889847071'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2012/11/osx-eclipse.html' title='如何在 OSX 中開啟多個  Eclipse'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-5865235605194250041</id><published>2012-07-25T19:41:00.000+08:00</published><updated>2012-07-25T19:54:01.597+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="mac"/><title type='text'>如何利用 script 來自動切換 OSX 的網路位置</title><content type='html'>OSX 有個很方便的功能，可以針對不同的網路環境設定位置 profile，利用切換網路位置來快速調整網路設定。雖然說很方便，但是，每次都要進到網路設定去改，還是有點麻煩。&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVO0nHSon2DYRJXxDDDAWYWThjkelU8mBY0tryhK6KF5fi8wI-G2nPRnURWq_di8s1sGR4J3FnLVVbptuQ3XbwGacYrUUHDrJVzviWCSrk7T_i5tQU6PcnrmgREwPQUcU9XRoy/s1600/ishot-1.png&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVO0nHSon2DYRJXxDDDAWYWThjkelU8mBY0tryhK6KF5fi8wI-G2nPRnURWq_di8s1sGR4J3FnLVVbptuQ3XbwGacYrUUHDrJVzviWCSrk7T_i5tQU6PcnrmgREwPQUcU9XRoy/s1600/ishot-1.png&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;span style=&quot;background-color: white;&quot;&gt;還好 OSX 有指令可以用來調整，因此我們可以利用指令取得目前使用的無線網路 SSID 來辨斷要切換到哪個網路位置去：&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;script src=&quot;https://gist.github.com/3175681.js?file=autolocation.sh&quot;&gt;
&lt;/script&gt;

參考：&lt;br /&gt;
http://hints.macworld.com/article.php?story=2005010613401823&lt;br /&gt;
http://stackoverflow.com/questions/4481005/get-wireless-ssid-through-shell-script-on-mac-os-x</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/5865235605194250041/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/5865235605194250041' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/5865235605194250041'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/5865235605194250041'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2012/07/script-osx.html' title='如何利用 script 來自動切換 OSX 的網路位置'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVO0nHSon2DYRJXxDDDAWYWThjkelU8mBY0tryhK6KF5fi8wI-G2nPRnURWq_di8s1sGR4J3FnLVVbptuQ3XbwGacYrUUHDrJVzviWCSrk7T_i5tQU6PcnrmgREwPQUcU9XRoy/s72-c/ishot-1.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-3936064682380475787</id><published>2012-06-29T09:42:00.001+08:00</published><updated>2012-06-29T09:42:12.116+08:00</updated><title type='text'>如何開啟 Mac OS X 的 tftp server</title><content type='html'>執行以下兩個指令就會啟動 OSX 內建的 tftp server 了：&lt;br /&gt;
&lt;br /&gt;
sudo launchctl load -F /System/Library/LaunchDaemons/tftp.plist&lt;br /&gt;
sudo launchctl start com.apple.tftpd&lt;br /&gt;
&lt;br /&gt;
tftp 預設的文件目錄為：&lt;br /&gt;
/private/tftpboot&lt;br /&gt;
&lt;br /&gt;
可以修改&amp;nbsp;/System/Library/LaunchDaemons/tftp.plist 來改變目錄位置(要重啟 tftp server)。&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://www.weezey.com/2011/07/using-os-x-built-in-tftp-server.html&quot;&gt;參考來源&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/3936064682380475787/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/3936064682380475787' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/3936064682380475787'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/3936064682380475787'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2012/06/mac-os-x-tftp-server.html' title='如何開啟 Mac OS X 的 tftp server'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-983748664844044239</id><published>2012-03-03T21:42:00.000+08:00</published><updated>2012-03-03T21:42:11.036+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ios"/><category scheme="http://www.blogger.com/atom/ns#" term="ipad"/><title type='text'>iPhone 如何利用 socks proxy 上網(不需 jailbreak)</title><content type='html'>&lt;span style=&quot;font-size: small;&quot;&gt;iPhone iPad 本身上網的設定並沒有可以利用 socks proxy 的方式，所以我們可以利用自動組態檔的方式來處理，方法如下：&lt;/span&gt;&lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;&lt;span style=&quot;font-size: small;&quot;&gt;在電腦(如 &lt;span style=&quot;color: red;&quot;&gt;192.168.11.1&lt;/span&gt;)建立一個 socks proxy ，如利用 ssh：&lt;br /&gt;&lt;code&gt;ssh -N -g -D &lt;span style=&quot;color: blue;&quot;&gt;1080&lt;/span&gt; 某主機ip&lt;/code&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;font-size: small;&quot;&gt;&lt;code&gt;在一台 web server 上放置一各自動組態檔，內容如下：&lt;br /&gt;function FindProxyForURL(url, host) {&lt;br /&gt;　　return &quot;SOCKS &lt;/code&gt;&lt;span style=&quot;color: red;&quot;&gt;192.168.11.1&lt;/span&gt;&lt;code&gt;:&lt;span style=&quot;color: blue;&quot;&gt;1080&lt;/span&gt;&quot;;&lt;br /&gt;}&lt;br /&gt;紅字的部份是對應 proxy 主機的 ip&lt;/code&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;font-size: small;&quot;&gt;&lt;code&gt;在 iphone 上使用此自動組態檔即可，如：&lt;br /&gt;http://192.168.11.1/mysupersecretproxy.pac&lt;/code&gt;&lt;/span&gt;&lt;/li&gt;
&lt;/ol&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;參考：&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;http://snipplr.com/view/16563/how-to-connect-to-a-socks-proxy-from-an-unjailbroken-iphoneipod-touch/&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;http://thireus.dareyourmind.net/index.php/thireus-home-news/8-general-announcement/112-pac--ssh-tunneling--iphone--success-&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;http://thireus.dareyourmind.net/index.php/iphone-hacks/115-how-to-get-socks-proxy-ssh-tunneling-to-work-on-a-jailbroken-iphoneipod-touchipad&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/983748664844044239/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/983748664844044239' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/983748664844044239'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/983748664844044239'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2012/03/iphone-socks-proxy-jailbreak.html' title='iPhone 如何利用 socks proxy 上網(不需 jailbreak)'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-6903477974743077440</id><published>2011-09-23T11:53:00.001+08:00</published><updated>2011-09-23T11:53:23.664+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="git"/><category scheme="http://www.blogger.com/atom/ns#" term="mac"/><category scheme="http://www.blogger.com/atom/ns#" term="svn"/><title type='text'>Git 與 subversion 透過 http proxy</title><content type='html'>小弟公司對外都要透過 proxy 才能存取，而我又常需要抓取外部 svn 或 github 中的程式碼下來參考，因此研究了一下如何設定 proxy 讓 git 與 svn 使用。&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
環境：&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;MacBook Pro with OSX Lion 10.7.1&lt;/li&gt;
&lt;li&gt;svn, version 1.6.16&lt;/li&gt;
&lt;li&gt;git version 1.7.4.4&lt;/li&gt;
&lt;/ul&gt;
Subversion&lt;br /&gt;
&lt;br /&gt;
編輯 ~/.subversion/servers 檔案，設定 globe 的&amp;nbsp;http-proxy-host 與&amp;nbsp;http-proxy-port&lt;br /&gt;
&lt;textarea clas=&quot;code&quot; style=&quot;height: 82px; margin-bottom: 2px; margin-left: 2px; margin-right: 2px; margin-top: 2px; width: 639px;&quot;&gt;http-proxy-exceptions = 10.60.36.157
http-proxy-host = 10.60.36.146
http-proxy-port = 3128
&lt;/textarea&gt;&lt;br /&gt;
在 svn checkout 時改用 http 或 https 協定即可：&lt;br /&gt;
svn checkout &lt;span class=&quot;Apple-style-span&quot; style=&quot;color: red;&quot;&gt;http&lt;/span&gt;://flot.googlecode.com/svn/trunk/ flot-read-only&lt;br /&gt;
&lt;br /&gt;
Git&lt;br /&gt;
&lt;br /&gt;
設定好環境變數 http_proxy 與 https_proxy 即可。&lt;br /&gt;
&lt;textarea clas=&quot;code&quot; style=&quot;height: 53px; margin-bottom: 2px; margin-left: 2px; margin-right: 2px; margin-top: 2px; width: 640px;&quot;&gt;export http_proxy=http://10.60.36.146:3128
export https_proxy=http://10.60.36.146:3128
&lt;/textarea&gt;
&lt;br /&gt;
&lt;br /&gt;
在 git clone 時改用 http 或 https 協定即可：&lt;br /&gt;
&lt;br /&gt;
git clone &lt;span class=&quot;Apple-style-span&quot; style=&quot;color: red;&quot;&gt;http&lt;/span&gt;://github.com/carlhuda/janus.git ~/.vim&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
參考&lt;br /&gt;
http://realchecko.blogspot.com/2007/05/git-over-http-proxy.html&lt;br /&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/6903477974743077440/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/6903477974743077440' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/6903477974743077440'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/6903477974743077440'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2011/09/git-subversion-http-proxy.html' title='Git 與 subversion 透過 http proxy'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-5566377632113232401</id><published>2011-09-23T11:35:00.004+08:00</published><updated>2011-09-23T11:36:02.887+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="virtualbox"/><title type='text'>利用 VirtualBox 附的 VBoxManage 將vmdk/vhd轉換為VDI格式</title><content type='html'>&lt;b&gt;VBoxManage&lt;/b&gt; clonehd source.vmdk target.vdi --format VDI&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-weight: normal;&quot;&gt;clonehd : 告訴 VBoxManage 要複制虛擬硬碟檔案&lt;/span&gt;&lt;/b&gt;&lt;/li&gt;
&lt;li&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-weight: normal;&quot;&gt;source.vmdk : 來源檔案&lt;/span&gt;&lt;/b&gt;&lt;/li&gt;
&lt;li&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-weight: normal;&quot;&gt;target.vdi&amp;nbsp;: 目地檔案&lt;/span&gt;&lt;/b&gt;&lt;/li&gt;
&lt;li&gt;--format VDI : 指定目地檔案的格式，來源檔案的格式似乎會自動判斷&amp;nbsp;&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
轉換完後就可以在 virtualbox 中建立新的虛擬環境，並使用 target.vdi 進行開機使用了。&lt;/div&gt;
&lt;br /&gt;
參考：&lt;br /&gt;
&amp;nbsp; &amp;nbsp; http://blog.tenyi.com/2009/12/convert-from-vmdkvhd-to-vdi-format.html
&lt;br /&gt;
&amp;nbsp; &amp;nbsp; http://nfolamp.wordpress.com/2010/06/10/converting-vmdk-files-to-vdi-using-vboxmanage/</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/5566377632113232401/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/5566377632113232401' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/5566377632113232401'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/5566377632113232401'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2011/09/virtualbox-vboxmanage-vmdkvhdvdi.html' title='利用 VirtualBox 附的 VBoxManage 將vmdk/vhd轉換為VDI格式'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-6116092408220883278</id><published>2011-09-09T16:59:00.000+08:00</published><updated>2011-09-09T17:02:01.454+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="css"/><category scheme="http://www.blogger.com/atom/ns#" term="html"/><category scheme="http://www.blogger.com/atom/ns#" term="web"/><title type='text'>CSS 解決網頁連續英數字文字太長而導致版面撐大的問題</title><content type='html'>一直以來，當網頁遇到連續的英文數字時，總是會無法斷行造成版面被撐大，以前的做法都是在文章中插入 br
來強制換行，今天終於找到利用 css 就可以控制版本並強制換行了。&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://www.minwt.com/?p=93&quot;&gt;一開始找到的方式&lt;/a&gt;是在 css 加上&lt;br /&gt;
&lt;pre class=&quot;code&quot;&gt;	word-wrap: break-word;
	word-break: break-all;
&lt;/pre&gt;
&lt;br /&gt;
&lt;br /&gt;
結果發現在 Internet Explorer 上是 ok 的，在 Firefox 上是無效的。&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://www.cnblogs.com/analyzer/articles/1285732.html&quot;&gt;後來又找到另外一個方法&lt;/a&gt;，在 css 上加上：&lt;br /&gt;
&lt;pre class=&quot;code&quot;&gt;	word-wrap:break-word;
	word-break:break-all;
	-moz-binding: url(&#39;./wordwrap.xml#wordwrap&#39;);
	overflow: hidden;
&lt;/pre&gt;
&lt;br /&gt;
然後再利用 wordwrap.xml 來處理：&lt;br /&gt;
&lt;textarea class=&quot;code&quot; cols=&quot;100&quot; rows=&quot;180&quot;&gt;&amp;lt;?xml version = &quot;1.0&quot;?&amp;gt;

&amp;lt;bindings xmlns = &quot;http://www.mozilla.org/xbl&quot; xmlns:html = &quot;http://www.w3.org/1999/xhtml&quot;&amp;gt;

&amp;lt;binding id = &quot;wordwrap&quot; applyauthorstyles = &quot;false&quot;&amp;gt;

     &amp;lt;implementation&amp;gt;
         &amp;lt;constructor&amp;gt;
             //&amp;lt;![CDATA[
            
             var elem = this;

             elem.addEventListener(&#39;overflow&#39;,
                 function()
                 {
                     var exp = /&amp;lt;​\/*[​_\s=&quot;&#39;\w]+&amp;gt;/g;
                    
                     var txt = elem.innerHTML;
                     var chars = txt.split(&#39;&#39;);
                     var newTxt = chars.join(&#39;​&#39;);                    
                     newTxt = newTxt.replace(exp, reconstructTag);                    
                     elem.innerHTML = newTxt;
                 },false);
                
                 function reconstructTag(_tag)
                 {
                     return _tag.replace(/​/g, &#39;&#39;);
                 }

             //]]&amp;gt;
         &amp;lt;/constructor&amp;gt;
     &amp;lt;/implementation&amp;gt;
&amp;lt;/binding&amp;gt;

&amp;lt;/bindings&amp;gt;
&amp;lt;!-- Web2 --&amp;gt;
&lt;/textarea&gt;
&lt;br /&gt;
結果發現這個方式 firefox 最新版本已經不能用了。&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://hacks.mozilla.org/2009/06/word-wrap/&quot;&gt;最後找到的方法&lt;/a&gt;，在 css 上加上：&lt;br /&gt;
&lt;pre class=&quot;code&quot;&gt;	word-wrap:break-word; 
	overflow: auto;
	width: 600px;
&lt;/pre&gt;
&lt;br /&gt;
&lt;br /&gt;
這樣 ie 與 firefox 都能使用了。&lt;br /&gt;
範例：
&lt;textarea class=&quot;code&quot; cols=&quot;100&quot; rows=&quot;10&quot;&gt;&amp;lt;div style=&quot;width: 600px;overflow: auto; word-wrap: break-word;&quot; &amp;gt;data:text/html;charset=utf-8;base64,Q29uZ3JhdHVsYXRpb25zISBZb3UndmUgZm91bmQgdGhlIGhpZGRlbiBtZXNzYWdlIQ0KDQpUbyBjbGFpbSB5b3VyIHByaXplLCB2aXNpdCBodHRwOi8vZ2V0ZmlyZWZveC5jb20gdG9kYXkhDQoNCkZyZWUgYnJvd3NlciBpbiBldmVyeSBib3ghDQo%3D&amp;lt;/div&amp;gt;
&lt;/textarea&gt;
結果
&lt;br /&gt;
&lt;div style=&quot;overflow: auto; width: 600px; word-wrap: break-word;&quot;&gt;
data:text/html;charset=utf-8;base64,Q29uZ3JhdHVsYXRpb25zISBZb3UndmUgZm91bmQgdGhlIGhpZGRlbiBtZXNzYWdlIQ0KDQpUbyBjbGFpbSB5b3VyIHByaXplLCB2aXNpdCBodHRwOi8vZ2V0ZmlyZWZveC5jb20gdG9kYXkhDQoNCkZyZWUgYnJvd3NlciBpbiBldmVyeSBib3ghDQo%3D&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
參考：
&lt;br /&gt;
http://www.minwt.com/?p=93&lt;br /&gt;
http://www.cnblogs.com/analyzer/articles/1285732.html&lt;br /&gt;
http://blog.longwin.com.tw/2008/06/css_word_wrap_fix_too_many_word_2008/&lt;br /&gt;
http://hacks.mozilla.org/2009/06/word-wrap/</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/6116092408220883278/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/6116092408220883278' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/6116092408220883278'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/6116092408220883278'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2011/09/css.html' title='CSS 解決網頁連續英數字文字太長而導致版面撐大的問題'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-7440157258227878549</id><published>2011-09-01T23:05:00.002+08:00</published><updated>2011-09-01T23:05:48.105+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="android"/><category scheme="http://www.blogger.com/atom/ns#" term="vnc"/><title type='text'>如何利用 vnc 控制 android 手機</title><content type='html'>小弟平常都是電腦利用手機來上網，最近一直在想，是不是有辦法從電腦控制手機，這樣就不用在電腦與手機中間換來換去，後來發現一個好東西：&lt;a href=&quot;https://market.android.com/details?id=org.onaips.vnc&quot;&gt;Droid Vnc Server&lt;/a&gt;，一個在 android 上執行的 vnc server ，安裝後就可以利用 vnc client 或是 browser 來控制手機了。&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-size: large;&quot;&gt;使用方式：&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
安裝完後，直接點選程式清單中的 droid VNC server &lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnDxdhfpmjjvt0eKjKTf07S5qkSZ2DFdOT-OeDSNCZfQSCOxKvbW8bF6SCKrF9-T16HCq121W5EpPgnES1e_5k_fxXfkOoPUk4JalzaEvUHL5ENUxEm6j-CkF4ucH2YQrpWvAF/s1600/2011-09-01_223909.png&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnDxdhfpmjjvt0eKjKTf07S5qkSZ2DFdOT-OeDSNCZfQSCOxKvbW8bF6SCKrF9-T16HCq121W5EpPgnES1e_5k_fxXfkOoPUk4JalzaEvUHL5ENUxEm6j-CkF4ucH2YQrpWvAF/s1600/2011-09-01_223909.png&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;進入之後&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHGEusxgEzDrzc2kWS0k9niCj3jCAvneW_pEN7iRz9BAnxp_M9LGASKqsMVE7IMA_xQsp9ICP_Pg5ppuJ1464vZDPEE_Zo9EXr7qPp14CtqYl2XtDeUTp83gYV3DSQ_z4Be4kl/s1600/screenshot.png&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHGEusxgEzDrzc2kWS0k9niCj3jCAvneW_pEN7iRz9BAnxp_M9LGASKqsMVE7IMA_xQsp9ICP_Pg5ppuJ1464vZDPEE_Zo9EXr7qPp14CtqYl2XtDeUTp83gYV3DSQ_z4Be4kl/s1600/screenshot.png&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
先按 menu 進行設定 vnc 密碼： &lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZa_bfPuduWdLc673_BfgkrMy6KhJAXTX7NTUrwqs7yKxVeYy98tAzsuaPBDnc2UNLi59rpVgWNxCI11AZJ8Yy-0ChFKBqStSS4OITrg_pXycNGHsFcRKSiAPK5LQR-Fltyzld/s1600/2011-09-01_224310.png&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZa_bfPuduWdLc673_BfgkrMy6KhJAXTX7NTUrwqs7yKxVeYy98tAzsuaPBDnc2UNLi59rpVgWNxCI11AZJ8Yy-0ChFKBqStSS4OITrg_pXycNGHsFcRKSiAPK5LQR-Fltyzld/s1600/2011-09-01_224310.png&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&amp;nbsp;設定 vnc 密碼：&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEio3fQolOngxPaaRWxMY6H63OVH6zStnyeqQUnBVxV2YLsC65g-9Ai856ThZ-mV7xmAFqs0hJrXd9Q4mPIsgVDXYtJP4QGV-Ka_DYl5z_-DyAVONFfkqM4p7HNQmTb9-2PD0l-7/s1600/2011-09-01_224324.png&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEio3fQolOngxPaaRWxMY6H63OVH6zStnyeqQUnBVxV2YLsC65g-9Ai856ThZ-mV7xmAFqs0hJrXd9Q4mPIsgVDXYtJP4QGV-Ka_DYl5z_-DyAVONFfkqM4p7HNQmTb9-2PD0l-7/s1600/2011-09-01_224324.png&quot; /&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
設定完密碼後，就可以啟動 server 了。&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhK5HcjYpgk5FrZ4zz3WGQlo_YetIvy4fuLJIHZMpN9vTgUBtPwNdG4y7S2KkdpOORwKTjZ5MYuGxbwHRBxLQ2DYZO_O_mDO13zQ7I2A2F-_wrRcn2EhhsBmN1Zjc0J7Hr-M0rx/s1600/2011-09-01_225359.png&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhK5HcjYpgk5FrZ4zz3WGQlo_YetIvy4fuLJIHZMpN9vTgUBtPwNdG4y7S2KkdpOORwKTjZ5MYuGxbwHRBxLQ2DYZO_O_mDO13zQ7I2A2F-_wrRcn2EhhsBmN1Zjc0J7Hr-M0rx/s1600/2011-09-01_225359.png&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
如上圖，啟動完 server 後，便會出現 vnc 的連線資訊，可以利用 vnc client 連到 192.168.43.1:5901 或是利用 browser (必需安裝好 java 環境)連到 http://192.168.43.1:5801 即可控制手機了。&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVIQvIZGQbvU7FE8EyP1GrA31azYJmJUA6daHQx6TuWYaQQSBZEsFBURUPAT9hw1p5scrJeXglYZ8Ht0GfhRqP9r9PGdus3I_W4S-Ja4l7FMZftQWnGmuzHiCz4IjTda5vYX0Z/s1600/2011-09-01_225748.png&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVIQvIZGQbvU7FE8EyP1GrA31azYJmJUA6daHQx6TuWYaQQSBZEsFBURUPAT9hw1p5scrJeXglYZ8Ht0GfhRqP9r9PGdus3I_W4S-Ja4l7FMZftQWnGmuzHiCz4IjTda5vYX0Z/s1600/2011-09-01_225748.png&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGuURZrD5iFifZ5Se2OnkDtfcTe8rNhsl1dRICf8h4scuPGBtNsvD4BKhqUDcWK2JXuD_qI7iWWgwV2Qk_B_cz2HCkiZT47oVppt9JDtKzzgq119WND9XDJ-a0R4S9MPkgJt3p/s1600/2011-09-01_225806.png&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGuURZrD5iFifZ5Se2OnkDtfcTe8rNhsl1dRICf8h4scuPGBtNsvD4BKhqUDcWK2JXuD_qI7iWWgwV2Qk_B_cz2HCkiZT47oVppt9JDtKzzgq119WND9XDJ-a0R4S9MPkgJt3p/s1600/2011-09-01_225806.png&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;另外，因為 vnc 沒有手機上的 home 鍵及 menu 鍵，因此直接由鍵盤上的按鍵來代替：&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;滑鼠右鍵 = home&lt;/li&gt;
&lt;li&gt;Home = home&lt;/li&gt;
&lt;li&gt;Page Up = menu&lt;/li&gt;
&lt;li&gt;  Page down = call&lt;/li&gt;
&lt;li&gt;Esc = back&lt;/li&gt;
&lt;li&gt; Del = back&lt;/li&gt;
&lt;li&gt;End = phone sleep&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
參考資料&lt;br /&gt;
&lt;br /&gt;
http://opensourceexcedio.wordpress.com/2010/10/28/droid-vnc-server/&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/7440157258227878549/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/7440157258227878549' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/7440157258227878549'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/7440157258227878549'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2011/09/vnc-android.html' title='如何利用 vnc 控制 android 手機'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnDxdhfpmjjvt0eKjKTf07S5qkSZ2DFdOT-OeDSNCZfQSCOxKvbW8bF6SCKrF9-T16HCq121W5EpPgnES1e_5k_fxXfkOoPUk4JalzaEvUHL5ENUxEm6j-CkF4ucH2YQrpWvAF/s72-c/2011-09-01_223909.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-8203828734545313174</id><published>2011-08-24T08:34:00.008+08:00</published><updated>2011-08-24T18:09:04.490+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Linux"/><category scheme="http://www.blogger.com/atom/ns#" term="network"/><title type='text'>如何在 Archlinux 下安裝 ATHEROS AR8151/AR8152 網路卡驅動程式</title><content type='html'>小弟使用的 Linux 版本為：Archlinux 2010.05 ，因為這個版本內建並不支援 ATHEROS AR8151/AR8152 網路卡，而 &lt;a href=&quot;https://wiki.archlinux.org/index.php/Acer_Aspire_5745g&quot;&gt;archlinux 的官方文件也說明不支援&lt;/a&gt;，因此需要自行編譯。  其步驟如下： &lt;br /&gt;
&lt;ol&gt;&lt;li&gt;首先，要先下載 &lt;a href=&quot;http://code.google.com/p/kyosls/downloads/detail?name=AR81Family-linux-v1.0.1.14.tar.gz&amp;amp;can=2&amp;amp;q=&quot;&gt;AR81Family-Linux-v1.0.1.14.tar.gz &lt;/a&gt;。&lt;br /&gt;
&lt;span style=&quot;font-weight: bold;&quot;&gt;wget http://kyosls.googlecode.com/files/AR81Family-linux-v1.0.1.14.tar.gz&lt;/span&gt; &lt;/li&gt;
&lt;li&gt;解壓縮 &lt;span style=&quot;font-weight: bold;&quot;&gt;&lt;br /&gt;
tar -xzvf AR81Family-linux-v1.0.1.14.tar.gz ./&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;到 src 目錄編譯並安裝(編譯安裝的驅動位於/lib/modules/版本-generic/kernel/drivers/net/atl1e 目錄下)&lt;br /&gt;
&lt;span style=&quot;font-weight: bold;&quot;&gt;cd src&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-weight: bold;&quot;&gt;make install&lt;/span&gt; &lt;/li&gt;
&lt;li&gt;找入驅動&lt;br /&gt;
&lt;span style=&quot;font-weight: bold;&quot;&gt;modprobe atl1e&lt;/span&gt; &lt;/li&gt;
&lt;li&gt;查看是否正確&lt;br /&gt;
&lt;span style=&quot;font-weight: bold;&quot;&gt;lsmod|grep atl1e&lt;/span&gt;&lt;br /&gt;
正常的話可以看到&lt;br /&gt;
atl1e                  57012  0&lt;br /&gt;
&lt;span style=&quot;font-weight: bold;&quot;&gt;dmesg|grep Network&lt;/span&gt;&lt;br /&gt;
正常的話可以看到&lt;br /&gt;
Atheros(R) AR8121/AR8113/AR8114/AR8131/AR8132/AR8152 PCI-E Ethernet Network Driver - version 1.0.1.14 &lt;/li&gt;
&lt;li&gt;啟動 eth0&lt;br /&gt;
&lt;span style=&quot;font-weight: bold;&quot;&gt;ifconfig eth0 up&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;如果一切都正常，再把 atl1e 加上 /etc/rc.conf 的 modules 中即可。 &lt;/li&gt;
&lt;/ol&gt;如果在第三步驟 make 時發生：Linux kernel source not configured:missing autoconf.h  &lt;br /&gt;
解決方式為：&lt;br /&gt;
&lt;div style=&quot;font-weight: bold;&quot;&gt;cd /usr/src/版本/include/linux&lt;br /&gt;
ln -s ../generated/autoconf.h .&lt;br /&gt;
ln -s ../generated/utsrelease.h .&lt;/div&gt;&lt;div style=&quot;font-weight: bold;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;參考資料&lt;br /&gt;
http://blog.csdn.net/maosanwan/article/details/6059826&lt;br /&gt;
http://code.google.com/p/kyosls/downloads/list </content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/8203828734545313174/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/8203828734545313174' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/8203828734545313174'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/8203828734545313174'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2011/08/archlinux-atheros-ar8151ar8152.html' title='如何在 Archlinux 下安裝 ATHEROS AR8151/AR8152 網路卡驅動程式'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8800113.post-6419972144083879617</id><published>2011-06-17T16:38:00.000+08:00</published><updated>2011-06-17T16:39:45.006+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Linux"/><title type='text'>Linux console 下如何解開 kernel26.img</title><content type='html'>&lt;ol&gt;&lt;li&gt;建立暫存路徑 &lt;div class=&quot;code panel&quot; style=&quot;border-width: 1px;&quot;&gt;&lt;div class=&quot;codeContent panelContent&quot;&gt; &lt;pre class=&quot;code-java&quot;&gt;mkdir /tmp/kernel &lt;/pre&gt; &lt;/div&gt;&lt;/div&gt;&lt;/li&gt;&lt;li&gt;將 kernel26.img 複制到暫存路徑，並將附檔名改為 .gz &lt;div class=&quot;code panel&quot; style=&quot;border-width: 1px;&quot;&gt;&lt;div class=&quot;codeContent panelContent&quot;&gt; &lt;pre class=&quot;code-java&quot;&gt;cp /boot/kernel26.img /tmp/kernel/kernel26.gz &lt;/pre&gt; &lt;/div&gt;&lt;/div&gt;&lt;/li&gt;&lt;li&gt;到暫存目錄 /tmp/kernel 下利用 gunzip 解開 kernel26.gz &lt;div class=&quot;code panel&quot; style=&quot;border-width: 1px;&quot;&gt;&lt;div class=&quot;codeContent panelContent&quot;&gt; &lt;pre class=&quot;code-java&quot;&gt;cd /tmp/kernel gunzip kernel26.gz &lt;/pre&gt; &lt;/div&gt;&lt;/div&gt;&lt;/li&gt;&lt;li&gt; 目前下會剩下 kernel26 這個檔案，再利用 cpio 解開： &lt;div class=&quot;code panel&quot; style=&quot;border-width: 1px;&quot;&gt;&lt;div class=&quot;codeContent panelContent&quot;&gt; &lt;pre class=&quot;code-java&quot;&gt;cpio -ivd --no-absolute-filenames &amp;lt; kernel26 &lt;/pre&gt; &lt;/div&gt;&lt;/div&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://scott0228.blogspot.com/feeds/6419972144083879617/comments/default' title='張貼留言'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8800113/6419972144083879617' title='0 個意見'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/6419972144083879617'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8800113/posts/default/6419972144083879617'/><link rel='alternate' type='text/html' href='http://scott0228.blogspot.com/2011/06/linux-console-kernel26img.html' title='Linux console 下如何解開 kernel26.img'/><author><name>小虫</name><uri>http://www.blogger.com/profile/17349966685400729821</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>