Install Bugzilla on Windows

On the internet to find some how to install Bugzilla on Windows article, feeling is not too troublesome, is the details are not very clear, spent a few days finally installed on Windows 2003 on the Bugzilla, the installation of my detailed written down, so that we do not have detours. This article is for Bugzilla 2.18RC3 only, other versions I have not tried. Also, I don't understand Perl scripts.

First, install MySQL
1, download mysql (http://www.mysql.com/), I downloaded the mysql-4.0.15-win.zip, the direct installation can be. At the same time you can download and install MySQL Administrator 1.0, which is the MySQL management software, very useful.
2, modify the root user password for MySQL
e:\>cd mysql
E:\mysql>cd bin
e:\mysql\bin>mysql-u root MySQL
mysql> UPDATE user SET Password=password (' <new_password ' >) WHERE user= ' root ';
Mysql>flush privileges;
where <new_password> is the root user's new password. After changing the password, to use the root user to access MySQL, you must use Mysql-u root-p, as prompted to hit the correct root password.
3, create the 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 [email protected] identified by ' <bugs_password> ';
Mysql> FLUSH privileges;
to remember the password for the bugs user, use the Bugzilla configuration file below.
4, create bugs database
Mysql>create bugs;

Second, download bugzilla (www.bugzilla.org)
Now the latest version is BUGZILLA-2.18RC3, downloaded and extracted to E:\Bugzilla

Third, install Perl (this section can refer to Bugzilla's documentation)
1, download ActivePerl (http://www.activestate.com/), I downloaded is ActivePerl-5.8.4.810-MSWin32-x86.msi, installed to E:\Perl ( The installation path can be customized to the same below)
Executed under the E:\bugzilla directory
E:\bugzilla>perl checksetup.pl

This script checks whether the required modules are installed, initializes the database, and finally asks for an administrator's email address, user name, and password. The first time will say not even to the database, find the E:\Bugzilla\localconfig file, open find $db_pass = "; this line, in the quotation marks in the previous step to the bugs user assigned password, save.

Look closely at the information returned to see which modules are not yet installed. Then, install the necessary modules, first execute the
C:\>PPM Repository Add Oi http://openinteract.sourceforge.net/ppmpackages

Then install it with the following command:
C:\>PPM Install < module name >

If you want to install an optional module:
Execute the following command to add the address of the download module
C:\>PPM rep Add glob http://glob.com.au/ppm

Then install it with the following command:
C:\>PPM Install < module name >

Once each module is successfully installed, it displays information similar to the following line:
Successfully installed AppConfig version 1.52 in ActivePerl 5.8.4.810.

Iv. Configuring IIS
1. Open Control Panel, Administrative tools->internet information Services, then default Web site right-click properties-> Home dictory-> Configuration, you can see in app mappings that files with the extension. PL and. PLX have been added to this, double-click the. PL line, open its Properties dialog box, select "All Actions" in "actions", Also modify the. PLX line, and then add a row with the following parameters:

Executable file: D:\Perl\bin\perl.exe-T '%s '%s
Extension:. CGI
Action: All actions

Note: This "-T" must be added, otherwise the access will be error: Too late for "-t" option at E:\BUGZILLA-2.18RC3\INDEX.CGI Line 1. (Many articles on the internet did not mention this, I found a half day)

2, in the default Web site right-click on the "New-" virtual directory, you can give the fake directory a name, such as "Bugzill", point to the E:\Bugzilla directory, the default page to add "index.cgi".

3, open the browser, in the address bar input:Http://localhost/bugzilla, see Bugzilla page is the installation success, now can normal use.

V. Mail delivery configuration
Since Bugzilla is using SendMail to send mail by default, there are several places you want to modify on Windows to send mail.
1. Open the cgi.pl, \bugzilla\bugmail.pm, and \bugzilla\token.pm files in the e:\bugzilla-2.18rc3\ directory to find the following (may be slightly different):

Open SENDMAIL, "|/usr/lib/sendmail-t-i";
Print SENDMAIL $msg;
Close SENDMAIL;

Into

Use NET::SMTP;
My $smtp _server = ' smtp.163.com '; # replace it with your own mail server address

# Use die On Error, so, the mail'll is in the ' unsent mails ' and
# can is sent from the Sanity check page.
My $smtp = net::smtp->new ($smtp _server) | |
Die ' cannot connect to server \ ' $smtp _server\ ';

$SMTP->auth ('[email protected]', ' password ') or die "auth error\n"; # Replace the user name and password on the mail server you use
$SMTP->mail ('[email protected]'); # change this to your own email address

$SMTP->to ($login); #注意这里, the login parameter name in each file is not the same
$SMTP->data ();
$SMTP->datasend ($msg); #注意这里, the msg parameter names in each file are not the same
$SMTP->dataend ();
$SMTP->quit;

2. Installing Perl's NET::SMTP module
In the DOS window, execute the following command to add the address of the download module
C:\>PPM rep Add glob http://glob.com.au/ppm

Then install it with the following command:
C:\>PPM Install NET::SMTP

You will be prompted to find multiple modules (3) and list the names of these modules

3, according to the module name listed in the previous step, again with the PPM install< module name >, the listed three modules are all installed.

4, save the following content to the c:\test.pl file,

#test. pl

#!/usr/local/bin/perl-w
Use NET::SMTP;

$SMTP = net::smtp->new (' smtp.163.com '); # replace it with your own mail server address

$SMTP->auth ('[email protected]', ' password ') or die "auth error\n"; # Replace the user name and password on the mail server you use
$SMTP->mail ('[email protected]'); # change this to your own email address
$SMTP->to ('[email protected]'); #这里是接收地址
$SMTP->data ();
$smtp->datasend ("to: [email protected]\ n");
$SMTP->datasend ("\ n");
$SMTP->datasend ("Chinese content one \nsecond line\n third row third line");
$SMTP->dataend ();
$SMTP->quit;

Then run C:\>perl test.pl

5, to your mailbox to see if you received a new email? When you receive it, it means that the message works correctly. If not received, check 2, 3, 4 steps.

Six, Chinese
1, the E:\bugzilla-2.18rc3\template\en in the original directory copy, directory for E:\BUGZILLA-2.18RC3\TEMPLATE\CN.
To http://www.sourceforge.net, find BUGZILLA-CN, The current version is only 2.17.99, but the same can be used (some pages will be different from 2.18), the file name is: bugzilla-2.17-cn-0.99-withcss.tar.gz. Download it and unpack it to the E:\bugzilla-2.18rc3\template directory, overwriting the file under the CN directory.

2, open the browser, enter in the Address bar:Http://localhost/bugzilla, click on the "Parameters" link below the page, modify the "languages" and "DefaultLanguage" The attribute value is "CN", submit the page, you can see the Chinese page, if you do not see Chinese, refresh it should be OK.

Reference:
Http://www.kuihua.net/bbs/dispbbs.asp?boardid=1&rootid=1035&id=1035&star=1&skin=

Http://blog.csdn.net/ycw/archive/2004/02/07/4187.aspx

Http://blog.csdn.net/s00n/archive/2004/09/20/111065.aspx

Author Blog:http://blog.csdn.net/acsu/

Install Bugzilla on Windows