Install BugZilla 5.0.3 on Windows 7 x64 localhost - opensource Perl Bug tracking software

Trabla: Install BugZilla 5.0.3 on Windows 7 x64 localhost ( XAMPP 5.6.24 + ActivePerl 5.24.0 ) - opensource Perl Bug tracking system ( used by the Mozilla projects )

Bugzilla is a web-based general-purpose bugtracker and testing tool originally developed and used by the Mozilla project, and licensed under the Mozilla Public License
Bugzilla has been adopted by a variety of organizations for use as a bug tracking system for both free and open-source software and proprietary projects and products. Bugzilla is used, among others, by the Mozilla Foundation, WebKit, Linux kernel, FreeBSD, GNOME, KDE, Apache, Red Hat, Eclipse and LibreOffice.

Solving:

Watch on YouTube

1.  Download and install XAMPP 5.6.24  from site:
https://sourceforge.net/projects/xampp/files/XAMPP%20Windows/5.6.24/

2. Download and install  ActivePerl 5.24.0 for Windows ( x64 ) from official site
http://www.activestate.com/activeperl/downloads

ATTENTION:

-  in ActivePerl Setup Wizard  - select "Custom" setup type

- create & select installation directory 
C:\usr 

3. Download BugZila 5.0.3  opensource Perl Bug tracking software  from
official site:
https://www.bugzilla.org/download/

4. Extract bugzilla-3.0.5.tar.gz archive  into \Downloads folder - using 7zip ( http://www.7-zip.org/download.html ) open source archive ( or any archiver processing tar.gz )

5. Create folder C:\bugzilla 

and copy all files from downloaded BugZila 5.0.3  opensource Perl Bug tracking software extracted archive

6. Run XAMPP Control Panel 

- open Apache( httpd.conf ) file ( Apache ->  Config-> Apache( httpd.conf ) )

- add following text string

Alias /bugzilla/ "C:/bugzilla/"

after text ScriptAlias /cgi-bin/ "C:/xampp/cgi-bin/"

-  after text

<Directory "C:/xampp/cgi-bin">
    AllowOverride All
    Options None
    Require all granted
</Directory>

add following text

<Directory "C:/bugzilla">
    ScriptInterpreterSource Registry-Strict
    Options +ExecCGI +FollowSymLinks
    DirectoryIndex index.cgi index.html
    AllowOverride All
    Require all granted
</Directory>

- save  & close Apache( httpd.conf )

- open my.ini file ( MySQL->  Config-> my.ini )

- Find max_allowed_packet 
change value to 16M  ( default is 1M )

- After string

log_error = "mysql_error.log"

add text string

ft_min_word_len=2

- save  & close my.ini

- start Apache
- start Database

7.  Now we need to create Database for BugZila 5.0.3  opensource Perl Bug tracking system

1) Open phpMyAdmin in new browser tab (or window :) ) -

 http://localhost/phpmyadmin

2) Open SQL tab
3) Execute following query

CREATE DATABASE `bugzilla` 
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE USER 'bugzilla-owner'@'localhost'; 
CREATE USER 'bugzilla-owner'@'127.0.0.1';
CREATE USER 'bugzilla-owner'@'::1';

SET PASSWORD 
FOR 'bugzilla-owner'@'localhost' = PASSWORD('bugzilla123$%');
SET PASSWORD 
FOR 'bugzilla-owner'@'127.0.0.1' = PASSWORD('bugzilla123$%');
SET PASSWORD 
FOR 'bugzilla-owner'@'::1' = PASSWORD('bugzilla123$%');


GRANT ALL PRIVILEGES ON 
`bugzilla`.* TO 'bugzilla-owner'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON 
`bugzilla`.* TO 'bugzilla-owner'@'127.0.0.1' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON 
`bugzilla`.* TO 'bugzilla-owner'@'::1' WITH GRANT OPTION;

8.  Now we are ready to start installation of  BugZila 5.0.3  opensource Perl Bug tracking system

- open Windows Command Promt ( CMD )

- type CD C:\bugzilla  and press Enter button on keyboard

- type perl checksetup.pl and press Enter button

You will see following output with list of required Perl modules to install 
( list of CMD commands ). Also we need to run  ppm install DBD-mysql - for  MySQL support.
Let's do it :)

- type  ppm install TimeDate  and press Enter button

- type  ppm install DateTime and press Enter button

- type  ppm install DateTime-TimeZone and press Enter button

- type  ppm install Template-Toolkit and press Enter button

- type  ppm install Email-Sender and press Enter button

- type  ppm install Email-MIME and press Enter button

- type  ppm install File-Slurp and press Enter button

- type  ppm install JSON-XS and press Enter button

- type  ppm install DateTime-TimeZone-Local-Win32 and press Enter button

- type  ppm install DBD-mysql and press Enter button

- type  perl checksetup.pl  and press Enter button

./localconfig  is generated. Now we need to edit this file - set Database connection params.
( DO NOT CLOSE CMD window !!! )

- open  C:\bugzilla\localconfig   file in text editor

- Find string

$db_name = 'bugs';

change value to

$db_name = 'bugzilla';

- Find string

$db_user = 'bugs';

change value to

$db_user = 'bugzilla-owner';

- Find string

$db_pass = '';

change value to

$db_pass = 'bugzilla123$%';

- Find string

$db_port = 0;

change value to

$db_port = 3306;

- Save & close C:\bugzilla\localconfig   file

- go back to CMD , type  perl checksetup.pl  and press Enter button

- installing database

- type admin email and press Enter button

- type admin name and press Enter button

- type admin password and press Enter button &
retype admin password and press Enter button

- close CMD

Hooray !!! Enjoy  BugZilla 5.0.3 opensource Perl Bug tracking software !!!

Open http://localhost/bugzilla/  in your browser

ATTENTION:  don't forget "/" in the end of url - or you will get error - Object not found!