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)
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;
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;
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
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';
# 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';
$db_host = '139.185.51.53';
# The name of the database
# The SID name
$db_name = 'orcl';
$db_name = 'orcl';
# Who we connect to the database as.
$db_user = 'bugs';
$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';
# 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.
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"
@="C:\\Perl\\bin\\perl.exe -T"
13. Restart Apache HTTP Server, and the installation is done.