Howto install Bugzilla on Ubuntu 11.04

Update : 1st may 2011 : Updated the installation for Ubuntu 11.04 and Bugzilla 4.0

I was trying out bugzilla installation on Ubuntu. Although there is a bugzilla3 package I never was able to properly configure it. Today, decided to look at this issue again and googled for any HOWTOs. I got this sweet piece of setup at : Handyowner . There are some formatting issues which made me struggle a bit - so here is the reformated installation guide.

Assumptions:
Ubuntu is already installed and configured on your target machine.
The machine is connected to the Internet you can browse the World Wide Web.
Here are the main steps:

1. Install Per l(5.8.1 or above)
2. Install MySQL
3. Install Apache2
4. Install Bugzilla 3.2
5. Install Perl modules
6. Bugzilla using apache

1. Perl
Verify if Perl is installed:

$ perl -v

If not installed :

$ sudo apt-get install perl

2. MySQL
Verify if MySQL is installed:

$ mysql --version

If not installed :

$ sudo apt-get install mysql-client mysql-server mysql-admin

Create “bugzilla” user with a strong password:

$ sudo useradd -d /home/bugzilla -m bugzilla
$ sudo passwd bugzilla

Tip! Here is what makes a password strong: make it lengthy, combine letters, numbers and symbols, use words and phrases that are easy for you to remember, but difficult for others to guess.

Create a database ‘bugzilla’ and grant privileges to ‘bugzilla’ database to ‘bugzilla’ user:

Tip! I usually set the bugzilla user password through the mysql admin interface ( Application -> Programming -> MySql Adminstrator).

$ mysql -u root -p
mysql> create database bugzilla;

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| bugzilla |
+--------------------+

2 rows in set (0.00 sec)

mysql> grant all privileges on bugzilla.* to bugzilla@localhost;

3. Apache2
Verify if Apache is installed:

$ apache2 -v

You can also view in a web browser the default welcome page at http://localhost
If not installed :

$ sudo apt-get install apache2

4. Bugzilla 3.2.2
Download Bugzilla from the site “ http://www.bugzilla.org/”.

Tip! Download a stable release, unless (1) you would like to go bleeding edge, (2) you do not care about spending time with your girlfriend, your wife, your kids or your buddies, (3) your boss said so and you couldn’t say no.

Untar the downloaded file to your download folder

$sudo tar -xvf bugzilla-3.2.2.tar

Move bugzilla dirrectory to /usr/local/

$ sudo mv /download/bugzilla-3.2.2 /usr/local/

Make a symbolic link from /usr/local/bugzilla3.x to /var/www/bugzilla

$ sudo ln -s /usr/local/bugzilla3.x /var/www/bugzilla

5. Perl Modules
Bugzilla’s installation process is based on a script called checksetup.pl. The first thing it checks is whether you have appropriate versions of all the required Perl modules. The aim of this section is to pass this check.

Verify if Perl modules are installed

$:/usr/local/bugzilla-3.2.2$ sudo ./checksetup.pl --check-modules

If not installed:

$:/usr/local/bugzilla-3.2.2$ sudo perl -MCPAN -e install

Edit the ‘localconfig’ file

$:/usr/local/bugzilla-3.2.2$ sudo gedit localconfig

Change the $db_name, $db_pass and $db_user value to the correct values. Here's how it looks like in my localconfig (replace the password with your actual password, this is just a placeholder here)

# The name of the database
$db_name = 'bugzilla';

# Who we connect to the database as.
$db_user = 'bugzilla';

# Enter your database password here.
$db_pass = 'bugzilla@123';

Run the checksetup.pl again. This will add a whole lot of tables for bugzilla, and you can verify that by looking at the tables in the 'bugzilla' database.

$:/usr/local/bugzilla-3.2.2$ sudo ./checksetup.pl

6. Configure Apache2 for Bugzilla
Add the following directives to /etc/apache2/apache2.conf

