[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] "Undefined symbol: nth" errors when adding
From:       "Michael Thadani" <michael.thadani () rlmgroup ! com ! au>
Date:       2006-04-26 1:05:40
Message-ID: 6B497232C18D86469157DD518C14201970267B () srv002 ! rlmgroup ! com ! au
[Download RAW message or body]

Hi there,

 

I am trying to install postgis on an installation of PostgresSQL 8.1.3.

I installed postgres from source and the automated test performs without
errors. I also downloaded the GEOS and PROJ libraries and installed them
as directed (./configure, make, make install).

 

I followed the instructions on installing postgis (again, ./configure,
make, make install) but when attempting to add the lwpostgis.sql file, I
receive a slew of errors.

 

Originally my attempts to use this file produced 

>NOTICE:  type "histogram2d" is not yet defined

>DETAIL:  Creating a shell type definition.

>ERROR:  could not access file "$libdir/liblwgeom.so.1.1": No such file
or directory

 

However, after sed'ing the sql to replace $libdir with my pgsql
directory I now receive 

>NOTICE:  type "histogram2d" is not yet defined

>DETAIL:  Creating a shell type definition.

>ERROR:  could not load library "/usr/lib64/pgsql/liblwgeom.so.1.1":
/usr/lib64/pgsql/liblwgeom.so.1.1: undefined symbol: nth

 

I noticed that someone else had encountered this issue before
(http://postgis.refractions.net/pipermail/postgis-devel/2006-February/00
1977.html) but have been unable to find information about how to resolve
it.

 

For reference, I am installing on RH Enterprise Linux 3.

The details of ./configure from postgis are

 

>SUMMARY

> -------------------------------------------------------

>  

> HOST_OS: linux-gnu

>  

>   PGSQL: /usr/local/pgsql/bin/pg_config

>    GEOS: /usr/local/bin/geos-config (with C-API)

>    PROJ: dir=/usr/local

>   ICONV: 1

   

> PORTNAME: linux

>   PREFIX: /usr/local/pgsql

>  EPREFIX: ${prefix}

>      DOC: /usr/local/pgsql/doc/contrib

>     DATA: /usr/local/pgsql/share/contrib

>      MAN: /usr/local/pgsql/man

>      BIN: /usr/local/pgsql/bin

>      EXT: /usr/local/pgsql/lib (\$$libdir)

> -------------------------------------------------------

 

The output from pg_config is

[mthadani@localhost postgis-1.1.2]$ pg_config

>BINDIR = /usr/local/pgsql/bin

>DOCDIR = /usr/local/pgsql/doc

>INCLUDEDIR = /usr/local/pgsql/include

>PKGINCLUDEDIR = /usr/local/pgsql/include

>INCLUDEDIR-SERVER = /usr/local/pgsql/include/server

>LIBDIR = /usr/local/pgsql/lib

>PKGLIBDIR = /usr/local/pgsql/lib

>LOCALEDIR =

>MANDIR = /usr/local/pgsql/man

>SHAREDIR = /usr/local/pgsql/share

>SYSCONFDIR = /usr/local/pgsql/etc

>PGXS = /usr/local/pgsql/lib/pgxs/src/makefiles/pgxs.mk

>CONFIGURE =

>CC = gcc

>CPPFLAGS = -D_GNU_SOURCE

>CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline
-Wdeclaration-after-statement -fno-strict-aliasing

>CFLAGS_SL = -fpic

>LDFLAGS = -Wl,-rpath,/usr/local/pgsql/lib

>LDFLAGS_SL =

>LIBS = -lpgport -lz -lreadline -ltermcap -lcrypt -lresolv -lnsl -ldl
-lm -lbsd

>VERSION = PostgreSQL 8.1.3

 

Thanks

 

Michael Thadani

Graduate Software Engineer

---------------------------------------------------

RLM Systems Pty. Ltd.

Email: michael.thadani@rlmgroup.com.au

 


[Attachment #3 (text/html)]

<html xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Verdana;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:Arial;
	color:windowtext;}
