Regarding Perl DBI version issue.

------_=_NextPart_001_01C77617.1B1DE2DA
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable


=20

HI

=20

When I am using the command from root user in the sunsolaris operating
system.

i.e=20

perl -e 'use DBI; print $DBI::VERSION,"\n";'

I am getting the following error.

=20

Can't locate DBI.pm in @INC (@INC contains:
/usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503
/usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .)

=20

Actually we are using perl 5.6.1,but it is showing location to some
other perl if we log in with root user only.

=20

If we login with some other user other than the root user,then it
showing correct path i.e=20

/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/ and getting
the correct version.

=20

And when I use the command with user other than the root user, I am
getting the correct DBI version

For eg: perl -e 'use DBI; print $DBI::VERSION,"\n";'

Output is 1.28

=20

=20

Could u plz help what to do for the root user, inorder to get the
correct DBI version with out the error.

What kind of changes should I do?

=20

=20

Thanks & Regards

Ravi



==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== ====


Disclaimer:

This message and the information contained herein is proprietary and=
confidential and subject to the Tech Mahindra policy statement, you may=
review at =3D"http://www.techmahindra.com/Disclaimer.html">http://www. techmahindra.co=
m/Disclaimer.html externally and =3D"http://tim.techmahindra.com/Disclaimer.html">http://tim. techmahindra.co=
m/Disclaimer.html internally within Tech Mahindra.

==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== ====
------_=_NextPart_001_01C77617.1B1DE2DA--

Re: Regarding Perl DBI version issue.

--------------040009020506070501090700
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Obviously root user gets another PATH variable than a normal user. From
your output I would assume the correct perl version to use is somewhere
under /usr/local (most probably /usr/local/bin). Rearrange PATH for root
before calling perl should do the trick.

If in doubt, do

echo $PATH

as normal user and set the result for root before calling perl.


OTOH, why do you you have to use *ROOT* for *ORACLE* things? This is
looks a little bit like a design flaw ...

HTH

Hannes

RaviChandra Chelikam schrieb:
>
>
> HI
>
>
>
> When I am using the command from root user in the sunsolaris operating
> system.
>
> i.e
>
> perl -e 'use DBI; print $DBI::VERSION,"\n";'
>
> I am getting the following error.
>
>
>
> Can't locate DBI.pm in @INC (@INC contains:
> /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503
> /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .)
>
>
>
> Actually we are using perl 5.6.1,but it is showing location to some
> other perl if we log in with root user only.
>
>
>
> If we login with some other user other than the root user,then it
> showing correct path i.e
>
> /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/ and getting
> the correct version.
>
>
>
> And when I use the command with user other than the root user, I am
> getting the correct DBI version
>
> For eg: perl -e 'use DBI; print $DBI::VERSION,"\n";'
>
> Output is 1.28
>
>
>
>
>
> Could u plz help what to do for the root user, inorder to get the
> correct DBI version with out the error.
>
> What kind of changes should I do?
>
>
>
>
>
> Thanks & Regards
>
> Ravi
>
>
>
> ============================================================ ============================================================ ====
>
>
> Disclaimer:
>
> This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review at internally within Tech Mahindra.
>
> ============================================================ ============================================================ ====


--------------040009020506070501090700--

RE: Regarding Perl DBI version issue.

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


Kai,

Yes u r correct. For root user I don't have have /usr/local/bin in the=
path.

For Root user, currently it is showing /usr/bin/perl. And It is=
pointing to perl, version 5.005_03 built for sun4-solaris.

Could u plz tell how to set the path as /usr/local/bin /perl for the=
Root user so that it points for 5.6.1 version.

=20

Thanks & Regards

Ravi=20

=20

________________________________

From: Kai Schwermann [mailto:Kai.Schwermann@bill-X.de]=20
Sent: Wednesday, April 04, 2007 1:35 PM
To: RaviChandra Chelikam
Subject: Re: Regarding Perl DBI version issue.

=20


Hi,=20

as ROOT you do not have /usr/local/bin in your path, isn't it?=20

You can try out "which perl" as ROOT and as regular user, i think that it=
is one time /usr/bin/perl and the other time /usr/local/bin/perl...=20

Just call the "right" perl including full path: /usr/local/bin/perl ...=20


Bye=20
Kai
--
Kai Schwermann, Geschäftsführer
bill-X GmbH
Möserstr. 34 49074 Osnabrück, Germany
Tel. +49-541-71008-0 Fax +49-541-71008-499
http://www.bill-X.de schwermann@bill-X.de
____________________________________________________________ _______________=
_=20



=20

"RaviChandra Chelikam" =20

03.04.2007 19:40=20

=20
To: =20
cc: =20
Subject: Regarding Perl DBI version issue.







HI



When I am using the command from root user in the sunsolaris operating
system.

i.e=20

perl -e 'use DBI; print $DBI::VERSION,"\n";'

I am getting the following error.



Can't locate DBI.pm in @INC (@INC contains:
/usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503
/usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .)



Actually we are using perl 5.6.1,but it is showing location to some
other perl if we log in with root user only.



If we login with some other user other than the root user,then it
showing correct path i.e=20

/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/ and getting
the correct version.



And when I use the command with user other than the root user, I am
getting the correct DBI version

For eg: perl -e 'use DBI; print $DBI::VERSION,"\n";'

