Install and configure Bugzilla (Windows)

Recently, a bug management system was required for the project. I checked it online and was prepared to find a lightweight defect tracking system for use. But I thought about it later, in fact, this system has played a very important role throughout the software life management cycle. We still need a professional tool to hold the mentality of "bugzilla, famous brand name factory, use it, it is correct, show it.
It is said that the installation and configuration of Bugzilla are troublesome, especially in Windows systems. Because I am also the first installation, some minor problems often occur. For example, a semicolon is required after the MySQL command, the backslash is used as a forward slash. It took half a day to install Bugzilla. In retrospect, it is not that troublesome. Here, we will summarize the installation experience.

Installation environment:
Operating System: WINXP SP2
Perl interpreter: ActivePerl (5.8.8.820)
Database: MySQL
Bugzilla 3.0
Web server: Apache 2.0.49

I. Install ActivePerl
The download and installation of ActivePerl is relatively simple and will not be described here. I installed a ActivePerl-5.8.8.820-MSWin32-x86-274739.msi ,:
Http://downloads.activestate.com/ActivePerl/Windows/5.8/ActivePerl-5.8.8.820-MSWin32-x86-274739.msi

Ii. Install MySQL
I am using the beta version 5.1.18.

After installing MySQL, perform the following configurations:
After the installation is complete, there should be a MySQL command line client, open the program, a prompt will be prompted and enter the root password, if you do not need this console, you can also open the console by yourself, go to the bin directory of MySQL and use MySQL-u root-P to enter MySQL configuration management.
First, create a Bugs database:
Mysql> Create Database bugs; (Note that there is a semicolon at the end)
Create a Bugs user and authorize
Mysql> grant select, insert, update, delete, index, alter, create, drop, references, lock tables, create temporary tables on bugs. * To Bugs @ localhost identified by 'buckets ';

Modify the password of a Bugs User:
Mysql> set password for 'buckets' @ 'localhost' = old_password ('bucketsassword ');
Last refresh
Mysql> flush privileges;
Check whether the bugs user is created successfully:
Mysql> quit
Mysql> mysql-u bugs-P
Enter Password: bugs

3. Install Bugzilla
Download and unzip the package, open the console, and go to the bugzilla directory.
First, let's talk about checksetup. the installation and configuration of Bugzilla depends on Pl. Generally, three Perl checksetup operations are required. pl, the first time running, all modules are not installed, copy the content to a notepad, so that you can view it later when installing the module.
There are two ways to install these modules: offline installation and online installation. I use online installation. to install these modules offline, first download a package from the bugzilla website, bugzilla-Boud
> Perl checksetup. pl
According to the checksetup prompt, Windows users must first run
Http://theoryx5.uwinnipeg.ca/ppms ppm repo add theory58s
Install the Perl module step by step as prompted, such
> Ppm install email-send

After installing all the modules, run Perl checksetup again. pl. If the main modules are correctly installed, a localconfig file will be generated in the bugzilla directory to modify the file, mainly including the following configurations:
$ Db_host = 'localhost ';
$ Db_name = 'buckets ';
$ Db_user = 'buckets ';
$ Db_pass = 'buckets ';

Finally, run Perl checksetup. pl again and you will be prompted to enter the Administrator information.

4. install and configure Apache
Almost all Apache configurations are in the httpd. conf file in the conf folder under the installation directory. Open the file and make the following changes:
1. Check whether the listening port is not in use. The default port is port 80. If it is occupied by other Web servers, modify the port number.
Listen 80
2. Modify the Home Directory Configuration

If you want to directly access through http: // localhost/, modify the main directory

Modify the DocumentRoot parameter. By default, this parameter is directed to the htdos folder under the Apache installation directory. Change this parameter to the installation path of Bugzilla. Remember to modify the following <directory> Parameters

To configure CGI Access, remove the # Above the following sentence
Addhandler CGI-script. cgi

Modify options indexes followsymlinks to options indexes followsymlinks execcgi
Change AllowOverride none to AllowOverride all
Add scriptinterpretersource registry-strict in the next line of AllowOverride all
Modify the default Apache Access File: add an index. cgi after directoryindex index.html. var.

3. Modify the registry and create the hkey_classes_root/. cgi/Shell/execcgi/command. Modify the default value to % Perl installation path %/bin/perl.exe-t.
Restart Apache

Configuration complete, enter
Http: // localhost/, you can see the bugzilla homepage.

PS. You can also create a virtual directory of Apache separately:
Find alias. By default, Apache has a virtual directory, such as Alias/icons/"D:/program files/Apache Group/apache2/icons /"
Add a virtual directory for Bugzilla below: alias/Bugzilla/"F:/software/etc/bugzilla-3.0/bugzilla-3.0 /"
Next, add the virtual directory permission in the next row:
Alias/bugzilla "F:/software/etc/bugzilla-3.0/bugzilla-3.0 /"
<Catalog "F:/software/etc/bugzilla-3.0/bugzilla-3.0">
Options execcgi all
AllowOverride all
Scriptinterpretersource registry-strict
Order allow, deny
Allow from all
</Directory>