Jersey's HOME

[Ubuntu] Ubuntu 13.10 missing ia32-libs

下午4:05

With a fresh install of Ubuntu 13.10 x86_64 version, ia32-libs will missing, their is a way to workaround it by using a previous distribution (13.04).

1. Launch Software & Updates

2. Select "Other software" and add

"deb http://archive.ubuntu.com/ubuntu/ raring main restricted universe multiverse"

3. Close it and launch terminal (Ctrl+Alt+T)

4. sudo apt-get update

5. sudo apt-get install ia32-libs

6. Reboot

[Reference]

http://ubuntuforums.org/showthread.php?t=2182653

http://wiki.phoenixviewer.com/ia32-libs-in-ubuntu-13-10

[Bugzilla] Product Dashboard extentions

晚上11:10

Once the bugs grows quickly, and if you wanna to review the bug status, you can use product dashboard extensions to manage your bugs.

How to Install?

Step 1. Install bzr.
On ubuntu you can use: apt-get install bzr

Step 2. bzr bugzilla 4.2.x branch

Step 3. bzr bugzilla 4.2.x bmo branch

Step 4. move bmo branch product dashboard extension to bugzilla branch

Step 5. ./checksetup.pl to setup extensions

Step 6. Go to check. (You cannot see ??)

Step 7. If you cannot see Product dashboard, since there are two bugs as follow:

https://bugzilla.mozilla.org/show_bug.cgi?id=875728
https://bugzilla.mozilla.org/show_bug.cgi?id=875732

Step 8. Patch bug #875728, #875732 to hook common-link and search-link.

Step 9. ./checksetup.pl to setup extensions again

[Ubuntu] How to install Chinese Input on Ubuntu 12.04

晚上9:39

Step 1: Setup up the Language

Dash home -> Language Support

Step 2: Install Language and select Keyboard input as ibus

Install Chinese (Traditional)

Step 3: Reboot

Step 4: Go to ibus

ibus -> Preferences -> Input method -> Select an input method

Step 5: Use ctrl + space to type Chinese

誰說QA不會CODING

[Ubuntu] Ubuntu live to USB

晚上11:07

Use tool UNetbootin.

1. Format USB drive to FAT32

2. Download certain Ubuntu iso

3. Download UNetbootin
http://unetbootin.sourceforge.net/

4. Launch tool and select Ubuntu iso

5. Start

6. Reboot or finish

誰說QA不會CODING

Baidu spider

晚上9:17

I have no idea why Baidu spider didn't follow robot.txt rules, finally I use iptables rules to block in and out ip address.

[Iptable rules]

iptables -p tcp -I INPUT -j DROP -s 119.63.192.x
iptables -p tcp -I INPUT -j DROP -s 123.125.64.x
iptables -p tcp -I INPUT -j DROP -s 180.76.0.x
iptables -p tcp -I INPUT -j DROP -s 220.181.0.x

[Reference]
http://blog.indeepnight.com/2012/03/how-to-block-web-spider-or-crawler.html

http://tools.dynamicdrive.com/userban/#.UphVwcQW2So

http://www.robotstxt.org/robotstxt.html

https://support.google.com/webmasters/answer/156449?hl=zh-Hant

http://forums.oscommerce.com/topic/382923-baiduspider-using-multiple-user-agents-how-to-stop-them/

http://baike.baidu.com/view/1847001.htm?noadapt=1#4

http://www.weithenn.org/cgi-bin/wiki.pl?Mysql_Apache_PHP-%E9%BB%83%E9%87%91%E6%9E%B6%E7%AB%99%E7%B5%84%E5%90%88#Heading43

誰說QA不會CODING

[Bugzilla] Bugzilla migration app and data notes

晚上10:01

I got a task to migrate 3.0.3 version to a new VM, just make a note.

Steps:
1. Install Ubuntu 11.04
2. Modified Sources.list
/etc/apt/sources.list
Replace us.archive.ubuntu.com to old-releases.ubuntu.com

