Software Test Management Bugzilla-2.18RC2 Installation (Windows 2000) Raiders
I. Introduction
Software Test is a very important stage in software development. The famous software engineering books have such a description: "The code is 1/6 in the entire software cycle, and the time to test is 1/4 ", Enough to see the importance of testing. Software test management tools have a lot of TestDirector, ClearQuest, BMS these product functions, and in small software projects, it is basically killing chicken with cow knife, and expensive software prices also make domestic software companies.
So now many software companies will use Bugzilla to batch this famous open source software test management tool. Installing this tool requires some basic knowledge of programming, because there is no basic knowledge of Perl and CGI programming, I spent a lot of time while installing this tool. Next, some of the techniques and experiences in the installation process are introduced. To let the colleagues will take less than one thing.
Second, below is the list of software used during my installation:
1. Software Test Management Platform: Bugzilla-2.18RC2
Download address: http://www.bugzilla.org/download/
2, background database: mysql-4_0_14 (higher, this version is used here)
Download address: www.mysql.com
3, CGI and PL language platform: ActivePerl-5.8.4.810-mswin32-x86
Download address: http://www.activestate.com/products/download/register.plex? Id = ActivePerl
4, the perl module you need to use - Thank you in the world (hou guanmin) collection
Download address: http://sourceforge.net/project/showfiles.php? Group_id = 75477 & package_id = 111950
Third, the background database platform mysql-4_0_14
Because the previously installed is the lower version (3.x.x) of MySQL (3.x.x), Bugzilla-2.18RC2 is found during the installation process and does not support. And at this time, you have to upgrade to new mysql may have problems, because the previous MySQL version is running this version of some registration information to the registry, so only the character mysql items in the registry, MySQL -4_0_14 can be used normally; this is also the result of my test.
MySQL-4_0_14 After installation is successful.
1, first modify the root password (if the password is a AAA after modification)
D: /> CD mysql-4_0_14
D: / mysql-4_0_14> cd bin
D: / mysql-4_0_14 / bin> mysql -u root mySQL
Mysql> Update User Set Password = Password ('aaa') where user = 'root'
mysql> flush privileges;
2. Create a bugs user and assign the appropriate permissions (password is also 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'
mysql> flush privileges;
3, create a bug database
Mysql> Create Database Bugs;
Mysql> EXIT
Fourth, install the CGI and PL language platform: ActivePerl-5.8.4.810-mswin32-x861, installing Perl is easy, assuming the installation directory is d: / perl
2, install Perl Module:
(1) There are two modules that need to download the latest versions:
(A) Chart (2, 3, 0) download address:
http://glob.com.au/ppm/x86/chart.tar.gz
(B) DBI (1, 37, 0) download address:
http://www.apache.org/dist/perl/win32-bin/ppms/x86/dbi.tar.gz
Replace the two identical files in the Perl Module downloaded above.
And modify the version number of the file chart.ppd is 2, 3, 0, 0
Modify the version number of DBI.ppd is 1,37,0,0
(2) Add a line in the installation file installmodule.bat
Call PPM Install Authen :: SASL
(3) Run installModule.bat
V. Configure 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 -t "% s"% s
Extension: .pl
Only: get, head, post
Note: Please pay attention to the -t parameter behind the executable.
3. CGI script parser: (*. Cgi) Please pay attention to the back -t parameter
Executable file: d: /perl/bin/perl.exe -t "% s"% s
Extension: .cgi
Only: get, head, post
Note: Please pay attention to the -t parameter behind the executable.
4. Default Web Site] -> [New] -> [Virtual Directory]:
Alias: Bugzilla, Access Directory: D: /Bugzilla-2.18rc2, access to [write] permissions in access.
5. Select the original virtual directory bugzilla, right click to select [Properties] -> [Document]. [Default Document] Add index.cgi.
6. Modify some scripts that are suitable for Windows2K platforms
1. Open the D: / Bugzilla-2.18RC2 / Globals.pl file, add the following mail sending code in front of the use bugzilla:
Sub sendmail
{
MY ($ msg, $ person) = @_;
Use 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;
}
2, open the D: / bugzilla-2.18rc2 / defparams.pl file, add the following parameters after the file:
(Note: SMTP.163.com; username; password replaced with your SMTP server, username and password)
{
Name => 'MailServer',
DESC => 'Mail-Server Assigned by Honggb in 2004.09.20!',
TYPE => 't',
Default => 'SMTP.163.com'
}
{
Name => 'Mailuser',
DESC => 'Mail-user assigned by honggb in 2004.09.20!',
TYPE => 't',
Default => 'Username'
}
{
Name => 'Mailpass',
DESC => 'Mail-Pass Assigned by Jackey In 2004.09.20!',
TYPE => 't',
Default => 'Password'
}
3. Modify the corresponding email paragraph in cgi.pl (notes a few lines, increasing a line)
# Open sendmail, "| / usr / lib / sendmail -t-t";
# Print Sendmail $ MSG;
# Close sendmail;
Sendmail ($ MSG, $ login);
4, modify the corresponding email paragraph in ImportXML.PL (notes a few lines, increasing a line)
# Open (sendmail,
# "| / Usr / lib / sendmail -odeliverymode = background -t -i") ||
# Die "can't open sendmail";
# Print Sendmail $ Header. $ Message. "/ N";
# Close sendmail;
Sendmail ($ Header. $ Message. "/ N", $ to);
5. Modify the other email segment in move.pl (notes a few lines, add a line)
#open (Sendmail,
# "| / Usr / lib / sendmail -odeliverymode = background -t -i") ||
# Die "can't open sendmail";
#Print Sendmail $ MSG;
#close sendmail;
Sendmail ($ MSG, $ TO);
6. Modify the corresponding email paragraph in WhineTnews.pl (note a few lines, add a line)
# Open sendmail, "| / usr / lib / sendmail $ sendmailparam -t -i"
# Or Die "can't open sendmail";
# Print Sendmail $ MSG;
# Close sendmail;
# Print "$ email". Join ("", @ {$ bugs {$ email}}). "/ N";
Sendmail ($ MSG, $ Substs {'UserId');
Seven, install bugzilla-2.18rc2
1. Type in the bugzilla-2.18rc2 directory under the DOS prompt:
D: /bugzilla-2.18rc2/perl checksetup.pl
If you prompt MySQL to start, start mysql and make sure the start is successful;
If prompted to connect the mysql username, password error, find and open the file localconfig
Modify the following paragraph as follows
$ db_pass = 'bugs';
2. After connecting the database successful and created the data structure, the next is to enter some basic administrator data information.
Very simple, don't introduce it.
Author: s00n (Jasea@sina.com)
Reference: 1.WIN2000 Bugzilla installation record:
http://dev.9cbs.net/develop/Article/24/Article/24/Article/24/24091.shtm
2.Bugzilla Windows Installed Red Book:
http://blog.msnfans.com/forrest/archives/38.html
3.www.apache.org
4.www.bugzilla.org
