Oracle Issues On Windows
Ron Fitzpatrick
I'm trying to install Bugzilla 3.2.4 on Windows XP Professional
Service Pack 2.
(Active State Perl 5.10.0.1005, Apache 2.2, Oracle 9i client)
I'm following the install instruction provided at the site:
https://wiki.mozilla.org/Bugzilla:Win32Install
After a few false starts things started to look promising. I ran
checksetup.pl and it set up the database on Oracle successfully. (see
results of the script below). I thought I was home, but when I try to
open up index.cgi on Apache 2.2) I get the following message:
Software error:
'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 30) line 3.
I tried copying the oci.dll to C:\Perl\lib\auto\DBD\Oracle as another
post suggest and I get this error:
Software error:
Can't connect to the database.
Error: ERROR OCINlsEnvironmentVariableGet(OCI_NLS_CHARSET_ID) Check
ORACLE_HOME and NLS settings etc.
Is your database installed and up and running?
Do you have the correct username and password selected in
localconfig?
It seems like the checksetup.pl script bypassed the Oracle Client
installed on my machine and was able to connect successfully, but the
the Bugzilla cgi's need access to the client (or what it seems like
from some of the reading I've done - a bit of a bummer) I have to
admit my Oracle set up on this machine might be a bit off. It's a
hacking 9 install over Oracle 8 - basically got the 9 client to work
through some registry changes. Oracle 8 is still installed and there
are some registry entries kicking about, but with that said the 9
client works fine (SQL Plus, Toad, Oracle tools). None of these
required ORACLE_HOME to be set in the Environment variables. I've
tried the full PERL install with and without this variable set with
the same result.
Any help or suggestions would be appreciated. I've sort of reached a
dead-end with what I can find to get further - and sorry for the long
post, but I thought I'd try to be thorough.
Thanks,
Ron
Here's the results of the checksetup.pl script...
C:\bugzilla>perl checksetup.pl
* This is Bugzilla 3.2.4 on perl 5.10.0
* Running on WinXP/.Net Build 2600 (Service Pack 2)
Checking perl modules...
Checking for CGI.pm (v3.33) ok: found v3.43
Checking for TimeDate (v2.21) ok: found v2.22
Checking for PathTools (v0.84) ok: found v3.2501
Checking for DBI (v1.41) ok: found v1.607
Checking for Template-Toolkit (v2.15) ok: found v2.20
Checking for Email-Send (v2.16) ok: found v2.197
Checking for Email-MIME (v1.861) ok: found v1.863
Checking for Email-MIME-Encodings (v1.313) ok: found v1.313
Checking for Email-MIME-Modifier (v1.442) ok: found v1.444
Checking available perl DBD modules...
Checking for DBD-Pg (v1.45) not found
Checking for DBD-mysql (v4.00) not found
Checking for DBD-Oracle (v1.19) ok: found v1.21
The following Perl modules are optional:
Checking for GD (v1.20) ok: found v2.41
Checking for Chart (v1.0) ok: found v2.4.1
Checking for Template-GD (any) ok: found v1.56
Checking for GDTextUtil (any) ok: found v0.86
Checking for GDGraph (any) ok: found v1.44
Checking for XML-Twig (any) ok: found v3.32
Checking for MIME-tools (v5.406) ok: found v5.427
Checking for libwww-perl (any) ok: found v5.826
Checking for PatchReader (v0.9.4) ok: found v0.9.5
Checking for PerlMagick (any) not found
Checking for perl-ldap (any) ok: found v0.39
Checking for Authen-SASL (any) ok: found v2.12
Checking for RadiusPerl (any) ok: found v0.13
Checking for SOAP-Lite (any) not found
Checking for HTML-Parser (v3.40) ok: found v3.60
Checking for HTML-Scrubber (any) ok: found v0.08
Checking for Email-MIME-Attachment-Stripper (any) ok: found v1.316
Checking for Email-Reply (any) ok: found v1.202
Checking for mod_perl (v1.999022) ok: found v2.000004
* NOTE: You must run any commands listed below as Administrator.
***********************************************************************
* Note For Windows Users
*
***********************************************************************
* In order to install the modules listed below, you first have to run
*
* the following command as an Administrator:
*
*
*
* ppm repo add theory58S http://cpan.uwinnipeg.ca/PPMPackages/10xx/
*
*
***********************************************************************
**********************************************************************
* OPTIONAL MODULES *
**********************************************************************
* Certain Perl modules are not required by Bugzilla, but by *
* installing the latest version you gain access to additional *
* features. *
* *
* The optional modules you do not have installed are listed below, *
* with the name of the feature they enable. If you want to install *
* one of these modules, just run the appropriate command in the *
* "COMMANDS TO INSTALL" section. *
**********************************************************************
***********************************************************************
* MODULE NAME * ENABLES FEATURE(S)
*
***********************************************************************
* PerlMagick * Optionally Convert BMP Attachments to PNGs
*
* SOAP-Lite * XML-RPC Interface
*
***********************************************************************
COMMANDS TO INSTALL:
PerlMagick: ppm install PerlMagick
SOAP-Lite: ppm install SOAP-Lite
Reading ./localconfig...
OPTIONAL NOTE: If you want to be able to use the 'difference between
two
patches' feature of Bugzilla (which requires the PatchReader Perl
module
as well), you should install patchutils from:
http://cyberelk.net/tim/patchutils/
Checking for DBD-Oracle (v1.19) ok: found v1.21
Checking for Oracle (v10.02.0) ok: found v10.02.0300
Removing existing compiled templates...
Precompiling templates...done.
Now that you have installed Bugzilla, you should visit the
'Parameters' page (linked in the footer of the Administrator
account) to ensure it is set up as you wish - this includes
setting the 'urlbase' option to the correct URL.
C:\bugzilla>
Xiaoou
> (Active State Perl 5.10.0.1005, Apache 2.2, Oracle 9i client)
>
http://www.oracle.com/technology/software/products/database/index.html
Ron Fitzpatrick
> On 2009/7/14 6:47, Ron Fitzpatrick wrote:> (Active State Perl 5.10.0.1005, Apache 2.2, Oracle 9i client)
>
> Please use Oracle 10g or 11g instant client.http://www.oracle.com/technology/software/products/database/index.html
Thanks Xiaoou. The instant client did the trick. I will add a few more
details that may assist others with this issue.
First, if you are looking for the Oracle Instant client, this page
will give you the download and install instructions:
http://www.oracle.com/technology/tech/oci/instantclient/index.html
I followed the install instructions, placed files in a folder, added
the folder to the path. This appeared to work in terms of the client -
it registered in my copy of TOAD for example. It did not fix my
Bugzilla problem however, so I combined the Oracle Instant Client
solution with another I found. Copying the Oracle Instant Client files
to the Perl DBD directory for Oracle did the trick. (index.cgi is
working now at least). In my case that was: C:\Perl\lib\auto\DBD
\Oracle, so I guess it would be something like:
<perl installation directory>\lib\auto\DBD\Oracle.
Thanks for the tip Xiaoou. The Oracle Instant Client may be helpful to
us in other situations. Maybe this will be helpful to others as well.
Ron
bignerd
Can you tell me which specific version of the Oracle Instant Client
you used? I'm running into the same error here (Here's my apache
access.log):
[Wed Jul 15 11:12:11 2009] [error] [client 127.0.0.1] [Wed Jul 15
11:12:11 2009] index.cgi:
[Wed Jul 15 11:12:11 2009] [error] [client 127.0.0.1] [Wed Jul 15
11:12:11 2009] index.cgi: Can't connect to the database.
[Wed Jul 15 11:12:11 2009] [error] [client 127.0.0.1] [Wed Jul 15
11:12:11 2009] index.cgi: Error: ERROR OCINlsEnvironmentVariableGet
(OCI_NLS_CHARSET_ID) Check NLS settings etc.
[Wed Jul 15 11:12:11 2009] [error] [client 127.0.0.1] [Wed Jul 15
11:12:11 2009] index.cgi: Is your database installed and up and
running?
[Wed Jul 15 11:12:11 2009] [error] [client 127.0.0.1] [Wed Jul 15
11:12:11 2009] index.cgi: Do you have the correct username and
password selected in localconfig?
[Wed Jul 15 11:12:11 2009] [error] [client 127.0.0.1] [Wed Jul 15
11:12:11 2009] index.cgi:
In regards to my setup:
1. I have Bugzilla 3.2.3 in C:\BugZilla
2. I have ActiveState Perl 5.10.0 installed into C:\Perl
3. My database is an Oracle 10g 102.0.3 instance running on Windows
2000
4. My Apache version is 2.2.8 and I was configuring it based on this
article:
8749084-Bugzilla-Installation-Guide-1218534521362869-9.pdf (found on
scribd)
5. The instantclient I have is is 10.2.0.4 (Basic), extracted to C:
\Program Files\Common Files\ODBC\instantclient_10_2
6. That folder is in the PATH
7. Three dlls have been copied from there into C:\Perl\lib\auto\DBD
\Oracle: oci.dll, ociw32.dll, and oraociei10.dll. I tried placing
them into the C:\Perl\lib\auto\DBD\Oracle, but ended up with another
error:
Software error:
'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 30) line 3.
For help, please send mail to the webmaster (ad...@PA.LCL), giving
this error
message and the time and date of the error.
Any ideas?
Xiaoou
Please follow the steps, you won't miss it.
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
<http://download.oracle.com/otn/nt/instantclient/111070/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. unzip
http://ftp.mozilla.org/pub/mozilla.org/webtools/bugzilla-3.2.4.tar.gz to
c:\bugzilla
4. unzip instantclient-basic-win32-11.1.0.7.0.zip
<http://download.oracle.com/otn/nt/instantclient/111070/instantclient-basic-win32-11.1.0.7.0.zip> and
copy oci.dll and oraociei11.dll to c:\bugzilla
5. cd to c:\bugzilla, and run perl checksetup.pl
6. 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
7. run perl checksetup.pl again to generate localconfig
8. 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';
9. run perl checksetup.pl again to install bugzilla.
10. configure Apache, see
https://wiki.mozilla.org/Bugzilla:Win32Install#Apache
11. 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"
12. Restart Apache HTTP Server, and the installation is done.
> _______________________________________________
> 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.
>
Xiaoou
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
<http://download.oracle.com/otn/nt/instantclient/111070/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.
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
5. unzip instantclient-basic-win32-11.1.0.7.0.zip
<http://download.oracle.com/otn/nt/instantclient/111070/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.
>> _______________________________________________
>> support-bugzilla mailing list
>> support-...@lists.mozilla.org
>> https://lists.mozilla.org/listinfo/support-bugzilla
>> PLEASE putsuppor...@lists.mozilla.org in the To: field when you reply.
>>
>
bignerd
actually had 10.2.0.1 to start with). When I went to the later
version (11.1.0.7), it worked! Thanks a bunch.