---------- Forwarded message ----------
From: Sajit Kalidas <SajitK@rewards.co.za>
Date: Mon, Dec 29, 2008 at 14:13
Subject: Re: [otrs] Oracle drivers
To: "User questions and discussions about OTRS." <otrs@otrs.org>

Hi,
I am still having issues with this. I have followed the instructions in
the readme.txt closely but get the following when running the
makefile.pl command:

Installing on a MSWin32, Ver#5.1
Using Oracle in D:/oracle/instantclient_11_1
DEFINE _SQLPLUS_RELEASE = "1101000700" (CHAR)
Oracle version 11.1.0.7 (11.1)
Using OCI directory 'sdk'

Checking for functioning wait.ph

System: perl5.008008
Compiler: gcc -s -O2 -s -O2 -DWIN32 -DHAVE_DES_FCRYPT
-DPERL_IMPLICIT_CONTEX
T -DPERL_IMPLICIT_SYS -fno-strict-aliasing -DPERL_MSVCRT_READFIX
Linker: not found
Sysliblist:

Checking if your kit is complete...
Warning: the following files are missing in your kit:
META.yml
Please inform the author.
... Detected uninstalled Perl. Trying to continue.
Have D:\OTRS\Perl\perl\lib\Config.pm expected
C:\strawberry\perl\lib\Config.pm
Note (probably harmless): No library found for -lmsvcrt
Note (probably harmless): No library found for -lmoldname
Note (probably harmless): No library found for -lkernel32
Note (probably harmless): No library found for -luser32
Note (probably harmless): No library found for -lgdi32
Note (probably harmless): No library found for -lwinspool
Note (probably harmless): No library found for -lcomdlg32
Note (probably harmless): No library found for -ladvapi32
Note (probably harmless): No library found for -lshell32
Note (probably harmless): No library found for -lole32
Note (probably harmless): No library found for -loleaut32
Note (probably harmless): No library found for -lnetapi32
Note (probably harmless): No library found for -luuid
Note (probably harmless): No library found for -lws2_32
Note (probably harmless): No library found for -lmpr
Note (probably harmless): No library found for -lwinmm
Note (probably harmless): No library found for -lversion
Note (probably harmless): No library found for -lodbc32
Note (probably harmless): No library found for -lodbccp32
LD_RUN_PATH=D:/oracle/instantclient_11_1/lib:D:/oracle/instantclient_11_
1/rdbms/
lib
Using DBD::Oracle 1.22.
Using DBD::Oracle 1.22.
Using DBI 1.607 (for perl 5.008008 on MSWin32-x86-multi-thread)
installed in D:/
OTRS/Perl/perl/site/lib/auto/DBI/
Writing Makefile for DBD::Oracle

Your assistance is appreciated.

Sajit

-----Original Message-----
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of
Michiel Beijen
Sent: 19 December 2008 02:02 PM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Oracle drivers

Sajit,

Apparently, you use Windows. Did you also use the Windows installer for
OTRS?
In that case, you are using Strawberry Perl. In the default
distribution DBD::Oracle is /not/ included.
This means you'll have to install this yourself. To do that you can
use either cpan or ppm. Just go to a console window, enter the
commands cpan or ppm and follow instructions. You can consult the
perldocs for more information.

DBD::Oracle is just a wrapper around the 'normal' Oracle client, so
you need to install that as well (if it is not yet present on your
machine). You can use Oracle Instant Client, which is a LOT easier to
install than the old 'regular' client.

Here are some notes on DBD::Oracle and Strawberry that might be of use
for you. This article also has a link to the place on the Oracle site
where you can download the Instant Client.
[http://win32.perl.org/wiki/index.php?title=Install_DBD::Oracle_on_Straw
berry_Perl]

Kind regards,
--
Michiel Beijen
Software Consultant
+31 6 - 457 42 418
Bee Free IT + http://beefreeit.nl

2008/12/19 Sajit Kalidas <SajitK@rewards.co.za>:
> Hi,
>
> I am getting the following error when trying to connect to the oracle
> database.
>
> install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC
(@INC
> contains: ../../ C:/OTRS/otrs/bin/cgi-bin/../../Kernel/cpan-lib
> C:/OTRS/otrs/bin/cgi-bin/../.. C:/OTRS/Perl/perl/lib
> C:/OTRS/Perl/perl/site/lib . C:/OTRS/otrs/bin/cgi-bin/../..
> C:/OTRS/otrs/bin/cgi-bin/../../Kernel/cpan-lib) at (eval 23) line 3.
>
> Perhaps the DBD::Oracle perl module hasn't been fully installed,
>
> or perhaps the capitalisation of 'Oracle' isn't right.
>
> Available drivers: DBM, ExampleP, File, Gofer, Proxy, SQLite, Sponge,
mysql.
>
> at C:/OTRS/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 216
>
>
>
> IF have made the following changes in the config.pm:
>
> $Self->{'DatabaseHost'} = 'dev';
>
> $Self->{'Database'} = 'dev';
>
> $Self->{'DatabaseUser'} = 'otrs';
>
> $Self->{'DatabasePw'} = 'pass';
>
> $Self->{DatabaseDSN} =
>
"DBI:Oracle:sid=$Self->{Database};host=$Self->{DatabaseHost};port=1521;"
;
>
>
>
> I have installed on windows using the windows installer package.
Where can
> I find the Oracle drivers?
>
>
>
> Any suggestions please.
>
>
>
> Thanks
>
> Sajit
>
> ________________________________
> This e-mail message has been scanned for Viruses and Content and
cleared by
> MailMarshal
> ________________________________
> _______________________________________________
> OTRS mailing list: otrs - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/otrs
> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
>
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

#####################################################################################

This e-mail message has been scanned for Viruses and Content and cleared
by MailMarshal
#####################################################################################
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs