bugzilla安装

bugzilla安装

最近需要安装bugzilla进行项目测试管理，安装环境：
OS：windows10
bugzilla:5.0.4
perl：Perl64-5.16.3
mysql：5.6.10

下载bugzilla安装文件:

https://www.bugzilla.org/download/

创建mysql数据库

mysql -u root -p
create database bugs;
create user bugs@localhost IDENTIFIED BY ‘myPassword’;
grant all on bugs.* to bugs@‘localhost’;
flush privileges;

安装perl

在perl官网下载安装包，建议版本Perl-5.16，或 Perl-5.18，如果版本高于Perl-5.20，某些perl依赖包安装不上。

perl添加资源库

默认资源库访问缓慢，需要添加其他镜像：
打开目录：D:\dev\Perl64-5.16.3\bin
打开ppm.bat，添加镜像地址
http://www.bribes.org/perl/ppm64

安装bugzilla

1、安装检查
D:\bugzilla-5.0.4>checksetup.pl
如下模块需要安装
COMMANDS TO INSTALL OPTIONAL MODULES:

      Chart: ppm install Chart
Template-GD: ppm install Template-GD
 MIME-tools: ppm install MIME-tools
   XML-Twig: ppm install XML-Twig
PatchReader: ppm install PatchReader
  perl-ldap: ppm install perl-ldap
Authen-SASL: ppm install Authen-SASL

Net-SMTP-SSL: ppm install Net-SMTP-SSL
RadiusPerl: ppm install RadiusPerl
SOAP-Lite: ppm install SOAP-Lite
XMLRPC-Lite: ppm install XMLRPC-Lite
JSON-RPC: ppm install JSON-RPC
Test-Taint: ppm install Test-Taint
HTML-Scrubber: ppm install HTML-Scrubber
Encode-Detect: ppm install Encode-Detect
Email-Reply: ppm install Email-Reply
HTML-FormatText-WithLinks: ppm install HTML-FormatText-WithLinks
TheSchwartz: ppm install TheSchwartz
Daemon-Generic: ppm install Daemon-Generic
mod_perl: ppm install mod_perl
Apache-SizeLimit: ppm install Apache-SizeLimit
File-MimeInfo: ppm install File-MimeInfo
IO-stringy: ppm install IO-stringy
Cache-Memcached: ppm install Cache-Memcached

COMMANDS TO INSTALL REQUIRED MODULES (You must run all these commands
and then re-run checksetup.pl):

ppm install TimeDate
ppm install Template-Toolkit
ppm install Email-Sender
ppm install Email-MIME
ppm install Math-Random-ISAAC
ppm install JSON-XS
ppm install DateTime-TimeZone-Local-Win32
*** Installation aborted. Read the messages above. ***

手工下载ppmx包

安装时提示需要使用 ppm install 安装缺失的包，但是总是出现丢包的问题，导致安装失败；
此时需要登录网站下载ppmx包，然后手工安装：
http://code.activestate.com/ppm/

Email-Sender相关包

Email-Sender depends on Capture-Tiny
Email-Sender depends on MooX-Types-MooseLike
Email-Sender depends on Email-Abstract
Email-Sender depends on Moo
Email-Sender depends on Throwable
Email-Sender depends on libnet
Email-Sender depends on Alt-Module-Runtime-ButEUMM
Email-Sender depends on Devel-GlobalDestruction
Email-Sender depends on Role-Tiny
Email-Sender depends on Class-Method-Modifiers
Email-Sender depends on Devel-StackTrace
Email-Sender depends on Socket
Email-Sender depends on Sub-Exporter-Progressive

可选包

Template-GD: ppm install Template-GD
 MIME-tools: ppm install MIME-tools
   XML-Twig: ppm install XML-Twig
PatchReader: ppm install PatchReader
  perl-ldap: ppm install perl-ldap
Authen-SASL: ppm install Authen-SASL

Net-SMTP-SSL: ppm install Net-SMTP-SSL
RadiusPerl: ppm install RadiusPerl
SOAP-Lite: ppm install SOAP-Lite
XMLRPC-Lite: ppm install XMLRPC-Lite
JSON-RPC: ppm install JSON-RPC
Test-Taint: ppm install Test-Taint
HTML-Scrubber: ppm install HTML-Scrubber
Encode-Detect: ppm install Encode-Detect
Email-Reply: ppm install Email-Reply
HTML-FormatText-WithLinks: ppm install HTML-FormatText-WithLinks
TheSchwartz: ppm install TheSchwartz
Daemon-Generic: ppm install Daemon-Generic
mod_perl: ppm install mod_perl
Apache-SizeLimit: ppm install Apache-SizeLimit
File-MimeInfo: ppm install File-MimeInfo
Cache-Memcached: ppm install Cache-Memcached

修改localconfig

安装完 checksetup.pl 的必选包后，在根目录下生成 localconfig文件，修改配置：
$db_port = 3306;
$index_html = 1;
$db_pass = ‘myPassword’;

再次执行 checksetup.pl

Enter the e-mail address of the administrator: admin@sina.com
Enter the real name of the administrator: admin
Enter a password for the administrator account: 123456
Please retype the password to verify: 123456

配置apache

How do I configure Apache 2.0.x to support ActivePerl?

These instructions assume that you have installed the Apache web server according to the instructions for the 2.0.x Windows version.

Open the httpd.conf file for editing by selecting Start > Programs > Apache HTTP Server > Configure Apache Server > Edit the Apache httpd.conf Configuration File.
 
This will open your httpd.conf file in the notepad editor.
Make the following changes to the httpd.conf file:
    In the DocumentRoot section, set the value of DocumentRoot to the directory in which your web site files will be located on your system's hard drive(s). Ensure that you use forward slashes (/) in the path, as Apache doesn't understand backward slashes (\) in paths. For example:

        # DocumentRoot: The directory out of which you will serve your
        # documents. By default, all requests are taken from this directory, but
        # symbolic links and aliases may be used to point to other locations.
        #
        DocumentRoot "C:/apacheroot"

    In the main directory section, add ExecCGI to the Options line. For example:

        Options FollowSymLinks ExecCGI

    Search for the following line and remove the hash mark character (#) to uncomment this line. (You can also change .cgi to .pl if you prefer.) For example:

        #AddHandler cgi-script .cgi

    Should look like:

        AddHandler cgi-script .pl

Save your changes to the httpd.conf file, and restart the Apache Service using the Apache Service Monitor.

安装apache服务

httpd.exe -k install -n “bugzilla”

启动服务

net start “bugzilla”

cgi 文件解析

完成上述配置后，访问如下地址，报500错误：
http://127.0.0.1/

错误描述：
[cgi:error] [pid 1992:tid 1300] (OS 2)系统找不到指定的文件。 : [client 127.0.0.1:60537] couldn’t create child process: 720002: index.cgi
[cgi:error] [pid 1992:tid 1300] (OS 2)系统找不到指定的文件。 : [client 127.0.0.1:60537] AH01223: couldn’t spawn child process: D:/bugzilla-5.0.4/index.cgi

解决办法：
index.cgi 第一行指定的是

#!/usr/bin/perl

需要将全部cgi文件头替换为Perl实际安装位置：

#!C:/Perl64/bin/perl.exe

邮件服务器

hMailServer-5.6.7-B2425
mail server 管理账号密码：myPassword

mail 数据库：
类型：mysql
数据库名称：mail
用户名：mail
密码：myPassword

错误描述：
安装邮件数据库时，使用mysql，可能提示如下错误：
需要将 mysql 32位 版的libmysql.dll 拷贝到
hMailServer\Bin\libmysql.dll
解决办法：
我安装的是mysql-x64位版本的，需要从hMailServer网站下载 32bit LIBmySQL_dll.zip，地址：
https://www.hmailserver.com/forum/viewtopic.php?f=21&t=29726

mail 创建用户

create user mail@localhost IDENTIFIED BY ‘myPassword’;
grant all on mail.* to mail@‘localhost’;
flush privileges;

至此，安装结束。

参考：

bugzilla安装
https://www.cnblogs.com/Warmsunshine/archive/2012/03/25/2416265.html
cgi异常处理
https://blog.csdn.net/default7/article/details/54669728