一直寻找合适的Bug Tracking System，网上找了很久，commercial的太贵，还有licence限制，远远超出我等贫民的承受范围。也曾考虑干脆自己写一个算了，但终究未能如愿。对Bugzilla倒是早有所闻，只可惜好像在Linux下比较好安装，在windows上却难上加难。在Bugzilla的document和FAQ中可见一斑：
Making Bugzilla work on windows is still a very painful processes. The Bugzilla Team is working to make it easier, but that goal is not considered a top priority. If you wish to run Bugzilla, we still recommend doing so on a Unix based system such as GNU/Linux. As of this writing, all members of the Bugzilla team and all known large installations run on Unix based systems.
If after hearing all that, you have enough pain tolerance to attempt installing Bugzilla on Win32, here are some pointers. Because this is a development version of the guide, these instructions are subject to change without notice. In fact, the Bugzilla Team hopes they do as we would like to have Bugzilla resonabally close to "out of the box" compatibility by the 2.18 release.
A.6.1. What is the easiest way to run Bugzilla on Win32 (Win98+/NT/2K)?
Remove Windows. Install Linux. Install Bugzilla. The boss will never know the difference.
本人花了差不多两天时间，终于基本上在windows 2000 professional上安装上了bugzilla，现在贡献出来，希望对大家能有所帮助。
二、安装Mysql
1、下载Mysql(http://www.onlinedown.net/)，我下载的是mysql-4.0.15-win.zip，直接安装即可。同时可以下载安装mysqlcc-0.9.3-win32.zip，这是mysql的管理软件，挺好用的。
2、修改mysql的root用户密码
E:\>cd mysql
E:\mysql>cd bin
E:\mysql\bin>mysql -u root mysql
mysql>UPDATE user SET Password=PASSWORD('<new_password'>) WHERE user='root';
mysql>FLUSH PRIVILEGES;
其中<new_password>为root用户的新密码。更改密码后，要用root用户访问mysql，必须使用mysql -u root -p，按提示敲入正确的root密码。
3、创建bugs用户，并赋给相应的权限
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, ALTER,CREATE,DROP,REFERENCES,LOCK TABLES,CREATE TEMPORARY TABLES ON bugs.* TO bugs@localhost IDENTIFIED BY '<bugs_password>';
mysql> FLUSH PRIVILEGES;
要记住bugs用户的密码，在下面的bugzilla配置文件要用。
4、创建bugs数据库
mysql>create database bugs;
四、配置IIS
1、打开控制面板->管理工具->Internet Information Services, 再Default Web Site右键选择Properties-> Home Dictory-> Configuration,在App Mappings中点击Add增加如下资料
Executable: D:\Perl\bin\perl.exe "%s" %s
Extension: .pl
Limit to: GET,HEAD,POST
Executable: D:\Perl\bin\perl.exe "%s" %s
Extension: .cgi
Limit to: GET,HEAD,POST
注意Perl.exe的路径
2、Default Web Site中增加Virtual Directory: Bugzilla。Access Permission增加Execute。
3、选择刚建立的虚拟目录Bugzilla,右键选择Properties-> Documents。Default Documents中增加index.cgi。
五、安装Bugzilla
bugzilla目录下有一个checksetup.pl脚本。这个脚本写的简直太好了，它既可以检查bugzilla需要的perl模块是否已安装，又可以创建数据库的表及admin用户。不过需要改几个地方才能够在windows下正常使用。在/bugzilla/docs/html/Bugzilla-Guide.html中有如下描述：
4.3.1.3.1. Changes to checksetup.pl
In checksetup.pl, the line reading:
my $mysql_binaries = `which mysql`;
to
my $mysql_binaries = "D:\\mysql\\bin\\mysql";
And you'll also need to change:
my $webservergid = getgrnam($my_webservergroup)
to
my $webservergid = '8'
我的邮箱lijw@lonwin.com.cn，欢迎测试同仁共同交流使用的经验。作者: 闲客 时间: 2004-5-25 09:41
谢谢楼上作者: 闲客 时间: 2004-5-26 16:03
你好！我按照Bugzilla Windows安装红宝书 以及http://www.devmanclub.com/ShowPost.aspx?PostID=4130上面讲的方法安装，但是在运行的D:/Bugzilla/PerlModule/PerlModule.dat这个批处理文件时，提示的信息是：
*******Start install perl module for Bugzilla***********
******************Ready Go!!!***********************
********* Install Bundle::Bugzilla Module ************
Searching for 'Bundle::Bugzilla' returned no results. Try a broader search fir
.
OK!!
********* Install Chart Module ************
Error: PPD for 'Chart.ppd' could not be found.
OK!!
********* Install CGI Module ************
Note: Package 'CGI' is already installed.
********* Failed??
********* Download it from fllowing URL ********** http://cpan.shellhung.org/authors/id/L/LD/LDS/CGI.pm-3.04.tar.gz
********* Use it with fllowing step **********
********* 1. Upzip this tar.gz
********* 2. Run the CMD.exe
********* 3. Into the upzipped tar.gz use dos command "cd"
********* 4. perl MakeFile.pl
********* 5. nmake
********* 6. nmake test
********* 7. nmake install
********* 8. OK!!
********* Install Date::Format Module ************
Searching for 'Date::Format' returned no results. Try a broader search first.
********* Failed??
********* Download it from fllowing URL ********** http://cpan.shellhung.org/author ... imeDate-1.16.tar.gz
********* Use it with fllowing step **********
********* 1. Upzip this tar.gz
********* 2. Run the CMD.exe
********* 3. Into the upzipped tar.gz use dos command "cd"
********* 4. perl MakeFile.pl
********* 5. nmake
********* 6. nmake test
********* 7. nmake install
********* 8. OK!!
********* Install AppConfig Module **********
Error: PPD for 'AppConfig.ppd' could not be found.
********* Failed??
********* Download it from fllowing URL ********** http://cpan.shellhung.org/author ... pConfig-1.55.tar.gz
********* Use it with fllowing step **********
********* 1. Upzip this tar.gz
********* 2. Run the CMD.exe
********* 3. Into the upzipped tar.gz use dos command "cd"
********* 4. perl MakeFile.pl
********* 5. nmake
********* 6. nmake test
********* 7. nmake install
********* 8. OK!!
********* Install Data:umper Module **********
Searching for 'Data:umper' returned no results. Try a broader search first.
OK!!
********* Install Date::Format Module **********
Searching for 'Date::Format' returned no results. Try a broader search first.
OK!!
********* Install DBI Module **********
Note: Package 'DBI' is already installed.
OK!!
********* Install DBD::mysql Module **********
Searching for 'DBD::mysql' returned multiple results. Using 'search' instead..
Searching in Active Repositories
1. DBD-mysql [2.9002] A MySQL driver for the Perl5 Database Interface (DB
2. DBD-mysqlPP [0.04] Pure Perl MySQL driver for the DBI
OK!!
********* Install File::Spec Module **********
Note: Package 'File-Spec' is already installed.
OK!!
********* Install File::Temp Module **********
Note: Package 'File-Temp' is already installed.
OK!!
********* Install Template::Toolkit Module **********
Searching for 'Template::Toolkit' returned no results. Try a broader search fi
t.
********* Failed??
********* Download it from fllowing URL ********** http://cpan.shellhung.org/author ... Toolkit-2.12.tar.gz
********* Use it with fllowing step **********
********* 1. Upzip this tar.gz
********* 2. Run the CMD.exe
********* 3. Into the upzipped tar.gz use dos command "cd"
********* 4. perl MakeFile.pl
********* 5. nmake
********* 6. nmake test
********* 7. nmake install
********* 8. OK!!
********* Install Text::Wrap Module **********
Searching for 'Text::Wrap' returned multiple results. Using 'search' instead..
Searching in Active Repositories
1. Text-Wrapper [1.000] Simple word wrapping routine
2. Text-WrapProp [0.03] proportional line wrapping to form simple paragraph
OK!!
********* Install Chart::Garph Module **********
Searching for 'Chart::Garph' returned no results. Try a broader search first.
********* Failed??
********* Download it from fllowing URL ********** http://cpan.shellhung.org/author ... rt-Graph-1.1.tar.gz
********* Use it with fllowing step **********
********* 1. Upzip this tar.gz
********* 2. Run the CMD.exe
********* 3. Into the upzipped tar.gz use dos command "cd"
********* 4. perl MakeFile.pl
********* 5. nmake
********* 6. nmake test
********* 7. nmake install
********* 8. OK!!
********* Install GD Module **********
Error: PPD for 'GD.ppd' could not be found.
OK!!
********* Install GD::Graph Module **********
Searching for 'GD::Graph' returned no results. Try a broader search first.
OK!!
********* Install GD::Text::Align Module **********
Searching for 'GD::Text::Align' returned no results. Try a broader search firs
umper Module **********