Mingster @ blogger

Undelete in Linux (ext3 file system)

2011-08-26T14:23:00.000+08:00

I accidentally wide out my 200 and some gigabytes of mp3 (again) by rsync'ing between bad disk. Luckily I found this undelete program and recover most of them.

http://extundelete.sourceforge.net

Also check out this great article if you're techie: http://carlo17.home.xs4all.nl/howto/undelete_ext3.html

Install BootCamp 4.0

2011-08-26T11:00:00.000+08:00

If you upgrade to Lion from Snow Leopard + Win7 bootcamp, you might find that you can't download new bootcamp 4.0 from Bootcamp Assistant. The way I go around it is by downloading it from Apple's CDN:

Download Bootcamp 4.0 Drivers, here's a link on some Apple CDN for the .pkg file containing the drivers (603MB): http://bit.fosk.it/bootcamp40
Open this file with 7Zip in Windows, and go through a few layers to extract BootCampESD.pkg\Payload\Payload~\.\Library\Application Support\BootCamp\WindowsSupport.dmg\0.Apple_ISO
Rename the file from 0.Apple_ISO to BootCamp4.iso
Extract the iso with 7Zip to a folder.
Open command prompt and navigate to the extracted folder, for example:
E: cd WindowsSupport\Drivers\Apple
From the prompt in that folder, run msiexec /i BootCamp64.msi

Generating Video Thumbnails With FFMPEG

2011-05-12T18:33:00.003+08:00

Check out flowplayer's - http://flowplayer.org/tutorials/generating-thumbs.html

In short,



ffmpeg -i [video_file] -f image2 -vframes 1 [output_image].jpg

For example,



ffmpeg -ss 12 -i flowplayer.mov -f image2 -vframes 1 flowplayer-12.jpg

Finding video/ image file info

2011-05-12T17:31:00.001+08:00

In ffmpeg, you can determine video or image file info:



ffmpeg -i my_video_filename

Another option is exiftool tool.

1. Install on RHEL
yum install perl-Image-ExifTool.noarch
**you need to have rpmforge repository installed.

2. Use it
exiftool my_video_file

Install Google Chrome on RHEL

2011-05-07T13:26:00.000+08:00

This howto explains howto install Google Chrome Web browser on Fedora 14, Fedora 13, Fedora 12 and Red Hat 6 (RHEL 6). Best way to install and keep up-to-date with Google Chrome browser is use Google’s own YUM repository.

1. Enable Google YUM repository

Add following to /etc/yum.repos.d/google.repo file:
32-bit

[google]
name=Google - i386
baseurl=http://dl.google.com/linux/rpm/stable/i386
enabled=1
gpgcheck=1
gpgkey=https://dl-ssl.google.com/linux/linux_signing_key.pub

64-bit

[google64]
name=Google - x86_64
baseurl=http://dl.google.com/linux/rpm/stable/x86_64
enabled=1
gpgcheck=1
gpgkey=https://dl-ssl.google.com/linux/linux_signing_key.pub

Note: Both 32-bit and 64-bit repos can be placed in the same file.

2. Install Google Chrome with YUM (as root user)

Install Google Chrome Stable Version

## Install Google Chrome Stable version ##
yum install google-chrome-stable

Install Google Chrome Beta Version

## Install Google Chrome Beta version ##
yum install google-chrome-beta

Install Google Chrome Unstable Version

## Install Google Chrome Unstable version ##
yum install google-chrome-unstable

Fix backspace/delete when ssh'ing into Linux machines

2011-03-12T22:44:00.000+08:00

the solution is very simple now-the-day. Just go to Terminal's preference, settings, advanced, and check the "Delete sends Ctrl-H".

There's no need to modify .tcshrc what so ever..

CentOS - trac 0.12 / SVN 1.6 install

2011-03-07T08:26:00.000+08:00

good reference here:
http://flakrat.blogspot.com/2010/06/installing-subversion-16-and-trac-012.html

Mac: Print screen key

2011-02-12T17:18:00.001+08:00

Windows 鍵	Mac 鍵	用途

