I’ve been playing around with the Bugzilla in order to understand how it works together with the system. I was being provided with the information about the flow of how to migrate the bug issues to the system but there are no detailed instructions on how to install Bugzilla. Although the main point is not to understand how to use Bugzilla but I’m curious to know about the functionalities and how the interface looks like.

So, I allocate some time to install the Bugzilla and before the installation, I thought there is no difference with other software installation that can be guided with the setup wizard but I was wrong. I feel the installation process is quite interesting and I jotted down each error or mistake that I had done during the installation with the solution as well. Although I don’t know since when I have this kind of habit but all these time, I will jot down every step, every error and every solution for installation that requires configuration. This is because I will probably need to perform the same installation in the future. Sometimes, installation (especially related to Apache) can put you into the situation of a platform game and you are solving each puzzle to finish the game

I did a research on how the installation works and I got this site which is quite useful for me and I had added some details in my own version of solution:

Install Bugzilla on Ubuntu 8.10

Let’s get started each step in a detailed way.

———————————————————-

Getting Bugzilla and Installation

1. You can either download from here: http://www.bugzilla.org/ if you are using Windows. As for Ubuntu, we have the advantage to install bugzilla with this command:

sudo apt-get install bugzilla3


2. During the installation process, the following information will be requested from you:

• email address (Bugzilla administrator)
• Real name of administrator
• Password of administrator
• Password confirmation
• dbconfig-common (Yes/No)
  * I answered yes. I don’t want to do any manual work with the database as I want to reduce the risk of anything working improperly.
• Password of administrator (Package configuration)
• MySQL application password (I assumed you already installed MySQL locally)
• Password confirmation

Further Setup after Installation

1. Copy the example Bugzilla configuration file to the Apache configuration folder

sudo cp/usr/share/bugzilla3/debian/apache.conf /etc/apache2/conf.d/bugzilla3.conf


2. Restart web server

sudo /etc/init.d/apache2 restart


Roadblock #1

• During restart apache2, the following error prompts out:

Restarting web server apache2
(98) Address already in use: make sock: could not bind to address 0.0.0.0:80
no listening sockets available, shutting down
Unable to open logs
[fail]


Clear the Roadblock #1

• Comment the following line in /etc/apache2/ports.conf:
Listen 80
• Check any processes are currently running for apache2

ps –elf | grep apache2

• Kill all the related processes

sudo killall apache2

• Test it by:

netstat –l |grep 443


3. Restart the web server by performing the step 2 again

4. Ensure that the Bugzilla parameter file is readable by Apache (as suggested in the page):

• sudo chmod g+rw /etc/bugzilla3/params
• sudo chown www-data:www-data /etc/bugzilla3/params

5. Access the bugzilla site (http://your_server_name/cgi-bin/bugzilla3)

Roadblock #2

• When accessing the site, the following error (Forbidden 403) prompts out:

Forbidden
You don’t have permission to access /cgi-bin/bugzilla3/ on this server


Clearing Roadblock #2

Access the site by either of the following:

• http://localhost/cgi-bin/bugzilla3/index.cgi

• http://IP_ADDRESS/cgi-bin/bugzilla3/index.cgi

Bugzilla site login

1. Access to the mysql

sudo mysql –h localhost –ppassword

2. Access the bugzilla database

use bugzilla3;

3. Check the user or login name for bugzilla site

select * from profiles;


If your system having the feature that provides Bugzilla Import and in order to make them to work together happily, you might

need to have the following information for the configuration:

• Bugzilla Database URL
• Database login name
• Database login password
• Driver Name

All the information can be mapped back or checked from /etc/bugzilla3/localconfig:

• $db_host
• $db_name
• $db_user
• $db_pass

So, you can configured the requested information as following:

• Bugzilla Database URL – jdbc:mysql://localhost/bugzilla3?autoReconnect=true&useUnicode=true
• Database login name – bugzilla3
• Database login password – password
• Driver Name – com.mysql.jdbc.Driver