As a developer, never thought one day I would install Bugzilla. I guess, developer always hates bug tracker. But I was appointed as a tester in a project, a there is no budget for any bug tracker. Thus, there is Bugzilla.

Several things you need to download using aptitude. Run below command in the terminal:

sudo apt-get perl apache2 libapache2-mod-perl2 build-essential mysql-server-5.1

Then download the latest Bugzilla from www.bugzilla.org. You may download it from Ubuntu repository, but I prefer to get the latest release, fresh from the oven. Once you have the bugzilla archived file. Unarchived it and you should get the bugzilla folder. Place the bugzilla folder in /var/www path and you should get /var/www/bugzilla.

Then you need to configure your apache2. Then open apache2 default file by command below:

sudo vi /etc/apache2/sites-available/default

Add this entry in your default file:

<Directory /var/www/bugzilla/ >
AddHandler cgi-script .cgi
Options +Indexes +ExecCGI
DirectoryIndex index.cgi
AllowOverride Limit
</Directory>

Then go to /var/www/bugzilla folder. Run below command:

sudo ./checksetup.pl --check-modules

It will list out which perl modules you need to install. You can install one-by-one depending on your needs. To keep things simple, we just install everything by running below command:

sudo perl install-module.pl -all

Perl will download, compile and install all the required and additional components for Bugzilla. Then open a file called localconfig by below command.

sudo vi /var/www/bugzilla/localconfig

Edit below attributes in the file:

#No .htacess file will be created. If set to 1, it will be created.
$create_htaccess=0;
#Web Server (Apache2) Group. Since I don't have one, I set to empty value.
$webservergroup='';
#Database type (default)
$db_driver='mysql';
#Database Host (default)
$db_host='localhost';
#Database Name (default)
$db_name='bugs';
#Database User (default)
$db_user='bugs';
#Database Password
$db_pass='';

Then enter your mysql console, and type below command to create a user named bugs and to set the privileges.

mysql > GRANT SELECT, INSERT,
UPDATE, DELETE, INDEX, ALTER, CREATE, LOCK TABLES,
CREATE TEMPORARY TABLES, DROP, REFERENCES ON bugs.*
TO bugs@localhost IDENTIFIED BY ’buggafool’;

mysql > FLUSH PRIVILEGES;

Run below command and the script will generate the necessary tables in your mysql server:

sudo /var/www/bugzilla/checksetup.pl

Restart your apache2 server by below command:

sudo service apache2 restart

Now you’re good to go. Browse your local bugzilla @ http://<ip-address>/bugzilla/.