Alt	Option	輸入特殊字元，如 é。
Control	Command (⌘)	執行動作或快速鍵。例如，按下 ⌘ + S，通常會儲存文件或檔案。
Num Lock	Num Lock Shift + Clear	在某些應用程式中，控制是否按下數字鍵盤的按鍵來輸入數字或移動游標。
Scoll Lock	Control + F14	在某些應用程式中，控制是否按下方向鍵來移動游標或在視窗中捲視。
Print Screen	⌘ + Shift + 3 ⌘ + Shift + 4	拍攝螢幕照片。⌘ + Shift + 3 會擷取整個螢幕的畫面。⌘ + Shift + 4 會擷取您螢幕所選區域的畫面。

On Windows 7, use those combo keys:
Shift + Fn + F11: Print Screen
Alt + Shift + Fn + F11: Print Active Window

http://docs.info.apple.com/article.html?path=Mac/10.5/yh/cdb_winkeys.html

Building HandBrakeCLI for CentOS

2011-02-10T11:52:00.010+08:00

Problem with CentOS & other RHEL is that it's packages are updated slowly. Building software like Handbrake needs additional steps.

1. First of all, you need to have the essential development tools:

yum groupinstall "Development Tools" "Development Libraries" \

"X Software Development" "GNOME Software Development"



yum install yasm zlib-devel bzip2-devel \

dbus-glib-devel libgudev1-devel webkitgtk-devel libnotify-devel \

gstreamer-devel gstreamer-plugins-base-devel

2. Build Autoconf 2.61 (stock is 2.59) and install to /opt

wget http://ftp.gnu.org/gnu/autoconf/autoconf-2.61.tar.bz2

tar xjf autoconf-2.61.tar.bz2

cd autoconf-2.61

./configure --prefix=/opt

make

sudo make install

3. Use the 2.61 version
export PATH=/opt/bin:$PATH

4. Greb latest source from subversion or download from Handbrake source.
Here we assume you download the tar source:

wget http://handbrake.fr/rotation.php?file=HandBrake-0.9.5.tar.bz2

tar zxvf HandBrake-0.9.5.tar.gz

5. Config & build
GUI version is no supported according to the Handbrake forum. --disable-gtk option will generate CLI build.

cd HandBrake-0.9.5

./configure --disable-gtk --launch

it's gonna take awhile depending on your hardware...

-------------------------------------------------------------------------------
time end: Thu Feb 10 12:57:49 2011
duration: 20 minutes, 2 seconds (1202.42s)
result: SUCCESS
-------------------------------------------------------------------------------
Build is finished!

6. Install
If no other trouble, you get the success build result. Now install it:

cd build

make install

This will copy the build to /usr/local/bin/HandBrakeCLI and now enjoy the work!
HandBrakeCLI --help

Reference:

Snow Leopard - clean up MySQL installation

2011-01-14T22:26:00.002+08:00

For whatever reason you need to reinstall/ clean MySQL. Here are the spots:

sudo rm -rf /usr/local/mysql*

sudo rm -rf /Library/StartupItems/MySQLCOM

sudo rm -rf /Library/PreferencePanes/My*

rm -rf ~/Library/PreferencePanes/My*

sudo rm -rf /Library/Receipts/mysql*

sudo rm -rf /Library/Receipts/MySQLStartupItem.pkg/

sudo rm -rf /var/db/receipts/com.mysql.mysql*

sudo rm -rf /var/db/receipts/com.mysql.mysqlstartup*

edit /etc/hostconfig and remove the line MYSQLCOM=-YES-

Launchctl

launchctl list|grep mysql

remove anything found.

iphone, 威寶 & APN

2011-01-07T17:28:00.001+08:00

威寶APN設定
吃到飽APN: internet
日租APN: vibo
username / password 皆空白

設好後internet tethering才會work.

device: iPhone 3G
iOS: 4.1 Pwnage JB
baseband: 6.15
bootloader: 6.02

2011年沒有景氣問題只有競爭力問題

2010-12-29T14:07:00.000+08:00

鴻海集團董事長郭台銘今天表示，2011年台灣有清廉政治和兩岸和平願景，加上有40-50歲受過良好教育的企業家崛起，「2011年沒有景氣問題，只有競爭力問題」。郭台銘並透露，他最近每2周去一次日本「取經」，包括日元升值到80幾元兌1美元，日本企業仍能生存，日本的確有值得師法之處，而台灣與日本就「經濟技術學」來講，有很大的結合空間。

