Bugzilla+mysql+iis+activeperl Construction Guide

The head is busy with his technical research, team building, test management, process specifications are not heeded, seeing the product into the late integration stage, in the test fault appeared a lot of bugs, relying on me alone with a txt to collect and collate the bug needs, and then organized into Word, put on the SVN above, Then the email notification to the module owner to fix, the efficiency is too slow. Take the engineer's money and do the project manager thing, eh.

The work begins when the complaining is done.

Bugzilla is an open source bug Tracking System that is specifically developed for UNIX customization. However, it can still be installed successfully under the Windows platform.

The Testopia is a test case management system integrated with the Bugzilla.
Its powerful features are reflected in the following areas:
1. Powerful search function
2. User-Configurable posting of bug changes via email
3. History change Record
4. Handling bugs by tracking and describing
5. Attachment Management
6. Complete product classification scheme and meticulous security strategy
7. Security Audit mechanism
8. Powerful back-end database support
9. Web,xml,email and Control Interface
10. Friendly Web user interface
11. Rich and varied configuration settings
12. Compatibility between versions

Install Deployment 1. Download the installation file

First download the Bugzilla installation package from the official website, read some readme, it is based on Perl, the database is using MySQL,

Perl Dot this. MySQL dot this. The Web server comes with IIS that comes with the system. Bugzilla click here.

Bugzilla of the Chinese package point this.

Unzip the bugzilla to D-disk, put it in the Bugzilla directory, install bugzilla need Perl related components, here first put.

2. Install MySQL Database

I downloaded the zip installation package, which is not the same as the installation package introduced by some tutorials on the web, and the next one goes on. MySQL offers two ways to install,

One is the MSI format, the other is the zip format, each with its own advantages, the zip format of the MySQL installation tutorial point this.

After installing MySQL, you need to create a new bug database and a MySQL account to access the bug database.

The MySQL bin directory is added to the environment variables of the system, the subsequent Perl is the same, you need to add the path of the executable file to the system environment variables.

To log in to MySQL as the root user, use the following method:

Configure the database.

This is the simple configuration of MySQL server.

3. Installing Perl

Follow the installation package step by step, and finally, add the bin directory in the installation package to the system environment variable, if the following variable is displayed on the command line, the installation is successful.

Bugzilla requires a series of Perl plug-ins, directly on the command line to enter the PPM Upgrade–install can install all Perl plug-ins

(In fact, as long as the installation of Bugzilla need to be able to, hand cheap fast, fortunately fast, the download process quite smooth)

Similar to the APT update source for Ubuntu, Peri also gets the update plugin package from the source, and in order to speed up the Perl download, you can add the Perl source to the PPM manager.

There are other Perl download problems that you can click to try to resolve.

4. Configure Bugzilla

Go to the Bugzilla directory and manually execute the checksetup.pl, which will check that all required Perl modules are installed and what is missing. When all is installed, execute checksetup.pl again, and the Localconfig file is generated in the current directory.

There are several key items that need to be configured:

Change to the same as configured in MySQL can, after configuration, execute checksetup.pl again, patiently wait, enter the SMTP server address, Bugzilla administrator name and password on it.

5. Configure IIS

I use Win7 's own IIS as a Web server. The Win7 flagship version does not open this service by default. Therefore, these services need to be opened first.

Win+r, enter Optionalfeatures, turn on Windows features, and select the following features.

Continue win+r, enter inetmgr, and open the Windows IIS Configuration Management tool.

Basic new New application and other basic settings, click here to get to know. The following describes the various pits encountered.

First Pit:

Access to directory without permissions when configuring IIS

Workaround: Click the basic settings, connect as, the default is "Application User", select the above specific user, enter the user name and password of the login computer.

A second pit:

When adding a script map, the following error occurred:

The reason is that CGI ASP functionality is not included

Workaround: Select the following function to do it,

The same kind of problem solving solution, click here to understand.

Fourth Pit: Error setting a script map

Workaround: Set the handler mappings under the default Web site Directory

Fifth Pit:

After adding an application account, when you enter http://localhost in the browser, the following error occurs:

Or

Workaround:

Add script map, request path Select *.pl, executable file according to the actual situation, choose Perl.exe–t%s%s, name select the Perl script map. You also need to add a script map to process the *.cgi script. Here, see a lot of people on the net to modify the Bugzilla directory of all the CGI scripts under the header file interpretation path, the #!/usr/bin/perl-wT is replaced with #!/usr/bin/perl-w, not modified, but also can be installed successfully.

Here, the-t parameter must be added, pop-up prompt box, a certain point is. Before, I was misled by the online installing under IIS 7.5. Point of No, the result, how to toss it out, gas dead, later point is, you can. At this point, I deeply understand that practice is the only criterion to test truth.

These are probably the kinds of pits that are encountered in tossing IIS.

6. Configure Bugzilla

When registering an account, the following error occurred while sending the message,

The suspected Bugzilla SMTP is not configured properly. According to the online Bugzilla user manual and solution, you need to confirm the Param file in the data/directory, the parameters are configured correctly. Second, view the SMTP authentication plug-in and the server's mail server open No.

Here is an example of configuration:

Maintainer:[email protected]
Mail_delivery_method:smtp
Mailfrom:[email protected]
Sendmailnow:on
Smtpserver:smtp.163.com
Smtp_username:[email protected]
Smtp_password: **********

It should be noted here: maintainer, mailfrom must be the same, Smtp_username mailbox must be a real mailbox, Smtp_password is the real mailbox for the password.

After the above configuration, the message has been sent successfully.

Tip: If you forget the Bugzilla Administrator's password, you can ./checksetup.pl--reset-password= Admin mailbox, you can change the password.

Basic Bugzilla Configuration

URLBase: The URL that points to your installation path, which is used in new user registration messages for login and intranet user access.

Set to the server IP where Bugzilla resides. Assuming that the IP is 192.168.1.100, it needs to be set to Http://192.168.1.100/

Special Note: When set up this setting, after the login can not use localhost to login, but need to use the set of URLBase to log in, I am here Card master for one hours, set up this parameter, in localhost inside the log off again, How on landing not up, in the Address bar entered URLBase address, only landed successfully.

You can make mistakes all at once, and next time you won't make mistakes again. See some online tutorials, everything is very smooth appearance, I in these two days of the building, almost impossible so smooth, make mistakes, reflection, search, summary record, repeat the mistake, re-reflection, search summary and record, so as to more in-depth understanding.

Cookiepath: Helps the browser manage cookies correctly.

Maintainer:bugzilla's principal maintainer.

Requirelogin: Login verification To prevent anonymous users from logging in.

CREATEEMAILREGEXP: Registered account name limit, if set to ". *", anyone can create his account.

If set to "@mycompany. com$", only users with Myconpany accounts are allowed to register for the application.

If set to NULL, only the administrator can create a new account, ordinary users are not allowed to apply for an account.

Allow_attachment_display: Whether to allow browser windows to open attachments, default to OFF, this is to prevent hidden malicious behavior in attachments

If you want to open this setting, you need to indicate the address of the attachment, and the property name is Attachment_base. For example: configured as http://www/Bugzilla.com/, the attachment is: http://www/Bugzilla.com/attachment.cgi?id=6

The default single upload attachment is up to 1MB, I now change it to 20M.

1. Configure Maxattachmentsize change to 20000

2. Configure the mysql max_allowed_packet parameter. into MySQL,

After the cookie has been set, the following error occurred after re-logging:

After this blog to give the solution, the blog address is Bugzilla cookie problem, can not solve the problem. In reset Bugzilla, after each execution of a setup, re-open a webpage to try to see if there is no need to re-login after the problem. Finally, navigate to the configuration of a parameter

shutdownhtml, especially red, to show vigilance. Finally, if this property is set to a value, no matter what the value, it will cause the above reason, the solution is not to set this parameter. For a deeper reason, not very well understood. Find this bug on Google, click here to enter.

Bugzilla upload attachment failed, pop up the following prompt:

Cause: The default temporary folder/usr/temp is used in the LIB/CGI.PM program for uploading attachments, and there is no such folder in the Windows system, so you can modify the temporary folder address in lig/cgi.pm as follows:

7. Bugzilla of Chinese

Font Chinese: The previous download of the Chinese package, unzip, the top-level folder renamed to CN, copied to the template directory can be.

Help file: Copy the En folder of the doc directory, which is CN, so as to ensure that the help file is not properly displayed in the Chinese environment.

8. Summary

After two days of deployment learning, Mysql+activeperl+iis+bugzilla finally achieved success, heart accumulated depressed swept away, these days I made mistakes and encountered problems, all summed up and try to find solutions to solve, the power of the network is very powerful, Make good use of Google, (if someone wants to Google, you can send me an email, I have Google's good baby, hey).

Hopefully this article will help more people who are confused on the installation of Bugzilla Road.

---------------------------Split Line-----------------------------------------------

Abominable landlord to take back the house, to his son to marry daughter-in-law, at the end of November to move again, hope all smooth transition.

Next week, Daoteng Testopia and hmailserver, see good enough.

Bugzilla+mysql+iis+activeperl Construction Guide