Cloud Experience

Got the chance to mess around with Amazon EC2 console. And was really amazed on how fast setting up a server with AMI(Amazon Machine Image) is. Just browse from already existing thousands of AMI then launch. That simple.

One experience though that I don’t like somehow are that these LAMP AMIs seems a little flaky. I was looking into CentOS LAMP AMI. First thing I do after connecting to SSH on the instance is check if all LAMP is working and what version they are on.

First AMI I selected, apache restart doesnt work properly, I get the

apr_sockaddr_get_info() error

tried troubleshooting it then finally quit. Terminated the AMI and launched another one.

Then on the next other instances I can’t connect to MySQL but Apache and PHP are working right.

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)

Terminated the instance again and started a new one but still get the same error on MySQL. The solution I found is to simply install all the updates to overwrite any corrupted files.

Simply yum

#yum -y upgrade mysql mysql-server php-mysql

Now my LAMP is working great and ready for more cloud computing.

Facebook Vanity URL

Starting June 13, Facebook is launching their vanity url, you can have your friends directly access your profile from something like

http://www.facebook.com/olopsman. < -- your username Check it out here.

Typetalk picks 10 amazing resources for typography

Typetalk is a blog on creativepro.com. I love the list of resources picked regarding typography. Check it out the list here

#1045 – Access denied for user ‘root’@’localhost’ (using password: NO)

Been using WAMP for several months now and once in awhile MySQL breaks. Somehow the user tables gets corrupted. To fix the problem instead of reinstalling the whole WAMP. Just replace the corrupted files. These 3 files are always corrupted.

      user.MYI
      user.MYD
      user.frm

Download this mysqlusertables. Unzip the file, copy the 3 files inside.

Go into your C:\wamp\bin\mysql\mysql5.x.xx\data\mysql directory and paste, click yes to overwrite.

Restart All Service on your WAMP. Then you are good to go.

I’ll keep you posted soon on why these tables easily gets corrupted.

*Update*

Digging deeper to the culprit I found out the tables for users in the mysql db has warnings, meaning they are corrupt. So to avoid doing the steps above while your MySQL and phpMyAdmin is still working. Go to phpMyAdmin, access mysql db, then select users table then click on operations then under “Table maintenance” click on Repair Table. Viola!!!