Win2000 Bugzilla installation record
(Author: Jackey, Website: www.kuihua.net)
1 Introduction:
Bugzilla is a software test tool, a good open source bug tracking system; because it is specially developed for UNIX, I want to install it under the Windows platform; I don't know what is why, online Most of the installation of Bugzilla is bracked, plus it itself is a Perl script that can be modified, and the Bugzilla development team may also have a small problem in code maintenance and release; these factors have to be in Windows. Building a relatively complete bugzilla system under the platform, but also difficult to increase; however, if there is a certain perl language knowledge, it is still relatively fast.
This article is an experience introduction to the installation and modification of the Bugzilla script in a Windows LAN environment, step by step to configure and build bugzilla installation environments. Here are some other connection maps in this article, welcome you to discuss use and make progress together.
Sunflower Forum: http://www.kuihua.net/bbs/dispbbs.asp? BoardId = 1 & rootid = 1035 & id = 1035
Microsoft Training: http://www.devmanclub.com/showpost.aspx? Postid = 4130
9CBS column: http://www.9cbs.net/develop/read_article.asp? Id = 24088
In addition, this article refers to the following article in the Microsoft Training Forum, this article should be the improvement version of this article :), if you have anything, please leave a message or E-mail contact me. At the same time, in order to ensure that all the officials can truly use Bugzilla to rescue the vast people from the compassion of the PERL script, I also provided a Chinese version that has already excluded a large number of bugs, but still wants to make simple modifications. It is mainly to fill in the installation path of the E-mail address and MySQL; the article also explores how to use the CVSNT system to simultaneously upgrade the Bugzilla Development Team to avoid repeatedly modifying the Upgrade of Bugzilla; refer to the CVSNT system.
Reference article: http://www.devmanclub.com/showpost.aspx? Postid = 2584
CVS article: http://www.9cbs.net/develop/read_article.asp? Id = 19756
Download connection: http://www.kuihua.net/soft/bugzilla-2.17.6 (jackey) .rar
Finally, I wish you all the best in the world, using bugzilla to eliminate countless bugs every day, haha! !
2 Install MySQL and MySQLCC:
1. This article uses the latest mysql for windows version 4.0.17, no problem, this is the official download connection: http://www.mysql.com/get/downloads/mysql-4.0/mysql-4.0.17- Win.zip
2. Need to pay attention to it is best not to change the default installation location of MySQL, otherwise, you cannot boot, you need to change some settings. Here, you have: d: / mysql
3. After the installation is complete, enter D: / mysql / bin, execute Winmysqladmin.exe, if a green light appears, indicating that your MySQL system is started normally. 4. Download the Mysql Center Control version, this is a MySQL manager that can directly modify the database content, which is very convenient. Download connection: http://ftp.tku.edu.tw/mysql/downloads/mysqlcc/mysqlcc-0.9.3-win32.zip
5. Modify the mysql root user password:
D: /> cd mysql
D: / mysql> cd bin
D: / mysql / bin> mysql -u root mySQL
MySQL> Update User Set Password = Password ('
mysql> flush privileges;
Description: Where
6. Create a BUGS user and assign the appropriate permissions:
Mysql> Grant Select, Insert, Update, Delete, Index, Alter, Create, Drop, References, Lock Tables, Create Temporary Tables on bugs. * to bugs @ localhost identified by '
mysql> flush privileges;
Note: To remember the password of the BUGS user, use it in the bugzilla configuration file below.
7. Create a BUGS database:
Mysql> Create Database Bugs;
Mysql> EXIT
8. You can open mysqlcc.exe at this time, log in to this machine's MySQL database with root users to see changes; note: The above database operation can be operated directly in MySQLCC.
3 Install ActivePerl and related modules:
1. Download ActivePerl-5.6.1.633-MSWIN32-x86.msi or above. Here, you assume that your installation path is: d: / perl
2. Modify the download address of the PPM (Perl Package Manager) to improve the download speed when Perl installing other modules.
Open d: /perl/lib/cpan.pm, find and change $ cpan: defaultsite || = "ftp://ftp.perl.org/pub/cpan"; $ CPAN: Defaultsite || = "http: / /CPAN.SHELLHUNG.ORG ";
3. Because there are several perl modules that cannot be installed directly, you need to download to local NMAKE.EXE and CL.EXE to be compiled and installed, so it is best to install a Visual C 6.0 so that the installation of special modules can be completed.
4. Bugzilla needs multiple perl module support. It is introduced in its help documentation. In order to facilitate and simplify the installation process of the officials, I wrote a simple batch file. If you download my own modification package After the decompression has a PerlModule directory, there is a perlmodule.bat file, running directly, but you need to pay attention to: There are several modules that cannot be installed directly, take a closer suggestion, tell you how to install these special modules. Here, the AUTHEN :: SASL module is added to send mail authentication information. In addition, the source code for this batch is listed in the appendix of this article for improvement and reference. 4 download bugzilla:
1. First explain: If you have downloaded the modified package I have, this part can be skipped directly, and it has been changed in the modification package.
2. Www.bugzilla.org currently only bugzilla-2.17.6.tar.gz download, but its user authentication section has a problem, which is bugzilla / bugzilla / auth / db.pm file, you can provide CVS servers from Mozilla Uploaded uploaded upload, Mozilla's CVS server is as follows: anonymous@cvs-mirror.mozilla.org: / cvsroot
3. Here you assume that your decompression position is: D: / bugzilla
4. Download the Chinese Chinese version, you can download the SourceForge.net download, I use the latest bugailla-2.17.4-cn-0.92.tar.gz in my modification package, and it is still in English. If you are interested in your business, you can use your own Chinese because it is some of some active code scripts.
5. Decompress the downloaded file and copy the CN directory to the D: / bugzilla / template directory.
5 Configuring IIS:
1. Open [Control Panel] -> [Management Tool] -> [Internet Service Manager], press the [Default Web Site] Press the [Properties] -> [Main Directory] -> [Configuration ...], in [ Application Mapping] Click [Add], add the following information:
2. Perl script parser: (*. Pl)
Executable file: d: /perl/bin/perl.exe "% s"% s
Extension: .pl
Only: get, head, post
3. CGI script parser: (*. Cgi)
Executable file: d: /perl/bin/perl.exe "% s"% s
Extension: .cgi
Only: get, head, post
4. Default Web Site] -> [New] -> [Virtual Directory]:
Alias: Bugzilla, Access Directory: D: / Bugzilla, access [write] permissions.
5. Select the original virtual directory bugzilla, right click to select [Properties] -> [Document]. [Default Document] Add index.cgi.
6 Modify Perl script files: 6.1 I have downloaded the concept of the modified package provided. Please see: 1. Open the D: /bugzilla/defParams.pl file, position to the end of the file, do the following information modification: 2. Replace Bugzilla Access Page: Replace HTTP: //
For example: $ db_pass = "i am ladeng"; 6.2 No download of the modified package provided by me: 1. Open the D: / bugzilla under all .cgi files, remove the last line T character, as follows: for example : #! / Usr / bin / perl-wt => #! / Usr / bin / perl -w 2. Open all the .cgi files under D: / bugzilla, find the Require "CGI.PL"; add a line behind it : Require "globals.pl"; Note G must write, otherwise Perl will report some files unable to locate; but there are several files very special, must be written as Require "globals.pl", it is strange, these files are: token. CGI, UserPrefs.cgi, token.pm, this question is not aware of the reason, what is the reason for the reason, please tell me :) 3. Open the d: /bugzilla/globals.pl file, in front of Use Bugzilla Join the following message Send code: Sub sendmail {MY ($ MSG, $ Person) = @_; user net :: smtp; my $ smtp_server = param ("mailserver"); My $ SMTP_USER = Param ("Mailuser"); MY $ SMTP_PASS = Param ("mailpass"); # $ Person. = param ('emailsuffix'); MY $ SMTP = Net :: SMTP-> New ($ SMTP_SERVER) || DIE 'Cannot Connect To Server /' $ SMTP_SERVER / ''; $ SMTP-> Auth ($ SMTP_USER, $ SMTP_PASS); $ SMTP-> Mail ($ SMTP_USER); $ SMTP-> To ($ Person); $ SMTP-> DATA (); $ SMTP-> Datasend ($ msg); $ SMTP-> DATAEND (); $ SMTP-> quit;} 4. Open the D: /Bugzilla/defParams.pl file, modify the default language settings: Find name => 'Language' Modify default => 'en' to default => 'CN' Find name => DEFAULTLANGUAGUE 'Modify default => 'en' is default => 'CN' 5. Open the D: /Bugzilla/defParams.pl file, modify the default Bugzilla login page: Find name => 'urlbase' to modify default => 'http: // .... The specific Bugzilla landing page is modified.
6. Open the D: / bugzilla / defparams.pl file, add 3 email notifications to the global parameter configuration item: 1 MailServer (mail send server address) {name => 'mailser', desc => 'mail-server assigned by Jackey In 2004.02.02! ', Type =>' t ', default =>' pop3.263.net '}, 2 Mailuser (mail sender mailbox) {name =>' mailuser ', desc =>' Mail-User Assigned by jackey in 2004.02.02! ', type =>' t ', default =>' yoyo@263.net '}, 3 mailpass (mail sender password) {name =>' mailpass ', desc =>' mail -Pass assigned by jackey in 2004.02.02! ', Type =>' t ', default =>' I am lade '}, 7. Open .cgi, .pl, .pm file for email configuration modification : The specific method is to block the original mail to send code Open Sendmail, replace it into a custom sendmail (...) function.
1 Open d: /bugzilla/cgi.pl and change Open Sendmail ($ msg, $ login); 2 Open d :/bugzilla/token.pm, change Open Sendmail to: Sendmail ($ Message, $ VARS -> {'emaildress'}; 3 Open d: /bugzilla/whineatnews.pl, change Open Sendmail to: Sendmail ($ MSG, $ Substs {'email'); 4 Open D: /Bugzilla/move.pl The Open Sendmail is changed to: Sendmail ($ msg, $ to); 5 Open D: /Bugzilla/importXML.PL, change Open Sendmail to: Sendmail ($ header. $ Message. "/ N", $)); 6 Open D: /Bugzilla/Bugmail.pm, change Open Sendmail to: Sendmail ($ MSG, $ Person) Open D: /Bugzilla/flag.pm, change Open Sendmail to: Sendmail ($ Message, $ FLAG- > {'type'} -> {'cc_list'}); 8 Open d: /bugzilla/globals.pl, change Open Sendmail to: Sendmail ($ MSG, $ Name); 8. Open D: / Bugzilla / Checksetup .pl file, comment out with the platform-related code: [3967-3972, 4004-4008] # $ sig {hup} = / & bailout; # $ sig {int} = / & bailout; # $ sig {quit} = / & bailout # $ Sig {term} = / & bailout; #system ("stty", "- echo"); # disable input echoing 9. Open D: /Bugzilla/checksetup.pl file, modify the mysql installation path: Find my $ mysql_binaries = `Which mysql`; => my $ mysql_binaries =" d: // mysql // bin // mysql "10. Open d: /bugzilla/checksetup.p l File, modify the CVSNT installation path: (Installing CVSNT to be modified) Locate MY $ CVS_EXECUTABLE = `Which CVS`; => MY $ CVS_EXECUTABLE =" D: //cvsnt//cvs.exe "; 11. Open d: /Bugzilla/checksetup.pl file, modify WebServergi information: Find my $ webservergid = getGRNAM ($ my_webservergroup) => my my $ webservergid = '8' 12. Open D: /Bugzilla/checksetup.pl file, correct the Enter the Route This is due to the difference between UNIX and Windows platform: UNIX's Enter, and Windows is / r / n, so you need to remove a character.
Find Chomp $ login; add a line of Chop $ login; find ChOMP $ realname; add a line of Chop $ RealName; find ChOMP $ Pass1; add a line of Chop $ Pass1; find ChOMP $ Pass2; 13. Open CMD.exe Go to the D: / Bugzilla directory, type perl checksetup.pl, run, then generate some files, open the generated localconfig file, modify the following information: $ index_html = 1 (Generate index.html) $ mysqlpath = "D: // mysql // bin "(Your MySQL / BIN path) $ WebServerGroup =" 8 "$ db_user =" BUGS "(mysql login user name) $ db_pass = '
First, download the latest bugzilla-2.17.6 version from www.bugzilla.org, decompress, use WinCVS to use the Bugzilla code import to the CVS system, and establish Mozilla development branch and distribution tag, note: The main branch is yourself Branch, modify according to your own needs; Mozilla is a development side branch, which is used to synchronize update with Mozilla's Bugzilla Development Team. That is, when Bugzilla has a big improvement, you can download the release version, add this Mozilla Develop branches, then merge with the main branch, you can get the latest, and it is a modified bugzilla version. In this way, you can avoid a lot of modifications to each new version of Bugzilla source code. Haha, 'cool' is a word! ! Of course, in the merged process, conflicts may be encountered, but at least three of them are more likely to change the source code. Below is the branch name used, for reference only: branch => mozilla (vendor tag) Release => Ver-2-17-6 (Release Tag) 9 Appendix: (Perlmodule.bat) @echo off @ echo *** **** Start Install Perl Module for Bugzilla ********** @echo ******************************* *******************
@echo ********* Install bundle :: bugzilla module *********** Call PPM Install bundle :: bugzilla @echo ok !!
@echo *************************** CALL PPM Install Chart @echo ok !!
@echo *************************** CALL PPM Install CGI @echo ******** Failed ?? :) @echo ** ******* Download it from flion url ********** @echo http://cpan.shellhung.org/cgi.pm-3.04. Tar.gz @echo ********* Use it with flion step ********* @echo ********* 1. Upzip this tar.gz @echo * ******** 2. Run the cmd.exe @echo ********* 3. INTO THE UPZIPPED TAR.GZ Use DOS Command "CD" @echo ******** * 4. Perl makefile.pl @echo ********* 5. nmake @echo ********* 6. nmake test @echo ******** 7. Nmake Install @echo ******** 8. OK !!
@echo ****************** ******** FAILED ?? ****** FAILED?? :) @echo ******************* @ e http://cpan.shellhung.org/authors/id/gb/gbarr/ TIMEDATE-1.16.tar.gz @echo **************** @echo ********* 1. Upzip this Tar. GZ @echo ********* 2. Run the cmd.exe @echo ********* 3. Into the upzipped tar.gz Use dos command "CD" @echo **** ***** 4. Perl makefile.pl @echo ********* 5. nmake @echo ********* 6. nmake test @echo ******* * 7. nmake install @echo ********* 8. OK !! @ echo ************************ CALL PPM Install Appconfig @ @ @ Echo ********* failed ?? :) @echo ***************** @echo http: //cpan.shellhung .org / authors / id / a / ab / abw / appconfig-1.55.tar.gz @echo **************** @******** @echo ** ******* 1. Upzip this tar.gz @echo ********** 2. Run the cmd.exe @echo ********** 3. INTO the UPZIPPED TAR. GZ Use dos Command "CD" @echo ********* 4. perl makefile.pl @echo ********* 5. nmake @echo ******** 6. Nmake Test @echo ********* 7. nmake install @echo ******** 8. OK !!
@echo ************** Call PPM Install Template :: Toolkit @echo ********* Failed ?? :) @echo ****************** @ e h http://cpan.shellhung.org/authors/id/a/ab/abw/template- Toolkit-2.12.tar.gz @echo ****************** 1. Upzip this Tar. GZ @echo ********* 2. Run the cmd.exe @echo ********* 3. Into the upzipped tar.gz Use dos command "CD" @echo **** ***** 4. Perl makefile.pl @echo ********* 5. nmake @echo ********* 6. nmake test @echo ******* * 7. nmake install @echo ******** 8. OK !! @ echo ******** install data :: Dumper module ********* Call PPM Install Data :: Dumper @echo ok !!
@ectall date :: format module ********** Call PPM Install Date :: format @echo ok !!
@echo ************************ Call PPM Install DBI @echo ok !!
@echo ********* install dbd :: mysql module ********** CALL PPM Install dbd :: mysql @echo ok !!
@echo ********* Install file :: spec module ********** Call PPM Install file :: spec @echo ok !!
@echo ********* Install file :: temp module ********** Call PPM Install File :: temp @echo ok !!
@echo ********* Install text :: wrap module ********** Call PPM install text :: wrap @echo ok !!
@echo **************** Call PPM Install GD @echo ok !!
@echo ********* install gd :: graph module ********** Call PPM install gd :: graph @echo ok !!
@echo ********* Install gd :: text :: align module ********* Call PPM Install Gd :: Text :: align @echo ok !!
@echo ************************* CALL PPM Install Patchreader @ echo ok !! @ echo ********* Install Mime :: Tools Module ********** CALL PPM Install Mime :: Tools @echo ok !!
@echo ********* Install Mime :: base64 module ********** CALL PPM Install Mime :: base64 @echo ok !!
@echo ********* Install automin :: sasl module ********** CALL PPM Install Authen :: SASL @echo ok !!
PAUSE
