King's Blog

Mouse problem on VMWare Player

2015-04-10T22:08:00.006-07:00

When your laptop connect to an extend moniter, and when you move your VMware guest to the second display then your mouse "fly away". Try this:
Step 1: Right click vmplayer.exe --> Properties

Step 2: Compatibility --> check "Disable display scaling on high DPI setting" --> OK

Can not connect to SQL Server?

2015-01-17T13:45:00.002-08:00

After install SQL Server, using following commands to open Firewall ports on SQL Server and client:

@echo ========= SQL Server Ports ===================
@echo Enabling SQLServer default instance port 1433
netsh firewall set portopening TCP 1433 "SQLServer"
@echo Enabling Dedicated Admin Connection port 1434
netsh firewall set portopening TCP 1434 "SQL Admin Connection"
@echo Enabling conventional SQL Server Service Broker port 4022
netsh firewall set portopening TCP 4022 "SQL Service Broker"
@echo Enabling Transact-SQL Debugger/RPC port 135
netsh firewall set portopening TCP 135 "SQL Debugger/RPC"
@echo ========= Analysis Services Ports ==============
@echo Enabling SSAS Default Instance port 2383
netsh firewall set portopening TCP 2383 "Analysis Services"
@echo Enabling SQL Server Browser Service port 2382
netsh firewall set portopening TCP 2382 "SQL Browser"
@echo ========= Misc Applications ==============
@echo Enabling HTTP port 80
netsh firewall set portopening TCP 80 "HTTP"
@echo Enabling SSL port 443
netsh firewall set portopening TCP 443 "SSL"
@echo Enabling port for SQL Server Browser Service's 'Browse' Button
netsh firewall set portopening UDP 1434 "SQL Browser"
@echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
netsh firewall set multicastbroadcastresponse ENABLE

OpenCart PHP Fatal Error: Allowed memory size of

2014-02-24T15:53:00.000-08:00

The Export/Import Tool is a very useful tool when you need to manage tons of products in OpenCart. However, you may see this message when you try to export your file:
PHP Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 48 bytes)

Then you can set "memory_limit = 512M;" in your php.ini file.

Use WDS (Windows Deployment Services) to deploy Windows 8.1 (2/2)

2014-02-14T15:19:00.003-08:00

Use WDS (Windows Deployment Services) to deploy Windows 8.1 (1/2)

3. Add Windows 8.1 Image
3.1 Right click "Install Images" and select [Add Install Image...].

3.2 You can give it an image group name. Click [Next >].

3.3 Click [Browse...].

3.4 Find your Windows 8.1 disk and the folder "sources". Select "install.wim".

3.5 Click [Next >].

3.6 Click [Next >].

3.7 Click [Next >].

3.8 Click [Finish].

3.9 Right click "Boot Images" and select [Add Boot Image...].

3.10 Click [Browse...].

3.11 Find your Windows 8.1 disk and the folder "sources". Select "boot.wim".

3.12 Click [Next >].

3.13 Click [Next >].

3.14 Click [Next >].

3.15 Click [Finish].

3.16 Right click your deploy server and select [All Tasks] and select [Start].

3.17 Click [OK].

4. Boot from client PC.
4.1 Change BIOS first boot order to Network boot.

4.2 Restart PC. When show "Press F12 for network serice boot", press keyboard [F12].

4.3 Wait...

4.4 Click [Next >]. You can install Windows 8.1 now.

Use WDS (Windows Deployment Services) to deploy Windows 8.1 (1/2)

2014-02-14T14:16:00.000-08:00

0. Prerequisites for installing Windows Deployment Services
0.1 Server: Windows Server 2012 R2 - ADDS, DNS, DHCP
0.2 Client PC: PXE boot

1. Add Windows Deployment Services Role
1.1 Click "Add roles and features".

1.2 Click [Next >].

1.3 Check "Role-based or feature-base installation".

1.4 Select your deploy server. Click [Next >].

1.5 Check "Windows Deployment Services".

1.6 Click [Add Features].

1.7 Click [Next >].

1.8 Click [Next >].

1.9 Click [Next >].

1.10 Click [Next >].

1.11 Click [Install].

1.12 Click [Close].

2. Configure Windows Deployment Services
2.1 Click [Tools] --> [Windows Deployment Services].

2.2 Right click your deploy server and select [Configure Server].

2.3 Click [Next >].

2.4 Click [Next >].

2.5 Click [Next >]. For production you can change to another hard drive.

2.6 Click [Yes].

2.7 Click [Next >].

2.8 Check "Respond to all client computers (known and unknown)". Click [Next >].

2.9 Click [Finish].

Use WDS (Windows Deployment Services) to deploy Windows 8.1 (2/2)

How to share SkyDrive documents with a browser

2014-02-12T14:49:00.003-08:00

1. Sign in to SkyDrive
1.1 Go https://skydrive.live.com . Sign in with a Microsoft account. (If you don't have one, click "Sign up now")

1.2 After you sign in. You can see your home folder.

2. Share your folder
2.1. Click [Create] --> [Folder].

2.2 Type the folder name which you'd want to share to others. Then click [Create].

2.3 Check the folder you want to share. Then click [Share] on the top.

2.4 Enter the email who you want to share. Click "Recipients can only view" to change the permissions.

2.5 You can change to "Recipients can edit". When you finish, click [Share]. (For detail: Share files and folders and change permissions)

3. Find shared folder
3.1 Click [Shared] on the left sidebar, you will find shared folders which someone share with you.

3.2 After click one shared folder. You will see the files which shared with you.

3.3 After click the shared file. You can see the file's content. If you have edit permission, you can click [EDIT DOCUMENT] to select [Edit in Word] (You need MS Word) or [Edit in Word Web App]. When you edit it, it saves automatically. Others who can read the file can see it has been changed.

How to use Chrome Remote Desktop

2014-02-07T12:06:00.000-08:00

0 Prerequisites
0.1 Install Google Chrome.

0.2 Sign in with Google Account.

1. Install Chrome Remote Desktop
1.1 Go Chrome Webstore. Search "Remote Desktop". Click [+ Free].

2. Run Chrome Remote Desktop
2.1 Go chrome://apps. Click Chrome Remote Desktop

2.2 For first using, you need to authorize your computer. Click [Continue].

2.3 Click [Accept].

2.4 Click [Get started].

2.5 Click [Share].

2.6 Give the access code to the person who will be assisting you.

3. Run Chrome Remote Desktop to help
3.1 Go chrome://apps. Click Chrome Remote Desktop.

3.2 Click [Access] and input the access code.

Use "Computer Management" to control Hyper-V Server

2013-12-03T16:17:00.002-08:00

If you want to use "Computer Management" to control your Hyper-V Server:

You may received following warning message "Computer xxx cannot be managed. ...":

You need to enable couple Firewall rules:
1. Open "Windows PowerShell".

2. Enable Firewall rules.
"Enable-NetFirewallRule -DisplayGroup "Remote Event Log Management"
"Enable-NetFirewallRule -DisplayGroup "Windows Firewall Remote Management"
"Enable-NetFirewallRule -DisplayGroup "Remote Volume Management"

3. If need to remote control Disk Management, need to enable host Firewall rules.

4. Enable Firewall rules.

5. Now you can see your Hyper-V Server's disks.

VMware Player & vmnetcfg.exe

2013-11-19T15:39:00.000-08:00

VMware Player is a very useful tool for evaluating software products. However, if you want to create a LAN lab, you'll need vmnetcfg.exe which you can find in VMware Workstation.

First, please make sure VMware Player and VMware Workstation are the last versions.

1. Run "Command Prompt".
2. Change directory to your download folder.
3. Type "VMware-workstation-full-10.0.1-1379776.exe /e .\temp".
4. Change directory to \temp folder.
5. Type "expand core.cab -F:vmnetcfg.exe .".
6. Type "expand core.cab -F:_vmnetcfglib.dll .".
7. Change file name "_vmnetcfglib.dll" to "vmnetcfglib.dll".
8. Copy "vmnetcfg.exe" and "vmnetcfglib.dll" to VMware Player installed folder. (default: C:\Program Files (x86)\VMware\VMware Player)
9. Run "vmnetcfg.exe".

How to setup CISCO QuickVPN?

2013-08-27T17:44:00.001-07:00

RV042 10/100 4-Port VPN Router
Click [VPN] –> [VPN Client Access] from left sidebar.
1. Create Username and Password and click [Add to list].
2. Click [Generate] for generating a new Certificate.
3. Click [Export for Client] and save the file to the folder where QuickVPN installed. (Default: “C:\Program Files (x86)\Cisco Small Business\QuickVPN Client”)
4. Click [Save].

CISCO QuickVPN
Install QuickVPN Client
1. Download “QuickVPN Client for all Small Business Routers“.
2. Unzip and install.

Run QuickVPN Client
Type “User Name” and “Password”. Type router’s IP address at “Server Address”. Click [Connect].

How to setup Windows 8 VPN?

2013-08-27T17:19:00.000-07:00

Create VPN Connection
1. [Win]+[x] –> “Control Panel” –> ”Network and Internet”

2. Click “Network and Sharing Center”.

3. Click “Set up a new connection or network”.

4. Select “Connect to a workplace”.

5. Select “Use my Internet connection (VPN)".

6. Type your VPN Server Internet address and Destination name. Click [Create].

Use VPN Connection

1. [Win]+[i] –> Network

2. Click [Connect] and type your User name and Password.

Desktop Skype for Windows 8

2013-07-23T08:47:00.002-07:00

Don't like your Skype App?

You can download a desktop version for Windows 8.

Reference: How do I get the desktop version of Skype on Windows 8?

OpenCart : Add Order Acceptance Policy when Checkout

2013-06-03T15:54:00.005-07:00

1. Add a variable at catalog/language/english/checkout/checkout.php

$_['order_acceptance_policy'] = "<h3>Order Acceptance Policy</h3><p>This order acknowledgement is not a contract and does not constitute an acceptance of your order; but only a record of your offer to purchase a particular item at a particular price.</p>";

2. Find "$this->data['totals'] = $total_data;" in catalog/controller/checkout/confirm.php. Add one line:

$this->data['totals'] = $total_data;

$this->data['order_acceptance_policy'] = $this->language->get('order_acceptance_policy');

3. Find "<div class="payment"><?php echo $payment; ?></div>" in catalog/view/theme/your-theme/template/checkout/confirm.tpl. Add one line before:

<?php echo $order_acceptance_policy; ?>

Build OpenCart Theme

2013-05-31T17:54:00.000-07:00

If you want to modify something about default theme, the best way is to copy one for yours then modify it.

Here is a tutorial of Build Opencart Theme.

One thing you need to modify by yourself:
Find "/catalog/view/theme/yourtheme/template/common/header.tpl"
On line 19:
<link rel="stylesheet" type="text/css" href="catalog/view/theme/yourtheme/stylesheet/stylesheet.css" />

Install vQmod on OpenCart

2013-05-31T15:58:00.000-07:00

"vQmod™" (aka Virtual Quick Mod) is an override system designed to avoid having to change core files. The concept is quite simple... Instead of making changes to the core files directly, the changes are created as xml search/replace script files. These script files are parsed during page load as each "source" core file is loaded with the "include" or "require" php functions. The source is then patched with the script file changes, and saved to a temp file. That temp file is then substituted for the original during execution. The original source file is never altered. This results in a "virtual" change to the core during execution without any actual modification to the core files. (from vQmod)

0. Backup your website.