郭台銘表示，對鴻海來說，沒有景氣問題，只有競爭力問題，例如鴻海進入桌上型電腦(DT)領域比較晚，但市占率愈來愈高，由於競爭力加強，網路安全獲得重視，反而讓DT需求上來。而鴻海集團今年營收達3兆元，今年成長幅度6成，明年成長幅度也有信心可以超過「下限」。郭台銘先前接受媒體採訪時，曾經將鴻海未來年成長率目標糾正為15%。

郭台銘今天並未正面答覆景氣、匯率等問題，尤其是匯率部分，郭台銘表示，不管他怎麼說，媒體都會大做文章，因此他不發表意見。

不過針對匯率部分，郭台銘以日元為例，日元對美元升值到80幾元兌1美元，日本企業仍能生存，以往的匯率可視為「環境的保護」，「順境人人會走，只是快或慢的問題，但逆境就看公司能不能生存」，因此明年的關鍵仍在於競爭力。

iPhone iPAD tethering

2010-11-19T15:41:00.000+08:00

1. JB the iPhone - redsn0w
2. Open Cydia, add the source - http://www.sinfuliphonerepo.com
3. Install MyWi Cracked
4. Open MyWi, set it up so iPhone become a wifi router.
5. wifi iPAD over.

not load file or assembly 'System.Windows, Version=2.0.5.0...'

2010-08-08T14:38:00.000+08:00

if you get this error, it's because Sliverlight assembly is not in GAC. Do this to fix:



cd C:\Program Files\Microsoft Silverlight\4.0.50524.0

gacutil -i System.Core.dll

gacutil -i system.dll

gacutil -i system.net.dll

gacutil -i system.xml.dll

gacutil -i System.Runtime.Serialization.dll

check out what other people said.

Snow Leopard's NTFS read/write support

2010-08-03T20:58:00.002+08:00

http://tool-box.info/blog/archives/1193-Snow-Leopards-NTFS-readwrite-support.html

This still stands for release version of Snow Leopard. It also works for USB disk.

update: 2010/8/6:
I switch back for NTFS-3G, the Apple built-in version is not stable and screw up my partition table. Apple did not enable it for a reason...

.NET fix: System.Security.SecurityException: Requested registry access is not allowed.

2010-06-21T12:11:00.002+08:00

If you get something like this:

Server Error in '/applicationname' Application.
---------------------------------------------------------------------------
Security Exception 
Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. 

Exception Details: System.Security.SecurityException: Requested registry access is not allowed.

Source Error: 
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 

Stack Trace: 
[SecurityException: Requested registry access is not allowed.]
Microsoft.Win32.RegistryKey.OpenSubKey(String name, Boolean writable) +473
....

I'm not sure there's a secured way, but adding permission for iis daemon user solve the problem for me.

1. Find out which deamon user your app is using, by looking up App_Pool and secruity section in event log.

2. Give the user permission to read/write access for the eventlog registry entry. To do so, open regedit and navigate to the key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog

.
Right click and select Permissions, and add permission for the user.

3. restart iis and give it a try.

MySQL 5.x Repair Cheat Sheet

2010-05-28T22:15:00.006+08:00

If you upgrade MySQL or move the database around, you are most likely need to do those operations:

Backup

 mysqldump -u root -p --default-character-set=utf8 databasename > data.sql

Restore

mysqldump -u root -p --default-character-set=utf8 databasename < data.sql
if database is larger then 100MB, this works better:



mysql -u root -p

#mysql> use the_database

#mysql> source data.sql

Check, Repair & Optimize All Tables in All Databases

If you need database server up, use mysqlcheck:



mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

Or you can make it offline and do a better check:



service mysqld stop

