Ashesh Saini | Blog

One day my friend came and asked me about the installation of bugzilla, He told me that his company is going to setup the testing infrastructure, so he was asked to set up the a bug tracking tool. As bugzilla was an free, open source tool for bug tracking, he suggested the bugzilla. but nobody in the company was knowing how to install it.  The steps to install involved in installation are not easy and have many configuration, version, os etc issues. I had installed the bugzilla in my laptop around a year ago. So I thought to do it again, and also write a post to help others in bugzilla installation. So dear here are the easy steps to install bugzilla on your system, in windows enviornment..

1. Download and Install Java 1.4 (j2sdk-1_4_2_17-windows-i586-p.exe)

2. Go to “My computer” Icon , Right Click and select properties.

System Properties >> Advanced >> Environment Variables
Add New Variables
“JAVA_HOME ”       C:\j2sdk1.4.2_17            [Or java directory path]

3. Download and Install MySQL Database, MySQL 5.1.22 and client version MySQL 5.1.11 including GUI tools.

Then create Database/catalogue with name “bugs”
Open MySQL Command Line Client From the menu and type the following command

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

This will create the User “bugs” with password “bugs”.

4. Now Download Perl (ActivePerl-5.8.8.822-MSWin32-x86-280952.msi) from ActiveState.com and Install It.

5. Open the PPM(pearl package manager) from

Start >> All Programs >> Active Perl 5.8.8 Build 822>> Pearl Package Manager
Select the First tab (Or press Shortcut Ctrl+1) to display all the packages and you can search using the text box search provided.
Then Install the Following Modules/ Package

# Bundle everything

#AppConfig (1.52)
Type In search Box : AppConfig
Install: AppConfig 1.66

#CGI (2.88)
Type In search Box : cgi
Install: CGI 2.93 (If shows warning that Higher Ver already Install then NO need to install)

#Data::Dumper (any)
Type In search Box : data-dumper
Install: Data-Dumper 2.121

#DBI (1.32)
Type In search Box : DBI
Install: DBI 1.58

#DBD::mysql (2.1010)
Type In search Box : DBD-mysql
Install: DBD-mysql 3.0002

#File::Spec (0.82)
Type In search Box : File-Spec
Install: File-Spec 0.84 (If shows warning that Higher Ver already Install then NO need to install)

#File::Temp (any)
Type In search Box : File-Temp
Install: File-Temp 0.2

#Template Toolkit (2.08)
Type In search Box : Template-Toolkit
Install: Template-Toolkit 2.19

#Text::Wrap (2001.0131)
Type In search Box : Text-wrap
Install: Text-wrapper 1.01

#Mime::Tools
Type In search Box : mime-tool
Install: Mime-tool, mime-xparser

#Date::Format (2.21)
Download from http://ppm.activestate.com/PPMPackages/zips/6xx-builds-only/TimeDate.zip
Unzip then and put the folder in “perl\lib” Directory
Open .ppd(its contains some xml ) file in MS .NET Development Environment Editor
Change the relevant section to

<IMPLEMENTATION>
<CODEBASE href=”MSWin32-x86-multi-thread/TimeDate.tar.gz” />
<ARCHITECTURE NAME=”" />
<OS NAME=”" />
</IMPLEMENTATION>

Read the readme and follow the Instructions
Go to Command prompt and cd c:\perl\lib\timedate
Now type ppm install TimeDate.ppd

6. Download Bugzilla (bugzilla-2.22.3.tar) and Unzip it in C:\ drive

7. Open the IIS Administration(RUN >> inetmgr), make a virtual directory with name “BugTracker”(any name except Bugzilla) and give the path of the folder C:\ bugzilla-2.22.3.

8. In the Bugzilla directory, Goto localconfig file and change there

$db_pass = ‘bugs’;

9. Open Command Prompt (Run >> cmd)

Open the file “checksetup.pl” inside the Bugzilla directory, e.g.

cd c:\bugzilla 2.33.2\

checksetup.pl

10. Follow the instructions.e.g.

Enter administrator Email ID
Enter Administrator Name
Enter Administrator Password

11. BUGZILLA is INSTALLED.!!.Now you only need to configure the IIS to handle .CGI scripts. this is very important and easiest part of installation, because with out completing this, everything is useless. like you have the food in front of you but dont have hands to eat.. anyways follow the below steps to accomplish the final target.

12. Using the IIS Administration tool again, open up the properties of the virtual directory, you created for bugzilla (see step 7) and select the Configuration option to access the Script Mappings. Create an entry mapping

.cgi
to
c:\perl\bin\perl.exe -xc:\bugzilla -wT “%s” %s

13. on the browser, Type “http://localhost/BugTracker/index.cgi”

14. You have done it dude!!! Congratulations!!!

This entry was posted by Ashesh Saini on Monday, March 31st, 2008 at 7:51 am and is filed under Knowledge base, Testing. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.