FW: Apache::DBI Failed due to +GlobalRequest

This is a multi-part message in MIME format.

------_=_NextPart_001_01CA3352.A87FED2C
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

I have configured with my apache 2.2 with Mod perl. When I tried to
use Apache::DBI for persistent Database connection, It shows the below
error

[Thu Sep 10 14:39:30 2009] [error] Global $r object is not available.
Set:\n\tPerlOptions +GlobalRequest\nin httpd.conf at
/var/www/audashboard/exec/startup.pl line 24.\nCompilation failed in
require at (eval 5) line 1.\n

[Thu Sep 10 14:40:05 2009] [warn] Init: Session Cache is not configured
[hint: SSLSessionCache]

[Thu Sep 10 14:40:05 2009] [error] Global symbol "$r" requires explicit
package name at startup.pl line 24.\nCompilation failed in require at
(eval 5) line 1.\n

I have re-installed CGI 3.45 and enable the PerlOptions in my virtual
host. But still it is not working for me .

Can you please suggest me on this ?

Raja

------_=_NextPart_001_01CA3352.A87FED2C
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Hi, <o:p></o:p>

<o:p> </o:p>

I have configured with my apache 2.2 with Mod
perl. When I tried to use Apache::DBI for persistent =
Database
connection, It shows the below error <o:p></o:p>

<o:p> </o:p>

[Thu Sep 10 14:39:30 2009] [error] Global $r object =
is not available.
Set:\n\tPerlOptions +GlobalRequest\nin httpd.conf at
/var/www/audashboard/exec/startup.pl line 24.\nCompilation failed in =
require at
(eval 5) line 1.\n<o:p></o:p>

 [Thu Sep 10 14:40:05 2009] [warn] Init: =
Session Cache
is not configured [hint: SSLSessionCache]<o:p></o:p>

[Thu Sep 10 14:40:05 2009] [error] Global symbol
"$r" requires explicit package name at startup.pl line
24.\nCompilation failed in require at (eval 5) line 1.\n<o:p></o:p>

<o:p> </o:p>

I have re-installed CGI 3.45 and enable the =
PerlOptions in
my virtual host. But still it is not working for me .<o:p></o:p>

<o:p> </o:p>

Can you please suggest me on this ? <o:p></o:p>

<o:p> </o:p>

Raja <o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

<o:p> </o:p>

</div>

</body>

</html>

------_=_NextPart_001_01CA3352.A87FED2C--

Hi,

Thanks for your mail. I did tried. It's not working .

Below is my virtual host detail

<VirtualHost xxxx>
ServerAdmin kraja [at] netapp.com
DocumentRoot "XXXX"
ServerName XXXX
ErrorLog XXXX
CustomLog XXXX common

SetEnv PERL5LIB " XXXX/lib/"
setenv ORACLE_USERID XXXX
setenv ORACLE_HOME XXXX
setenv LD_LIBRARY_PATH XXXX
setenv ORACLE_SID XXXX
setenv ORA_NLS10 XXXX

PerlModule Apache::DBI
PerlPostConfigRequire XXXX/startup.pl
PerlOptions +GlobalRequest

<Directory "XXXX">
AddHandler server-parsed .shtml .html
AddOutputFilter INCLUDES .cgi .shtml .pl .html
AllowOverride None
Options Indexes FollowSymLinks MultiViews +ExecCGI Includes
Allow from all,deny
</Directory>
</VirtualHost>

- Raja

-----Original Message-----
From: Andr=E9 Warnier [mailto:aw [at] ice-sa.com]
Sent: Saturday, September 12, 2009 3:43 PM
To: Kulasekaran, Raja
Subject: Re: FW: Apache::DBI Failed due to +GlobalRequest

Kulasekaran, Raja wrote:
> Hi,
>
>
>
> I have configured with my apache 2.2 with Mod perl. When I tried to
> use Apache::DBI for persistent Database connection, It shows the =
below
> error
>
>
>
> [Thu Sep 10 14:39:30 2009] [error] Global $r object is not available.
> Set:\n\tPerlOptions +GlobalRequest\nin httpd.conf at
> /var/www/audashboard/exec/startup.pl line 24.\nCompilation failed in
> require at (eval 5) line 1.\n
>
> [Thu Sep 10 14:40:05 2009] [warn] Init: Session Cache is not =
configured
> [hint: SSLSessionCache]
>
> [Thu Sep 10 14:40:05 2009] [error] Global symbol "$r" requires =
explicit
> package name at startup.pl line 24.\nCompilation failed in require at
> (eval 5) line 1.\n
>
>
>
> I have re-installed CGI 3.45 and enable the PerlOptions in my virtual
> host. But still it is not working for me .
>
What happens if you set that option *outside* of any VirtualHost
section, like in the main config. file ?

Kulasekaran, Raja wrote:
> Hi,
>
> Thanks for your mail. I did tried. It's not working .
>
Yes, I am sorry. I did not look close enough at the following error :

[Thu Sep 10 14:39:30 2009] [error] Global $r object is not available.
Set:\n\tPerlOptions +GlobalRequest\nin httpd.conf at
/var/www/audashboard/exec/startup.pl line 24.\nCompilation failed in
require at (eval 5) line 1.\n

In a mod_perl *request* handler, the first argument
(my $r = shift;)
is usually a pointer to the current Request object.

But in your startup script (startup.pl), that is not the case, because
when that script is run, there is no request yet.
I don't know what you are trying to do with $r in that startup script,
but something is wrong and maybe the error message above is misleading.
(I mean that it may have nothing to do with GlobalRequest at that stage.)

This is a multi-part message in MIME format.
--------------020307020900070701060602
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

I've run into this before. It's a bug in v1.07 of Apache::DBI

Open up the Apache/DBI.pm source file (on one of my test systems it's
installed in /usr/lib/perl5/site_perl/5.8.8/Apache/DBI.pm) aind the
following block of code:
/ if (!$Rollback{$Idx}) {
my $r;
if (MP2) {
$r = Apache2::RequestUtil->request;
}
elsif (Apache->can('push_handlers')) {
$r = 'Apache';
}
/
The problem with this is that if you're calling this from startup.pl
you're not actually in a request at that point (as someone already
mentioned) so without the eval there the script dies.

Fix it by wrapping the "/$r = Apache2::RequestUtil->request;/" part in
an eval so it looks like this: /eval { $r = Apache2::RequestUtil->request;}

/

André Warnier wrote:
> Kulasekaran, Raja wrote:
>> Hi,
>>
>> Thanks for your mail. I did tried. It's not working .
>>
> Yes, I am sorry. I did not look close enough at the following error :
>
> [Thu Sep 10 14:39:30 2009] [error] Global $r object is not available.
> Set:\n\tPerlOptions +GlobalRequest\nin httpd.conf at
> /var/www/audashboard/exec/startup.pl line 24.\nCompilation failed in
> require at (eval 5) line 1.\n
>
> In a mod_perl *request* handler, the first argument
> (my $r = shift;)
> is usually a pointer to the current Request object.
>
> But in your startup script (startup.pl), that is not the case, because
> when that script is run, there is no request yet.
> I don't know what you are trying to do with $r in that startup script,
> but something is wrong and maybe the error message above is misleading.
> (I mean that it may have nothing to do with GlobalRequest at that stage.)

--------------020307020900070701060602
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
I've run into this before. It's a bug in v1.07 of Apache::DBI 
 
Open up the Apache/DBI.pm source file (on one of my test systems it's
installed in /usr/lib/perl5/site_perl/5.8.8/Apache/DBI.pm) aind the
following block of code: 
 if (!$Rollback{$Idx}) { 
 my $r; 
 if (MP2) { 
 $r = Apache2::RequestUtil->request; 
 } 
 elsif (Apache->can('push_handlers')) { 
 $r = 'Apache'; 
 } 
 
The problem with this is that if you're calling this from startup.pl
you're not actually in a request at that point (as someone already
mentioned) so without the eval there the script dies. 
 
Fix it by wrapping the "$r = Apache2::RequestUtil->request;"
part in an eval so it looks like this: eval { $r =
Apache2::RequestUtil->request;} 
 
 
 
 
 
 
 
 
André Warnier wrote:
<blockquote cite="mid:4AABA26E.8050309 [at] ice-sa.com" type="cite">Kulasekaran,
Raja wrote:
 
<blockquote type="cite">Hi,
 
 
Thanks for your mail. I did tried. It's not working .
 
 
</blockquote>
Yes, I am sorry. I did not look close enough at the following error :
 
 
[Thu Sep 10 14:39:30 2009] [error] Global $r object is not available.
 
