Friday, April 13, 2012

Install LAMP in Ubuntu 12.04 Precise(Apache, MySQL, PHP)

This is a short guide to installing a basic LAMP(Linux, Apache, MySQL, PHP) development environment on Ubuntu 12.04 Precise Pangolin.

First install lamp:
Open a terminal and run the following:

sudo apt-get install lamp-server^

After the lamp server installation you will need write permissions to the /var/www directory.  Follow these steps to configure permissions.

Add your user to the www-data group

sudo usermod -a -G www-data <your user name>

now add the /var/www folder to the www-data group

sudo chgrp -R www-data /var/www

now give write permissions to the www-data group

sudo chmod -R g+w /var/www

now log out and log back in to see the changes reflected in nautilus.

Some extra things to install
The following are not essential but they are things I almost always need as part of a LAMP install so I have included instructions on installing them.

Curl:

sudo apt-get install php5-curl

Mod rewrite:

sudo a2enmod rewrite

GD2 Graphics Lib:

sudo apt-get install php5-gd


And that's it, how easy was that?  Ubuntu rocks!

Sunday, April 1, 2012

Install MySQL Workbench on Ubuntu 12.04

Currently there is no pre-built .deb file or repo available to install MySQL Workbench on Ubuntu 12.04.  One will probably appear soon after official release of 12.04 but at the moment it is still in beta so there are a few extra steps to get it working.

NOTE: Once Ubuntu 12.04 moves out of beta there will probably be a better way of doing this so please check the official MySQL Workbench download page and the official 12.04 repos before attempting this.

First of all you will need to download the latest MySQL Workbench from here.

Next you must download a .deb file for libzip1 as it is not available in the 12.04 repos.

32 bit version - https://launchpad.net/ubuntu/+archive/primary/+files/libzip1_0.9.3-1_i386.deb
64 bit version - https://launchpad.net/ubuntu/+source/libzip/0.9.3-1/+build/1728114/+files/libzip1_0.9.3-1_amd64.deb
for other architectures go here

After downloading just open them with the software centre and click install.

*NEW: The libmysqlclient16 package was removed from the 12.04 repos so you will need to download the old deb files for it:

32 bit version - http://launchpadlibrarian.net/94563300/libmysqlclient16_5.1.58-1ubuntu5_i386.deb
64 bit version - http://launchpadlibrarian.net/94808408/libmysqlclient16_5.1.58-1ubuntu5_amd64.deb


 Next open a terminal and install the following packages:

sudo apt-get install libzip1 python-paramiko python-pysqlite2 libctemplate0 libgtkmm-2.4-1c2a libmysqlclient16

Then cd to the directory where you downloaded the deb file and run:

sudo dpkg -i mysql-workbench-gpl-5.2.38-1ubu1104-i386.deb

And that should be it, enjoy!

Instructions loosely based on those found here: http://blog.csdn.net/kevin6216/article/details/7420421