general trouble installing languages

On Tue, 2002-09-17 at 18:46, Cindy wrote:

I suspect at this point I may need to recompile things? I'm not sure
what the trouble is. Can I try the directions in

...

The error message is now a bit more detailed:

createlang -L /usr/local/pgsql/lib -d Text plperl

ERROR: Load of file /usr/local/pgsql/lib/plperl.so failed: ld.so.1: /usr/local
/pgsql/bin/postmaster: fatal: libperl.so.1: open failed: No such file or direct
ory

^^^^^^^^^^^^

It is missing libperl, that is the shared library version of Perl
itself. This is not part of PostgreSQL, so rebuilding PostgreSQL will
do you no good at all.

You need to build Perl from source or install a shared library package
of it.

--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Honour the LORD with thy substance, and with the
firstfruits of all thine increase; So shall thy barns
be filled with plenty, and thy presses shall burst out
with new wine." Proverbs 3:9,10

Oliver Elphick writes:

Cindy wrote:

ERROR: Load of file /usr/local/pgsql/lib/plperl.so failed: ld.so.1: /usr/l

ocal

/pgsql/bin/postmaster: fatal: libperl.so.1: open failed: No such file or di

rect

ory

^^^^^^^^^^^^

It is missing libperl, that is the shared library version of Perl
itself. This is not part of PostgreSQL, so rebuilding PostgreSQL will
do you no good at all.

You need to build Perl from source or install a shared library package
of it.

Thanks. I guess I was looking for a message more like that indicated
in the install docs, but since I didn't do the initial installation,
for all I know that was overlooked. I'll ask our admin about the
shared library package. They probably have it in a nonstandard
directory <sigh>.

--
Cindy
ctmoore@uci.edu

Cindy writes:

Thanks. I guess I was looking for a message more like that indicated
in the install docs, but since I didn't do the initial installation,
for all I know that was overlooked. I'll ask our admin about the
shared library package. They probably have it in a nonstandard
directory <sigh>.

OK, related question while I wait for my admin to respond. Assuming
the shared libary package is available in some other directory, I'm
assuming I'm still going to have to do something to wind up with a
libperl.so in the /usr/local/pgsql/lib directory.

And I'm guessing that's what is outlined in
http://www.postgresql.org/idocs/index.php?plperl-install.html

??

Thanks,
--
Cindy, impatient :-)
ctmoore@uci.edu

On Tuesday 17 September 2002 02:42 pm, Cindy wrote:

OK, related question while I wait for my admin to respond. Assuming
the shared libary package is available in some other directory, I'm
assuming I'm still going to have to do something to wind up with a
libperl.so in the /usr/local/pgsql/lib directory.

Perl itself has to be rebuilt to provide libperl.so
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

On Tue, 2002-09-17 at 13:47, Lamar Owen wrote:

On Tuesday 17 September 2002 02:42 pm, Cindy wrote:

OK, related question while I wait for my admin to respond. Assuming
the shared libary package is available in some other directory, I'm
assuming I'm still going to have to do something to wind up with a
libperl.so in the /usr/local/pgsql/lib directory.

Perl itself has to be rebuilt to provide libperl.so

FWIW, it seems perl 5.8 gets this right. LER

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Lamar Owen writes:

On Tuesday 17 September 2002 02:42 pm, Cindy wrote:

OK, related question while I wait for my admin to respond. Assuming
the shared libary package is available in some other directory, I'm
assuming I'm still going to have to do something to wind up with a
libperl.so in the /usr/local/pgsql/lib directory.

Perl itself has to be rebuilt to provide libperl.so

Not if the shared library is in fact already built? It very well
may be on this system, I'm working at a university which has an
overall administration in place on top of the individual unix boxes,
and practically nothing is in standard paths (infuriating, but...).
So if it's already there, just in some oddball directory, I shd
be able to use it?

They may have to recompile, if htis is the dir (I'm guessing,
though)

ls /dcs/lib/perl/