Set:\n\tPerlOptions +GlobalRequest\nin httpd.conf at
 
/var/www/audashboard/exec/startup.pl line 24.\nCompilation failed in
 
require at (eval 5) line 1.\n
 
 
In a mod_perl *request* handler, the first argument
 
(my $r = shift;)
 
is usually a pointer to the current Request object.
 
 
But in your startup script (startup.pl), that is not the case, because
when that script is run, there is no request yet.
 
I don't know what you are trying to do with $r in that startup script,
but something is wrong and maybe the error message above is misleading.
 
(I mean that it may have nothing to do with GlobalRequest at that
stage.)
 
</blockquote>
</body>
</html>

--------------020307020900070701060602--

This is a multi-part message in MIME format.

------_=_NextPart_001_01CA33BD.9111FD4B
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

Great. I guess this might solve the problem.

I had found in one of the forum stating that we can write a handler =
which generates the "$r" global object before initiate the Apache::DBI =
connection . Is that possible ? .

Otherwise, Shall I install Apache::DBI 1.06 instead of Apache::DBI 1.07 =
?

Thanks,

Raja

From: Brad Van Sickle [mailto:bvs7085 [at] gmail.com]
Sent: Saturday, September 12, 2009 7:54 PM
To: mod_perl list
Cc: Kulasekaran, Raja
Subject: Re: FW: Apache::DBI Failed due to +GlobalRequest

I've run into this before. It's a bug in v1.07 of Apache::DBI

Open up the Apache/DBI.pm source file (on one of my test systems it's =
installed in /usr/lib/perl5/site_perl/5.8.8/Apache/DBI.pm) aind the =
following block of code:
if (!$Rollback{$Idx}) {
my $r;
if (MP2) {
$r =3D Apache2::RequestUtil->request;
}
elsif (Apache->can('push_handlers')) {
$r =3D 'Apache';
}

The problem with this is that if you're calling this from startup.pl =
you're not actually in a request at that point (as someone already =
mentioned) so without the eval there the script dies.

Fix it by wrapping the "$r =3D Apache2::RequestUtil->request;" part in =
an eval so it looks like this: eval { $r =3D =
Apache2::RequestUtil->request;}

Andr=E9 Warnier wrote:

Kulasekaran, Raja wrote:

Hi,

Thanks for your mail. I did tried. It's not working .

Yes, I am sorry. I did not look close enough at the following error :

[Thu Sep 10 14:39:30 2009] [error] Global $r object is not available.
Set:\n\tPerlOptions +GlobalRequest\nin httpd.conf at
/var/www/audashboard/exec/startup.pl line 24.\nCompilation failed in
require at (eval 5) line 1.\n

In a mod_perl *request* handler, the first argument
(my $r =3D shift;)
is usually a pointer to the current Request object.

But in your startup script (startup.pl), that is not the case, because =
when that script is run, there is no request yet.
I don't know what you are trying to do with $r in that startup script, =
but something is wrong and maybe the error message above is misleading.
(I mean that it may have nothing to do with GlobalRequest at that =
stage.)

------_=_NextPart_001_01CA33BD.9111FD4B
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" =
xmlns:a=3D"urn:schemas-microsoft-com:office:access" =
xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" =
xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" =
xmlns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema" =
xmlns:b=3D"urn:schemas-microsoft-com:office:publisher" =
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet" =
xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" =
xmlns:odc=3D"urn:schemas-microsoft-com:office:odc" =
xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" =
xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" =
xmlns:rtc=3D"http://microsoft.com/officenet/conferencing" =
xmlns:D=3D"DAV:" xmlns:Repl=3D"http://schemas.microsoft.com/repl/" =
xmlns:mt=3D"http://schemas.microsoft.com/sharepoint/soap/mee tings/" =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/x ml" =
xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" =
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/oi s/" =
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/di rectory/" =
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" =
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp" =
xmlns:udc=3D"http://schemas.microsoft.com/data/udc" =
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" =
xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/20 02/1/alerts/"=
xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#" =
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" =
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" =
xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/soap" =
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " =
xmlns:udcp2p=3D"http://schemas.microsoft.com/data/udc/partto part" =
xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/wor kflow/" =
xmlns:dsss=3D"http://schemas.microsoft.com/office/2006/digsi g-setup" =
xmlns:dssi=3D"http://schemas.microsoft.com/office/2006/digsi g" =
xmlns:mdssi=3D"http://schemas.openxmlformats.org/package/200 6/digital-sig=
nature" =
xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compa tibility/2006=
" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns:mrels=3D"http://schemas.openxmlformats.org/package/200 6/relationshi=
ps" xmlns:spwp=3D"http://microsoft.com/sharepoint/webpartpages" =
xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/2006/types"=
=
xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/2006/messag=
es" =
xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ SlideLibrary/=
" =
xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor talServer/Pub=
lishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" =
xmlns:st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>

</style>

</head>

<body bgcolor=3Dwhite lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Hi,<o:p></o:p>

<o:p> </o:p>

Great. I guess this might solve the problem. =
<o:p></o:p>

<o:p> </o:p>

I had found in one of the forum stating that=A0 we can =
write a
handler which generates the “$r” global object =A0before =
initiate the
Apache::DBI =A0connection . =A0Is that possible ? =
..<o:p></o:p>

<o:p> </o:p>

Otherwise, Shall I=A0 install Apache::DBI 1.06 instead of
Apache::DBI 1.07 ? <o:p></o:p>

<o:p> </o:p>

Thanks,<o:p></o:p>

Raja <o:p></o:p>

<o:p> </o:p>

<div>

<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt =
0in 0in 0in'>

From: Brad Van Sickle
[mailto:bvs7085 [at] gmail.com] 
Sent: Saturday, September 12, 2009 7:54 PM 
To: mod_perl list 
Cc: Kulasekaran, Raja 
Subject: Re: FW: Apache::DBI Failed due to =
+GlobalRequest<o:p></o:p>

</div>

</div>

<o:p> </o:p>

I've run into this before. It's a bug in =
v1.07 of
Apache::DBI 
 
Open up the Apache/DBI.pm source file (on one of my test systems it's =
installed
in /usr/lib/perl5/site_perl/5.8.8/Apache/DBI.pm) aind the following =
block of
code: 
 if (!$Rollback{$Idx}) { 
 my $r; 
 if (MP2) { 
 &=
nbsp;
$r =3D Apache2::RequestUtil->request; 
 &=
nbsp;
} 
 elsif
(Apache->can('push_handlers')) { 
 $r =
=3D
'Apache'; 
 } 
 
The problem with this is that if you're calling this from startup.pl =
you're not
actually in a request at that point (as someone already mentioned) =
so
without the eval there the script dies. 
 
Fix it by wrapping the "$r =3D =
Apache2::RequestUtil->request;"
part in an eval so it looks like this: eval { $r =3D
Apache2::RequestUtil->request;} 
 
 
 
 
 
 
 
 
Andr=E9 Warnier wrote: <o:p></o:p>

Kulasekaran, Raja wrote: 
 
<o:p></o:p>

Hi, 
 
Thanks for your mail. I did tried. It's not working . <o:p></o:p>

Yes, I am sorry. I did not look close enough =
at the
following error : 
 
[Thu Sep 10 14:39:30 2009] [error] Global $r object is not available. =
 
Set:\n\tPerlOptions +GlobalRequest\nin httpd.conf at 
/var/www/audashboard/exec/startup.pl line 24.\nCompilation failed in =
 
require at (eval 5) line 1.\n 
 
In a mod_perl *request* handler, the first argument 
(my $r =3D shift;) 
is usually a pointer to the current Request object. 
 
But in your startup script (startup.pl), that is not the case, because =
when
that script is run, there is no request yet. 
I don't know what you are trying to do with $r in that startup script, =
but
something is wrong and maybe the error message above is misleading. 
(I mean that it may have nothing to do with GlobalRequest at that =
stage.) <o:p></o:p>

</div>

</body>

</html>

------_=_NextPart_001_01CA33BD.9111FD4B--

Kulasekaran, Raja wrote:
> Hi,
>
> Great. I guess this might solve the problem.
>
> I had found in one of the forum stating that we can write a handler
> which generates the â€œ$râ€ global object before initiate the Apache::DBI
> connection . Is that possible ? .
>
> Otherwise, Shall I install Apache::DBI 1.06 instead of Apache::DBI 1.07 ?

I would recommend running 1.06 until a new version is pushed with this
issue fixed.

Adam

This is a multi-part message in MIME format.

------_=_NextPart_001_01CA347B.D5215838
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

Persistent DB connection working fine with Apache::DBI .

But When I try to benchmark the performance with apache "ab" command =
( ab -n 100 -c 3 hostname ) , It failed with Segmentation fault (11) =
..

I have enabled the DBI trace and it shows like

" DBD::Oracle::st execute failed: ORA-01002: fetch out of sequence (DBD =
ERROR: OCIStmtExecute) [for Statement "

Any suggestion on this ?

Thanks,

Raja

From: Brad Van Sickle [mailto:bvs7085 [at] gmail.com]
Sent: Saturday, September 12, 2009 9:29 PM
To: Kulasekaran, Raja
Cc: mod_perl list
Subject: Re: FW: Apache::DBI Failed due to +GlobalRequest

That simple modification of the code I gave you should solve your =
problem in 2 minutes. No need to downgrade.

Kulasekaran, Raja wrote:

Hi,

Great. I guess this might solve the problem.

I had found in one of the forum stating that we can write a handler =
which generates the "$r" global object before initiate the Apache::DBI =
connection . Is that possible ? .

Otherwise, Shall I install Apache::DBI 1.06 instead of Apache::DBI 1.07 =
?

Thanks,

Raja

From: Brad Van Sickle [mailto:bvs7085 [at] gmail.com]
Sent: Saturday, September 12, 2009 7:54 PM
To: mod_perl list
Cc: Kulasekaran, Raja
Subject: Re: FW: Apache::DBI Failed due to +GlobalRequest

I've run into this before. It's a bug in v1.07 of Apache::DBI

Open up the Apache/DBI.pm source file (on one of my test systems it's =
installed in /usr/lib/perl5/site_perl/5.8.8/Apache/DBI.pm) aind the =
following block of code:
if (!$Rollback{$Idx}) {
my $r;
if (MP2) {
$r =3D Apache2::RequestUtil->request;
}
elsif (Apache->can('push_handlers')) {
$r =3D 'Apache';
}

The problem with this is that if you're calling this from startup.pl =
you're not actually in a request at that point (as someone already =
mentioned) so without the eval there the script dies.

Fix it by wrapping the "$r =3D Apache2::RequestUtil->request;" part in =
an eval so it looks like this: eval { $r =3D =
Apache2::RequestUtil->request;}

Andr=E9 Warnier wrote:

Kulasekaran, Raja wrote:

Hi,

Thanks for your mail. I did tried. It's not working .

Yes, I am sorry. I did not look close enough at the following error :

[Thu Sep 10 14:39:30 2009] [error] Global $r object is not available.
Set:\n\tPerlOptions +GlobalRequest\nin httpd.conf at
/var/www/audashboard/exec/startup.pl line 24.\nCompilation failed in
require at (eval 5) line 1.\n

In a mod_perl *request* handler, the first argument
(my $r =3D shift;)
is usually a pointer to the current Request object.

But in your startup script (startup.pl), that is not the case, because =
when that script is run, there is no request yet.
I don't know what you are trying to do with $r in that startup script, =
but something is wrong and maybe the error message above is misleading.
(I mean that it may have nothing to do with GlobalRequest at that =
stage.)

------_=_NextPart_001_01CA347B.D5215838
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>

</style>

</head>

<body bgcolor=3Dwhite lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Hi,<o:p></o:p>

<o:p> </o:p>

Persistent DB =A0connection working fine with Apache::DBI =
.. <o:p></o:p>

<o:p> </o:p>

But When I try to benchmark the performance with=A0 =
apache=A0 “ab”
command =A0( ab -n 100 -c 3=A0 hostname ) ,=A0 It failed with =
=A0Segmentation fault
(11) . <o:p></o:p>

<o:p> </o:p>

I have enabled the DBI trace and it shows like =
<o:p></o:p>

<o:p> </o:p>

“ DBD::Oracle::st execute failed: ORA-01002: fetch =
out of
sequence (DBD ERROR: OCIStmtExecute) [for Statement =
“<o:p></o:p>

<o:p> </o:p>

Any suggestion on this ? <o:p></o:p>

<o:p> </o:p>

Thanks,<o:p></o:p>

Raja <o:p></o:p>

<o:p> </o:p>

<div>

<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt =
0in 0in 0in'>

From: Brad Van Sickle
[mailto:bvs7085 [at] gmail.com] 
Sent: Saturday, September 12, 2009 9:29 PM 
To: Kulasekaran, Raja 
Cc: mod_perl list 
Subject: Re: FW: Apache::DBI Failed due to =
+GlobalRequest<o:p></o:p>

</div>

</div>

<o:p> </o:p>

That simple modification of the code I gave you =
should solve
your problem in 2 minutes. No need to downgrade. 
 
Kulasekaran, Raja wrote: <o:p></o:p>

Hi,<o:p></o:p>

 <o:p></o:p>

Great. I guess this might solve the problem. =
<o:p></o:p>

 <o:p></o:p>

I had found in one of the forum stating that we can =
write
a handler which generates the “$r” global object =
before
initiate the Apache::DBI connection . Is that possible ? =
..<o:p></o:p>

 <o:p></o:p>

Otherwise, Shall I install Apache::DBI 1.06 instead =
of
Apache::DBI 1.07 ? <o:p></o:p>

 <o:p></o:p>

Thanks,<o:p></o:p>

Raja <o:p></o:p>

 <o:p></o:p>

<div>

<div style=3D'border:none;border-top:solid windowtext =
1.0pt;padding:3.0pt 0in 0in 0in;
border-color:-moz-use-text-color -moz-use-text-color'>

From: Brad Van Sickle [<a
href=3D"mailto:bvs7085 [at] gmail.com">mailto:bvs7085 [at] gmail.com</a>] 
Sent: Saturday, September 12, 2009 7:54 PM 
To: mod_perl list 
Cc: Kulasekaran, Raja 
Subject: Re: FW: Apache::DBI Failed due to =
+GlobalRequest<o:p></o:p>

</div>

</div>

 <o:p></o:p>

I've run into this before. It's a bug in =
v1.07 of
Apache::DBI 
 
Open up the Apache/DBI.pm source file (on one of my test systems it's =
installed
in /usr/lib/perl5/site_perl/5.8.8/Apache/DBI.pm) aind the following =
block of
code: 
 if (!$Rollback{$Idx}) { 
 my $r; 
 if (MP2) { 
 &=
nbsp;
$r =3D Apache2::RequestUtil->request; 
 &=
nbsp;
} 
 elsif
(Apache->can('push_handlers')) { 
 $r =
=3D
'Apache'; 
 } 
 
The problem with this is that if you're calling this from startup.pl =
you're not
actually in a request at that point (as someone already mentioned) =
so
without the eval there the script dies. 
 
Fix it by wrapping the "$r =3D =
Apache2::RequestUtil->request;"
part in an eval so it looks like this: eval { $r =3D
Apache2::RequestUtil->request;} 
 
 
 
 
 
 
 
 
Andr=E9 Warnier wrote: <o:p></o:p>

Kulasekaran, Raja wrote: 
 
 
<o:p></o:p>

Hi, 
 
Thanks for your mail. I did tried. It's not working . <o:p></o:p>

Yes, I am sorry. I did not look close enough =
at the
following error : 
 
[Thu Sep 10 14:39:30 2009] [error] Global $r object is not available. =
 
Set:\n\tPerlOptions +GlobalRequest\nin httpd.conf at 
/var/www/audashboard/exec/startup.pl line 24.\nCompilation failed in =
 
require at (eval 5) line 1.\n 
 
In a mod_perl *request* handler, the first argument 
(my $r =3D shift;) 
is usually a pointer to the current Request object. 
 
But in your startup script (startup.pl), that is not the case, because =
when
that script is run, there is no request yet. 
I don't know what you are trying to do with $r in that startup script, =
but
something is wrong and maybe the error message above is misleading. 
(I mean that it may have nothing to do with GlobalRequest at that =
stage.) <o:p></o:p>

</div>

</body>

</html>

------_=_NextPart_001_01CA347B.D5215838--

FW: Apache::DBI Failed due to +GlobalRequest

RE: FW: Apache::DBI Failed due to +GlobalRequest

Re: FW: Apache::DBI Failed due to +GlobalRequest

Re: FW: Apache::DBI Failed due to +GlobalRequest

RE: FW: Apache::DBI Failed due to +GlobalRequest

Re: FW: Apache::DBI Failed due to +GlobalRequest

RE: FW: Apache::DBI Failed due to +GlobalRequest