@page Section1
	{size:595.3pt 841.9pt;
	margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=EN-AU link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi there,<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I am trying to install postgis on an installation of
PostgresSQL 8.1.3.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I installed postgres from source and the automated test
performs without errors. I also downloaded the GEOS and PROJ libraries and
installed them as directed (./configure, make, make \
install).<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I followed the instructions on installing postgis (again,
./configure, make, make install) but when attempting to add the lwpostgis.sql
file, I receive a slew of errors.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Originally my attempts to use this file produced \
<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;NOTICE:&nbsp; type &quot;histogram2d&quot; is not yet
defined<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;DETAIL:&nbsp; Creating a shell type \
definition.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;ERROR:&nbsp; could not access file \
&quot;$libdir/liblwgeom.so.1.1&quot;: No such file or \
directory<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>However, after sed&#8217;ing the sql to replace $libdir with
my pgsql directory I now receive <o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;NOTICE:&nbsp; type &quot;histogram2d&quot; is not yet
defined<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;DETAIL:&nbsp; Creating a shell type \
definition.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;ERROR:&nbsp; could not load library
&quot;/usr/lib64/pgsql/liblwgeom.so.1.1&quot;:
/usr/lib64/pgsql/liblwgeom.so.1.1: undefined symbol: nth<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I noticed that someone else had encountered this issue
before (<a
href="http://postgis.refractions.net/pipermail/postgis-devel/2006-February/001977.html \
">http://postgis.refractions.net/pipermail/postgis-devel/2006-February/001977.html</a>)
 but have been unable to find information about how to resolve \
it.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>For reference, I am installing on RH Enterprise Linux \
3.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The details of ./configure from postgis \
are<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;SUMMARY<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt; \
-------------------------------------------------------<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;&nbsp; <o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt; HOST_OS: linux-gnu<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;&nbsp; <o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;&nbsp;&nbsp; PGSQL: \
/usr/local/pgsql/bin/pg_config<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;&nbsp;&nbsp;&nbsp; GEOS: /usr/local/bin/geos-config
(with C-API)<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;&nbsp;&nbsp;&nbsp; PROJ: \
dir=/usr/local<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;&nbsp;&nbsp; ICONV: 1<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&nbsp;&nbsp; <o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt; PORTNAME: linux<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;&nbsp;&nbsp; PREFIX: \
/usr/local/pgsql<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;&nbsp; EPREFIX: ${prefix}<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DOC:
/usr/local/pgsql/doc/contrib<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;&nbsp;&nbsp;&nbsp;&nbsp; DATA:
/usr/local/pgsql/share/contrib<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MAN: \
/usr/local/pgsql/man<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BIN: \
/usr/local/pgsql/bin<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXT: /usr/local/pgsql/lib
(\$$libdir)<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt; \
-------------------------------------------------------<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The output from pg_config is<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[mthadani@localhost postgis-1.1.2]$ \
pg_config<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;BINDIR = /usr/local/pgsql/bin<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;DOCDIR = /usr/local/pgsql/doc<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;INCLUDEDIR = \
/usr/local/pgsql/include<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;PKGINCLUDEDIR = \
/usr/local/pgsql/include<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;INCLUDEDIR-SERVER = \
/usr/local/pgsql/include/server<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;LIBDIR = /usr/local/pgsql/lib<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;PKGLIBDIR = /usr/local/pgsql/lib<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;LOCALEDIR =<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;MANDIR = /usr/local/pgsql/man<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;SHAREDIR = /usr/local/pgsql/share<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;SYSCONFDIR = /usr/local/pgsql/etc<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;PGXS = \
/usr/local/pgsql/lib/pgxs/src/makefiles/pgxs.mk<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;CONFIGURE =<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;CC = gcc<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;CPPFLAGS = -D_GNU_SOURCE<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Winline -Wdeclaration-after-statement \
-fno-strict-aliasing<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;CFLAGS_SL = -fpic<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;LDFLAGS = \
-Wl,-rpath,/usr/local/pgsql/lib<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;LDFLAGS_SL =<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;LIBS = -lpgport -lz -lreadline -ltermcap -lcrypt
-lresolv -lnsl -ldl -lm -lbsd<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&gt;VERSION = PostgreSQL 8.1.3<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks<o:p></o:p></span></font></p>

<p class=MsoNormal><strong><b><font size=3 face=Verdana><span style='font-size:
12.0pt;font-family:Verdana'><o:p>&nbsp;</o:p></span></font></b></strong></p>

<p class=MsoNormal><strong><b><font size=3 face=Verdana><span style='font-size:
12.0pt;font-family:Verdana'>Michael Thadani</span></font></b></strong><font
face=Verdana><span style='font-family:Verdana'><o:p></o:p></span></font></p>

<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>Graduate Software Engineer</span></font><font
face=Verdana><span style='font-family:Verdana'><o:p></o:p></span></font></p>

<p class=MsoNormal><font size=1 face=Arial><span style='font-size:7.5pt;
font-family:Arial'>---------------------------------------------------<o:p></o:p></span></font></p>


<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>RLM Systems Pty. Ltd.</span></font><font face=Verdana><span
style='font-family:Verdana'><o:p></o:p></span></font></p>

<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>Email: michael.thadani@rlmgroup.com.au</span></font><font
face=Verdana><span style='font-family:Verdana'><o:p></o:p></span></font></p>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

</div>

</body>

</html>



[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic