Steps to install Bugzilla with Oracle on Windows (XP above) X86

Steps to install Bugzilla with Oracle on Windows (XP above) X86

1. Preparation

1) Oracle Database. You need Oracle version 10.02.0 or higher

2) ActivePerl-5.10.0.1005-MSWin32-x86-290470.msi (Recommanded)

3) Get Instant Client Package - Basic ( instantclient-basic-win32-11.1.0.7.0.zip)

from http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

4) Apache HTTP Server from http://httpd.apache.org/download.cgi

The latest will be fine.

2. Install Oracle Database(The Oracle Database can be on another server too), ActivePerl, Apache HTTP Server.

3. Add a User to Oracle.

login to Oracle as 'system' user, and run:

-- Create the user
create user BUGs
identified by "bugs"
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to BUGs;
grant resource to BUGs;
-- Grant/Revoke system privileges
grant unlimited tablespace to BUGs;
grant execute on ctxsys.ctx_ddl to bugs;

4. unzip http://ftp.mozilla.org/pub/mozilla.org/webtools/bugzilla-3.2.4.tar.gz to c:\bugzilla

5. unzip instantclient-basic-win32-11.1.0.7.0.zip and copy oci.dll and oraociei11.dll to c:\bugzilla

6. cd to c:\bugzilla, and run perl checksetup.pl

7. install the required packages:

ppm install TimeDate
ppm install Template-Toolkit
ppm install Email-Send
ppm install Email-MIME
ppm install Email-MIME-Modifier
ppm install Chart
ppm install Template-GD
ppm install XML-Twig
ppm install MIME-tools
ppm install PatchReader
ppm install PerlMagick
ppm install perl-ldap
ppm install Authen-SASL
ppm install RadiusPerl
ppm install SOAP-Lite
ppm install HTML-Scrubber
ppm install Email-MIME-Attachment-Stripper
ppm install Email-Reply

8. run perl checksetup.pl again to generate localconfig

9. edit localconfig like this and save:

# What SQL database to use. Default is mysql. List of supported databases
# can be obtained by listing Bugzilla/DB directory - every module corresponds
# to one supported database and the name corresponds to a driver name.
$db_driver = 'oracle';

# The DNS name of the host that the database server runs on.
$db_host = '139.185.51.53';

# The name of the database

# The SID name
$db_name = 'orcl';

# Who we connect to the database as.
$db_user = 'bugs';

# Enter your database password here. It's normally advisable to specify
# a password for your bugzilla database user.
# If you use apostrophe (') or a backslash (\) in your password, you'll
# need to escape it by preceding it with a '\' character. (\') or (\)
# (Far simpler just not to use those characters.)
$db_pass = 'bugs';

10. run perl checksetup.pl again to install bugzilla.

11. configure Apache, see https://wiki.mozilla.org/Bugzilla:Win32Install#Apache

12. save the following text as perl.reg, and double click to import it:

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\.cgi\Shell\ExecCGI\Command]
@="C:\\Perl\\bin\\perl.exe -T"

13. Restart Apache HTTP Server, and the installation is done.