abbrev.pl fmtmsg.ph netdir.ph std.ph
admin/ form.ph netinet/ stdarg.ph
alloca.ph ftw.ph newgetopt.pl stddef.ph
ar.ph getcwd.pl nfs/ stdio.ph
archives.ph getopt.pl nl_types.ph stdlib.ph
arpa/ getopts.pl nlist.ph storclass.ph
assert.ph getwidth.ph nsaddr.ph string.ph
assert.pl grp.ph nserve.ph stropts.ph
bigfloat.pl ieeefp.ph nsswitch.ph sum.ph
bigint.pl importenv.pl open2.pl syms.ph
bigrat.pl inet/ panel.ph sys/
cacheout.pl kerberos/ perldb.pl syslog.ph
chat2.pl kstat.ph ph.pl syslog.pl
complete.pl kvm.ph pkgdev.ph table.ph
core langinfo.ph pkginfo.ph tar.ph
cpio.ph lastlog.ph pkglocs.ph term.ph
crypt.ph libelf.ph pkgstrct.ph termcap.pl
ctime.pl libgen.ph pkgtrans.ph termio.ph
ctype.ph libgenIO.ph pn.ph termios.ph
curses.ph libintl.ph poll.ph time.ph
deflt.ph libw.ph prof.ph timelocal.pl
des/ limits.ph protocols/ tiuser.ph
devmgmt.ph linenum.ph pw.ph tzfile.ph
dial.ph link.ph pwd.ph ucontext.ph
dirent.ph listen.ph pwd.pl ulimit.ph
dlfcn.ph locale.ph regexp.ph unctrl.ph
dumpvar.pl look.pl regexpr.ph unistd.ph
elf.ph macros.ph resolv.ph userdefs.ph
errno.ph maillock.ph rje.ph ustat.ph
eti.ph malloc.ph rpc/ utime.ph
euc.ph math.ph rpcsvc/ utmp.ph
exceptions.pl memory.ph sac.ph utmpx.ph
fastcwd.pl menu.ph search.ph validate.pl
fatal.ph mon.ph setjmp.ph valtools.ph
fcntl.ph mp.ph sgtty.ph values.ph
find.pl nan.ph shadow.ph varargs.ph
finddepth.pl ndbm.ph shellwords.pl vm/
float.ph net/ siginfo.ph wait.ph
floatingpoint.ph netconfig.ph signal.ph wctype.ph
flush.pl netdb.ph stat.pl widec.ph

since I dont see libperl.* up there.

So what exactly does the make install from the src/pl/plperl directory
do, then? And would I have to do it once libperl.whatever became available?

Oh, and if libperl.so is from a perl compilation why is it in psql's lib
dir? Does it get copied there at some point in installation?

--
Cindy
ctmoore@uci.edu

On Tuesday 17 September 2002 02:58 pm, Cindy wrote:

Lamar Owen writes:

On Tuesday 17 September 2002 02:42 pm, Cindy wrote:

OK, related question while I wait for my admin to respond. Assuming
the shared libary package is available in some other directory, I'm
assuming I'm still going to have to do something to wind up with a
libperl.so in the /usr/local/pgsql/lib directory.

Perl itself has to be rebuilt to provide libperl.so

Not if the shared library is in fact already built? It very well
may be on this system, I'm working at a university which has an
overall administration in place on top of the individual unix boxes,
and practically nothing is in standard paths (infuriating, but...).
So if it's already there, just in some oddball directory, I shd
be able to use it?

Oh, and if libperl.so is from a perl compilation why is it in psql's lib
dir? Does it get copied there at some point in installation?

The file libperl.so is a dynamically linkable version of the embeddable
libperl.a. This allows an extension module to embed perl in itself. The
plperl.so module is a 'wrapper' with a few extra features that embeds the
whole perl interpreter (libperl.so) into the backend.

It shouldn't be in the psql libdir; it should be in a system libdir. If you
have sufficient privileges to do so, do a 'find / -name "libperl.so*" -print'
and see if it is anywhere on your system in a place the dynamic loader
(ld.so) can find it.

To recap:
1.) plperl.so is the PL/Perl extension module provided as part of the
PostgreSQL distribution;
2.) libperl.so is the perl interpreter suitable for dynamic loading into an
extension module and is provided by the perl package;
3.) 1 uses 2.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

On Tue, 17 Sep 2002 10:46:35 -0700
Cindy <ctmoore@uci.edu> wrote:

<SNIP>

createlang -L /usr/local/pgsql/lib -d Text plperl

ERROR: Load of file /usr/local/pgsql/lib/plperl.so failed: ld.so.1: /usr/local
/pgsql/bin/postmaster: fatal: libperl.so.1: open failed: No such file or direct
ory
createlang: language installation failed

<SNIP>
Ok, a major question, what OS and version are you running? This would help things out.

Thanks,
--Cindy

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

GB

--
GB Clark II | Roaming FreeBSD Admin
gclarkii@VSServices.COM | General Geek
CTHULU for President - Why choose the lesser of two evils?