1. Install vQmod:
1.1 Download vQmod.
1.2 Follow instruction of Install_OpenCart.
ps. You may need to modify "vqmod/install/index.php" and "pathReplaces.php" files if you've changed your admin folder name.

2. Install VQMod Manager:
2.1 Download VQMod Manager.
2.2 Follow instruction of README.pdf.

Example for using:
1. New a xml file as vqmod_modifycopyright.xml .
2. Copy these codes to vqmod_modifycopyright.xml .
<modification>
<id>Modify copyright</id>
<version>1.0</version>
<vqmver>2.0</vqmver>
<author>author</author>
<file name="catalog/controller/common/footer.php">
<operation>
<search position="after"><![CDATA[$this->data['powered']]]></search>
<add><![CDATA[$this->data['powered'] = 'Your company © ' . date('Y') . '<br />';]]></add>
</operation>
</file>
</modification>

3. Upload vqmod_modifycopyright.xml. [Extensions] --> [Modules] --> [VQMod Manager]

Netfirms PHP

2013-05-23T13:59:00.003-07:00

Just opened an account at Netfirms and faced PHP Sessions problems.
Before using PHP at Netfirms, check this first:
Using PHP http://www.netfirms.com/knowledgebase/beta/article.bml?ArticleID=1290#Nugget_1374

If having Server Error problem, delete php.ini.

PMP 之路

2013-05-07T11:23:00.001-07:00

