Perl DBI Urgent
am 27.03.2007 14:11:01 von Sanjay.Tripathi
------_=_NextPart_001_01C77068.FC4A3AE7
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi,
I getting problem with Perl/Cgi/DBI. Can you guys help me out.
=20
Please see the log below.
=20
Aapche Logs:
=20
Can't locate DBI.pm in @INC (@INC contains: /app/custom/steve/perl
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .
/app/custom/steve/perl /app/custom/perl /heb/appl/ewa/perl/bin/perl) at
/app/w3/steve/cgi/ewa_new_user.cgi line 3.
BEGIN failed--compilation aborted at /app/w3/steve/cgi/ewa_new_user.cgi
line 3.
[Tue Mar 27 06:47:06 2007] [error] [client x.x.x.x] Premature end of
script headers: /app/w3/steve/cgi/ewa_new_user.cgi
=20
=20
Then I tried=20
root@sys # perl -e 'use DBI; print $DBI::VERSION,"\n";'
=20
Can't locate loadable object for module DBI in @INC (@INC contains:
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at DBI.pm line
254
BEGIN failed--compilation aborted at DBI.pm line 254.
Compilation failed in require at -e line 1.
BEGIN failed--compilation aborted at -e line 1.
=20
=20
=20
Thanks
ST
------_=_NextPart_001_01C77068.FC4A3AE7--
RE: Perl DBI Urgent
am 27.03.2007 16:34:23 von Philip.Garrett
Sanjay Tripathi wrote:
> I am using SunOS and Oracle as a DB.
>=20
> To Install DBI I'm using below command
>=20
> perl -MCPAN -e 'install Bundle::DBI'
>=20
[snip]
>=20
> CPAN.pm: Going to build T/TI/TIMB/DBI-1.54.tar.gz
>=20
>
************************************************************ ************
> Perl versions below 5.6.1 are no longer supported by the DBI.
> Perl versions 5.6.x may fail during installation with a complaint
> about the use of =3Dhead3 in the pod documentation.
>
************************************************************ ************
> Press return to continue...
Did you press return? What happened? Did the tests pass?
If the installation did indeed fail because of the "=3Dhead3" problem, =
you
can install like this:
perl -MCPAN -e 'force install DBI'
And then restart with Bundle::DBI like you tried before.
- Philip
RE: Perl DBI Urgent
am 27.03.2007 19:02:27 von Philip.Garrett
Kimberly Mount wrote:
> Can someone please help me out? I've asked a couple of times and
> haven't had any success. Can you please remove me from this list? I
> don't know what else to do?
Unsubscribe: Send an empty email to dbi-users-unsubscribe@perl.org
Cc: list, maybe somebody else will find this useful.
- Philip
RE: Perl DBI Urgent
am 28.03.2007 15:12:52 von Sanjay.Tripathi
How do I will check that Perl is having DBI and DBD(Oracle) Module or
not!
~~Sanjay~~~
-----Original Message-----
From: Satya Shiv Mohanty [mailto:Satya_Mohanty@infosys.com]=20
Sent: Tuesday, March 27, 2007 8:00 PM
To: Sanjay Tripathi
Subject: RE: Perl DBI Urgent
Probably u did not add the exact location of the DBI.pm in ur script.
Assuming that ur DBI.pm is at /usr/perl5/lib/sun4-solaris/DBI.pm, then u
need to include it using following:-
use lib "/usr/perl5/lib/sun4-solaris";
in ur script.
Also for " Premature end of
script headers" I think u r not mentioning the output type of the
document u r trying to display. Like u use print "Content-type:
text/html\n\n"; for html output.
Hope this helps u.
Regards
Satya Shiv
-----Original Message-----
From: Sanjay Tripathi [mailto:Sanjay.Tripathi@ustri.com]
Sent: Tuesday, March 27, 2007 5:41 PM
To: dbi-users@perl.org
Subject: Perl DBI Urgent
Hi,
I getting problem with Perl/Cgi/DBI. Can you guys help me out.
Please see the log below.
Aapche Logs:
Can't locate DBI.pm in @INC (@INC contains: /app/custom/steve/perl
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .
/app/custom/steve/perl /app/custom/perl /heb/appl/ewa/perl/bin/perl) at
/app/w3/steve/cgi/ewa_new_user.cgi line 3.
BEGIN failed--compilation aborted at /app/w3/steve/cgi/ewa_new_user.cgi
line 3.
[Tue Mar 27 06:47:06 2007] [error] [client x.x.x.x] Premature end of
script headers: /app/w3/steve/cgi/ewa_new_user.cgi
Then I tried
root@sys # perl -e 'use DBI; print $DBI::VERSION,"\n";'
Can't locate loadable object for module DBI in @INC (@INC contains:
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at DBI.pm line
254
BEGIN failed--compilation aborted at DBI.pm line 254.
Compilation failed in require at -e line 1.
BEGIN failed--compilation aborted at -e line 1.
Thanks
ST
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this
e-mail or its contents to any other person and any such actions are
unlawful. This e-mail may contain viruses. Infosys has taken every
reasonable precaution to minimize this risk, but is not liable for any
damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
RE: Perl DBI Urgent
am 28.03.2007 15:14:26 von Sanjay.Tripathi
-----Original Message-----
From: Garrett, Philip (MAN-Corporate)
[mailto:Philip.Garrett@manheim.com]=20
Sent: Tuesday, March 27, 2007 8:04 PM
To: Sanjay Tripathi; dbi-users@perl.org
Subject: RE: Perl DBI Urgent
Sanjay Tripathi wrote:
> I am using SunOS and Oracle as a DB.
>=20
> To Install DBI I'm using below command
>=20
> perl -MCPAN -e 'install Bundle::DBI'
>=20
[snip]
>=20
> CPAN.pm: Going to build T/TI/TIMB/DBI-1.54.tar.gz
>=20
>
************************************************************ ************
> Perl versions below 5.6.1 are no longer supported by the DBI.
> Perl versions 5.6.x may fail during installation with a complaint
> about the use of =3Dhead3 in the pod documentation.
>
************************************************************ ************
> Press return to continue...
>Did you press return? What happened? Did the tests pass?
I>f the installation did indeed fail because of the "=3Dhead3" problem,
you
>can install like this:
> perl -MCPAN -e 'force install DBI'
>And then restart with Bundle::DBI like you tried before.
I did that But still facing same problem? I m not getting what to do?
~~Sanjay~~
RE: Perl DBI Urgent
am 28.03.2007 15:23:59 von Philip.Garrett
Sanjay Tripathi wrote:
>>> I am using SunOS and Oracle as a DB.
>>> To Install DBI I'm using below command
>>> perl -MCPAN -e 'install Bundle::DBI'
>>>=20
>>[snip]
>>> CPAN.pm: Going to build T/TI/TIMB/DBI-1.54.tar.gz
>>> ************************************************************ *******
>>> Perl versions below 5.6.1 are no longer supported by the DBI.
>>> Perl versions 5.6.x may fail during installation with a complaint
>>> about the use of =3Dhead3 in the pod documentation.
>>> ************************************************************ *******
>>> Press return to continue...
>>
>> Did you press return? What happened? Did the tests pass?
>>
>> If the installation did indeed fail because of the "=3Dhead3" =
problem,
>> you can install like this:
>> perl -MCPAN -e 'force install DBI'
>>
>> And then restart with Bundle::DBI like you tried before.
>
> I did that But still facing same problem? I m not getting what to do?
Again, did you press return? What happened? Did the tests pass?
It would probably be helpful for you to post the actual output of the
installation attempt.
- Philip
RE: Perl DBI Urgent
am 28.03.2007 15:55:51 von matthew.ramadanovic
Why not just do something like this:
#!/usr/bin/perl=20
eval {
use DBI;=20
};
if ($@) {
print "Couldn't use DBI : $@\n";
} else {
print "Loaded DBI successfully\n";
}
eval {
use DBD::Oracle;
};
if ($@) {
print "Couldn't use DBD::ORACLE : $@\n";
} else {
print "Loaded DBD::Oracle successfully\n";
}
print "Done\n";
-Matt
-----Original Message-----
From: Sanjay Tripathi [mailto:Sanjay.Tripathi@ustri.com]=20
Sent: Wednesday, March 28, 2007 9:13 AM
To: Satya Shiv Mohanty
Cc: dbi-users@perl.org
Subject: RE: Perl DBI Urgent
How do I will check that Perl is having DBI and DBD(Oracle) Module or
not!
~~Sanjay~~~
-----Original Message-----
From: Satya Shiv Mohanty [mailto:Satya_Mohanty@infosys.com]=20
Sent: Tuesday, March 27, 2007 8:00 PM
To: Sanjay Tripathi
Subject: RE: Perl DBI Urgent
Probably u did not add the exact location of the DBI.pm in ur script.
Assuming that ur DBI.pm is at /usr/perl5/lib/sun4-solaris/DBI.pm, then u
need to include it using following:-
use lib "/usr/perl5/lib/sun4-solaris";
in ur script.
Also for " Premature end of
script headers" I think u r not mentioning the output type of the
document u r trying to display. Like u use print "Content-type:
text/html\n\n"; for html output.
Hope this helps u.
Regards
Satya Shiv
-----Original Message-----
From: Sanjay Tripathi [mailto:Sanjay.Tripathi@ustri.com]
Sent: Tuesday, March 27, 2007 5:41 PM
To: dbi-users@perl.org
Subject: Perl DBI Urgent
Hi,
I getting problem with Perl/Cgi/DBI. Can you guys help me out.
Please see the log below.
Aapche Logs:
Can't locate DBI.pm in @INC (@INC contains: /app/custom/steve/perl
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .
/app/custom/steve/perl /app/custom/perl /heb/appl/ewa/perl/bin/perl) at
/app/w3/steve/cgi/ewa_new_user.cgi line 3.
BEGIN failed--compilation aborted at /app/w3/steve/cgi/ewa_new_user.cgi
line 3.
[Tue Mar 27 06:47:06 2007] [error] [client x.x.x.x] Premature end of
script headers: /app/w3/steve/cgi/ewa_new_user.cgi
Then I tried
root@sys # perl -e 'use DBI; print $DBI::VERSION,"\n";'
Can't locate loadable object for module DBI in @INC (@INC contains:
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at DBI.pm line
254
BEGIN failed--compilation aborted at DBI.pm line 254.
Compilation failed in require at -e line 1.
BEGIN failed--compilation aborted at -e line 1.
Thanks
ST
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this
e-mail or its contents to any other person and any such actions are
unlawful. This e-mail may contain viruses. Infosys has taken every
reasonable precaution to minimize this risk, but is not liable for any
damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
Missing libs in /export/home/oracle/product/9.2.0/rdbms/lib* prevented dbi from functioning
am 28.03.2007 16:11:32 von matthew.ramadanovic
Folks,
Some of these posts remind me that a few weeks ago I came across
a Solaris 8 server that had functioning sqlplus access to a separate
oracle server and perl 5.8.7.=20
The vendor was trying to load a compiled version of DBI from their
installation media. Their install would claim success but neither DBI
nor DBD::Oracle would work (it would just fail upon the use statement).
=20
Rather than wait for the vendor to "escalate" things (which would be sad
seeing as how I see 5000 DBI related emails a day) I compared the Oracle
installs (one was a server one was a client install). As it turns out,
even though sqlplus worked from this machine, the "broken" machine was
missing a few files in the following directories :
(these directories weren't empty but they were exactly the same)
/export/home/oracle/product/9.2.0/rdbms/lib and
/export/home/oracle/product/9.2.0/rdbms/lib32
In this case I just copied what was missing them from the Oracle server
(luckily same OS and same platform) and immediately everything worked
fine. Removing the files again "broke" DBI in the same way again so the
fix/cause was clear.
Just thought I'd post since I think people something think that if you
have sqlplus access working then everything must be fine and it clearly
wasn't in this case.
-Matt
RE: Perl DBI Urgent
am 28.03.2007 16:13:13 von Philip.Garrett
Sanjay Tripathi wrote:
> Please find the Logs for both of Perl Command as an attachment as per
> your request.
Welcome to Dependency Hell. Here is your problem:
> Writing Makefile for List::Util
> -- NOT OK
> Running make test
> Can't test without successful make
> Running make install
> make had returned bad status, install seems impossible
>
> Running make for K/KW/KWILLIAMS/PathTools-3.24.tar.gz
> Is already unwrapped into directory /.cpan/build/PathTools-3.24
> CPAN.pm: Going to build K/KW/KWILLIAMS/PathTools-3.24.tar.gz
> -- NOT OK
> Running make test
> Can't test without successful make
DBI requires File::Spec. File::Spec requires Scalar::Util.
Scalar::Util (packaged alongside List::Util) is failing to install. If
you can get Scalar::Util to install, you'll probably have no problem
with DBI. Here is one way to try it:
# perl -MCPAN -e shell
cpan> look Scalar::Util
(this spawns a shell)
# perl Makefile.PL && make test && make install &&
echo "INSTALL SUCCEEDED" ||
echo "INSTALL FAILED!"
# exit
cpan>
If the installation succeeded, you can try to install DBI again.
Otherwise,
post the output and I'll try to help more.
- Philip
RE: Perl DBI Urgent
am 28.03.2007 16:16:31 von Sanjay.Tripathi
Matt,
As your suggestion, I did like that
root@sys # vi sanjay_test.pl
"sanjay_test.pl" [New file]
#!/usr/bin/perl
eval {
use DBI;
};
if ($@) {
print "Couldn't use DBI : $@\n";
} else {
print "Loaded DBI successfully\n";
}
eval {
use DBD::Oracle;
};
if ($@) {
print "Couldn't use DBD::ORACLE : $@\n"; } else { print "Loaded
DBD::Oracle successfully\n"; } print "Done\n";
root@sys # perl sanjay_test.pl
Can't locate DBI.pm in @INC (@INC contains:
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at sanjay_test.pl
line 3.
BEGIN failed--compilation aborted at sanjay_test.pl line 3.
root@sys #
Still I'm facing same problem any Idea :)
Thanks
Sanjay Tripathi
-----Original Message-----
From: Matthew Ramadanovic [mailto:matthew.ramadanovic@yale.edu]=20
Sent: Wednesday, March 28, 2007 7:26 PM
To: Sanjay Tripathi; Satya Shiv Mohanty
Cc: dbi-users@perl.org
Subject: RE: Perl DBI Urgent
Why not just do something like this:
#!/usr/bin/perl=20
eval {
use DBI;=20
};
if ($@) {
print "Couldn't use DBI : $@\n";
} else {
print "Loaded DBI successfully\n";
}
eval {
use DBD::Oracle;
};
if ($@) {
print "Couldn't use DBD::ORACLE : $@\n";
} else {
print "Loaded DBD::Oracle successfully\n";
}
print "Done\n";
-Matt
-----Original Message-----
From: Sanjay Tripathi [mailto:Sanjay.Tripathi@ustri.com]=20
Sent: Wednesday, March 28, 2007 9:13 AM
To: Satya Shiv Mohanty
Cc: dbi-users@perl.org
Subject: RE: Perl DBI Urgent
How do I will check that Perl is having DBI and DBD(Oracle) Module or
not!
~~Sanjay~~~
-----Original Message-----
From: Satya Shiv Mohanty [mailto:Satya_Mohanty@infosys.com]=20
Sent: Tuesday, March 27, 2007 8:00 PM
To: Sanjay Tripathi
Subject: RE: Perl DBI Urgent
Probably u did not add the exact location of the DBI.pm in ur script.
Assuming that ur DBI.pm is at /usr/perl5/lib/sun4-solaris/DBI.pm, then u
need to include it using following:-
use lib "/usr/perl5/lib/sun4-solaris";
in ur script.
Also for " Premature end of
script headers" I think u r not mentioning the output type of the
document u r trying to display. Like u use print "Content-type:
text/html\n\n"; for html output.
Hope this helps u.
Regards
Satya Shiv
-----Original Message-----
From: Sanjay Tripathi [mailto:Sanjay.Tripathi@ustri.com]
Sent: Tuesday, March 27, 2007 5:41 PM
To: dbi-users@perl.org
Subject: Perl DBI Urgent
Hi,
I getting problem with Perl/Cgi/DBI. Can you guys help me out.
Please see the log below.
Aapche Logs:
Can't locate DBI.pm in @INC (@INC contains: /app/custom/steve/perl
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .
/app/custom/steve/perl /app/custom/perl /heb/appl/ewa/perl/bin/perl) at
/app/w3/steve/cgi/ewa_new_user.cgi line 3.
BEGIN failed--compilation aborted at /app/w3/steve/cgi/ewa_new_user.cgi
line 3.
[Tue Mar 27 06:47:06 2007] [error] [client x.x.x.x] Premature end of
script headers: /app/w3/steve/cgi/ewa_new_user.cgi
Then I tried
root@sys # perl -e 'use DBI; print $DBI::VERSION,"\n";'
Can't locate loadable object for module DBI in @INC (@INC contains:
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at DBI.pm line
254
BEGIN failed--compilation aborted at DBI.pm line 254.
Compilation failed in require at -e line 1.
BEGIN failed--compilation aborted at -e line 1.
Thanks
ST
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this
e-mail or its contents to any other person and any such actions are
unlawful. This e-mail may contain viruses. Infosys has taken every
reasonable precaution to minimize this risk, but is not liable for any
damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
RE: Perl DBI Urgent
am 28.03.2007 16:24:15 von Sanjay.Tripathi
>DBI requires File::Spec. File::Spec requires Scalar::Util.
>Scalar::Util (packaged alongside List::Util) is failing to install. If
>you can get Scalar::Util to install, you'll probably have no problem
>with DBI. Here is one way to try it:
># perl -MCPAN -e shell
>cpan> look Scalar::Util
> (this spawns a shell)
># perl Makefile.PL && make test && make install &&
> echo "INSTALL SUCCEEDED" ||
>echo "INSTALL FAILED!"
># exit
>cpan>
>If the installation succeeded, you can try to install DBI again.
>Otherwise,
>post the output and I'll try to help more.
- Philip
-----------------------------
Philip,
Once again no luck :(
See the output below
root@sys # perl -MCPAN -e shell
cpan shell -- CPAN exploration and modules installation (v1.59_54)
ReadLine support available (try 'install Bundle::CPAN')
cpan> look Scalar::Util
Going to read /.cpan/sources/authors/01mailrc.txt.gz
Going to read /.cpan/sources/modules/02packages.details.txt.gz
Database was generated on Wed, 28 Mar 2007 06:10:34 GMT
HTTP::Date not available
There's a new CPAN.pm version (v1.8802) available!
[Current version is v1.59_54]
You might want to try
install Bundle::CPAN
reload cpan
without quitting the current session. It should be a seamless upgrade
while we are running...
Scanning cache /.cpan/build for sizes
x Scalar-List-Utils-1.19, 0 bytes, 0 tape blocks
x Scalar-List-Utils-1.19/t, 0 bytes, 0 tape blocks
x Scalar-List-Utils-1.19/t/refaddr.t, 1793 bytes, 4 tape blocks
x Scalar-List-Utils-1.19/t/p_tainted.t, 228 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/t/p_maxstr.t, 156 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/t/p_blessed.t, 156 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/t/tainted.t, 672 bytes, 2 tape blocks
x Scalar-List-Utils-1.19/t/maxstr.t, 717 bytes, 2 tape blocks
x Scalar-List-Utils-1.19/t/p_minstr.t, 156 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/t/p_readonly.t, 156 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/t/p_min.t, 156 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/t/p_refaddr.t, 156 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/t/reftype.t, 1180 bytes, 3 tape blocks
x Scalar-List-Utils-1.19/t/blessed.t, 748 bytes, 2 tape blocks
x Scalar-List-Utils-1.19/t/lln.t, 1105 bytes, 3 tape blocks
x Scalar-List-Utils-1.19/t/proto.t, 1476 bytes, 3 tape blocks
x Scalar-List-Utils-1.19/t/p_first.t, 217 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/t/minstr.t, 716 bytes, 2 tape blocks
x Scalar-List-Utils-1.19/t/first.t, 3187 bytes, 7 tape blocks
x Scalar-List-Utils-1.19/t/p_shuffle.t, 156 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/t/min.t, 628 bytes, 2 tape blocks
x Scalar-List-Utils-1.19/t/reduce.t, 3647 bytes, 8 tape blocks
x Scalar-List-Utils-1.19/t/p_lln.t, 156 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/t/max.t, 629 bytes, 2 tape blocks
x Scalar-List-Utils-1.19/t/p_openhan.t, 156 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/t/p_max.t, 156 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/t/openhan.t, 574 bytes, 2 tape blocks
x Scalar-List-Utils-1.19/t/readonly.t, 1041 bytes, 3 tape blocks
x Scalar-List-Utils-1.19/t/isvstring.t, 648 bytes, 2 tape blocks
x Scalar-List-Utils-1.19/t/p_sum.t, 156 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/t/p_reduce.t, 217 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/t/sum.t, 596 bytes, 2 tape blocks
x Scalar-List-Utils-1.19/t/shuffle.t, 626 bytes, 2 tape blocks
x Scalar-List-Utils-1.19/t/dualvar.t, 1152 bytes, 3 tape blocks
x Scalar-List-Utils-1.19/t/00version.t, 416 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/t/weak.t, 3001 bytes, 6 tape blocks
x Scalar-List-Utils-1.19/t/p_reftype.t, 156 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/inc, 0 bytes, 0 tape blocks
x Scalar-List-Utils-1.19/inc/Test, 0 bytes, 0 tape blocks
x Scalar-List-Utils-1.19/inc/Test/Builder.pm, 25016 bytes, 49 tape
blocks
x Scalar-List-Utils-1.19/inc/Test/Builder, 0 bytes, 0 tape blocks
x Scalar-List-Utils-1.19/inc/Test/Builder/Module.pm, 1239 bytes, 3 tape
blocks
x Scalar-List-Utils-1.19/inc/Test/More.pm, 14095 bytes, 28 tape blocks
x Scalar-List-Utils-1.19/inc/Module, 0 bytes, 0 tape blocks
x Scalar-List-Utils-1.19/inc/Module/Install.pm, 8073 bytes, 16 tape
blocks
x Scalar-List-Utils-1.19/inc/Module/Install, 0 bytes, 0 tape blocks
x Scalar-List-Utils-1.19/inc/Module/Install/InstallDirs.pm, 656 bytes, 2
tape blocks
x Scalar-List-Utils-1.19/inc/Module/Install/Include.pm, 524 bytes, 2
tape blocks
x Scalar-List-Utils-1.19/inc/Module/Install/Makefile.pm, 5883 bytes, 12
tape blocks
x Scalar-List-Utils-1.19/inc/Module/Install/Metadata.pm, 7998 bytes, 16
tape blocks
x Scalar-List-Utils-1.19/inc/Module/Install/Win32.pm, 1806 bytes, 4 tape
blocks
x Scalar-List-Utils-1.19/inc/Module/Install/Fetch.pm, 2456 bytes, 5 tape
blocks
x Scalar-List-Utils-1.19/inc/Module/Install/Base.pm, 1053 bytes, 3 tape
blocks
x Scalar-List-Utils-1.19/inc/Module/Install/Can.pm, 1788 bytes, 4 tape
blocks
x Scalar-List-Utils-1.19/Changes, 9573 bytes, 19 tape blocks
x Scalar-List-Utils-1.19/lib, 0 bytes, 0 tape blocks
x Scalar-List-Utils-1.19/lib/List, 0 bytes, 0 tape blocks
x Scalar-List-Utils-1.19/lib/List/Util.pm, 7088 bytes, 14 tape blocks
x Scalar-List-Utils-1.19/lib/Scalar, 0 bytes, 0 tape blocks
x Scalar-List-Utils-1.19/lib/Scalar/Util.pm, 9079 bytes, 18 tape blocks
x Scalar-List-Utils-1.19/MANIFEST, 851 bytes, 2 tape blocks
x Scalar-List-Utils-1.19/META.yml, 302 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/Util.xs, 10579 bytes, 21 tape blocks
x Scalar-List-Utils-1.19/mytypemap, 250 bytes, 1 tape blocks
x Scalar-List-Utils-1.19/multicall.h, 4598 bytes, 9 tape blocks
x Scalar-List-Utils-1.19/Makefile.PL, 1021 bytes, 2 tape blocks
x Scalar-List-Utils-1.19/README, 795 bytes, 2 tape blocks
x Scalar-List-Utils-1.19/SIGNATURE, 4186 bytes, 9 tape blocks
Removing previously used /.cpan/build/Scalar-List-Utils-1.19
Working directory is /.cpan/build/Scalar-List-Utils-1.19
root@sys #
root@sys # pwd
/.cpan/build/Scalar-List-Utils-1.19
root@sys99120 # perl Makefile.PL && make test && make install &&
echo "INSTALL SUCCEEDED" ||
echo "INSTALL FAILED!"
> > Checking if your kit is complete...
Looks good
Writing Makefile for List::Util
make: not found
INSTALL FAILED!
~~~Sanjay~~~
RE: Perl DBI Urgent
am 28.03.2007 16:37:09 von Sanjay.Tripathi
Matt,
One more interesting thing let me tell you!!
When I'm moving to the directory where my DBI.pm and after then if I m
running that same script, the output is different, see below
# cd ~/DBI/DBI-1.48/
# ls
# ls
Changes dbipport.h dbi_sql.h DBIXS.h ex
MANIFEST README test.pl
dbd_xsh.h dbiprof.PL dbivport.h Driver.xst lib
META.yml Roadmap.pod ToDo
DBI.pm dbiproxy.PL DBI.xs Driver_xst.h Makefile.PL
Perl.xs t typemap
#perl sanjay_test.pl
Can't locate loadable object for module DBI in @INC (@INC contains:
/heb/appl/ewa/DBI/DBI-1.48 /usr/perl5/5.6.1/lib/sun4-solaris-64int
/usr/perl5/5.6.1/lib /usr/perl5/site_perl/5.6.1/sun4-solaris-64int
/usr/perl5/site_perl/5.6.1 /usr/perl5/site_perl
/usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at DBI.pm line
255
BEGIN failed--compilation aborted at DBI.pm line 255.
Compilation failed in require at /app/w3/steve/sanjay_test.pl line 3.
BEGIN failed--compilation aborted at /app/w3/steve/sanjay_test.pl line
3.
------------------------------------------------------------ ------------
----
As ooutput says that error/problem at line 255 of DBI.pm, Please see
below=20
The lines of DBI.pm=20
---------------------------------- See Below the lines of DBI.pm
-----------
227 utils =3D> [ qw(
228 neat neat_list $neat_maxlen dump_results
looks_like_number
229 data_string_diff data_string_desc data_diff
230 ) ],
231 profile =3D> [ qw(
232 dbi_profile dbi_profile_merge dbi_time
233 ) ], # notionally "in" DBI::Profile and normally imported
from there
234 );
235
236 $DBI::dbi_debug =3D 0;
237 $DBI::neat_maxlen =3D 400;
238
239 # If you get an error here like "Can't find loadable object ..."
240 # then you haven't installed the DBI correctly. Read the README
241 # then install it again.
242 if ( $ENV{DBI_PUREPERL} ) {
243 eval { bootstrap DBI } if $ENV{DBI_PUREPERL} == 1;
244 require DBI::PurePerl if $@ or $ENV{DBI_PUREPERL} >=3D 2;
245 $DBI::PurePerl ||=3D 0; # just to silence "only used once"
warnings
246 }
247 else {
248 bootstrap DBI;
249 }
250
251 $EXPORT_TAGS{preparse_flags} =3D [ grep { /^DBIpp_\w\w_/ } keys
%{__PACKAGE__."::"} ];
252
253 Exporter::export_ok_tags(keys %EXPORT_TAGS);
254
255 }
256
257 # Alias some handle methods to also be DBI class methods
258 for (qw(trace_msg set_err parse_trace_flag parse_trace_flags)) {
259 no strict;
260 *$_ =3D \&{"DBD::_::common::$_"};
261 }
262
263 use strict;
264
265 DBI->trace(split /=3D/, $ENV{DBI_TRACE}, 2) if $ENV{DBI_TRACE};
266
267 $DBI::connect_via =3D "connect";
268
269 # check if user wants a persistent database connection ( Apache
+ mod_perl )
------------------------------------------------------------ ------------
-
Any Idea or clue OOOO
~~~Sanjay Tripathi ~~~
-----Original Message-----
From: Sanjay Tripathi=20
Sent: Wednesday, March 28, 2007 7:47 PM
To: 'Matthew Ramadanovic'; Satya Shiv Mohanty
Cc: dbi-users@perl.org
Subject: RE: Perl DBI Urgent
Matt,
As your suggestion, I did like that
root@sys # vi sanjay_test.pl
"sanjay_test.pl" [New file]
#!/usr/bin/perl
eval {
use DBI;
};
if ($@) {
print "Couldn't use DBI : $@\n";
} else {
print "Loaded DBI successfully\n";
}
eval {
use DBD::Oracle;
};
if ($@) {
print "Couldn't use DBD::ORACLE : $@\n"; } else { print "Loaded
DBD::Oracle successfully\n"; } print "Done\n";
root@sys # perl sanjay_test.pl
Can't locate DBI.pm in @INC (@INC contains:
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at sanjay_test.pl
line 3.
BEGIN failed--compilation aborted at sanjay_test.pl line 3.
root@sys #
Still I'm facing same problem any Idea :)
Thanks
Sanjay Tripathi
-----Original Message-----
From: Matthew Ramadanovic [mailto:matthew.ramadanovic@yale.edu]=20
Sent: Wednesday, March 28, 2007 7:26 PM
To: Sanjay Tripathi; Satya Shiv Mohanty
Cc: dbi-users@perl.org
Subject: RE: Perl DBI Urgent
Why not just do something like this:
#!/usr/bin/perl=20
eval {
use DBI;=20
};
if ($@) {
print "Couldn't use DBI : $@\n";
} else {
print "Loaded DBI successfully\n";
}
eval {
use DBD::Oracle;
};
if ($@) {
print "Couldn't use DBD::ORACLE : $@\n";
} else {
print "Loaded DBD::Oracle successfully\n";
}
print "Done\n";
-Matt
-----Original Message-----
From: Sanjay Tripathi [mailto:Sanjay.Tripathi@ustri.com]=20
Sent: Wednesday, March 28, 2007 9:13 AM
To: Satya Shiv Mohanty
Cc: dbi-users@perl.org
Subject: RE: Perl DBI Urgent
How do I will check that Perl is having DBI and DBD(Oracle) Module or
not!
~~Sanjay~~~
-----Original Message-----
From: Satya Shiv Mohanty [mailto:Satya_Mohanty@infosys.com]=20
Sent: Tuesday, March 27, 2007 8:00 PM
To: Sanjay Tripathi
Subject: RE: Perl DBI Urgent
Probably u did not add the exact location of the DBI.pm in ur script.
Assuming that ur DBI.pm is at /usr/perl5/lib/sun4-solaris/DBI.pm, then u
need to include it using following:-
use lib "/usr/perl5/lib/sun4-solaris";
in ur script.
Also for " Premature end of
script headers" I think u r not mentioning the output type of the
document u r trying to display. Like u use print "Content-type:
text/html\n\n"; for html output.
Hope this helps u.
Regards
Satya Shiv
-----Original Message-----
From: Sanjay Tripathi [mailto:Sanjay.Tripathi@ustri.com]
Sent: Tuesday, March 27, 2007 5:41 PM
To: dbi-users@perl.org
Subject: Perl DBI Urgent
Hi,
I getting problem with Perl/Cgi/DBI. Can you guys help me out.
Please see the log below.
Aapche Logs:
Can't locate DBI.pm in @INC (@INC contains: /app/custom/steve/perl
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .
/app/custom/steve/perl /app/custom/perl /heb/appl/ewa/perl/bin/perl) at
/app/w3/steve/cgi/ewa_new_user.cgi line 3.
BEGIN failed--compilation aborted at /app/w3/steve/cgi/ewa_new_user.cgi
line 3.
[Tue Mar 27 06:47:06 2007] [error] [client x.x.x.x] Premature end of
script headers: /app/w3/steve/cgi/ewa_new_user.cgi
Then I tried
root@sys # perl -e 'use DBI; print $DBI::VERSION,"\n";'
Can't locate loadable object for module DBI in @INC (@INC contains:
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at DBI.pm line
254
BEGIN failed--compilation aborted at DBI.pm line 254.
Compilation failed in require at -e line 1.
BEGIN failed--compilation aborted at -e line 1.
Thanks
ST
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this
e-mail or its contents to any other person and any such actions are
unlawful. This e-mail may contain viruses. Infosys has taken every
reasonable precaution to minimize this risk, but is not liable for any
damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
RE: Perl DBI Urgent
am 28.03.2007 16:50:09 von Philip.Garrett
Sanjay Tripathi wrote:
> Writing Makefile for List::Util
> make: not found
> INSTALL FAILED!
You need to install make. You'll also need a C compiler if you don't
already have it installed (which you probably don't).
- Philip
RE: Perl DBI Urgent
am 28.03.2007 17:01:31 von Philip.Garrett
Matthew Ramadanovic wrote:
> Why not just do something like this:
>=20
> #!/usr/bin/perl
> eval {
> use DBI;
> };
> if ($@) {
> print "Couldn't use DBI : $@\n";
> } else {
> print "Loaded DBI successfully\n";
> }
Output:
Can't locate DBI.pm in @INC ...
Although this does indeed tell me that DBI is not installed, it doesn't
happen the way you wanted. "use" happens at compile time so you can't
capture compile errors in $@. To check for these at run time, you need
to use either require() or eval "".
if (eval { require DBI }) {
print "DBI is installed\n";
}
if (eval "use DBI") {
print "DBI is installed\n";
}
- Philip
RE: Perl DBI Urgent
am 28.03.2007 17:21:11 von Ron.Reidy
Sanjay,
I suggest the following:
1. Upgrade your version of Perl to 5.8.8 (someone else suggested this
already) and put it in a different location (not /usr/bin or
/usr/local/bin). You most definitely will need a C compiler to do this.
2. Change your path in /etc/profile to have this new Perl found before
the Perl that is a standard part of your O/S.
3. Install DBI/DBD::Oracle and other modules you need to get things
rolling.=20
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: Sanjay Tripathi [mailto:Sanjay.Tripathi@ustri.com]=20
Sent: Wednesday, March 28, 2007 8:17 AM
To: Matthew Ramadanovic; Satya Shiv Mohanty
Cc: dbi-users@perl.org
Subject: RE: Perl DBI Urgent
Matt,
As your suggestion, I did like that
root@sys # vi sanjay_test.pl
"sanjay_test.pl" [New file]
#!/usr/bin/perl
eval {
use DBI;
};
if ($@) {
print "Couldn't use DBI : $@\n";
} else {
print "Loaded DBI successfully\n";
}
eval {
use DBD::Oracle;
};
if ($@) {
print "Couldn't use DBD::ORACLE : $@\n"; } else { print "Loaded
DBD::Oracle successfully\n"; } print "Done\n";
root@sys # perl sanjay_test.pl
Can't locate DBI.pm in @INC (@INC contains:
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at sanjay_test.pl
line 3.
BEGIN failed--compilation aborted at sanjay_test.pl line 3.
root@sys #
Still I'm facing same problem any Idea :)
Thanks
Sanjay Tripathi
-----Original Message-----
From: Matthew Ramadanovic [mailto:matthew.ramadanovic@yale.edu]
Sent: Wednesday, March 28, 2007 7:26 PM
To: Sanjay Tripathi; Satya Shiv Mohanty
Cc: dbi-users@perl.org
Subject: RE: Perl DBI Urgent
Why not just do something like this:
#!/usr/bin/perl
eval {
use DBI;
};
if ($@) {
print "Couldn't use DBI : $@\n";
} else {
print "Loaded DBI successfully\n";
}
eval {
use DBD::Oracle;
};
if ($@) {
print "Couldn't use DBD::ORACLE : $@\n"; } else { print "Loaded
DBD::Oracle successfully\n"; } print "Done\n";
-Matt
-----Original Message-----
From: Sanjay Tripathi [mailto:Sanjay.Tripathi@ustri.com]
Sent: Wednesday, March 28, 2007 9:13 AM
To: Satya Shiv Mohanty
Cc: dbi-users@perl.org
Subject: RE: Perl DBI Urgent
How do I will check that Perl is having DBI and DBD(Oracle) Module or
not!
~~Sanjay~~~
-----Original Message-----
From: Satya Shiv Mohanty [mailto:Satya_Mohanty@infosys.com]
Sent: Tuesday, March 27, 2007 8:00 PM
To: Sanjay Tripathi
Subject: RE: Perl DBI Urgent
Probably u did not add the exact location of the DBI.pm in ur script.
Assuming that ur DBI.pm is at /usr/perl5/lib/sun4-solaris/DBI.pm, then u
need to include it using following:-
use lib "/usr/perl5/lib/sun4-solaris";
in ur script.
Also for " Premature end of
script headers" I think u r not mentioning the output type of the
document u r trying to display. Like u use print "Content-type:
text/html\n\n"; for html output.
Hope this helps u.
Regards
Satya Shiv
-----Original Message-----
From: Sanjay Tripathi [mailto:Sanjay.Tripathi@ustri.com]
Sent: Tuesday, March 27, 2007 5:41 PM
To: dbi-users@perl.org
Subject: Perl DBI Urgent
Hi,
I getting problem with Perl/Cgi/DBI. Can you guys help me out.
Please see the log below.
Aapche Logs:
Can't locate DBI.pm in @INC (@INC contains: /app/custom/steve/perl
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .
/app/custom/steve/perl /app/custom/perl /heb/appl/ewa/perl/bin/perl) at
/app/w3/steve/cgi/ewa_new_user.cgi line 3.
BEGIN failed--compilation aborted at /app/w3/steve/cgi/ewa_new_user.cgi
line 3.
[Tue Mar 27 06:47:06 2007] [error] [client x.x.x.x] Premature end of
script headers: /app/w3/steve/cgi/ewa_new_user.cgi
Then I tried
root@sys # perl -e 'use DBI; print $DBI::VERSION,"\n";'
Can't locate loadable object for module DBI in @INC (@INC contains:
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at DBI.pm line
254
BEGIN failed--compilation aborted at DBI.pm line 254.
Compilation failed in require at -e line 1.
BEGIN failed--compilation aborted at -e line 1.
Thanks
ST
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this
e-mail or its contents to any other person and any such actions are
unlawful. This e-mail may contain viruses. Infosys has taken every
reasonable precaution to minimize this risk, but is not liable for any
damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.
RE: Perl DBI Urgent
am 30.03.2007 20:43:20 von matthew.ramadanovic
I thought you said you are on perl 5.8 not perl 5.6? Looks like Solaris
64 bit (and not on Windows). Either way, DBI is failing so there is no
chance DBD::Oracle will work until you fix that. Fix that first :
If you have more than one perl in your path try calling the one that
does have DBI installed explicitly from your shebang line :
#!/usr/bin/perl=20
#!/usr/bin/perl58
If that wasn't it you may have to get more involved :-) :
If you have a c compiler and just need to install perl modules get any
prerequisites (not DBI itself) from CPAN :
perl -MCPAN -e shell o conf prerequisites_policy ask
you can then install modules like this :
install some::module
If elves messed up your cpan configuration (see that a lot) you can
rerun the config script by rerunning the cpan script
Cpan
Once you are in the CPAN shell enter
o conf init
This will kick off the wizard.
You should also make sure your Oracle install is complete for when you
eventually compile DBI and DBD Oracle. Specifically I have found that I
need to have files in my /rdbms/lib and /lib32 directories for DBI to
compile. By default you don't get them in a client oracle install.
Either reinstall and let the universal installer put them there or fetch
them from you database server (which probably has them in /rdbms/lib and
/lib32.
Installing most modules will only work IF you have a C Compiler and
make. Solaris doesn't give you one by default and charge like $4000 for
theirs so . . .=20
If you don't have a c compiler or make or some other essential
component, get the pkg-get script http://sunfreeware.com/ and use it to
install them (a free one) :
pkg-get install gcc
I have used gcc on solaris to compile DBI and DBD::Oracle and frankly
had no luck with the $4000 compiler (though I still need it since gcc
won't compile external procedures for oracle but that is another story)
Once you are sure you are using the correct verion of perl, have the
correct Oracle files and libs available, have tools needed to compile
stuff installed, and have all the perl prerequisites installed you can
worry about compiling/installing DBI.
-M
-----Original Message-----
From: Sanjay Tripathi [mailto:Sanjay.Tripathi@ustri.com]=20
Sent: Wednesday, March 28, 2007 10:17 AM
To: Matthew Ramadanovic; Satya Shiv Mohanty
Cc: dbi-users@perl.org
Subject: RE: Perl DBI Urgent
Matt,
As your suggestion, I did like that
root@sys # vi sanjay_test.pl
"sanjay_test.pl" [New file]
#!/bin/sh
echo DEFANGED.1400
exit
#!/usr/bin/perl
eval {
use DBI;
};
if ($@) {
print "Couldn't use DBI : $@\n";
} else {
print "Loaded DBI successfully\n";
}
eval {
use DBD::Oracle;
};
if ($@) {
print "Couldn't use DBD::ORACLE : $@\n"; } else { print "Loaded
DBD::Oracle successfully\n"; } print "Done\n";
root@sys # perl sanjay_test.pl
Can't locate DBI.pm in @INC (@INC contains:
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at sanjay_test.pl
line 3.
BEGIN failed--compilation aborted at sanjay_test.pl line 3.
root@sys #
Still I'm facing same problem any Idea :)
Thanks
Sanjay Tripathi
-----Original Message-----
From: Matthew Ramadanovic [mailto:matthew.ramadanovic@yale.edu]=20
Sent: Wednesday, March 28, 2007 7:26 PM
To: Sanjay Tripathi; Satya Shiv Mohanty
Cc: dbi-users@perl.org
Subject: RE: Perl DBI Urgent
Why not just do something like this:
#!/usr/bin/perl=20
eval {
use DBI;=20
};
if ($@) {
print "Couldn't use DBI : $@\n";
} else {
print "Loaded DBI successfully\n";
}
eval {
use DBD::Oracle;
};
if ($@) {
print "Couldn't use DBD::ORACLE : $@\n";
} else {
print "Loaded DBD::Oracle successfully\n";
}
print "Done\n";
-Matt
-----Original Message-----
From: Sanjay Tripathi [mailto:Sanjay.Tripathi@ustri.com]=20
Sent: Wednesday, March 28, 2007 9:13 AM
To: Satya Shiv Mohanty
Cc: dbi-users@perl.org
Subject: RE: Perl DBI Urgent
How do I will check that Perl is having DBI and DBD(Oracle) Module or
not!
~~Sanjay~~~
-----Original Message-----
From: Satya Shiv Mohanty [mailto:Satya_Mohanty@infosys.com]=20
Sent: Tuesday, March 27, 2007 8:00 PM
To: Sanjay Tripathi
Subject: RE: Perl DBI Urgent
Probably u did not add the exact location of the DBI.pm in ur script.
Assuming that ur DBI.pm is at /usr/perl5/lib/sun4-solaris/DBI.pm, then u
need to include it using following:-
use lib "/usr/perl5/lib/sun4-solaris";
in ur script.
Also for " Premature end of
script headers" I think u r not mentioning the output type of the
document u r trying to display. Like u use print "Content-type:
text/html\n\n"; for html output.
Hope this helps u.
Regards
Satya Shiv
-----Original Message-----
From: Sanjay Tripathi [mailto:Sanjay.Tripathi@ustri.com]
Sent: Tuesday, March 27, 2007 5:41 PM
To: dbi-users@perl.org
Subject: Perl DBI Urgent
Hi,
I getting problem with Perl/Cgi/DBI. Can you guys help me out.
Please see the log below.
Aapche Logs:
Can't locate DBI.pm in @INC (@INC contains: /app/custom/steve/perl
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .
/app/custom/steve/perl /app/custom/perl /heb/appl/ewa/perl/bin/perl) at
/app/w3/steve/cgi/ewa_new_user.cgi line 3.
BEGIN failed--compilation aborted at /app/w3/steve/cgi/ewa_new_user.cgi
line 3.
[Tue Mar 27 06:47:06 2007] [error] [client x.x.x.x] Premature end of
script headers: /app/w3/steve/cgi/ewa_new_user.cgi
Then I tried
root@sys # perl -e 'use DBI; print $DBI::VERSION,"\n";'
Can't locate loadable object for module DBI in @INC (@INC contains:
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at DBI.pm line
254
BEGIN failed--compilation aborted at DBI.pm line 254.
Compilation failed in require at -e line 1.
BEGIN failed--compilation aborted at -e line 1.
Thanks
ST
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this
e-mail or its contents to any other person and any such actions are
unlawful. This e-mail may contain viruses. Infosys has taken every
reasonable precaution to minimize this risk, but is not liable for any
damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***