2Wire Network Issue

Filed in wireless Leave a comment

Just bought a new MacBook Pro with Retina Display recently, and when setting up, my 2Wire Wireless Modem dropped fibre connection and need to be reset.
As i have another MacBook that i am now using to run as backup server and other cron job, my Pro and MacBook is connected together through a network switch. Somehow every time i disconnect my Pro from this switch to go purely on home wireless network, 2wire will crash.

Ok, if you don’t understand what i am saying above, just ignore it.
I google and some says to uncheck “Packet Flood” under the Firewall Settings. Sadly, this have become an advance option for my 2wire router.
I am in Singapore with Singtel Fibre on the Black 2Wire Pace 5012 Box, not sure if it will works for other provided or make.

Go to, http://gateway.2wire.net/singtel. you will be prompted for a technician password. Enter “techsupport” without the quotes.
The advance options will be made available. Do note that these are advance options, and is not supported by Singtel, so proceed at your own risk.

I will be testing for a couple of days with Packet Flood disabled and see if it help solve the issue.

2Wire really need to conform to networking standard and not continuously suck up to telco configuration. argh.

, ,

Thoughts on the iPhone 4S

Filed in Apple | iPhone Leave a comment

It’s all disappointment, with Apple shares dropping 5% on the supposedly disappointing iPhone 4S launch. The lack of a new design iPhone 5 seems to dry the desire to buy this new iPhone. Like what Jonathan mentioned, People that say “meh” to the iPhone 4S are just unhappy that it looks like an iPhone 4, which means that its not a status symbol upgrade.

But quite frankly, the way i look at it, this iPhone is going to be another big hit. It’s going to be a very big hit because of Siri. Just check out this video i embedded on a post by 9to5mac a few days ago.

Look at how they are changing AI. It’s like reinventing interaction with your phone, all over again. We can expect an API to come before iOS6 or maybe even in iOS 5.2 – giving developers power to tap on the AI of Siri to bring apps interaction to a new level. Imagine dictation. Imagine how transcribing is going to be a thing of the pass! and how people are going to compose messages on the move. reply messages while jogging!

Open a file by speech, launch presentation, move presentation slides. Pop up relevant images, videos or website half way through a presentation. Wow, imagine the possibilities!

it’s endless.

So if you think that iPhone 4S is just another iPhone 4, think again. It’s probably the first step to evolving your phone, into a buttonless screen, mic and speaker only device.
“Volume Up”. “Take a snapshot”. “Shoot video”. “Lock Screen”. “Delete this photo”. “Unlock screen”. “Switch to silent”.

Now imagine they add voice recognition such that command will only obey your voices. It’s blowing me away already!

Steve Jobs resigns as Apple CEO

Filed in Apple Leave a comment

Steve Jobs resigns as Apple CEO on Wednesday afternoon, citing that he is no longer able to meet the duties and expectation as Apple’s CEO. He however would like to stay on as Chairman of the Board and recommend Tim Cook as his successor.

Quoting from the Letter Steve Jobs wrote: “I have always said if there ever came a day when I could no longer meet my duties and expectations as Apple’s CEO, I would be the first to let you know. Unfortunately, that day has come.”

I know that this post is totally irrelevant, but i thought, i would like to share my views on this. I have been an Apple fanboy even since i touched and own my first MacBook merely 3 years back. The question many will have is definitely, why now? Why the resignation only now, since Steve have been on medical leave since January and have appeared publicly for major Apple’s events.

This is not a complete analysis, i will post it again when i can find the time.
But i believe that Steve have been planning this move for quite sometime, and have considered Wednesday for the most appropriate date, having observed APPL. APPL have reached it’s peak, to become the world’s most valuable company. Have billions of cash on hand. Have set record profit in all the past many Quarters. Wednesday is really the best time, having see APPL stablised at it’s peak.

Even if the stock is to crash, it can’t go too far, and will recover very quickly come Sept/Oct where you will be having it’s major announcement on new iPod, iPhone or other iDevices. APPL will definitely hit it’s new peak then. I would like to observe APPL for the next 2 days and monday, and we can see how the market is reacting. But my take, it’s too valuable for any serious invested to sell now just because Steve Jobs resigned.

You know, it maybe the case only a few months back, should Steve have resigned, the market will definitely reacted quite bullishly. His move on being absence for more than 6 months, is simply to prove to the market that, “Hey! Apple can go on as great, without me!”, while he work the succession plans for Tim internally.

Pretty smart move. But Steve, we will definitely miss you lots, you will be always remembered as the legendary one :)
However, still looking forward to even more amazing products from Apple.

iPhone Apps: iTunes on fivoca

Filed in iPhone | mac | web Leave a comment

stumble on this pretty interesting website that let you browse top ranking free/paid/grossing apps for the different countries that have itunes, for apple iphone, ipad and mac apps.

browse application through their screenshots, i personally love the photography category, allowing me to browse through all the camera sample screenshots instead of having to guess them from their icons and figure what type of lenses or effect it may offer!

worth the checks!

Downgrade to MySQL 5.0 from 5.1

Filed in dreamhost | mysql 3 Comments

If ever a installation or upgrade to MySQL 5.1 goes wrong and you want to revert back to MySQL 5.0 by installing 5.0, you will probably run into the following nasty error message.

Unpacking mysql-server-5.0 (from …/mysql-server-5.0_5.0.51a-24+lenny5_amd64.deb) …
Aborting downgrade from (at least) 5.1 to 5.0.
dpkg: error processing /var/cache/apt/archives/mysql-server-5.0_5.0.51a-24+lenny5_amd64.deb (–unpack):
subprocess pre-installation script returned error exit status 1
Errors were encountered while processing:
E: Sub-process /usr/bin/dpkg returned an error code (1)

You probably get this error message when you run “sudo apt-get install mysql-server”. To fix this problem, simply run:

Warning: THIS WILL DELETE ALL YOUR DATA. Pleas backup your tables before continuing.

sudo rm -R /var/lib/mysql

this will delete the mysql data directory, which will fix the issue! continue your downgrade back to 5.0 by running:

sudo apt-get -f install

Installing mysqld on Dreamhost VPS

Filed in dreamhost | mysql | software | unix | web 8 Comments

If you do not already know, PS MySQL is useless! It’s basically a MySQL installation on a VPS where you have control over nothing! The only thing you have is assured memory allocation, which is pretty much useless.

So how? Why not create another VPS and install mysqld on it! Seriously, it’s that simple, with that you get full control of your MySQL server, in a real VPS environment.

Simple steps!

ssh into your VPS

ssh my_vps_admin_username@psXXXXX.dreamhostps.com

where psXXXXX is your VPS server name, like PS23535 etc.

type the following commands to install mysql server and client

sudo apt-get install mysql-server
sudo apt-get install mysql-client
All this point, your installation may fail, with errors like:

Can’t exec “/tmp/mysql-server-5.1.config.181101”: Permission denied at /usr/share/perl/5.10/IPC/Open3.pm line 168.
open2: exec of /tmp/mysql-server-5.1.config.181101 configure failed at /usr/share/perl5/Debconf/ConfModule.pm line 59

when you run:

sudo mount

you will see:

/dev/hdv1 on / type ufs (defaults)
none on /proc type proc (defaults)
none on /tmp type tmpfs (size=128m,mode=1777,nosuid,noexec,nodev)
none on /dev/pts type devpts (gid=5,mode=620)

you need

/dev/hdv1 on / type ufs (defaults)
none on /proc type proc (defaults)
none on /tmp type tmpfs (size=128m,mode=1777)
none on /dev/pts type devpts (gid=5,mode=620)

for your installation to run completely, without error.

Please submit a ticket to DH support, to request for the admin to mount /tmp folder without noexec. However, do note of the potential security issues, you may encounter.

Updates: from dlo in the comment, the default apt-get with DH will install only version 5.0, to get 5.1 while maintaining future update compatibility, simply:

sudo apt-get -t lenny-backports install mysql-server-5.1

Along with the pins in /etc/apt/preferences, this should allow you to keep it updated into the future. lenny-backports is already configured by DH in /etc/apt/sources.list by default.

Add Note
Verified: If you are on a new VPS, it is quite possible that your /etc/apt/preferences and /etc/apt/sources.list are not update or correctly configured for lenny-backports.

In /etc/apt/sources.list you will need to comment out the following line by adding a “#” in the beginning of the line


#deb http://www.backports.org/debian/ lenny-backports main

then ADD:

deb http://mirror.newdream.net/debian-backports/ lenny-backports main contrib non-free

In /etc/apt/preferences


Package: *
Pin: release a=lenny
Pin-Priority: 500

Package: *
Pin: release a=lenny-backports
Pin-Priority: 200

Package: emacs23
Pin: release a=lenny-backports
Pin-Priority: 900

Package: emacs23-common
Pin: release a=lenny-backports
Pin-Priority: 900

Package: debian-backports-keyring
Pin: release a=lenny-backports
Pin-Priority: 900

if you want to setup for remote access, do the follow:

sudo vi /etc/mysql/my.conf