最早開始學 PMP 的時候是 2005 年版的，當時已經做過幾年專案，就報名去上個 PMP 班看看到底是怎麼回事，上課的老師八成沒什麼專案經驗，問問題問急了就說按照 PMBOK 就對了，上完課想想不過如此，也就沒有興趣再花個幾百塊美金去考試。後來 2008 年改版，因為工作的關係有稍微翻過一下，今年 (2013) 發覺又要改版了，才認真思考去考一下 PMP 吧，不然年紀越大唸書越累。
首先，碰到的問題是需要 35 Contact Hours，在國外隨便上個課都要好幾千，後來在網路上找到一家 Whizlabs (http://www.whizlabs.com/)，選了最便宜的 PMP Exam Simulator (90 Days)，後來還收到一張七折卷，做完 4 個模擬測驗，就可以拿到 35 Contact Hours，目前是所找到最便宜的方案。
35 Contact Hours 拿到之後，就要開始填工作經驗，說實話，之前還真的沒有好好想想這幾年到底做了什麼，填完之後，還是有點成就感的。不過，填的時數夠了之後，就不用繼續想下去，太累了。
最後，就是最緊張的繳費，報名費還真夠貴，定價算完還加稅。繳費完了就可以訂考場，還好，走路十分鐘就可以到。考試報到比機場還嚴格，口袋還要全部翻出來，還好沒有破洞的。
這次準備時間大概花了兩週，先把 PMBOK 很快瀏覽一遍，大概先知道每個流程在做什麼，接著把 Whizlabs 模擬試題做完，大概可以知道題目是怎麼問的，不過千萬不要只看模擬試題，類似題目不到一成。最後，最重要的是把 Inputs, Outputs, Tools and Techniques 看懂讀熟，題目大概都圍著這些觀念打轉。
考試題目其實不難，題目一時看不懂的話先去看答案，從答案可以思考題目在問什麼。CPM, EVM 都有出，不過都是很簡單的計算，甚至還碰到一題像是國小應用數學的計算題。
一次考兩百題真的是滿累人的，看來 PMI 知道當 PM 體力也是很重要的事。

Unable to retrieve metadata for 'MvcMusicStore.Models.Album'.

2012-12-04T17:41:00.000-08:00

When you practice this Tutorials at MVC Music Store. You may got this error message when you create the StoreManagerController: "Unable to retrieve metadata for 'MvcMusicStore.Models.Album'."

You can change:

to:

Windows 8 Pre-order

2012-10-17T14:24:00.002-07:00

1. $14.99 (no DVD, upgrade), If you buy a qualifying Windows 7 PC between 2 June 2012 and 31 January 2013, you can purchase a download of Windows 8 Pro at a special promotional price that varies by region.

2. $39.99 (no DVD, upgrade), if you want to wait until October 26th you will be able to upgrade online via Windows.com using the Windows 8 Upgrade Assistant. Upgrade from Windows XP SP3, Windows Vista, or Windows 7 to Windows 8 Pro.

3. $69.99 (packaged DVD, upgrade), Pre-order from now to October 26th.

4. $69.99 (no DVD, upgard), Pack Product Key only, Pre-order from now to October 26th.

5. $99.99 Windows 8 (Full Version).

6. $139.99 Windows 8 Professional (Full Version).

Reference from: http://blogs.windows.com/windows/b/bloggingwindows/archive/2012/10/12/reserve-your-copy-of-windows-8-pro-and-pre-order-windows-8-pcs-today.aspx

Retake an Microsoft Exam for Free

2012-08-30T08:54:00.000-07:00

Retake an Exam for Free

http://www.microsoft.com/learning/en/us/offers/secondshot.aspx

When you earn a certification from Microsoft, you prove to the world that you have knowledge and skills in the most current and specialized technologies and solutions. Passing the exams needed to demonstrate those skills can be tough, but for a limited time, you’ll get a free second chance to succeed.
In today's challenging economic times, how do you stand out from the crowd, stay up to date with relevant technologies, and get the top jobs? Becoming a part of the Microsoft Certification program is a great start.
Sign up today for your Second Shot exam or exam pack. You’ll save at least 15 percent on the cost of the single certification exams, and you’ll be able to retake any exam you don’t pass the first time, at no extra cost.

Windows 8 Release Preview 出來了

2012-06-01T09:51:00.001-07:00

Windows 8 Release Preview (應該就是 RC 版本) 可以在這裡下載：
http://windows.microsoft.com/en-US/windows-8/release-preview?ocid=O_MSC_W8R_OandO_Dev_EN-US

下載完不要太興奮，先看看 Faq，再決定用哪種方式安裝。

Windows Server 2012 RC 安裝 Hyper-V 後開不了機

2012-05-31T15:21:00.000-07:00

這幾天把 Windows Server 2012 RC 後，看起來還滿正常，今天安裝 Hyper-V 之後，開機就一直停在 Windows 字樣的畫面。重裝幾次，發覺只要是安裝了 Hyper-V 就開不了機。後來在網站上看到有可能是 Gigabyte 主機板 USB 3.0 的關係，果然 Disable 後就可以開機了。

我的主機板是 Gigabyte GA-P55A-UD3，BIOS 版本升級到 F11，Disable 的方式如下：
1. 開機畫面時按下 [Del] 鍵。
2. 選擇 [Integrated Peripherals] --> [Onboard USB 3.0 Controller] --> [Disabled]。
3. 按下 [F10] 鍵，Save 後重開機即可。

Microsoft Private Cloud Evaluation 安裝

2012-05-15T10:12:00.000-07:00

前陣子收到 Private Cloud Evaluation 的 email ，全部下載完之後，一直到上周才有時間裝起來玩看看，安裝過程主要是參考 Microsoft Private Cloud Evaluation Guide 及 System Center 2012 Unified Installer。用 Unified Installer 安裝是很方便，但前提是要先把所有 Prerequisites 先準備好，光是準備這些就花了不少時間。全部大致步驟是：

1. 下載 Microsoft Private Cloud Evaluation Software。下載完後分別建立目錄，該解壓縮的，要先解壓縮。
2. 下載 Prerequisites。下載完後分別建立目錄，該解壓縮的，要先解壓縮。
3. 在 Hyper-V 建立 AD Server。
4. 在 Hyper-V 建立每台虛擬主機，Guide 上有說明。
5. 接下來就可以按照 Guide 的說明用 Unified Installer 安裝。

註：
1. 因為都是裝在 Hyper-V 上 RAM 最好要有 24 GB 以上。
2. 有時間也可以自行一台一台的安裝。

蘋果派

2012-04-07T15:29:00.001-07:00

派皮的作法: 麵粉, 無鹽奶油250克, 糖, 鹽, 蘋果汁(無糖)

1. 麵粉2杯半

2. 糖2大茶匙 (tea spoon)

3. 鹽(2.5ml) 一匙

4. 無鹽奶油250克切成小丁

將料1, 2, 3 ,4全部攪拌後用手抓至鬆散放入冰箱一小時

5. 另準備6大茶匙的無糖蘋果汁(如没有蘋果汁, 可用2匙白醋及4匙水代替), 放入冰箱一小時

6. 將5加入攪拌後的麵粉,並揉成團

7. 將麵團滾成麵皮, 放入圓型烤盤, 底部要壓平, 外緣留大約一吋, 其餘的切除

8. 將蘋果舖放到麵皮裡,

9. 上層麵皮可作成條狀, 舖在蘋果上面, 將下層麵皮及上層麵皮折進烤盤裡.

10. 烤箱要預熱至350度

11. 打一顆蛋, 放少許水及鹽後打散

12. 將上層麵皮塗上蛋汁

13. 放入烤箱烤1小時至蘋果餡起泡

內餡作法

材料: 蘋果6顆, 糖, 肉桂粉, 太白粉, 麵粉, 鹽

蘋果6顆, 去皮去核, 切成薄片
2分之一杯(1/2 cup) 糖
肉桂粉2.5ML 一匙
太白粉一大茶匙
麵粉2大茶匙
鹽一半小匙
將2-6的料全和蘋果攪伴放1小時等蘋果出水

Windows 8 Consumer Preview 初體驗

2012-02-29T17:24:00.000-08:00

Windows 8 整個操作起來非常的平板，如果用過 Windows Phone，應該可以馬上就上手。

[Win Key] 是非常重要的按鍵，可以在各個 Apps 切換。還有基本的操作像是滑鼠移到左下角，會出現 Start Window，滑鼠再往上移，可以選之前執行過的 Apps。

滑鼠再移到右下角，會出現 [Search], [Share], [Start], [Devices] 及 [Settings]，桌面上也會有時間跟日期。

按下 [Search] 可以看到有那些 Apps 可以用。

直接來看看幾個 Apps 的畫面：

1. Store 終於有東西可以下載了。

2. Xbox LIVE Games

3. Photos 可以同步好幾個帳號。

4. Calendar 會跟 Live 的帳號同步。

5. Messaging 像手機的對話模式。

6. People 可以整合數個帳號的聯絡人。

7. Weather 下雪了。

8. Finance

9. Reader 可支援的格式還不是太多。

當執行過一些 Apps 後，動態磚上就會顯示即時訊息，非常有用。

感想：

1. 整體操作順暢，資訊簡潔清楚，可以包含多年齡層的使用者。(我不是說 iPad)

2. 未來的概念大概是所有資料都上雲端，各個設備間 (電腦、手機...) 的同步都會到雲端。(公有雲及私有雲)

3. 純粹猜想一下，如果所有電腦、筆電的螢幕都能觸控的時候，Windows 8 應該可以成長很快。

但是 (一定要有個但是)，對於一些傳統使用者，或是每天坐辦公桌的人來說，只是要用用 Office，再到 ERP 打打單，不需要這些會分心的東西吧。不知道會不會有個簡潔的 Workstation 版本。

後記：

安裝完 Windows 8 之後，馬上把 Nokia Lumia 710 接上去看看有什麼事發生，結果什麼也沒發生，後來看了一下 PC settings 有找到 Lumia 710，但似乎出了什麼問題。

再看一下 Action Center 的 Maintenance，原來還要另外裝 Zune，算了吧。