Facing Problem during BugZilla configuration using Oracle.
Mainak Majumder
Facing some problems during BugZilla configuration.I am using Oracle as a
database.
But after running checksetup.pl getting the below errors:
'oracle' is not a valid choice for $db_driver in localconfig: Can't load
'C:/Perl/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle:
load_file:The specified module could not be found at
C:/Perl/lib/DynaLoader.pm line 202.
at Bugzilla/DB/Oracle.pm line 41
Compilation failed in require at Bugzilla/DB/Oracle.pm line 41.
BEGIN failed--compilation aborted at Bugzilla/DB/Oracle.pm line 41.
Compilation failed in require at (eval 31) line 3.
I have verifed that the specified dll does exist.I have changed the
localconfig file as:
$db_driver='oracle'
$db_name='BUGZILLA'
$db_user='bugs'
$db_pass='bugs'
$db_port='1521'
Anyone can help me regarding this??
Regards,
Mainak Majumder
Tata Consultancy Services
Victoria Park Building,
Plot No. 37/2, Block GN, Salt Lake,
Kolkata - 700091,West Bengal
India
Ph:- +9133-6636-4704
Buzz:- 4334762
Cell:- +919836330077
Mailto: mainak....@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Outsourcing
____________________________________________
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
Mainak Majumder
Facing some problems during BugZilla configuration.I am using Oracle
as a database.
But after running checksetup.pl getting the below errors:
'oracle' is not a valid choice for $db_driver in localconfig: Can't
load 'C:/Perl/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle:
load_file:The specified module could not be found at C:/Perl/lib/
DynaLoader.pm line 202.
at Bugzilla/DB/Oracle.pm line 41
Compilation failed in require at Bugzilla/DB/Oracle.pm line 41.
BEGIN failed--compilation aborted at Bugzilla/DB/Oracle.pm line 41.
Compilation failed in require at (eval 31) line 3.
I have verifed that the specified dll does exist.I have changed the
localconfig file as:
$db_driver='oracle'
$db_name='BUGZILLA'
$db_user='bugs'
$db_pass='bugs'
$db_port='1521'
Could you please help me regarding this??
Xiaoou
Below is my steps to install Bugzilla with Oracle on Windows.
1. untar bugzilla-3.2.3.tar.gz to c:\bugzilla
2. unzip instantclient-basic-win32-11.1.0.7.0.zip(if you don't have
instantclient-basic-win32, you can download it from otn) , then copy
oci.dll and oraociei11.dll to c:\bugzilla
3. login to the Oracle DB with the system user, and run the following
script to create the db user 'bugs':
-- 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. cd c:\bugzilla, run perl checksetup.pl, then follow the output and
install the ppm 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 perl-ldap
ppm install Authen-SASL
ppm install RadiusPerl
ppm install HTML-Scrubber
ppm install Email-MIME-Attachment-Stripper
ppm install Email-Reply
5. run perl checksetup.pl again to generate the 'localconfig' file
6. notepad localconfig, edit the following fields like:
# 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 = 'bugzilla.host';
# The name of the database
$db_name = 'XE';
# 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';
7. run perl checksetup.pl again.
> _______________________________________________
> support-bugzilla mailing list
> support-...@lists.mozilla.org
> https://lists.mozilla.org/listinfo/support-bugzilla
> PLEASE put support-...@lists.mozilla.org in the To: field when you reply.
>