Hi,
I have an installation of Postgres 7.4.2 on SuSE 9.1. This version
of SuSE comes with a binary for plperl and several other postgres
procedural languages. All the others, including plpgsql install without
a problem, but executing:
createlang -u postgres plperl template1
produces the result:
createlang: language installation failed: ERROR: could not load library
"/usr/lib/postgresql/plperl.so": libperl.so: cannot open shared object
file: No such file or directory
The file, however, is there:
# ls -l /usr/lib/postgresql/plperl.so
-rwxr-xr-x 1 root root 37097 Apr 5 2004 /usr/lib/postgresql/plperl.so
Some googling gave me the idea that it may be a problem with the way
perl was compiled - i.e, perl is not compiled for shared libraries. Can
anyone confirm this? If so, do I need to rebuild perl, or pl/perl, or
both? Are there any binaries that can resolve this? (yes not wanting
to compile plperl is plain old laziness, but I do have reservations
about recompiling the perl interpreter)
Any ideas would be helpful.
Thanks,
Eric
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html 3 3697
On Fri, Oct 22, 2004 at 12:13:12PM -0400, Eric E wrote: Hi, I have an installation of Postgres 7.4.2 on SuSE 9.1. This version of SuSE comes with a binary for plperl and several other postgres procedural languages. All the others, including plpgsql install without a problem, but executing: createlang -u postgres plperl template1 produces the result: createlang: language installation failed: ERROR: could not load library "/usr/lib/postgresql/plperl.so": libperl.so: cannot open shared object file: No such file or directory
The file, however, is there:
# ls -l /usr/lib/postgresql/plperl.so -rwxr-xr-x 1 root root 37097 Apr 5 2004 /usr/lib/postgresql/plperl.so
Some googling gave me the idea that it may be a problem with the way perl was compiled - i.e, perl is not compiled for shared libraries. Can anyone confirm this? If so, do I need to rebuild perl, or pl/perl, or both? Are there any binaries that can resolve this? (yes not wanting to compile plperl is plain old laziness, but I do have reservations about recompiling the perl interpreter)
The error message gives you the hint you need. The missing file isn't
plperl.so - it's libperl.so.
libperl.so is the dynamic library version of perl. It's not usually
installed by most people building perl. (It's also not neccesarily
needed by plperl.so, as libperl.a can be statically linked into
plperl.so, I believe).
I don't know SuSEs package system (I always install from source) but
there may well be another perl package that would provide libperl.so.
Failing that you'll either need to build a perl installation and tell
Configure to build libperl.so, or rebuild plperl.so. It's also
possible that you do have libperl.so somewhere, but it's not on
the standard library search path and not where plperl expects
to find it.
'ldd' is a useful command for tracking down this sort of problem.
Cheers,
Steve
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Eric E <wh*******@bonb on.net> writes: createlang: language installation failed: ERROR: could not load library "/usr/lib/postgresql/plperl.so": libperl.so: cannot open shared object file: No such file or directory
The file, however, is there:
# ls -l /usr/lib/postgresql/plperl.so -rwxr-xr-x 1 root root 37097 Apr 5 2004 /usr/lib/postgresql/plperl.so
It's complaining that it can't find libperl.so (ie, the Perl interpreter)
not plperl.so. Do you have a libperl.so? Is it in your ldconfig search
path?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly
Hi Steve and Tom,
Thanks for the tip, I was clearly not reading the error message closely
enough.
I copied libperl.so into /lib, and now everything works.
Many thanks,
Eric
Steve Atkins wrote: On Fri, Oct 22, 2004 at 12:13:12PM -0400, Eric E wrote:
Hi, I have an installation of Postgres 7.4.2 on SuSE 9.1. This version of SuSE comes with a binary for plperl and several other postgres procedural languages. All the others, including plpgsql install without a problem, but executing: createlang -u postgres plperl template1 produces the result: createlang: language installation failed: ERROR: could not load library "/usr/lib/postgresql/plperl.so": libperl.so: cannot open shared object file: No such file or directory
The file, however, is there:
# ls -l /usr/lib/postgresql/plperl.so -rwxr-xr-x 1 root root 37097 Apr 5 2004 /usr/lib/postgresql/plperl.so
Some googling gave me the idea that it may be a problem with the way perl was compiled - i.e, perl is not compiled for shared libraries. Can anyone confirm this? If so, do I need to rebuild perl, or pl/perl, or both? Are there any binaries that can resolve this? (yes not wanting to compile plperl is plain old laziness, but I do have reservations about recompiling the perl interpreter)
The error message gives you the hint you need. The missing file isn't plperl.so - it's libperl.so.
libperl.so is the dynamic library version of perl. It's not usually installed by most people building perl. (It's also not neccesarily needed by plperl.so, as libperl.a can be statically linked into plperl.so, I believe).
I don't know SuSEs package system (I always install from source) but there may well be another perl package that would provide libperl.so. Failing that you'll either need to build a perl installation and tell Configure to build libperl.so, or rebuild plperl.so. It's also possible that you do have libperl.so somewhere, but it's not on the standard library search path and not where plperl expects to find it.
'ldd' is a useful command for tracking down this sort of problem.
Cheers, Steve
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Phil |
last post by:
I realize this is the php group, but I have a question that recurses
back to my php install.
My objective is a pure 64 bit shared object installation of php 5.0 on
UltraSparc Solaris 9 compiled with the Sun Compiler version 8.
My problem is that EVERYTHING builds great EXCEPT that the 6b
distribution of JPEG will NOT build a shared object, thus gd cannot
include support for JPEG, thus php loses that functionality.
|
by: Douglass Turner |
last post by:
Hi,
Please release me from my own private hell.
Platform: SuSE 8.1
I'm installing python 2.3 tarball as follows:
../configure --enable-shared
make
|
by: Joshua D. Drake |
last post by:
Hello,
There is now an updated version of plPerl with trigger support
available at the Command Prompt community page. It can
be viewed with documentation here:
https://www.commandprompt.com/entry.lxp?lxpe=285
Sincerely,
Joshua Drake
|
by: Christopher Murtagh |
last post by:
Greetings,
I'm trying to build 7.3.4 and I've come across two problems, one during
the configure and the other afterward.
Problem 1)
Trying to build with openssl support gives this:
../configure --with-openssl --enable-odbc --with-perl --enable-multibyte
|
by: Ed L. |
last post by:
I'm trying to load plperl to experiment with it in 7.3.4 with perl v5.8.0.
I've basically tried the following:
configure --with-perl, then
initdb, then
start postmaster, then
createlang plplerl template1
No matter what I try, I keep getting this error:
| |
by: Gianni Mariani |
last post by:
Before I go deep into this - does anyone have the quick fix for this ?
Some facts - the 7.3.4 version of plperl.c has the same errors in the
7.4 tree.
The 7.4 version of plperl.c (with some error handling API calls
commented out) compiles fine in the 7.3.4 tree.
(Same machine - same install of perl !) Points to using some alternate
perl API probably by macro collision ?
|
by: gilles.rayrat |
last post by:
Hi,
I am facing a weird issue:
We are using a shared library (libcarob) that can throw exceptions.
Everything goes well under most platforms, but under suse (SLES 9, gcc
3.3.3), we get a segfault anytime we try to throw an exception out of
carob.
The weird thing is that when linking statically carob to the libstdc++,
the problem disappears. Google showed nothing convincing, so I try
other
|
by: David T. Ashley |
last post by:
I've occasionally had trouble compiling and linking programs that use shared
libraries. That never made a lot of sense to me, because I thought the
operating system went hunting for the symbols and libraries at runtime (and
not before).
Questions:
a)How do the development tools know that a given symbol (a function entry
point, for example) is located in a shared library and won't be linked in
statically?
|
by: rski |
last post by:
I've installed postgres v. 8.2.4 with plperl support (--with-perl option with configure).
But when I try to create plperl languge (createlang plperl) i've got an error
createlang: language installation failed: ERROR: could not load library "/usr/ocal/pgsql/lib/plperl.so": /usr/local/pgsql/lib/plperl.so: undefined symbol: Perl_croak
can somebody explain where the problem is. File /usr/local/pgsql/plperl.so exists.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |