如何在windows上安装bugzilla

因為工作需要，開始使用Bugzilla，不過因為Bugzilla大多都安裝在Linux平台，對於Windows平台而言，其實還是可以安裝Bugzilla，只是安裝的方式不同。

硬體規畫

因為原來安裝的APPServ已經安裝了其他的系統，而且APPServ內已經有了Web介面的PHPMyAdmin，對於管理MySQL而言相當方便，因此在這備範例中是將Bugzilla的AP和DB切開分別放在兩台電腦(PC:A、PC:B)上，和參考資料內AP和DB放在同一台電腦的情形不同。

PC:A、PC:B系統需求：OS: WindowsXP Professional

[PC:A]需要的軟體：

• Apache_2.0.59
• ActivePerl-5.8.8
• Bugzilla 4.0.1

[PC:B]需要的軟體：

• APPServ

[PC:B]安裝步驟

1. 安裝APPServ
2. 由網頁進入PHPMyAdmin在MySQL內建立一個帳號
   1. id: bugs
   2. password: password
   3. 主機: %(任何)
   4. 權限: ALL PRIVILEGES
      
3. 在MySQL內建立一個bugs資料庫

[PC:A]安裝步驟

1. 安裝Apache Server至D:\TestingEnv\Apache（By default）；
2. 安裝ActivePerl-5.8.8至D:\TestingEnv\Perl（By default）；
3. 設定Perl；
   複製<in.bat>至D:\TestingEnv\Perl，並執行它
4. 解壓縮bugzilla-2.22.2.tar.gz至D:\TestingEnv\bugzilla
5. 設定Apache的設定檔httpd.conf;
   1. 開啟D:\TestingEnv\Apache\Apache2\conf\httpd.conf
   2. 在<directory>的最後面加入：
      <directory testingenv="" bugzilla="">
      AddHandler cgi-script .cgi
      Options +Indexes +ExecCGI
      DirectoryIndex index.cgi
      AllowOverride Limit
      Options Indexes FollowSymLinks ExecCGI
      AllowOverride All
      Order allow,deny
      Allow from all
      ScriptInterpreterSource Registry-Strict </directory>
   3. 設定預設的首頁名稱
      以DirectoryIndex index.cgi index.html index.html.var default.htm
      取代DirectoryIndex index.html index.html.var
   4. 設定網頁別名
      # /別名/ 　"/真正目錄的路徑/"
      在Alias /icons/ "/home/httpd/icons/"下加入
      Alias /bugzilla/ "D:/TestingEnv/bugzilla/"
      
6. 執行<cgi.reg>在註冊表註冊CGI
7. 設定Bugzilla的設定檔localconfig;
   1. 開啟localconfig
   2. 設定$db_port = 3306;
   3. 設定$db_pass = password';
      
   4. 儲存並離開
8. 啟動Bugzilla
   1. 進入Dos視窗後
      D:\> cd d:\TestingEnv\bugzilla
      D:\TestingEnv\bugzilla>checksetup.pl
      
      Checking perl modules ...
      Checking for AppConfig (v1.52) ok: found v1.66
      Checking for CGI (v2.93) ok: found v3.29
      Checking for Data::Dumper (any) ok: found v2.121_12
      Checking for Date::Format (v2.21) ok: found v2.22
      Checking for DBI (v1.38) ok: found v1.58
      Checking for File::Spec (v0.84) ok: found v3.25
      Checking for File::Temp (any) ok: found v0.18
      Checking for Template (v2.10) ok: found v2.15
      Checking for Text::Wrap (v2001.0131) ok: found v2006.1117
      Checking for Mail::Mailer (v1.67) ok: found v1.77
      Checking for MIME::Base64 (v3.01) ok: found v3.07
      Checking for MIME::Tools (v5.406) ok: found v6.106
      Checking for Storable (any) ok: found v2.16
      
      The following Perl modules are optional:
      Checking for GD (v1.20) ok: found v2.16
      Checking for Template::Plugin::GD::Image (any) not found
      Checking for Chart::Base (v1.0) ok: found v2.3
      Checking for XML::Twig (any) ok: found v3.26
      Checking for GD::Graph (any) ok: found v1.43
      Checking for GD::Text::Align (any) ok: found v1.18
      Checking for PatchReader (v0.9.4) ok: found v0.9.5
      Checking for Image::Magick (any) not found
      Checking for HTML::Parser (v3.40) ok: found v3.56
      Checking for HTML::Scrubber (any) ok: found v0.08
      
      All the required modules are available at:
      http://landfill.bugzilla.org/ppm/
      You can add the repository with the following command:
      ppm rep add bugzilla http://landfill.bugzilla.org/ppm/
      
      If you want to convert BMP image attachments to PNG to conserve
      disk space, you will need to install the ImageMagick application
      Available from http://www.imagemagick.org, and the Image::Magick
      Perl module by running (as Administrator):
      
      ppm install Image::Magick
      
      If you you want to see graphical bug reports (bar, pie and line charts of
      current data), you should install libgd and the following Perl modules:
      
      Template::Plugin::GD: ppm install Template
      
      Checking user setup ...
      Creating data directory (./data) ...
      Creating local attachments directory ...
      Creating graphs directory...
      Creating .htaccess...
      Creating ./data/attachments/.htaccess...
      Creating Bugzilla/.htaccess...
      Creating ./data/.htaccess...
      Creating ./template/.htaccess...
      Creating ./data/webdot/.htaccess...
      
      Bugzilla requires an SMTP server to function on Windows.
      Please enter your SMTP server's hostname: mail.andestech.com
      Precompiling templates ...
      Checking for DBD::mysql (v2.9003) ok: found v3.0002
      Checking for MySQL (v4.0.14) ok: found v5.0.45-community-nt-log
      
      Building Schema object from database...
      Adding new table bz_schema ...
      Initializing the new Schema storage...
      Adding new table attach_data ...
      Adding new table attachments ...
      Adding new table bug_group_map ...
      Adding new table bug_severity ...
      Adding new table bug_status ...
      Adding new table bugs ...
      Adding new table bugs_activity ...
      Adding new table category_group_map ...
      Adding new table cc ...
      Adding new table classifications ...
      Adding new table components ...
      Adding new table dependencies ...
      Adding new table duplicates ...
      Adding new table email_setting ...
      Adding new table fielddefs ...
      Adding new table flagexclusions ...
      Adding new table flaginclusions ...
      Adding new table flags ...
      Adding new table flagtypes ...
      Adding new table group_control_map ...
      Adding new table group_group_map ...
      Adding new table groups ...
      Adding new table keyworddefs ...
      Adding new table keywords ...
      Adding new table logincookies ...
      Adding new table longdescs ...
      Adding new table milestones ...
      Adding new table namedqueries ...
      Adding new table op_sys ...
      Adding new table priority ...
      Adding new table products ...
      Adding new table profile_setting ...
      Adding new table profiles ...
      Adding new table profiles_activity ...
      Adding new table quips ...
      Adding new table rep_platform ...
      Adding new table resolution ...
      Adding new table series ...
      Adding new table series_categories ...
      Adding new table series_data ...
      Adding new table setting ...
      Adding new table setting_value ...
      Adding new table tokens ...
      Adding new table user_group_map ...
      Adding new table versions ...
      Adding new table votes ...
      Adding new table watch ...
      Adding new table whine_events ...
      Adding new table whine_queries ...
      Adding new table whine_schedules ...
      Converting attach_data maximum size to 100G...
      Inserting value 'P1' in table priority with sortkey 100...
      Inserting value 'P2' in table priority with sortkey 200...
      Inserting value 'P3' in table priority with sortkey 300...
      Inserting value 'P4' in table priority with sortkey 400...
      Inserting value 'P5' in table priority with sortkey 500...
      Inserting value 'UNCONFIRMED' in table bug_status with sortkey 100...
      Inserting value 'NEW' in table bug_status with sortkey 200...
      Inserting value 'ASSIGNED' in table bug_status with sortkey 300...
      Inserting value 'REOPENED' in table bug_status with sortkey 400...
      Inserting value 'RESOLVED' in table bug_status with sortkey 500...
      Inserting value 'VERIFIED' in table bug_status with sortkey 600...
      Inserting value 'CLOSED' in table bug_status with sortkey 700...
      Inserting value 'All' in table rep_platform with sortkey 100...
      Inserting value 'PC' in table rep_platform with sortkey 200...
      Inserting value 'Macintosh' in table rep_platform with sortkey 300...
      Inserting value 'Other' in table rep_platform with sortkey 400...
      Inserting value '' in table resolution with sortkey 100...
      Inserting value 'FIXED' in table resolution with sortkey 200...
      Inserting value 'INVALID' in table resolution with sortkey 300...
      Inserting value 'WONTFIX' in table resolution with sortkey 400...
      Inserting value 'LATER' in table resolution with sortkey 500...
      Inserting value 'REMIND' in table resolution with sortkey 600...
      Inserting value 'DUPLICATE' in table resolution with sortkey 700...
      Inserting value 'WORKSFORME' in table resolution with sortkey 800...
      Inserting value 'MOVED' in table resolution with sortkey 900...
      Inserting value 'blocker' in table bug_severity with sortkey 100...
      Inserting value 'critical' in table bug_severity with sortkey 200...
      Inserting value 'major' in table bug_severity with sortkey 300...
      Inserting value 'normal' in table bug_severity with sortkey 400...
      Inserting value 'minor' in table bug_severity with sortkey 500...
      Inserting value 'trivial' in table bug_severity with sortkey 600...
      Inserting value 'enhancement' in table bug_severity with sortkey 700...
      Inserting value 'All' in table op_sys with sortkey 100...
      Inserting value 'Windows' in table op_sys with sortkey 200...
      Inserting value 'Mac OS' in table op_sys with sortkey 300...
      Inserting value 'Linux' in table op_sys with sortkey 400...
      Inserting value 'Other' in table op_sys with sortkey 500...
      Creating initial dummy product 'TestProduct' ...
      Populating duplicates table...
      Migrating old chart data into database ...
      Initializing "Dependency Tree Changes" email_setting ...
      Adding group tweakparams ...
      Adding group editusers ...
      Adding group creategroups ...
      Adding group editclassifications ...
      Adding group editcomponents ...
      Adding group editkeywords ...
      Adding group admin ...
      Adding group editbugs ...
      Adding group canconfirm ...
      Adding group bz_canusewhines ...
      Adding group bz_canusewhineatothers ...
      Adding group bz_sudoers ...
      Adding group bz_sudo_protect ...
      Adding a new user setting called 'display_quips'
      Adding a new user setting called 'comment_sort_order'
      Adding a new user setting called 'post_bug_submit_action'
      Adding a new user setting called 'csv_colsepchar'
      Adding a new user setting called 'per_bug_queries'
      
      Looks like we don't have an administrator set up yet.
      Either this is your first time using Bugzilla, or your
      administrator's privileges might have accidentally been deleted.
      
   2. 輸入administrator的e-mailEnter the e-mail address of the administrator: josesun@andestech.com
      You entered josesun@andestech.com. Is this correct? [Y/n]
      
   3. 輸入administrator的姓名
      Enter the real name of the administrator: Jose Sun
      
      
   4. 輸入administrator的密碼
      Enter a password for the administrator account: xxxxxx
      
      
   5. 再次確認administrator的密碼
      Please retype the password to verify: xxxxxx
      
      yyy@xxx.com is now set up as an administrator account.
      Now that you have installed Bugzilla, you should visit the
      'Parameters' page (linked in the footer of the Administrator
      account) to ensure it is set up as you wish - this includes
      setting the 'urlbase' option to the correct url.
      

備註

1. 安裝的位置請自行依需求決定，本文使用D:\TestingEnv
2. 請注意文內的<複製後需要重新置換
3. <in.bat>的內容如下
   call ppm rep add bugzilla http://landfill.bugzilla.org/ppm/
   call ppm install AppConfig
   call ppm install Date::Format
   call ppm install Template
   call ppm install Mail::Mailer
   call ppm install MIME::Tools
   call ppm install GD
   call ppm install Template::Plugin
   call ppm install Chart
   call ppm install XML::Twig
   call ppm install GD::Graph
   call ppm install GD::Text::Align
   call ppm install PatchReader
   call ppm install Image::Magick
   call ppm install HTML::Scrubber
   call ppm install GDGraph
   call ppm install GDTextUtil
   call ppm install DBD-mysql
   call ppm install Net::Ldap
4. <cgi.reg>的內容如下
   Windows Registry Editor Version 5.00
   [HKEY_CLASSES_ROOT\.cgi]
   [HKEY_CLASSES_ROOT\.cgi\Shell]
   [HKEY_CLASSES_ROOT\.cgi\Shell\ExecCGI]
   [HKEY_CLASSES_ROOT\.cgi\Shell\ExecCGI\Command]
   @="d:\\TestingEnv\\perl\\bin\\perl.exe -T"

1. 51cto博客-《如何在windows上安装bugzilla》