Installing GoDaddy SSL on an EC2 Ubuntu Instance in AWS

If you have sensitive data on your site, you may want to install an SSL Certificate to make it more secure. Here is a brief tutorial being on AWS EC2 Ubuntu instance on how to set it up.

My server settings are Apache2 and Ubuntu 9.x
Read the rest of this entry »

Import sql dump using the MySQL client

This is useful if you don’t have access to phpmyadmin on your server but have access to ssh and ftp. Or you have a huge sql dump like 10MB or higher that you cannot import directly on phpmyadmin. In my case the phpmyadmin directory was password protected by Apache and I don’t have the right password.

First upload the .sql file on your server using an FTP client and remember the path.

eg.
For Linux
/home/lopau/mydump.sql

for Windows
C:/wamp/www/lopau/mydump.sql

Login to your server using an SSH client like Putty.

On the command line access MySQL
$> mysql -u username -p password

replace username and password with yours.

On the MySQL client command line access and use your database.
$> use lopaudb;

Now to import your dump;
$> source /home/lopau/mydump.sql;

If successful you should see
Query OK, 13 rows affected (0.00 sec)

That easy.

All in One Package

I didn’t like using All in One Package during the my early years of learning how to install Apache, PHP and MySQL in my Windows box – there were programs like PHPTriad and similar which offers these three in one convenient installation without getting your hands dirty so to speak on the configuration. From my experience you should start with the manual installation to know the ins and out. That was what I was doing for the years, when a new version comes out I apply the upgrade to my system.

Earlier this month I got this client who uses WAMP 2.0 setup for the system we were developing.  Somehow I wasted several hours trying to make it run on my system. Was getting close but somehow if some changes were done to the system codes I feel it would break again. So I decided to try using WAMP 2.0 and it turns out its not that bad afterall. It has a UI for disabling/enabling extensions and modules, you can still go into the php.ini, my.ini, httpd.conf if you decide to edit manually from a shortcut all in one convenient place in your systray.

image_menu_wamp

It made my work faster, overall if you are using the manual way and move to an all in one package like WAMP 2.0 you would benefit both time and organization. I’m now a believer.

WordPress error- Is its parent directory writable by the server?

Been using WordPress now for about 4 months on my projects and I occasionally find problems with plugins and themes but not on WordPress itself. I seem to be getting good at troubleshooting some.

Yesterday my host changed servers, then I upgraded to the latest version of WordPress and everything got whack on uploading images in the admin with this error.
Read the rest of this entry »