Forwarding HTTP request headers

Forwarding HTTP request headers

am 04.10.2007 13:24:06 von Mark Knoop

Hi

I would like to pass through almost all http request headers from the
browser that accesses my gci script to a request that I make to another
host.

I can obtain a list of all HTTP request header names by using the cgi http()
function and access the values by using $ENV{$http_header_name};

Some of the header names I have seen returned are

HTTPS_SERVER_ISSUER
HTTP_USER_AGENT
HTTP_ACCEPT_LANGUAGE
HTTPS_KEYSIZE
HTTPS
HTTP_REFERER
HTTP_ACCEPT_CHARSET
HTTP_HOST
....

Now if I want to make a request using the same headers (with perhaps one or
two being changed as required - therefore I need to be able to process them
individually) I can use the LWP::UserAgent get() method, however it looks
like I should use the header names as they would appear in the http request
which are not the same as the header names returned by http().

(from an example on
http://www.perl.com/pub/a/2002/08/20/perlandlwp.html?page=2 )

$response = $browser->get($url,
'User-Agent' => 'Mozilla/4.76 [en] (Win98; U)',
'Accept' => 'image/gif, image/x-xbitmap, image/jpeg,
image/pjpeg, image/png, */*',
'Accept-Charset' => 'iso-8859-1,*,utf-8',
'Accept-Language' => 'en-US',
);


So - can anyone suggest a method of getting from HTTP_USER_AGENT to
User-Agent - and so on for all http headers present (many of which I will
not know in advance)?

It feels like I am missing something really obvious...

Cheers
Mark


_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

RE: Forwarding HTTP request headers

am 05.10.2007 12:43:13 von Brian Raven

Mark Knoop <> wrote:
> Hi
> =

> I would like to pass through almost all http request headers from the
> browser that accesses my gci script to a request that I make to
> another host. =

> =

> I can obtain a list of all HTTP request header names by using the cgi
> http() function and access the values by using
> $ENV{$http_header_name}; =

> =

> Some of the header names I have seen returned are
> =

> HTTPS_SERVER_ISSUER
> HTTP_USER_AGENT
> HTTP_ACCEPT_LANGUAGE
> HTTPS_KEYSIZE
> HTTPS
> HTTP_REFERER
> HTTP_ACCEPT_CHARSET
> HTTP_HOST
> ...
> =

> Now if I want to make a request using the same headers (with perhaps
> one or two being changed as required - therefore I need to be able to
> process them =

> individually) I can use the LWP::UserAgent get() method, however it
> looks like I should use the header names as they would appear in the
> http request which are not the same as the header names returned by
> http(). =

> =

> (from an example on
> http://www.perl.com/pub/a/2002/08/20/perlandlwp.html?page=3D 2 )
> =

> $response =3D $browser->get($url,
> 'User-Agent' =3D> 'Mozilla/4.76 [en] (Win98; U)',
> 'Accept' =3D> 'image/gif, image/x-xbitmap, image/jpeg,
> image/pjpeg, image/png, */*',
> 'Accept-Charset' =3D> 'iso-8859-1,*,utf-8',
> 'Accept-Language' =3D> 'en-US',
> );
> =

> =

> So - can anyone suggest a method of getting from HTTP_USER_AGENT to
> User-Agent - and so on for all http headers present (many of which I
> will not know in advance)? =

> =

> It feels like I am missing something really obvious...

AFAIK, the CGI only provides indirect and incomplete access to the
contents of the original HTTP request via the environment variable that
you already know about. If you need more complete and accurate access to
the HTTP request, the CGI is probably not appropriate. What you are
suggesting sound like something a proxy server might do, so have a look
at HTTP::Daemon, or even HTTP::Proxy.

HTH

-- =

Brian Raven =


==================== =====3D=
================
Atos Euronext Market Solutions Disclaimer
==================== =====3D=
================

The information contained in this e-mail is confidential and solely for the=
intended addressee(s). Unauthorised reproduction, disclosure, modification=
, and/or distribution of this email may be unlawful.
If you have received this email in error, please notify the sender immediat=
ely and delete it from your system. The views expressed in this message do =
not necessarily reflect those of Atos Euronext Market Solutions.

Atos Euronext Market Solutions Limited - Registered in England & Wales with=
registration no. 3962327. Registered office address at 25 Bank Street Lon=
don E14 5NQ United Kingdom. =

Atos Euronext Market Solutions SAS - Registered in France with registration=
no. 425 100 294. Registered office address at 6/8 Boulevard Haussmann 750=
09 Paris France.

L'information contenue dans cet e-mail est confidentielle et uniquement des=
tinee a la (aux) personnes a laquelle (auxquelle(s)) elle est adressee. Tou=
te copie, publication ou diffusion de cet email est interdite. Si cet e-mai=
l vous parvient par erreur, nous vous prions de bien vouloir prevenir l'exp=
editeur immediatement et d'effacer le e-mail et annexes jointes de votre sy=
steme. Le contenu de ce message electronique ne represente pas necessaireme=
nt la position ou le point de vue d'Atos Euronext Market Solutions.
Atos Euronext Market Solutions Limited Soci=E9t=E9 de droit anglais, enregi=
str=E9e au Royaume Uni sous le num=E9ro 3962327, dont le si=E8ge social se =
situe 25 Bank Street E14 5NQ Londres Royaume Uni.

Atos Euronext Market Solutions SAS, soci=E9t=E9 par actions simplifi=E9e, e=
nregistr=E9 au registre dui commerce et des soci=E9t=E9s sous le num=E9ro 4=
25 100 294 RCS Paris et dont le si=E8ge social se situe 6/8 Boulevard Hauss=
mann 75009 Paris France.
==================== =====3D=
================

_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Re: Forwarding HTTP request headers

am 08.10.2007 10:06:41 von Mark Knoop

>Mark Knoop <> wrote:
>> Hi
>>
>> I would like to pass through almost all http request headers from the
>> browser that accesses my gci script to a request that I make to
>> another host.
>>
>> I can obtain a list of all HTTP request header names by using the cgi
>> http() function and access the values by using
>> $ENV{$http_header_name};
>>
>> Some of the header names I have seen returned are
>>
>> HTTPS_SERVER_ISSUER
>> HTTP_USER_AGENT
>> HTTP_ACCEPT_LANGUAGE
>> HTTPS_KEYSIZE
>> HTTPS
>> HTTP_REFERER
>> HTTP_ACCEPT_CHARSET
>> HTTP_HOST
>> ...
>>
>> Now if I want to make a request using the same headers (with perhaps
>>one or two being changed as required - therefore I need to be able to
>> process them
>> individually) I can use the LWP::UserAgent get() method, however it
>> looks like I should use the header names as they would appear in the
>> http request which are not the same as the header names returned by
>> http().
>>
>> (from an example on
>> http://www.perl.com/pub/a/2002/08/20/perlandlwp.html?page=2 )
>>
>> $response = $browser->get($url,
>> 'User-Agent' => 'Mozilla/4.76 [en] (Win98; U)',
>> 'Accept' => 'image/gif, image/x-xbitmap, image/jpeg,
>> image/pjpeg, image/png, */*',
>> 'Accept-Charset' => 'iso-8859-1,*,utf-8',
>> 'Accept-Language' => 'en-US',
>> );
>>
>>
>> So - can anyone suggest a method of getting from HTTP_USER_AGENT to
>> User-Agent - and so on for all http headers present (many of which I
>> will not know in advance)?
>>
>> It feels like I am missing something really obvious...
>
>AFAIK, the CGI only provides indirect and incomplete access to the
>contents of the original HTTP request via the environment variable that
>you already know about. If you need more complete and accurate access to
>the HTTP request, the CGI is probably not appropriate. What you are
>suggesting sound like something a proxy server might do, so have a look
>at HTTP::Daemon, or even HTTP::Proxy.
>
>HTH

Cheers Brian - will investigate further...

Mark


_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

A bit confused about DBI, DBD and ODBC

am 31.10.2007 19:07:50 von Alejandro Santillan

I need to access an Oracle data base and I am a bit confused about which
module should I use.
Can someone give me an advice if DBI, DBD, or ODBC?

Thank you!

Alejandro


_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Re: A bit confused about DBI, DBD and ODBC

am 31.10.2007 19:15:35 von David Moreno Garza

On Wed, 2007-10-31 at 15:07 -0300, Alejandro Santillan Iturres wrote:
> I need to access an Oracle data base and I am a bit confused about which
> module should I use.
> Can someone give me an advice if DBI, DBD, or ODBC?

I'd suggest you using DBD::Oracle, which inherits from DBI. Reading it's
documentation should give you a hint on what to do to connect and work
with properly.

--
David Moreno Garza | http://www.damog.net/
http://www.cervezatecate.com/


_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Re: A bit confused about DBI, DBD and ODBC

am 01.11.2007 10:30:12 von Foo JH

You have 2 options:
1. DBD::Oracle, which is (iirc) a native call to the database
2. DBD::ODBC which goes through the oledb layer to connect

ODBC is generally to be avoided if you need performance.

Alejandro Santillan Iturres wrote:
> I need to access an Oracle data base and I am a bit confused about which
> module should I use.
> Can someone give me an advice if DBI, DBD, or ODBC?
>
> Thank you!
>
> Alejandro
>
>
> _______________________________________________
> ActivePerl mailing list
> ActivePerl@listserv.ActiveState.com
> To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
>

_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Re: A bit confused about DBI, DBD and ODBC

am 01.11.2007 10:40:53 von Mark Knoop

Hi

> ODBC is generally to be avoided if you need performance.
>

Is there a better option for connecting to SQL Server than using DBD::ODBC?

Cheers
Mark

_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

RE: A bit confused about DBI, DBD and ODBC

am 01.11.2007 12:07:00 von Brian Raven

David Moreno Garza <> wrote:
> On Wed, 2007-10-31 at 15:07 -0300, Alejandro Santillan Iturres wrote:
>> I need to access an Oracle data base and I am a bit confused about
>> which module should I use. Can someone give me an advice if DBI,
>> DBD, or ODBC? =

> =

> I'd suggest you using DBD::Oracle, which inherits from DBI.

I don't think so. DBI provides the database independent interface, while
DBD::* provides the drivers for the drivers used by DBI to talk to a
specific database. The relationship is not one of inheritance, at least
as far as I can see.

> Reading
> it's documentation should give you a hint on what to do to connect
> and work with properly. =


Absolutely, but it's the documentation for DBI that you need to read. So
far I have never needed to look at the documentation for DBD::Oracle. In
fact you don't usually need to mention DBD::Oracle in your script, as it
is specified in the DSN that you use to create a connection to your
database. However you do need it installed, so you do use it in that
sense.

HTH

-- =

Brian Raven =


==================== =====3D=
================
Atos Euronext Market Solutions Disclaimer
==================== =====3D=
================

The information contained in this e-mail is confidential and solely for the=
intended addressee(s). Unauthorised reproduction, disclosure, modification=
, and/or distribution of this email may be unlawful.
If you have received this email in error, please notify the sender immediat=
ely and delete it from your system. The views expressed in this message do =
not necessarily reflect those of Atos Euronext Market Solutions.

Atos Euronext Market Solutions Limited - Registered in England & Wales with=
registration no. 3962327. Registered office address at 25 Bank Street Lon=
don E14 5NQ United Kingdom. =

Atos Euronext Market Solutions SAS - Registered in France with registration=
no. 425 100 294. Registered office address at 6/8 Boulevard Haussmann 750=
09 Paris France.

L'information contenue dans cet e-mail est confidentielle et uniquement des=
tinee a la (aux) personnes a laquelle (auxquelle(s)) elle est adressee. Tou=
te copie, publication ou diffusion de cet email est interdite. Si cet e-mai=
l vous parvient par erreur, nous vous prions de bien vouloir prevenir l'exp=
editeur immediatement et d'effacer le e-mail et annexes jointes de votre sy=
steme. Le contenu de ce message electronique ne represente pas necessaireme=
nt la position ou le point de vue d'Atos Euronext Market Solutions.
Atos Euronext Market Solutions Limited Soci=E9t=E9 de droit anglais, enregi=
str=E9e au Royaume Uni sous le num=E9ro 3962327, dont le si=E8ge social se =
situe 25 Bank Street E14 5NQ Londres Royaume Uni.

Atos Euronext Market Solutions SAS, soci=E9t=E9 par actions simplifi=E9e, e=
nregistr=E9 au registre dui commerce et des soci=E9t=E9s sous le num=E9ro 4=
25 100 294 RCS Paris et dont le si=E8ge social se situe 6/8 Boulevard Hauss=
mann 75009 Paris France.
==================== =====3D=
================

_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Re: A bit confused about DBI, DBD and ODBC

am 02.11.2007 01:11:55 von Alejandro Santillan

Thank you, 2nd step: INSTALLATION

I've tried, time and time again, and always getting:

The ORACLE_HOME environment variable is not set and I couldn't guess it.
It must be set to hold the path to an Oracle installation directory
on this machine (or a machine with a compatible architecture).
See the README.clients.txt file for more information.
ABORTED!

The problem is that this linux system hasn't Oracle inside it. My intention =

is to access an Oracle server remotely. WHAT #$%@ SHOULD BE THE VALUE OF =

THE ORACLE_HOME VARIABLE?????/

Help me, please!!!!

Thank you all.

Alejandro


----- Original Message ----- =

From: "Brian Raven"
To:
Sent: Thursday, November 01, 2007 8:07 AM
Subject: RE: A bit confused about DBI, DBD and ODBC


> David Moreno Garza <> wrote:
>> On Wed, 2007-10-31 at 15:07 -0300, Alejandro Santillan Iturres wrote:
>>> I need to access an Oracle data base and I am a bit confused about
>>> which module should I use. Can someone give me an advice if DBI,
>>> DBD, or ODBC?
>>
>> I'd suggest you using DBD::Oracle, which inherits from DBI.
>
> I don't think so. DBI provides the database independent interface, while
> DBD::* provides the drivers for the drivers used by DBI to talk to a
> specific database. The relationship is not one of inheritance, at least
> as far as I can see.
>
>> Reading
>> it's documentation should give you a hint on what to do to connect
>> and work with properly.
>
> Absolutely, but it's the documentation for DBI that you need to read. So
> far I have never needed to look at the documentation for DBD::Oracle. In
> fact you don't usually need to mention DBD::Oracle in your script, as it
> is specified in the DSN that you use to create a connection to your
> database. However you do need it installed, so you do use it in that
> sense.
>
> HTH
>
> -- =

> Brian Raven
>
> ==================== =====
=================3D
> Atos Euronext Market Solutions Disclaimer
> ==================== =====
=================3D
>
> The information contained in this e-mail is confidential and solely for =

> the intended addressee(s). Unauthorised reproduction, disclosure, =

> modification, and/or distribution of this email may be unlawful.
> If you have received this email in error, please notify the sender =

> immediately and delete it from your system. The views expressed in this =

> message do not necessarily reflect those of Atos Euronext Market =

> Solutions.
>
> Atos Euronext Market Solutions Limited - Registered in England & Wales =

> with registration no. 3962327. Registered office address at 25 Bank =

> Street London E14 5NQ United Kingdom.
> Atos Euronext Market Solutions SAS - Registered in France with =

> registration no. 425 100 294. Registered office address at 6/8 Boulevard =

> Haussmann 75009 Paris France.
>
> L'information contenue dans cet e-mail est confidentielle et uniquement =

> destinee a la (aux) personnes a laquelle (auxquelle(s)) elle est adressee=
.. =

> Toute copie, publication ou diffusion de cet email est interdite. Si cet =

> e-mail vous parvient par erreur, nous vous prions de bien vouloir preveni=
r =

> l'expediteur immediatement et d'effacer le e-mail et annexes jointes de =

> votre systeme. Le contenu de ce message electronique ne represente pas =

> necessairement la position ou le point de vue d'Atos Euronext Market =

> Solutions.
> Atos Euronext Market Solutions Limited Soci=E9t=E9 de droit anglais, =

> enregistr=E9e au Royaume Uni sous le num=E9ro 3962327, dont le si=E8ge so=
cial se =

> situe 25 Bank Street E14 5NQ Londres Royaume Uni.
>
> Atos Euronext Market Solutions SAS, soci=E9t=E9 par actions simplifi=E9e, =

> enregistr=E9 au registre dui commerce et des soci=E9t=E9s sous le num=E9r=
o 425 100 =

> 294 RCS Paris et dont le si=E8ge social se situe 6/8 Boulevard Haussmann =

> 75009 Paris France.
> ==================== =====
=================3D
>
> _______________________________________________
> ActivePerl mailing list
> ActivePerl@listserv.ActiveState.com
> To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
> =



_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

RE: A bit confused about DBI, DBD and ODBC

am 02.11.2007 11:29:53 von Brian Raven

Alejandro Santillan Iturres wrote:
> Thank you, 2nd step: INSTALLATION
> =

> I've tried, time and time again, and always getting:
> =

> The ORACLE_HOME environment variable is not set and I couldn't guess
> it. It must be set to hold the path to an Oracle installation
> directory on this machine (or a machine with a compatible
> architecture). See the README.clients.txt file for more
> information. ABORTED!
> =

> The problem is that this linux system hasn't Oracle inside it. My
> intention is to access an Oracle server remotely. WHAT #$%@ SHOULD
> BE THE VALUE OF THE ORACLE_HOME VARIABLE?????/ =


It only makes sense to install DBD::Oracle on a box that has the Oracle
client available. So only install DBD::Oracle on a box that has the
Oracle client.

If you want to use DBI on a box that doesn't have the Oracle client you
can use dbiproxy. It should be a relatively easy matter to run the
dbiproxy server on the box that has the Oracle client, and set the
DBI_AUTOPROXY on the box that doesn't, and the same Perl script can be
run on either box. At least, that was my experience a few years ago.

Read the documentation for DBI::ProxyServer, as well as DBI.

HTH

-- =

Brian Raven =


==================== =====3D=
================
Atos Euronext Market Solutions Disclaimer
==================== =====3D=
================

The information contained in this e-mail is confidential and solely for the=
intended addressee(s). Unauthorised reproduction, disclosure, modification=
, and/or distribution of this email may be unlawful.
If you have received this email in error, please notify the sender immediat=
ely and delete it from your system. The views expressed in this message do =
not necessarily reflect those of Atos Euronext Market Solutions.

Atos Euronext Market Solutions Limited - Registered in England & Wales with=
registration no. 3962327. Registered office address at 25 Bank Street Lon=
don E14 5NQ United Kingdom. =

Atos Euronext Market Solutions SAS - Registered in France with registration=
no. 425 100 294. Registered office address at 6/8 Boulevard Haussmann 750=
09 Paris France.

L'information contenue dans cet e-mail est confidentielle et uniquement des=
tinee a la (aux) personnes a laquelle (auxquelle(s)) elle est adressee. Tou=
te copie, publication ou diffusion de cet email est interdite. Si cet e-mai=
l vous parvient par erreur, nous vous prions de bien vouloir prevenir l'exp=
editeur immediatement et d'effacer le e-mail et annexes jointes de votre sy=
steme. Le contenu de ce message electronique ne represente pas necessaireme=
nt la position ou le point de vue d'Atos Euronext Market Solutions.
Atos Euronext Market Solutions Limited Soci=E9t=E9 de droit anglais, enregi=
str=E9e au Royaume Uni sous le num=E9ro 3962327, dont le si=E8ge social se =
situe 25 Bank Street E14 5NQ Londres Royaume Uni.

Atos Euronext Market Solutions SAS, soci=E9t=E9 par actions simplifi=E9e, e=
nregistr=E9 au registre dui commerce et des soci=E9t=E9s sous le num=E9ro 4=
25 100 294 RCS Paris et dont le si=E8ge social se situe 6/8 Boulevard Hauss=
mann 75009 Paris France.
==================== =====3D=
================

_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Re: A bit confused about DBI, DBD and ODBC

am 02.11.2007 14:41:59 von Alejandro Santillan

This is a multi-part message in MIME format.

--===============0189040852==
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_005F_01C81D3C.FF4B7E40"

This is a multi-part message in MIME format.

------=_NextPart_000_005F_01C81D3C.FF4B7E40
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

It seems that one has to install something from Oracle before installing =
DBD::Oracle.

Curious that this is not plainly said on the module docs.



http://www.oracle.com/technology/software/tech/oci/instantcl ient/htdocs/l=
inuxsoft.html




http://www.perlmonks.org/?node_id=3D394696




http://www.oracle.com/technology/tech/oci/instantclient/inde x.html

Compiling and installing DBD::Oracle on Linux requires that the Oracle =
OCI needs to be installed. Basically its the oracle C librarie

s and header files. These are located on the oracle install media, but =
are only visible under the advanced install options.

So yes, some oracle stuff needs to be installed before you can use =
DBD::Oracle, but there will not be an oracle server running on your =
linux box and it will not require an oracle license (unless youre under =
oracle client licensing).



------=_NextPart_000_005F_01C81D3C.FF4B7E40
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">



style=3D"WORD-WRAP: break-word; -khtml-nbsp-mode: space; =
-khtml-line-break: after-white-space"=20
bgColor=3D#ffffff>


It seems that one has to install something from Oracle =
before=20
installing DBD::Oracle.


Curious that this is not plainly said on the =
module=20
docs.


 

href=3D"http://www.oracle.com/technology/software/tech/oci/i nstantclient/=
htdocs/linuxsoft.html">http://www.oracle.com/technology/soft ware/tech/oci=
/instantclient/htdocs/linuxsoft.html





face=3DTimes=20
size=3D4> 16px"> class=3DApple-style-span face=3DHelvetica size=3D3> class=3DApple-style-span=20
style=3D"FONT-SIZE: 12px"> =
href=3D"http://www.perlmonks.org/?node_id=3D394696">http://w ww.perlmonks.=
org/?node_id=3D394696



class=3Dkhtml-block-placeholder>


face=3DTimes=20
size=3D4> 16px"> class=3DApple-style-span face=3DHelvetica size=3D3> class=3DApple-style-span=20
style=3D"FONT-SIZE: 12px"> =
href=3D"http://www.oracle.com/technology/tech/oci/instantcli ent/index.htm=
l">http://www.oracle.com/technology/tech/oci/instantclient/i ndex.html=


face=3DTimes=20
size=3D4> 16px">Compiling and=20
installing DBD::Oracle on Linux requires that the Oracle OCI needs to =
be=20
installed. Basically its the oracle C librarie


face=3DTimes=20
size=3D4>s =
and header=20
files. These are located on the oracle install media, but are only =
visible=20
under the advanced install options.


face=3DTimes=20
size=3D4>So =
yes, some=20
oracle stuff needs to be installed before you can use DBD::Oracle, but =
there=20
will not be an oracle server running on your linux box and it will not =
require=20
an oracle license (unless youre under oracle client=20
licensing).


style=3D"WORD-SPACING: 0px; FONT: 12px Helvetica; TEXT-TRANSFORM: =
none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; =
LETTER-SPACING: normal; BORDER-COLLAPSE: separate; border-spacing: 0px =
0px; -khtml-text-decorations-in-effect: none; -apple-text-size-adjust: =
auto; orphans: 2; widows: 2"> =
class=3DApple-interchange-newline>
<=
/BODY>

------=_NextPart_000_005F_01C81D3C.FF4B7E40--



--===============0189040852==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
--===============0189040852==--

RE: A bit confused about DBI, DBD and ODBC

am 02.11.2007 15:00:14 von Brian Raven

From: activeperl-bounces@listserv.ActiveState.com
[mailto:activeperl-bounces@listserv.ActiveState.com] On Behalf Of
Alejandro Santillan Iturres
Sent: 02 November 2007 13:42
To: activeperl@listserv.ActiveState.com
Subject: Re: A bit confused about DBI, DBD and ODBC

> It seems that one has to install something from Oracle before
installing DBD::Oracle.
> =

> Curious that this is not plainly said on the module docs.

You mean like in the README file, under "*BEFORE* BUILDING, TESTING AND
INSTALLING DBD::Oracle:" where it says:

Install enough Oracle software to enable DBD::Oracle to build.

For Oracle Instant Client: that means install the following
packages:
* The "Basic" package for the essential Oracle libraries.
* The "SDK" package for the headers and makefile.
* The "SQL*Plus" component is optional, but will help you check
your configuration and DBD::Oracle determine your Oracle
version.

For full Oracle installs: that usually includes Pro*C and SQL*Net.
(That's not very specific because it varies between Oracle
releases.)

The ORACLE_HOME environment variable must point to the Oracle Home
used to create DBD::Oracle. (Not essential under MS Windows).

*** MOST IMPORTANTLY:

Make sure Oracle is working and you can use the Oracle sqlplus
command to talk to the database from the machine you
want to build DBD::Oracle on. This often involves setting
environment variables like PATH, LD_LIBRARY_PATH, TWO_TASK etc.
Consult Oracle documentation for more details.

Only once you can connect to Oracle using sqlplus
should you try building and testing DBD::Oracle.

HTH

-- =

Brian Raven =


==================== =====3D=
================
Atos Euronext Market Solutions Disclaimer
==================== =====3D=
================

The information contained in this e-mail is confidential and solely for the=
intended addressee(s). Unauthorised reproduction, disclosure, modification=
, and/or distribution of this email may be unlawful.
If you have received this email in error, please notify the sender immediat=
ely and delete it from your system. The views expressed in this message do =
not necessarily reflect those of Atos Euronext Market Solutions.

Atos Euronext Market Solutions Limited - Registered in England & Wales with=
registration no. 3962327. Registered office address at 25 Bank Street Lon=
don E14 5NQ United Kingdom. =

Atos Euronext Market Solutions SAS - Registered in France with registration=
no. 425 100 294. Registered office address at 6/8 Boulevard Haussmann 750=
09 Paris France.

L'information contenue dans cet e-mail est confidentielle et uniquement des=
tinee a la (aux) personnes a laquelle (auxquelle(s)) elle est adressee. Tou=
te copie, publication ou diffusion de cet email est interdite. Si cet e-mai=
l vous parvient par erreur, nous vous prions de bien vouloir prevenir l'exp=
editeur immediatement et d'effacer le e-mail et annexes jointes de votre sy=
steme. Le contenu de ce message electronique ne represente pas necessaireme=
nt la position ou le point de vue d'Atos Euronext Market Solutions.
Atos Euronext Market Solutions Limited Soci=E9t=E9 de droit anglais, enregi=
str=E9e au Royaume Uni sous le num=E9ro 3962327, dont le si=E8ge social se =
situe 25 Bank Street E14 5NQ Londres Royaume Uni.

Atos Euronext Market Solutions SAS, soci=E9t=E9 par actions simplifi=E9e, e=
nregistr=E9 au registre dui commerce et des soci=E9t=E9s sous le num=E9ro 4=
25 100 294 RCS Paris et dont le si=E8ge social se situe 6/8 Boulevard Hauss=
mann 75009 Paris France.
==================== =====3D=
================

_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Re: A bit confused about DBI, DBD and ODBC

am 02.11.2007 19:33:44 von Alejandro Santillan

> You mean like in the README file, under "*BEFORE* BUILDING, TESTING AND
> INSTALLING DBD::Oracle:" where it says:


You 're rigth Brian. Thank you very much. It seems this solved my problem.
Alejandro

----- Original Message ----- =

From: "Brian Raven"
To:
Sent: Friday, November 02, 2007 11:00 AM
Subject: RE: A bit confused about DBI, DBD and ODBC


> From: activeperl-bounces@listserv.ActiveState.com
> [mailto:activeperl-bounces@listserv.ActiveState.com] On Behalf Of
> Alejandro Santillan Iturres
> Sent: 02 November 2007 13:42
> To: activeperl@listserv.ActiveState.com
> Subject: Re: A bit confused about DBI, DBD and ODBC
>
>> It seems that one has to install something from Oracle before
> installing DBD::Oracle.
>>
>> Curious that this is not plainly said on the module docs.
>
> You mean like in the README file, under "*BEFORE* BUILDING, TESTING AND
> INSTALLING DBD::Oracle:" where it says:
>
> Install enough Oracle software to enable DBD::Oracle to build.
>
> For Oracle Instant Client: that means install the following
> packages:
> * The "Basic" package for the essential Oracle libraries.
> * The "SDK" package for the headers and makefile.
> * The "SQL*Plus" component is optional, but will help you check
> your configuration and DBD::Oracle determine your Oracle
> version.
>
> For full Oracle installs: that usually includes Pro*C and SQL*Net.
> (That's not very specific because it varies between Oracle
> releases.)
>
> The ORACLE_HOME environment variable must point to the Oracle Home
> used to create DBD::Oracle. (Not essential under MS Windows).
>
> *** MOST IMPORTANTLY:
>
> Make sure Oracle is working and you can use the Oracle sqlplus
> command to talk to the database from the machine you
> want to build DBD::Oracle on. This often involves setting
> environment variables like PATH, LD_LIBRARY_PATH, TWO_TASK etc.
> Consult Oracle documentation for more details.
>
> Only once you can connect to Oracle using sqlplus
> should you try building and testing DBD::Oracle.
>
> HTH
>
> -- =

> Brian Raven
>
> ==================== =====
=================3D
> Atos Euronext Market Solutions Disclaimer
> ==================== =====
=================3D
>
> The information contained in this e-mail is confidential and solely for =

> the intended addressee(s). Unauthorised reproduction, disclosure, =

> modification, and/or distribution of this email may be unlawful.
> If you have received this email in error, please notify the sender =

> immediately and delete it from your system. The views expressed in this =

> message do not necessarily reflect those of Atos Euronext Market =

> Solutions.
>
> Atos Euronext Market Solutions Limited - Registered in England & Wales =

> with registration no. 3962327. Registered office address at 25 Bank =

> Street London E14 5NQ United Kingdom.
> Atos Euronext Market Solutions SAS - Registered in France with =

> registration no. 425 100 294. Registered office address at 6/8 Boulevard =

> Haussmann 75009 Paris France.
>
> L'information contenue dans cet e-mail est confidentielle et uniquement =

> destinee a la (aux) personnes a laquelle (auxquelle(s)) elle est adressee=
.. =

> Toute copie, publication ou diffusion de cet email est interdite. Si cet =

> e-mail vous parvient par erreur, nous vous prions de bien vouloir preveni=
r =

> l'expediteur immediatement et d'effacer le e-mail et annexes jointes de =

> votre systeme. Le contenu de ce message electronique ne represente pas =

> necessairement la position ou le point de vue d'Atos Euronext Market =

> Solutions.
> Atos Euronext Market Solutions Limited Soci=E9t=E9 de droit anglais, =

> enregistr=E9e au Royaume Uni sous le num=E9ro 3962327, dont le si=E8ge so=
cial se =

> situe 25 Bank Street E14 5NQ Londres Royaume Uni.
>
> Atos Euronext Market Solutions SAS, soci=E9t=E9 par actions simplifi=E9e, =

> enregistr=E9 au registre dui commerce et des soci=E9t=E9s sous le num=E9r=
o 425 100 =

> 294 RCS Paris et dont le si=E8ge social se situe 6/8 Boulevard Haussmann =

> 75009 Paris France.
> ==================== =====
=================3D
>
> _______________________________________________
> ActivePerl mailing list
> ActivePerl@listserv.ActiveState.com
> To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
> =



_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs