Reply-To: <mykarz@miyabara.com>
From: "Michael Miyabara-McCaskey" <mykarz@miyabara.com>
To: "'Tom Lane'" <tgl@sss.pgh.pa.us>
Cc: <pgsql-interfaces@postgresql.org>
Subject: RE: Plperl make fails with Error1 at plperl.o (7.0.3) 
Date: Mon, 18 Dec 2000 22:58:30 -0800
Message-ID: <001501c06989$18ffd7b0$c700a8c0@ncc1701e>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
In-reply-to: <2715.976497131@sss.pgh.pa.us>
Importance: Normal

Tom,

Again your help was excellent and on target.

I had gone through the fun and games of building a shared libperl.so, and
the plperl.so... but...

The LD_LIBRARY_PATH was the culprit.  As I'm running RedHat, by default it
does not create a /usr/local/bin, but I created one by hand, and then dumped
my libperl.so there... Well... This was not in the "/etc/ld.so.conf" file.
So I added the path, and ran the ldconfig and presto... Everything works
very well.

With Perl up and running I'm actually able to make PostgreSQL drive around
the block a few times.

Thank you again.

-Michael

> -----Original Message-----
> From: pgsql-interfaces-owner@postgresql.org
> [mailto:pgsql-interfaces-owner@postgresql.org]On Behalf Of Tom Lane
> Sent: Sunday, December 10, 2000 5:12 PM
> To: mykarz@miyabara.com
> Cc: pgsql-interfaces@postgresql.org
> Subject: Re: [INTERFACES] Plperl make fails with Error1 at plperl.o
> (7.0.3)
>
>
> "Michael Miyabara-McCaskey" <mykarz@miyabara.com> writes:
> > ... I am now getting the error message that:
>
> > ERROR: Load of file /usr/local/pgsql/lib/plperl.so failed:
> shared object not
> > open
>
> Hm.  That's a pretty unhelpfully worded error message, isn't it?
> You may be able to find a more extensive error report in the
> postmaster's log file, assuming you routed the postmaster's stderr
> to someplace other than /dev/null.
>
> But I'll bet that the real problem is not with plperl.so but
> with Perl's
> libperl.so, which plperl.so depends on.  On the Perl versions
> I've used,
> a shared library version of libperl is *not* built unless you
> specifically request it while configuring the Perl build.  On some
> platforms you get a usable shlib anyway, on some you don't.
>
> Another possibility is that libperl.so exists but is not being found
> by the dynamic loader; you may need to run ldconfig or set
> LD_LIBRARY_PATH or some such to include the proper directory in the
> Perl install in the search path.
>
> 			regards, tom lane
>