You are viewing a plain text version of this content. The canonical link for it is here.
Posted to modperl@perl.apache.org by Paul Harrison <cu...@austin.rr.com> on 2005/11/08 16:44:35 UTC
Apache-DBI
p5-DBD-mysql50-3.0002
p5-DBI-1.48
p5-Apache-DBI-0.94_1
I upgraded the database server from the "4" version to "5", so I updated the
Perl database Drivers -> DBD,DBI, and Apache-DBI.
Once I updated the software, I get the following text in the Apache error
log -->
[Tue Nov 8 10:41:04 2005] DBI.pm: Use of uninitialized value in numeric eq
(==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 211.
[Tue Nov 8 10:41:04 2005] startup.perl: Use of uninitialized value in
numeric eq (==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line
35.
Why does this happen?
Cure
RE: Apache-DBI
Posted by Paul Harrison <cu...@austin.rr.com>.
Thx u so much
Cure
-----Original Message-----
From: Philip M. Gollucci [mailto:pgollucci@p6m7g8.com]
Sent: Tuesday, November 08, 2005 10:40 AM
To: Paul Harrison
Cc: 'Enno'; claco@chrislaco.com; modperl@perl.apache.org
Subject: Re: Apache-DBI
Paul Harrison wrote:
> p5-Apache-DBI-0.94_1 <-- I got it from the ports-tree FreeBSD
Ah, they hand patched it with my original patch after mp2 RC5 came out
to unbreak the port build.
I believe I filed an gnats upgrade for this
http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/83980
which is of course now out of date, but newer then what you've got.
Also,
http://www.freebsd.org/cgi/query-pr-summary.cgi?category=&severity=&priority
=&class=&state=&sort=none&text=&responsible=&multitext=&originator=Philip+M.
+Gollucci&release=
I would expect a whole slew of FreeBSD Pr's relating to p5-Apache-* and
mod_perl2.x from me before 2006 as soon as I have some time.
--
------------------------------------------------------------------------
"Love is not the one you can picture yourself marrying,
but the one you can't picture the rest of your life without."
"It takes a minute to have a crush on someone, an hour to like someone,
and a day to love someone, but it takes a lifetime to forget someone..."
Philip M. Gollucci (pgollucci@p6m7g8.com) 301.254.5198
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Software Engineer - TicketMaster - http://ticketmaster.com
Re: Apache-DBI
Posted by "Philip M. Gollucci" <pg...@p6m7g8.com>.
Paul Harrison wrote:
> p5-Apache-DBI-0.94_1 <-- I got it from the ports-tree FreeBSD
Ah, they hand patched it with my original patch after mp2 RC5 came out
to unbreak the port build.
I believe I filed an gnats upgrade for this
http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/83980
which is of course now out of date, but newer then what you've got.
Also,
http://www.freebsd.org/cgi/query-pr-summary.cgi?category=&severity=&priority=&class=&state=&sort=none&text=&responsible=&multitext=&originator=Philip+M.+Gollucci&release=
I would expect a whole slew of FreeBSD Pr's relating to p5-Apache-* and
mod_perl2.x from me before 2006 as soon as I have some time.
--
------------------------------------------------------------------------
"Love is not the one you can picture yourself marrying,
but the one you can't picture the rest of your life without."
"It takes a minute to have a crush on someone, an hour to like someone,
and a day to love someone, but it takes a lifetime to forget someone..."
Philip M. Gollucci (pgollucci@p6m7g8.com) 301.254.5198
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Software Engineer - TicketMaster - http://ticketmaster.com
RE: Apache-DBI
Posted by Paul Harrison <cu...@austin.rr.com>.
p5-Apache-DBI-0.94_1 <-- I got it from the ports-tree FreeBSD
Cure
-----Original Message-----
From: Philip M. Gollucci [mailto:pgollucci@p6m7g8.com]
Sent: Tuesday, November 08, 2005 10:33 AM
To: Paul Harrison
Cc: 'Enno'; claco@chrislaco.com; modperl@perl.apache.org
Subject: Re: Apache-DBI
Paul Harrison wrote:
> if (defined $ENV{MOD_PERL_API_VERSION} and $ENV{MOD_PERL_API_VERSION} ==
2)
> {
Exactly what version of Apache-DBI do you have (0.94_1) and where did
you get it ?
I would reccommend you use 0.9901 in my CPAN dir its the latest. I image
a 0.9902 soonish and then a 1.0 before 2006.
--
------------------------------------------------------------------------
"Love is not the one you can picture yourself marrying,
but the one you can't picture the rest of your life without."
"It takes a minute to have a crush on someone, an hour to like someone,
and a day to love someone, but it takes a lifetime to forget someone..."
Philip M. Gollucci (pgollucci@p6m7g8.com) 301.254.5198
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Software Engineer - TicketMaster - http://ticketmaster.com
Re: Apache-DBI
Posted by "Philip M. Gollucci" <pg...@p6m7g8.com>.
Paul Harrison wrote:
> if (defined $ENV{MOD_PERL_API_VERSION} and $ENV{MOD_PERL_API_VERSION} == 2)
> {
Exactly what version of Apache-DBI do you have (0.94_1) and where did
you get it ?
I would reccommend you use 0.9901 in my CPAN dir its the latest. I image
a 0.9902 soonish and then a 1.0 before 2006.
--
------------------------------------------------------------------------
"Love is not the one you can picture yourself marrying,
but the one you can't picture the rest of your life without."
"It takes a minute to have a crush on someone, an hour to like someone,
and a day to love someone, but it takes a lifetime to forget someone..."
Philip M. Gollucci (pgollucci@p6m7g8.com) 301.254.5198
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Software Engineer - TicketMaster - http://ticketmaster.com
RE: Apache-DBI
Posted by Paul Harrison <cu...@austin.rr.com>.
if (defined $ENV{MOD_PERL_API_VERSION} and $ENV{MOD_PERL_API_VERSION} == 2)
{
<-- that fixed the error.
Thxs
Cure
-----Original Message-----
From: Paul Harrison [mailto:cure@austin.rr.com]
Sent: Tuesday, November 08, 2005 10:22 AM
To: 'Enno'
Cc: claco@chrislaco.com; modperl@perl.apache.org
Subject: RE: Apache-DBI
I will try that thxs.
On my other box, I have mp2 and p5-Apache-DBI-0.94_1 works just fine.
But then again, I don't preload the connections on server startup.
Cure
-----Original Message-----
From: Enno [mailto:burglar@xs4all.nl]
Sent: Tuesday, November 08, 2005 10:17 AM
To: Paul Harrison
Cc: claco@chrislaco.com; modperl@perl.apache.org
Subject: RE: Apache-DBI
hmmm, dont have any experience with mp1, so I'm guess MOD_PERL_API_VERSION
isnt set in it.
To fix, change
if ($ENV{MOD_PERL_API_VERSION} == 2) {
into
if (defined $ENV{MOD_PERL_API_VERSION} and $ENV{MOD_PERL_API_VERSION} == 2)
{
hope this helps.
Enno
On Tue, 8 Nov 2005, Paul Harrison wrote:
> Here's the code form Apache::DBI
>
>
>
> Line 211 causing the warning: --> if ($ENV{MOD_PERL_API_VERSION} == 2) {
>
>
> sub connect_on_init {
> # provide a handler which creates all connections during server
startup
>
> if ($ENV{MOD_PERL_API_VERSION} == 2) {
> if (!@ChildConnect) {
> require Apache2::ServerUtil;
> my $s = Apache2::ServerUtil->server;
> $s->push_handlers(PerlChildInitHandler => \&childinit);
> }
> } else {
> carp "Apache.pm was not loaded\n" and return unless
> $INC{'Apache.pm'};
> if (!@ChildConnect and Apache->can('push_handlers')) {
> Apache->push_handlers(PerlChildInitHandler => \&childinit);
> }
> }
>
> # store connections
> push @ChildConnect, [@_];
> }
>
>
>
> If the problem is harmless, than no biggie.
>
>
> Cure
>
> -----Original Message-----
> From: Christopher H. Laco [mailto:claco@chrislaco.com]
> Sent: Tuesday, November 08, 2005 9:51 AM
> To: Paul Harrison
> Cc: modperl@perl.apache.org
> Subject: Re: Apache-DBI
>
> Paul Harrison wrote:
> > p5-DBD-mysql50-3.0002
> >
> > p5-DBI-1.48
> >
> > p5-Apache-DBI-0.94_1
> >
> >
> >
> > I upgraded the database server from the "4" version to "5", so I updated
> the
> > Perl database Drivers -> DBD,DBI, and Apache-DBI.
> >
> >
> >
> > Once I updated the software, I get the following text in the Apache
error
> > log -->
> >
> >
> >
> > [Tue Nov 8 10:41:04 2005] DBI.pm: Use of uninitialized value in numeric
> eq
> > (==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 211.
> >
> > [Tue Nov 8 10:41:04 2005] startup.perl: Use of uninitialized value in
> > numeric eq (==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm
line
> > 35.
> >
> >
> >
> >
> >
> >
> >
> > Why does this happen?
>
>
> I imagine somewhere in the code, there's something resembling
>
> eval 'use Apache::BI 0.90';
>
> The error is because 0.094_01 can't be used in a numeric comparison like
> that. The message itself is harmless I believe and things should still
work.
>
> I had the same problem last night in my test suite when doing:
>
> eval 'use Catalyst 5.00';
>
> when I had a dev version of Catalyst 5.5_03 installed.
>
> -=Chris
>
>
>
RE: Apache-DBI
Posted by Paul Harrison <cu...@austin.rr.com>.
I will try that thxs.
On my other box, I have mp2 and p5-Apache-DBI-0.94_1 works just fine.
But then again, I don't preload the connections on server startup.
Cure
-----Original Message-----
From: Enno [mailto:burglar@xs4all.nl]
Sent: Tuesday, November 08, 2005 10:17 AM
To: Paul Harrison
Cc: claco@chrislaco.com; modperl@perl.apache.org
Subject: RE: Apache-DBI
hmmm, dont have any experience with mp1, so I'm guess MOD_PERL_API_VERSION
isnt set in it.
To fix, change
if ($ENV{MOD_PERL_API_VERSION} == 2) {
into
if (defined $ENV{MOD_PERL_API_VERSION} and $ENV{MOD_PERL_API_VERSION} == 2)
{
hope this helps.
Enno
On Tue, 8 Nov 2005, Paul Harrison wrote:
> Here's the code form Apache::DBI
>
>
>
> Line 211 causing the warning: --> if ($ENV{MOD_PERL_API_VERSION} == 2) {
>
>
> sub connect_on_init {
> # provide a handler which creates all connections during server
startup
>
> if ($ENV{MOD_PERL_API_VERSION} == 2) {
> if (!@ChildConnect) {
> require Apache2::ServerUtil;
> my $s = Apache2::ServerUtil->server;
> $s->push_handlers(PerlChildInitHandler => \&childinit);
> }
> } else {
> carp "Apache.pm was not loaded\n" and return unless
> $INC{'Apache.pm'};
> if (!@ChildConnect and Apache->can('push_handlers')) {
> Apache->push_handlers(PerlChildInitHandler => \&childinit);
> }
> }
>
> # store connections
> push @ChildConnect, [@_];
> }
>
>
>
> If the problem is harmless, than no biggie.
>
>
> Cure
>
> -----Original Message-----
> From: Christopher H. Laco [mailto:claco@chrislaco.com]
> Sent: Tuesday, November 08, 2005 9:51 AM
> To: Paul Harrison
> Cc: modperl@perl.apache.org
> Subject: Re: Apache-DBI
>
> Paul Harrison wrote:
> > p5-DBD-mysql50-3.0002
> >
> > p5-DBI-1.48
> >
> > p5-Apache-DBI-0.94_1
> >
> >
> >
> > I upgraded the database server from the "4" version to "5", so I updated
> the
> > Perl database Drivers -> DBD,DBI, and Apache-DBI.
> >
> >
> >
> > Once I updated the software, I get the following text in the Apache
error
> > log -->
> >
> >
> >
> > [Tue Nov 8 10:41:04 2005] DBI.pm: Use of uninitialized value in numeric
> eq
> > (==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 211.
> >
> > [Tue Nov 8 10:41:04 2005] startup.perl: Use of uninitialized value in
> > numeric eq (==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm
line
> > 35.
> >
> >
> >
> >
> >
> >
> >
> > Why does this happen?
>
>
> I imagine somewhere in the code, there's something resembling
>
> eval 'use Apache::BI 0.90';
>
> The error is because 0.094_01 can't be used in a numeric comparison like
> that. The message itself is harmless I believe and things should still
work.
>
> I had the same problem last night in my test suite when doing:
>
> eval 'use Catalyst 5.00';
>
> when I had a dev version of Catalyst 5.5_03 installed.
>
> -=Chris
>
>
>
RE: Apache-DBI
Posted by Enno <bu...@xs4all.nl>.
hmmm, dont have any experience with mp1, so I'm guess MOD_PERL_API_VERSION
isnt set in it.
To fix, change
if ($ENV{MOD_PERL_API_VERSION} == 2) {
into
if (defined $ENV{MOD_PERL_API_VERSION} and $ENV{MOD_PERL_API_VERSION} == 2) {
hope this helps.
Enno
On Tue, 8 Nov 2005, Paul Harrison wrote:
> Here's the code form Apache::DBI
>
>
>
> Line 211 causing the warning: --> if ($ENV{MOD_PERL_API_VERSION} == 2) {
>
>
> sub connect_on_init {
> # provide a handler which creates all connections during server startup
>
> if ($ENV{MOD_PERL_API_VERSION} == 2) {
> if (!@ChildConnect) {
> require Apache2::ServerUtil;
> my $s = Apache2::ServerUtil->server;
> $s->push_handlers(PerlChildInitHandler => \&childinit);
> }
> } else {
> carp "Apache.pm was not loaded\n" and return unless
> $INC{'Apache.pm'};
> if (!@ChildConnect and Apache->can('push_handlers')) {
> Apache->push_handlers(PerlChildInitHandler => \&childinit);
> }
> }
>
> # store connections
> push @ChildConnect, [@_];
> }
>
>
>
> If the problem is harmless, than no biggie.
>
>
> Cure
>
> -----Original Message-----
> From: Christopher H. Laco [mailto:claco@chrislaco.com]
> Sent: Tuesday, November 08, 2005 9:51 AM
> To: Paul Harrison
> Cc: modperl@perl.apache.org
> Subject: Re: Apache-DBI
>
> Paul Harrison wrote:
> > p5-DBD-mysql50-3.0002
> >
> > p5-DBI-1.48
> >
> > p5-Apache-DBI-0.94_1
> >
> >
> >
> > I upgraded the database server from the "4" version to "5", so I updated
> the
> > Perl database Drivers -> DBD,DBI, and Apache-DBI.
> >
> >
> >
> > Once I updated the software, I get the following text in the Apache error
> > log -->
> >
> >
> >
> > [Tue Nov 8 10:41:04 2005] DBI.pm: Use of uninitialized value in numeric
> eq
> > (==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 211.
> >
> > [Tue Nov 8 10:41:04 2005] startup.perl: Use of uninitialized value in
> > numeric eq (==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line
> > 35.
> >
> >
> >
> >
> >
> >
> >
> > Why does this happen?
>
>
> I imagine somewhere in the code, there's something resembling
>
> eval 'use Apache::BI 0.90';
>
> The error is because 0.094_01 can't be used in a numeric comparison like
> that. The message itself is harmless I believe and things should still work.
>
> I had the same problem last night in my test suite when doing:
>
> eval 'use Catalyst 5.00';
>
> when I had a dev version of Catalyst 5.5_03 installed.
>
> -=Chris
>
>
>
RE: Apache-DBI
Posted by Paul Harrison <cu...@austin.rr.com>.
Here's the code form Apache::DBI
Line 211 causing the warning: --> if ($ENV{MOD_PERL_API_VERSION} == 2) {
sub connect_on_init {
# provide a handler which creates all connections during server startup
if ($ENV{MOD_PERL_API_VERSION} == 2) {
if (!@ChildConnect) {
require Apache2::ServerUtil;
my $s = Apache2::ServerUtil->server;
$s->push_handlers(PerlChildInitHandler => \&childinit);
}
} else {
carp "Apache.pm was not loaded\n" and return unless
$INC{'Apache.pm'};
if (!@ChildConnect and Apache->can('push_handlers')) {
Apache->push_handlers(PerlChildInitHandler => \&childinit);
}
}
# store connections
push @ChildConnect, [@_];
}
If the problem is harmless, than no biggie.
Cure
-----Original Message-----
From: Christopher H. Laco [mailto:claco@chrislaco.com]
Sent: Tuesday, November 08, 2005 9:51 AM
To: Paul Harrison
Cc: modperl@perl.apache.org
Subject: Re: Apache-DBI
Paul Harrison wrote:
> p5-DBD-mysql50-3.0002
>
> p5-DBI-1.48
>
> p5-Apache-DBI-0.94_1
>
>
>
> I upgraded the database server from the "4" version to "5", so I updated
the
> Perl database Drivers -> DBD,DBI, and Apache-DBI.
>
>
>
> Once I updated the software, I get the following text in the Apache error
> log -->
>
>
>
> [Tue Nov 8 10:41:04 2005] DBI.pm: Use of uninitialized value in numeric
eq
> (==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 211.
>
> [Tue Nov 8 10:41:04 2005] startup.perl: Use of uninitialized value in
> numeric eq (==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line
> 35.
>
>
>
>
>
>
>
> Why does this happen?
I imagine somewhere in the code, there's something resembling
eval 'use Apache::BI 0.90';
The error is because 0.094_01 can't be used in a numeric comparison like
that. The message itself is harmless I believe and things should still work.
I had the same problem last night in my test suite when doing:
eval 'use Catalyst 5.00';
when I had a dev version of Catalyst 5.5_03 installed.
-=Chris
Re: Apache-DBI
Posted by "Christopher H. Laco" <cl...@chrislaco.com>.
Paul Harrison wrote:
> p5-DBD-mysql50-3.0002
>
> p5-DBI-1.48
>
> p5-Apache-DBI-0.94_1
>
>
>
> I upgraded the database server from the "4" version to "5", so I updated the
> Perl database Drivers -> DBD,DBI, and Apache-DBI.
>
>
>
> Once I updated the software, I get the following text in the Apache error
> log -->
>
>
>
> [Tue Nov 8 10:41:04 2005] DBI.pm: Use of uninitialized value in numeric eq
> (==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 211.
>
> [Tue Nov 8 10:41:04 2005] startup.perl: Use of uninitialized value in
> numeric eq (==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line
> 35.
>
>
>
>
>
>
>
> Why does this happen?
I imagine somewhere in the code, there's something resembling
eval 'use Apache::BI 0.90';
The error is because 0.094_01 can't be used in a numeric comparison like
that. The message itself is harmless I believe and things should still work.
I had the same problem last night in my test suite when doing:
eval 'use Catalyst 5.00';
when I had a dev version of Catalyst 5.5_03 installed.
-=Chris
RE: Apache-DBI
Posted by Paul Harrison <cu...@austin.rr.com>.
I'm currently running mp1, so I'm lost here.
Cure
-----Original Message-----
From: Enno [mailto:burglar@xs4all.nl]
Sent: Tuesday, November 08, 2005 9:51 AM
To: Paul Harrison
Cc: modperl@perl.apache.org
Subject: Re: Apache-DBI
you need Apache::DBI 0.96 or higher for mp2 compatibility.
from the pod:
Apache::DBI version 0.96 and should work under mod_perl 2.0 RC5 and later.
See the Changes file for more information. Beware that it has only been
tested very lightly.
Enno
On Tue, 8 Nov 2005, Paul Harrison wrote:
> p5-DBD-mysql50-3.0002
>
> p5-DBI-1.48
>
> p5-Apache-DBI-0.94_1
>
>
>
> I upgraded the database server from the "4" version to "5", so I updated
the
> Perl database Drivers -> DBD,DBI, and Apache-DBI.
>
>
>
> Once I updated the software, I get the following text in the Apache error
> log -->
>
>
>
> [Tue Nov 8 10:41:04 2005] DBI.pm: Use of uninitialized value in numeric
eq
> (==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 211.
>
> [Tue Nov 8 10:41:04 2005] startup.perl: Use of uninitialized value in
> numeric eq (==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line
> 35.
>
>
>
>
>
>
>
> Why does this happen?
>
>
>
>
>
>
>
> Cure
>
>
Re: Apache-DBI
Posted by Enno <bu...@xs4all.nl>.
you need Apache::DBI 0.96 or higher for mp2 compatibility.
from the pod:
Apache::DBI version 0.96 and should work under mod_perl 2.0 RC5 and later.
See the Changes file for more information. Beware that it has only been
tested very lightly.
Enno
On Tue, 8 Nov 2005, Paul Harrison wrote:
> p5-DBD-mysql50-3.0002
>
> p5-DBI-1.48
>
> p5-Apache-DBI-0.94_1
>
>
>
> I upgraded the database server from the "4" version to "5", so I updated the
> Perl database Drivers -> DBD,DBI, and Apache-DBI.
>
>
>
> Once I updated the software, I get the following text in the Apache error
> log -->
>
>
>
> [Tue Nov 8 10:41:04 2005] DBI.pm: Use of uninitialized value in numeric eq
> (==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 211.
>
> [Tue Nov 8 10:41:04 2005] startup.perl: Use of uninitialized value in
> numeric eq (==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line
> 35.
>
>
>
>
>
>
>
> Why does this happen?
>
>
>
>
>
>
>
> Cure
>
>