Output is 1.28

=20



Could u plz help what to do for the root user, inorder to get the
correct DBI version with out the error.

What kind of changes should I do?





Thanks & Regards

Ravi



==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== ====


Disclaimer:

This message and the information contained herein is proprietary and=
confidential and subject to the Tech Mahindra policy statement, you may=
review at =3D"http://www.techmahindra.com/Disclaimer.html">http://www. techmahindra.co=
m/Disclaimer.html externally and =3D"http://tim.techmahindra.com/Disclaimer.html">http://tim. techmahindra.co=
m/Disclaimer.html internally within Tech Mahindra.

==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== =====20



==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== ====


Disclaimer:

This message and the information contained herein is proprietary and=
confidential and subject to the Tech Mahindra policy statement, you may=
review at =3D"http://www.techmahindra.com/Disclaimer.html">http://www. techmahindra.co=
m/Disclaimer.html externally and =3D"http://tim.techmahindra.com/Disclaimer.html">http://tim. techmahindra.co=
m/Disclaimer.html internally within Tech Mahindra.

==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== ====
------_=_NextPart_001_01C77693.8ACD2FB4--

Re: Regarding Perl DBI version issue.

--S1BNGpv0yoYahz37
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On 2007-04-04 10:25:42 +0200, Johannes Gritsch wrote:
> Obviously root user gets another PATH variable than a normal user. From y=
our=20
> output I would assume the correct perl version to use is somewhere under=
=20
> /usr/local (most probably /usr/local/bin). Rearrange PATH for root before=
=20
> calling perl should do the trick.
>=20
> If in doubt, do
>=20
> echo $PATH
>=20
> as normal user and set the result for root before calling perl.
>=20
>=20
> OTOH, why do you you have to use *ROOT* for *ORACLE* things? This is look=
s a=20
> little bit like a design flaw ...

For scripts the PATH shouldn't matter since the full path of the perl
binary is normally in the #! line.

However, the PATH does matter when you do the usual "perl Makefile.PL &&
make && make test && make install" dance or when invoking cpan (although
you can use absolute paths in this case, too).

I'm ignoring the case of perl one-liners here. I don't think you can do
much useful work with DBI in one line ...

hp


--=20
_ | Peter J. Holzer | If I wanted to be "academically correct",
|_|_) | Sysadmin WSR | I'd be programming in Java.
| | | hjp@wsr.ac.at | I don't, and I'm not.
__/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users

--S1BNGpv0yoYahz37
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGE3RSMdFfQa64PCwRAusnAJ0aLMDxQy11bF1seoQjLF6fqe53GQCc CJru
jhUWASYsS0uQDD8JdotiaLY=
=DYdb
-----END PGP SIGNATURE-----

--S1BNGpv0yoYahz37--

Re: Regarding Perl DBI version issue.

--RYJh/3oyKhIjGcML
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On 2007-04-04 14:00:45 +0530, RaviChandra Chelikam wrote:
> Yes u r correct. For root user I don't have have /usr/local/bin in th=
e path.
>=20
> For Root user, currently it is showing /usr/bin/perl. And It is poin=
ting to perl, version 5.005_03 built for sun4-solaris.
>=20
> Could u plz tell how to set the path as /usr/local/bin /perl for the =
Root user so that it points for 5.6.1 version.

Read a "Unix for beginners" style book.

This is not a DBI or even perl-related question, and if you don't know
how to set the path you shouldn't know the root password of that
machine.

hp

--=20
_ | Peter J. Holzer | If I wanted to be "academically correct",
|_|_) | Sysadmin WSR | I'd be programming in Java.
| | | hjp@wsr.ac.at | I don't, and I'm not.
__/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users

--RYJh/3oyKhIjGcML
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGE3UWMdFfQa64PCwRAoYkAJ9vrm0ug6yNXKWjj0ytocaxaxVqgQCf RKiW
95nwQNMTAXdGd313NjHSuuc=
=F7V2
-----END PGP SIGNATURE-----

--RYJh/3oyKhIjGcML--

Re: Regarding Perl DBI version issue.

------=_Part_50458_23404727.1175696564821
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Amen!

(And politely put - I'm not sure I could have managed to be so tactful.)

On 4/4/07, Peter J. Holzer wrote:
>
> On 2007-04-04 14:00:45 +0530, RaviChandra Chelikam wrote:
> > Yes u r correct. For root user I don't have have /usr/local/bin in
> the path.
> >
> > For Root user, currently it is showing /usr/bin/perl. And It is
> pointing to perl, version 5.005_03 built for sun4-solaris.
> >
> > Could u plz tell how to set the path as /usr/local/bin /perl for the
> Root user so that it points for 5.6.1 version.
>
> Read a "Unix for beginners" style book.
>
> This is not a DBI or even perl-related question, and if you don't know
> how to set the path you shouldn't know the root password of that
> machine.
>
> hp
>
> --
> _ | Peter J. Holzer | If I wanted to be "academically correct",
> |_|_) | Sysadmin WSR | I'd be programming in Java.
> | | | hjp@wsr.ac.at | I don't, and I'm not.
> __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users
>
>


--
Jonathan Leffler #include
Guardian of DBD::Informix - v2007.0226 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never lack
amusement."

------=_Part_50458_23404727.1175696564821--