Export Open Webmail Address Book to IMP Turba

Log on to Open Webmail to navigate to Address Book, and click on Export

After that, select the email address(es) you would like to export, select export format as CSV and click on Export Now, save the address book on your PC.

Log on to IMP Webmail, Select Organizing > Address Book, and click on Import/Export on top menu. Browse the address book data you have saved earlier and click Next.

After that, continue with Next too,

Right now, you have to match your address book data by doing Pair Matching, match your

EMAIL > Email
FN > Name

You have to click on Add pair, after that, continue with Next…

Done, you address book has been successfully imported, now you can browse to your address book.

Excel Logo Quiz Answer Cracked

This prove Microsoft Excel password protection is the best software ever in the world, because it’s so easy to crack. Pity the fellow who put the effort on the logo quiz and protect it.

People around me has been cracking their head doing the logo quiz. Well, who care how many you answer? I got all the answer :) Microsoft Rocks!

Download the answer here. If you want the unprotect password, it’s TTGTTUZXPFVTGVS

MySQL Cannot Connect with PHP in OSX

I think some of you might have problem connecting to MySQL with PHP(mysql_connect) in Max OS X if you configured MySQL5 with Darwin Ports. Most probably you will get these error message;

Warning: mysql_connect() [function.mysql-connect]: Can’t connect to local MySQL server through socket ‘/opt/local/var/run/mysql5/mysqld.sock’ (13) in /Users/paulooicongjen/myproject/web/info.php on line 10
Could not connect: Can’t connect to local MySQL server through socket ‘/opt/local/var/run/mysql5/mysqld.sock’ (13)

The error message is caused by the folder mode created by MySQL installation by default. To solve this problem, change your folder mode to 755 and restart apache.

cd /opt/local/var/run
sudo chmod 755 mysql5
sudo apachectl restart

It should works now!

Install MySQL5 on Mac OSX With Darwin Port

Before installing MySQL5, please be sure you have Darwin Port installed on your OS X. If yes, let’s start to roll now… Fire up your terminal and type

port variants mysql5

You will see variants support for mysql5 installation.

mysql5 has the variants:
darwin_8
server

Next, is the time to start install MySQL5 with Darwin Port.

sudo port -v install mysql5 +server

After MySQL is installed, is time to configure and make MySQL start and running. First you have to init mysql data db with this command

sudo /opt/local/lib/mysql5/bin/mysql_install_db –user=mysql

Before starting mysql, copy my.cnf file to /opt/local/etc folder

cp /opt/local/share/mysql5/mysql/my-small.cnf /opt/local/etc/my.cnf

To start mysql,

sudo /opt/local/share/mysql5/mysql/mysql.server start

mysql.server is default start up script. You can copy it to /bin for your convenient to start/stop MySQL daemon anytime. For the first time, please make your MySQL username: root with password by this command.

mysqladmin5 -uroot password ‘your-passwd-here’

TextMate: Creating New Project in Shell Instantly

Been using TextMate recently, really loving it like hell. There is a best part of TextMate that you can create a New Project instantly from your www folder. But first and foremost you got to create symlink to /bin.

To create a symlink, do this

sudo ln -s /Applications/TextMate.app/Contents/Resources/mate /bin/mate

After you have created the symlink, change directory to your www folder for example

cd /opt/local/apache/htdocs/myproject

And run the command mate .

mate .

Congrat, new project has been created with Text Mate, just save it with shortcut key Ctrl + Command + S