Installing Apache, MySQL, PHP on Ubuntu (Karmic Koala)


Posted on 19th December 2009 by Krow in Setup or Configuration |Tips & Tricks |Ubuntu

, , , , ,

Recently I have been asked by friends, colleagues and even family, how to install and configure a “development or testing” area on their personal computer (localhost). Because I have been asked to do this and each time I end up searching the Internet for guides and help, I thought that it would be a good time to condense what I have found, learned and know to be an ideal setup for a localhost environment.

I have set this post up differently then others that I have seen. I have broken the parts into sections and have linked to those sections so that if you need to come back for help on just one area you can jump to that section/area of the post.

Let me give guidance to those people who run Windows and even Mac OSx:

Windows Users
I would recommend you use a program called XAMPP. XAMPP is a great program and can be installed on all OS platforms (Linux, Mac and Windows). You can download a executable file from XAMPPs Site

Mac OSx Users
I would recommend you use a program called MAMP. MAMP is also a great program for the Mac users. It makes it easy for the users to get things done. You can download the dmg from the MAMP Site

Linux Users
Let’s get started since this post is for you.

Install Apache
Install MySQL
Install PHP

Installing Apache
Everything that I suggest here will be done through terminal. To launch terminal follow these steps:
Application -> Accessories -> Terminal

  1. Once terminal is open type or copy the following command:
    sudo aptitude install apache2
  2. Answer any questions that arise as you see fit. Once the process is finished installing you will need to test that the installation worked. To do this open another tab in your browser and in the address bar type localhost (link to help http://localhost). You should see the text “It works” and that means you have installed Apache2 correctly

If at the end of your installation you get an error or a message inside the terminal window that says “Could not reliably determine the server’s fully qualified domain name, using for ServerName” you can fix this by running the following command in terminal.
gksu gedit /etc/apache2/conf.d/fqdn

You might need to enter your password before the file will open. This command will open a file in gedit (a text editor for Linux).

  • When gedit opens, type “ServerName localhost” (without the quotes) inside the file and click Save.
  • Close the file.

Installing MySQL
Everything in the MySQL section will be done through the terminal window. To launch terminal follow these steps: Application -> Accessories -> Terminal

  1. Once terminal is open type of copy the following command:
    sudo aptitude install mysql-server libapache2-mod-auth-mysql php5-mysql
  2. Near the end of the installation you will be asked to give a user name and password for MySQL
    If you leave the user name blank it will default to “root”

That is it. At this point you should now have MySQL installed an running on your localhost. You can test this by typing mysql in the terminal window. If all is setup correctly you should get a “Welcome to MySQL monitor. Commands end with ; or \g.” and a prompt that says mysql>. From here you can run your mysql commands.

Installing PHP
Everything in the PHP section will be done through the terminal window. To launch a terminal follow these steps: Application -> Accessories -> Terminal

  1. Once your terminal is open type or copy the following command:
    sudo aptitude install php5 php5-common libapache2-mod-php5 php5-gd php5-dev curl libcurl3 libcurl3-dev php5-curl
  2. After everything is installed you will need to restart Apache for the server to see and implement PHP
    sudo /etc/init.d/apache2 restart
  3. You can now test to see if PHP5 is working with Apache. To test if PHP is installed you can create a .php file inside your /var/www/ directory
    sudo gedit /var/www/test.php
  4. The command will open gedit (Linux text editor). Once gedit is open type in the following code:
  5. Open a new tab in your browser and in the address bar type localhost/test.php (link to help http://localhost/test.php)

After running step 5 you should see your PHP Info page. This page will display the settings of your PHP configuration file and what is available via Apache2, MySQL and many other settings you may not care to know about. But the thing is if you see the PHP Information page you have successfully set up PHP5 to work with Apache.

Congratulations, I hope this means you have been able to install one, two or even all three of the items outlined in this post. If everything has worked out correctly you know have a local environment to develop on. Good luck and have fun.

If you have questions please leave a comment.

Play DVDs With Ubuntu 9.10:Karmic


Posted on 31st October 2009 by Krow in Tips & Tricks |Ubuntu


Ubuntu LogoI decided to upgrade my Ubuntu from 9.04 to the most recent release. The most recent being 9.10 Karmic Koala. Usually I tend to wait for a month or so to give the developers some time to fix stability, bugs and any other issues that arise. But all the reviews I was reading about and hearing from friends that it was a really good release, I just couldn’t wait.

So on Thursday night I started the process of backing up my personal stuff and anything else I could think of. Just in case something went horribly wrong. And at 1:28am on Friday morning I started the process. I ended up mostly working while it did its thing and I assume that due to the popularity the download process was very very slow.

On Friday morning at 7:30 (after I had gone to bed) it was almost finished. Just another 20 mins of things wrapping up and cleaning up. But at 9:00 the power went out. Luckily enough though the process was far enough that it was not relying on the Internet any more. So if wrapped up and I was able to check things out until power came back on at 10:30.

At this time I decided I would watch a movie and work at the same time. So I placed a horror film into the DVD Rom (28 Days Later, it is Halloween you know). The DVD never mounted. No matter what I did I could not find the DVD I put into the Rom. It was not in Nautilis, nothing mounted and displayed on the desktop. And now I couldn’t eject the Rom.

No matter what I did it would not eject so I went into my drawer can got my handy dandy “Disfigured Clippy” MS Mascot - Clippy(for those who don’t know “Clippy” is a Microsoft Mascot. Even though I use Linux I still call it “Clippy”). Any way so my clippy has been bent so that I can shove one end into the Rom hole to eject it.

So I shut it again with the DVD thinking it might have not registered the first time. Nope, same issue and I could hear the Rom spin and then stop. So now thinking that maybe for some reason my Rom is broken I used “Clippy” once again to eject the disk and placed a music CD into the Rom. Worked like a charm. Mounted and asked me what to play the music with.

So then with much frustration I figured I would try to get my movie playing. I mean I was in the mood to watch a movie and work so I had to have my movie now. It would be like telling a kid there is no Santa Clause. It had to work, it used to work until I upgraded.

My Friend GoogleI went to ask my friend what the heck and what can I do. He had the answer he always does. He is a great friend. I am sure you know him and probably ask him questions too. His name is Google. I take no credit for having the answer. Google lead me to many other friends that did have the answer. Some thought they did but did not (for instance it is just common knowledge to install libdvdcss2), and others did have the answers but only parts. So I am writing this so that if you find this post you will have all the answers from all those people in one place. I found the answers out there in the world but it took a lot of time and many trials and errors.

On to why you are here now. How to play DVDs within Ubuntu 9.10: Karmic Koala. You will need to open up a terminal and paste the following information into the terminal window. You will need to be connected to the Internet and depending on your Internet connection speed the process will take anywhere between 5 – 15 mins. Mine took 12 mins and I connect at 7MB down.

Paste this into your terminal window:
sudo wget`lsb_release -cs`.list --output-document=/etc/apt/sources.list.d/medibuntu.list; sudo apt-get -q update; sudo apt-get --yes -q --allow-unauthenticated install medibuntu-keyring; sudo apt-get -q update && sudo apt-get install -y ubuntu-restricted-extras non-free-codecs w32codecs totem-mozilla libdvdcss2 totem-xine xine-ui libxine1 libxinerama1 libxine1-all-plugins libxine1 libxine1-ffmpeg libdvdnav4 libdmx1 libdvdread4 gstreamer0.10-plugins-bad gstreamer0.10-plugins-ugly vlc smplayer smplayer-themes smplayer-translations && sudo /usr/share/doc/libdvdread4/

This is the magic. Once this is finished you are done. You can now watch your DVDs (and work happily).

Thanks for looking and if you know of any other tips and tricks for 9.10 please leave a comment so we all can be informed.


1 comment

Posted on 25th July 2009 by Krow in Tips & Tricks


I have a lot of music (legally owned and legally given to me from friends. Where they got it I don’t always know). Either way the tags on the music are all over the place and the file names are just horrible. Some of them are in the format I like (Artist/Album/Track# – Artist – Track Title) and some are not even close. While working at Code Greene I met Dexter The Dragon who is just as obsessed as I am in making sure the file names are in a specific way too.

I was using Windows and Dexter told me about a great tool that helps with this. The tool is excellent and it is known as Media Monkey and it does a good job. But I didn’t stick with Windows too much longer and moved to Linux as my Operating System. Sad as it seems I was not able to get all my music tagged and the file names into the format that I wanted so I was stuck with them as is. But then I found a program after many months of searching. It needed to work in Linux as I was not going down the road of Windows anymore. The program was named EasyTAG.

EasyTAG is just what you would think from the name. It is “easy” to use and “tag” your music and structure the file names in any format you choose. EasyTag is a utility for viewing and editing tags for MP3, MP2, MP4/AAC, FLAC, Ogg, MusePack, Monkey’s Audio and WavPack files. And for you Windows users it even runs on Windows too.

EasyTAG has a “scanner” option that is divine. The scanner option fills out tags for you based on the file-name. Because of the way I wanted my music tagged I had to go through a few extra steps to get them in my format but still it took me far less time to rename the files and tag the files the way I like. This process still took me some time to get done but now that it is I am so glad that my music is in the format I want.

EasyTAG is free and does a great job. It even helped me find Album Art that I was not able to find myself. How? I am unsure but I am happy it did.

If you are anything like me and ike your music formatted and tagged in a specific way but have a bunch that is so far gone that you felt there is no hope. I am here to say there is. It will take time but still there is hope. EasyTAG was the answer to my problems and saved me so much time and headaches.

As I briefly mentioned EasyTAG can be run on all types of OS’s. To list a few: Debian, Fedora, SuSE, FreeBSD MacOSX and Winodws. EasyTAG Download If you give it a try I would be interested to hear what you thought of it.