$sudo gedit /etc/apache2/apache2.conf

*Note : Since the brackets give problem with blogger, added pic for the relevant code changes. All the non commented lines are what you have to type in.

7. Additional security
create user “apache2″

$ sudo useradd -d /home/apache2 -m apache2
$ sudo passwd apache2

Edit /etc/apache2/envvars to add. This is how my config looks

export APACHE_RUN_USER=apache2
export APACHE_RUN_GROUP=apache2

Note : The default user and group is www-data. I don't really know how to setup the export to use both the www-data and the apache2 user simultaneously. If anyone can help with the syntax, it will be great ! 

Edit /usr/local/bugzilla-3.2.2/localconfig to add

$webservergroup = ‘apache2′;

Rerun checksetup.pl

$:/usr/local/bugzilla-3.2.2$ sudo ./checksetup.pl

This will ask you to setup your administrator for bugzilla. Go ahead and enter the password and email ids.


8. Check the Installation
Restart the apache server using the command

$ sudo /etc/init.d/apache2 restart

Type the in your browser http://localhost/bugzilla/ . You should be getting the bugzilla login page. Login using the email and password you did at end of pt 7.

Commandline Twitter

Got this idea about seeing if I can make a command line app for Twitter. I just don't want the full fledged thing, just the basic latest updates. Since I am also interested in learning python ( call it a geek itch), I decided to take it as a sample app for my foray.

It took me about 1 hour from setting out to finding the library to use and to write the code, and put in some text beautification. Nothing fancy, but does the job.

for those interested the code is as follows :

import twitter
api = twitter.Api(username='username', password ='password')
statuses = api.GetFriendsTimeline()
for s in statuses:
print "%s \t: %s" % (s.user.name , s.text)

An IDEA can change ur Life ... But, a Girl Can change Ur IDEA

Heat is On : Fire Blooms

Just another day's drive to the office.. or was it ? Yesterday evening's rain had made the temperature bearable. Also, this time I was with my camera looking for an opportunity to take a pic.

Its not easy though.

The traffic is the slow stop and go types. There is no place where you can pull over and get out of the car without the cars piling up behind you and blaring their horns. At a traffic light ( I was trying a new route through RK Puram), I saw a flash of yellow. Took out the camera from my bag and took a couple of pics. The gulmohar trees ( I hope I have identified the tree correctly) bloom in the summers , painting the treelines in reds and yellows.

The Heat is On : Its a dogs life

I have got a lot of suggestions about the 'Heat is On' photography project I am doing. I am still to start taking around my camera for the pics, so all the shots till now are from the iPhone's camera - not too great quality. This weekend I was moving around , shifting to Dwarka, so did not get much pics.

Blazing Hot Evening

The sun setting on a very hot Delhi evening. Unfortunately the pic does not bring out the riot of colours that were painting the sky. And since I was in peak traffic times, I did not stop the car to take a pic from a good place. Next time for sure. :)

Glucose Drip for the Dog

On Saturday I had to go to the Sanjay Gandhi Memorial Animal Hospital , taking the Dog along. He had not eaten for 2 days and was flopping around , hardly moving. Sunday morning, I took him to the hospital, and he was put on the glucose drip. After him a few more dogs were put on glucose.

The trees are now coming in colour, and I will try to get those pics. I also need to start travelling with my camera always in my bag, else I miss some neat shots.

The Heat is On

Its HOT.

Let me repeat that.

Its HOT. Really HOT. And its gonna get Hotter!

The screenshot shows the temperature today. The wind blows - hot. Its called लू (loo) in Hindi. It sucks you of energy, makes you want to find shelter out of the sun as soon as you can. The sweat dries off as soon as it forms, hardly giving any respite.

However, I have decided to figure out what can I do about it all. I am planning to start photographing the heat. What I want from you is ... give me your thoughts on what the heat brings to your mind. I will try to find those subjects and take pics and see how it goes.