look for bind-address and change to:

bind-address = psXXXXX.dreamhostps.com

again where psXXXXX is your VPS server name.

mysql -u root -p

then enter your password,

mysql> CREATE DATABASE your_new_database_name;
mysql> CREATE USER ‘newusr’@’psXXXXX.dreamhostps.com’ IDENTIFIED BY ‘your_password’;
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘newusr’@’psXXXXX.dreamhostps.com’ WITH GRANT OPTION;
mysql> CREATE USER ‘newusr’@’%’ IDENTIFIED BY ‘your_password’;

your mysql database user with username ‘newusr’ can now connect from any remote host, since using wildcard “%”.
just change “%” to a specified hostname if you are having a web application connecting to this database from say dreamhost shared hosting, with “%.dreamhost.com” or “%.dreamhostps.com”

alright! written in a bit of a rush cause i wasted many hours trying to install with much complicated methods! gosh*

iPhone 4: Fixing the home button

Filed in hardware | iPhone Leave a comment

my iPhone 4 home button have been unresponsive and is confirmed a hardware issue. my back panel is actually lose and i can shift i slightly up and down against its metallic frame. so i suspect is some mechanical fault, or something loose that is causing the button to be not responsive. i can only get response by pressing from a certain angel or in certain time of the day!

so, now it’s fix! for the adventurous only.
unscrew the 2 screws at the bottom of your phone, push the back panel slightly up, it will move a bit and you can remove the back panel already. or simply follow the photo illustration from ifixit here.

then put a small piece of paper between the back panel and the area directly behind the home button. apparently that added pressure is needed for the home button sense to work!


Restarting MySQL in Mac OS X

Filed in mac 2 Comments

Update: Apparently the method i mentioned below is incorrect, at least for Mac OS X!
Here’s the more proper way, simply:

launchctl stop com.mysql.mysqld


launchctl list

and stop all process with mysql as the label, mysql should automatically restart. if it don’t simply

launchctl start com.mysql.mysqld

to bring it back to life!

Never really have to change any configuration to the mysql installation on my mac os x (10.6) (snow leopard). but when the need arises, i can’t seems to find my installation directory or how i can safely restart the mysqld services.

Good thing i found a few ways to do so!
To restart, start or stop your mysql server, you first need to identify your mysql installation base directory, that’s on assumption that you already have your mysql server up and running previously. Run the following sql command:


this command will return a list of variables along with its respective configured values. to find your base directory directly, you can just use the command below.

SHOW GLOBAL VARIABLES WHERE Variable_name = ‘basedir’;

The value returned will be something like this:


from my case, it’s quite obvious that mysql installation was from 10.5, before i upgrade to snow leopard. So this guide may differs slightly for those who mac came with 10.6, i haven’t got the chance to confirm that yet. Now to restart your mysql server.

Simply go to terminal and enter the following command:

/usr/local/mysql-5.0.51a-osx10.5-x86/support-files/mysql.server restart

or you can cd into your basedir and then go into “support-files” folder.
then run

./mysql.server restart

the other option to stop and start will be as follows:

./mysql.server stop
./mysql.server start

, , ,

Google Calendar on iPhone

Filed in gmail | iPhone Leave a comment

Since iOS 3.0, CalDAV was introduced allowing Google Apps Calendar or Google Calendar to be used to sync with iPhone calendar. The setup is pretty straight forward. But the tricky part is figuring out how to access the Shared Calendar of your friends that you have added to your calendar!

But just for the record, here’s how you can add your Google Apps Calendar into your iPhone.

  1. Go to Settings.
  2. Select Mail, Contacts, Calendars.
  3. Under Accounts, select Add Account….
  4. Choose Other.
  5. Under Calendars, select Add CalDAV Account
  6. Enter the following details:
    Server: www.google.com
    User Name: email@yourdomain.com (Google Account or Google Apps Email Address)
    Password: your password
    Description: My Gapps CalDAV (or whatever name that’s suitable)
  7. Click on Next on top of your screen.

You Gapps CalDAV will be setup and ready to go in your Calendar. However, it will by default be opening only your own calendar. So how do you sync your shared calendar too!

Simple! Just go to:
while logged into your Google Account or Google Apps Account. You will then be given the option to select or uncheck calendars appearing in your Google Calendar you will want to have them sync-ed on your iPhone.
Google Apps User can go to
replacing ‘yourdomain.com’ with your actual Google Apps domain name. I have tried simply using the link above, and all is fine too.

Web: Facebook Share Button Generator

Filed in web 5 Comments

Ok, so i decided to write a generator myself! and here goes…





, ,