Enable SSH/SCP AutoLogin in Batch

http://www.rebol.com/docs/ssh-auto-login.html

Write NTFS USB Drive on Mac OS X

Nowadays USB is so large that usually format in NTFS only.

But Mac OS X only mount NTFS as readonly.

On the web there are many guide to teach you how to enable read/write NTFS on Mac OS X by modifying /etc/fstab as follow

1. sudo vi /etc/fstab  (it is normal if file is not exist and please create a new file)

2. Add the following line in /etc/fstab and save the file

LABEL=YOURDISKNAME none ntfs rw,auto,nobrowse

3. Open /Volume and you will not able to use your USB in read/write mode

**TRICK, if your mounted drive name is "Untitled", it will not work. Please rename your USB drive to some name in Windows first!

Installation of Oracle XE

http://www.davidghedini.com/pg/entry/install_oracle_11g_xe_on

Change MiWIFI back to a normal WIFI LAN CARD

XIAOMI is selling a USB WIFI Adapter in RMB9.9

http://www.xiaomi.com/miniwifi

But it is designed to make your PC to a WIFI router instead of a pure WIFI adapter.

I figured a way to change it back to a normal WIFI Adapter by just installing its driver without using bundled software.

Please download from here.

https://docs.google.com/uc?authuser=0&id=0B8gWj5_Gu6ZudU1FOFp5NzhHdTQ&export=download

Huge Oracle Trace + Alert Log

SQL> show parameter max_dump_file_size

SQL> alter system set max_dump_file_size='1024m' scope=both;

UTF8 issue after upgrading MySQL to 5.5

In MySQL 5.5.X it introduce utf8mb4 and lead to old table might have coding issue.

<my.cnf>

[client]
default_character_set = utf8mb4

[mysql]
default-character-set=utf8mb4
skip-character-set-client-handshake

[mysqld]
character_set_server = utf8mb4
collation_server = utf8mb4_general_ci
init-connect = 'SET NAMES utf8mb4'
skip-character-set-client-handshake


----------
Convert your table / column collation

ALTER TABLE mytable CONVERT TO CHARACTER SET utf8mb4

ALTER DATABASE  `databasename` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci

Installing SMT on SLES 11

1. Generate nu.novell.com credentials on novell support portal

2. Download SMT iso from novell

3. install and setup

4. a2enmod ssl

https://www.suse.com/documentation/smt11/book_yep/data/book_yep.html