myisamchk /var/lib/mysql/the_database/*.MYI

service mysqld start

Repair single table

 mysql -u root -p

#mysql> use the_database

#mysql> repair table the_table

Reference:
http://www.felipecruz.com/repair-mysql-database.php

MySQL 5.1.x & unicode

2010-05-24T17:07:00.002+08:00

In our recent upgrade from 5.0 to 5.1.47, the new version behaves differently and it screw up character set when user submit info from our web app powered by .NET.

After digging around for a afternoon, this is how to fix it:



vi /etc/my.cnf

And add those lines to the config:



init_connect='SET collation_connection = utf8_general_ci'

init_connect='SET NAMES utf8'

default-character-set=utf8

character-set-server=utf8

collation-server=utf8_general_ci

skip-character-set-client-handshake

There are other options for collation besides utf8_general_ci such as utf8_unicode_ci. See this article:
http://dev.mysql.com/doc/refman/5.1/en/charset-unicode-sets.html

Reference: http://rhyous.com/2009/11/05/how-to-create-a-utf-8-unicode-database-on-mysql/

RHEL: Install GNOME from console

2010-04-08T17:20:00.001+08:00

this will do:



yum groupinstall "X Window System" "GNOME Desktop Environment"

To start the desktop, just type startx

CentOS: Install git

2010-04-03T15:54:00.000+08:00

1. Download and install EPEL if you don't have it yet:

rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-3.noarch.rpm

2. Install git via yum
yum --enablerepo=epel install git

XShell profile/session backup

2010-03-31T17:20:00.000+08:00

XShell from NetSarang is a great SSH client that we use. Even one awhile, you might wanna back up all the saved profiles.

The profiles are actually located at: %user_profile%\%username%\AppData\Roaming\NetSarang\Xshell. For example, C:\Users\johnny\AppData\Roaming\NetSarang\Xshell.

You can just copy the directory to where you want to back it up. You can also create sub-directories if you want to manage them a bit.

開發網路電視 Panasonic不採用Android系統

2010-03-31T13:48:00.000+08:00

Bloomberg報導，日本電子大廠 Panasonic (6752-JP) 高層表示，由於成本過高，公司生產的網路電視決定不採用 Google (GOOG-US) Android 作業系統。

積極推廣 Android 作為網路電視平台的 Google，嘗試與 Panasonic 合作卻遇挫。

Panasonic Consumer Electronics Co. 資深副總派瑞 (Robert Perry) 說，Android 雖是免費，卻需要價格不斐的技術來支援，包括英特爾的高價晶片。

Panasonic Consumer Electronics 是 Panasonic 的美國子公司。

派瑞周二出席舊金山召開 3D 技術發表會，他會後表示，Android 平台「須利用晶片的處理能力，將增加成本負擔」。

將網路導入家庭娛樂產品漸成趨勢，Panasonic、三星電子 (005930-KR)、索尼 (6758-JP) 等電視製造商今年均計畫推出相關產品。

根據日前報導，Google 與英特爾正攜手開發「Google TV」平台，讓用戶可透過電視來上網。消息人士透露，索尼也參與了該平台開發計劃。

全球第4大電視製造廠的 Panasonic，則選擇自行研發網路軟體，透過自家的伺服器傳送網路內容。

Mastering the VI editor

2010-03-24T15:04:00.000+08:00

Good basic - http://www.eng.hawaii.edu/Tutor/vi.html
Download PDF version here

iPhone: Internet Tethering option is gone!?

2010-03-12T12:57:00.001+08:00

If it happens to you, on the phone, navigate to help.BenM.at, follow the instruction to reinstall carrier profile.

This works 3G, 3GS, OS version 3.1 or up, no need to jail-break.

Google Testing TV Internet Search

2010-03-12T12:49:00.000+08:00

The experiment could determine whether TV viewers would favor Web-like searches over the use of remote control searches.

By W. David Gardner
InformationWeek
March 10, 2010 11:00 PM

Google and Dish Network are testing a search service that would enable users to find video content on conventional TV and on the Internet, according to a report in the Wall Street Journal.

The test, which uses Google's Android software, could determine whether TV viewers would favor Web-like searches over the use of remote control searches, which usually involve the use of menus and much clicking around via a TV's remote control. The test is said to be restricted to a small number of set-top boxes in the hands of Google employees.

The experiment is another indication that a wide range of companies is seeking to take advantage of the emerging convergence of TV and Internet video offerings. Google and Dish Network officials have declined to discuss the test publically. Google's chief executive, Eric Schmidt, however, has suggested that Android technology could be used by TV hardware manufacturers.

"It makes sense that people would use Android as an operating system for set-top boxes, buddy boxes and TVs," he said, according to published reports. "All of those ideas have been proposed by our partners."

Two years ago, Google teamed up with satellite TV provider Dish Network to test the automation of ad buying, delivery sales, and metrics to study how TV search and advertising operate. At the time Schmidt said that test was important because Google said it believed it could add value to TV by delivering more relevant ads to viewers.

The 2007 experiment was also meant to test the waters by providing better accountability for advertisers and to better monetize inventory for TV operators and programmers.

Microsoft Entertainment and Devices Division created the Mediaroom solution powering 4 million telco IPTV set-top boxes. It is also home to Xbox 360 with over 30 million consoles sold with more foc...