3. Update modules
4. Copy certain folder to apache2 folder
5. Install Webmin
6. Import mysql database by Webmin
7. Modified custom template under ./template/en/custom
8. Rebuild Bugzilla3.0.3
9. Configuration apache and mysql than restart services.

------------------------------------------------------------------------------------------------------
Official document to move Installation
https://wiki.mozilla.org/Bugzilla:Move_Installation

Adding a New Disk Drive to an Ubuntu Linux System

http://www.techotopia.com/index.php/Adding_a_New_Disk_Drive_to_an_Ubuntu_Linux_System

Bugzilla with Gmail
http://rndm-snippets.blogspot.tw/2011/05/bugzilla-issue-tracking-send-mail.html
http://dawood.in/bugzilla-alerts-using-gmail/

Apache2 with mod_evasive to protect DDos attack
http://www.mmncs.com/2011/07/how-to-protect-apache-against-dos-ddos-or-brute-force-attacks-using-mod_evasive-and-mod_security-and-mod_qos-on-linux-ubuntu-11-04/

Webmin install
http://www.ubuntugeek.com/how-to-install-webmin-on-ubuntu-11-04-natty-server.html

Import database through webmin

http://www.webhostingtalk.com/showthread.php?t=871600

lftp backup
http://ezkuro.blogspot.tw/2007/03/lftp-mirror.html

vsftp install
https://help.ubuntu.com/10.04/serverguide/ftp-server.html

Bugzilla install prerequisites instance
https://wiki.mozilla.org/Bugzilla:Prerequisites#Ubuntu

apache2 mysql-server libappconfig-perl libdate-calc-perl libtemplate-perl libmime-perl build-essential libdatetime-timezone-perl libdatetime-perl libemail-send-perl libemail-mime-perl libemail-mime-modifier-perl libdbi-perl libdbd-mysql-perl libcgi-pm-perl libmath-random-isaac-perl libmath-random-isaac-xs-perl libtext-diff-perl
Optional
apache2-mpm-prefork libapache2-mod-perl2 libapache2-mod-perl2-dev libchart-perl libxml-perl libxml-twig-perl perlmagick libgd-graph-perl libtemplate-plugin-gd-perl libsoap-lite-perl libhtml-scrubber-perl libjson-rpc-perl libdaemon-generic-perl libtheschwartz-perl libtest-taint-perl libauthen-radius-perl libfile-slurp-perl libencode-detect-perl libmodule-build-perl libnet-ldap-perl libauthen-sasl-perl

誰說QA不會CODING

[Bugzilla] Server-Sent Events problem under Bugzilla 4.4 / 3.0.3 with IE11

下午4:47

[Problem]

In bugzilla 3.0.3, when you using IE11 to search bugs, it will pop-up message as follow:
WARNING: YOUR BROWSER DOESN'T SUPPORT THIS SERVER-PUSH TECHNOLOGY. --------- =_aaaaaaaaaa0 Content-Type: text/html

...................

In Bugzilla 4.4, when you using IE 11 to search bugs, it sent the results back to IE11, which offered to save it to a file named buglist.cgi

[Root Cause]

Bugzilla use HTML 4.01 Transitional, not HTML 5, and so doesn't support Server-Sent Events which is part of HTML5. And IE11 gets multipart/x-mixed-replace since it not follow older versions of IE.

[Solution]

Since IE 11 's string contains 'like Gecko', so add "Tridents" to detect IE.

Modified file buglist.cgi

Bugzilla 3.0.3 / Bugzilla 4.4

- && $ENV{'HTTP_USER_AGENT'} !~ /WebKit/

+ && $ENV{'HTTP_USER_AGENT'} !~ /(?:WebKit|Trident)/

[Reference]

Bugzilla

https://bugzilla.mozilla.org/show_bug.cgi?id=902515

Server-sent Events

http://en.wikipedia.org/wiki/Server-sent_events

IE 11 capability