[postgis-users] OpenBSd installation problem

Marcelo Bacha dronsz at gmail.com
Wed Jul 10 14:08:05 PDT 2013 

Here´s the output:

# ldd /usr/local/pgsql/lib/rtpostgis-2.2.so
/usr/local/pgsql/lib/rtpostgis-2.2.so:
        Start    End      Type Open Ref GrpRef Name
        0ee98000 2eebd000 dlib 1    0   0      /usr/local/pgsql/lib/
rtpostgis-2.2.so
        08a43000 28cec000 rlib 0    1   0
 /usr/local/lib/libgdal.so.18.0
        041ef000 241f9000 rlib 0    2   0
 /usr/local/lib/libgeos_c.so.8.8
        003f6000 20400000 rlib 0    1   0      /usr/local/lib/libproj.so.7.0
        0e834000 2e838000 rlib 0    1   0      /usr/local/lib/libjson.so.1.1
        0a36a000 2a391000 rlib 0    2   0
 /usr/local/lib/libxml2.so.14.0
        06045000 2604c000 rlib 0    5   0      /usr/lib/libz.so.4.1
        0fce8000 2fdc8000 rlib 0    5   0
 /usr/local/lib/libiconv.so.6.0
        059df000 259e8000 rlib 0    9   0      /usr/lib/libm.so.7.1
        064e4000 26526000 rlib 0    2   0      /usr/local/lib/libgeos.so
        0dfef000 2dffd000 rlib 0    1   0      /usr/lib/libsqlite3.so.21.0
        07bdf000 27be4000 rlib 0    1   0      /usr/lib/libexpat.so.10.0
        007b8000 207c7000 rlib 0    1   0
 /usr/local/lib/libjasper.so.2.1
        0ae63000 2ae67000 rlib 0    1   0      /usr/local/lib/libgif.so.5.4
        077d1000 277d7000 rlib 0    1   0
 /usr/local/lib/libjpeg.so.64.0
        0978e000 29795000 rlib 0    1   0
 /usr/local/lib/libpng.so.15.14
        09594000 2959c000 rlib 0    1   0      /usr/local/lib/libpq.so.5.5
        00a2d000 20a39000 rlib 0    1   0
 /usr/local/lib/libcurl.so.23.0
        05f63000 25f8f000 rlib 0    2   0      /usr/local/lib/libidn.so.17.0
        02e03000 22e07000 rlib 0    3   0      /usr/local/lib/libintl.so.6.0
        0ab0d000 2ab1a000 rlib 0    3   0      /usr/lib/libssl.so.19.0
        0d71c000 2d75b000 rlib 0    3   0      /usr/lib/libcrypto.so.22.0
        094ce000 294fc000 rlib 0    3   0      /usr/lib/libstdc++.so.55.0

Indeed, there´s no shared object from /usr/local/pgsql/lib, is this correct?

Anyway, I´ve included this path at the /etc/rc.conf shlib_dirs variable, so
rc execute the proper ldconfig command, which is just OK:

# ldconfig -r | grep pgsql
        search directories:
/usr/lib:/usr/X11R6/lib:/usr/local/lib:/usr/local/pgsql/lib
        328:-lpgtypes.3.3 => /usr/local/pgsql/lib/libpgtypes.so.3.3
        329:-lecpg.6.4 => /usr/local/pgsql/lib/libecpg.so.6.4
        331:-lecpg_compat.3.4 => /usr/local/pgsql/lib/libecpg_compat.so.3.4

Marcelo





On Wed, Jul 10, 2013 at 5:06 PM, dustymugs <dustymugs at gmail.com> wrote:

> Marcelo,
>
> See if rtpostgis-2.2.so can find the PostgreSQL libs.
>
> ldd /usr/local/pgsql/lib/rtpostgis-2.2.so
>
> -bborie
>
> On 07/10/2013 12:32 PM, Marcelo Bacha wrote:
> > Thanks Bborie.
> >
> > I went back to PostgreSQL, to check the warnings from compilation. I
> > Corrected a couple of things, applied a recent patch for the configure
> > properly recognize sys/ucred.h, and so on, but nothing changed the
> > situation.
> > Here´s how it´s configured:
> >
> > ./configure --enable-depend --with-openssl --with-libxml --with-libxslt
> > --with-perl --enable-debug --disable-thread-safety
> >
> > I´m running out of ideas...
> >
> > Best,
> > Marcelo
> >
> >
> > On Mon, Jul 1, 2013 at 5:19 PM, Bborie Park <dustymugs at gmail.com> wrote:
> >
> >> Marcelo,
> >>
> >> Those missing symbols are all from PostgreSQL. You'll want to make
> >> sure the PostgreSQL libs and dev files are provided.
> >>
> >> -bborie
> >>
> >> On Mon, Jul 1, 2013 at 1:17 PM, Marcelo Bacha <dronsz at gmail.com> wrote:
> >>> Hi,
> >>>
> >>> This is my first posting, I´m new to Postgis. I´ve seen similar
> problems
> >>> related in lists all around, but this one, I couldn´t manage to solve.
> >>>
> >>> I have an OpenBSD 5.3 server, with PostgreSQL 9.2.4 on it, which always
> >>> worked fine. I have to transfer some geospatial databases from a
> Windows
> >>> server, so I downloaded Postgis from the source (I needed the latest
> >>> versions), configured, compiled & installed it.
> >>> Everything seems to be fine, but when I try to create the postgis
> >> extension
> >>> (with raster support) on psql:
> >>>
> >>>   postgres=# CREATE EXTENSION postgis;
> >>>   ERROR:  could not load library "/usr/local/pgsql/lib/
> rtpostgis-2.2.so
> >> ":
> >>> dlopen (/usr/local/pgsql/lib/rtpostgis-2.2.so) failed: Cannot load
> >> specified
> >>> object
> >>>
> >>> The paths seems all to be OK:
> >>>
> >>>   # ls -l /usr/local/pgsql/lib/*post*
> >>>   -rwxr-xr-x  1 root  wheel  1276039 Jul  1 16:50
> >>> /usr/local/pgsql/lib/postgis-2.2.so
> >>>   -rwxr-xr-x  1 root  wheel  1208861 Jul  1 16:50
> >>> /usr/local/pgsql/lib/rtpostgis-2.2.so
> >>>
> >>> (I know it´s the development, and not the stable release, but the
> results
> >>> are the same with all other releases.)
> >>>
> >>> When I try to preload the rtpostgis shared object setting the
> LD_PRELOAD
> >>> environment variable, I get this on psql:
> >>>
> >>>   $ psql
> >>>   psql:/usr/local/pgsql/lib/rtpostgis-2.2.so: undefined symbol
> >>> 'CurrentMemoryContext'
> >>>   psql:/usr/local/pgsql/lib/rtpostgis-2.2.so: undefined symbol
> >>> 'SPI_tuptable'
> >>>   psql:/usr/local/pgsql/lib/rtpostgis-2.2.so: undefined symbol
> >> 'SPI_result'
> >>>   psql:/usr/local/pgsql/lib/rtpostgis-2.2.so: undefined symbol
> >>> 'InterruptPending'
> >>>   psql:/usr/local/pgsql/lib/rtpostgis-2.2.so: undefined symbol
> >>> 'SPI_processed'
> >>>   psql (9.2.4)
> >>>
> >>> Didn´t find any further useful info setting LD_DEBUG (I may list the
> >> output
> >>> if necessary, anyway).
> >>>
> >>> Any hint on how to solve this? I´m running out of ideas.
> >>>
> >>> Thanks in advance,
> >>> Marcelo
> >>>
> >>>
> >>> _______________________________________________
> >>> postgis-users mailing list
> >>> postgis-users at lists.osgeo.org
> >>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> >>>
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at lists.osgeo.org
> >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> >>
> >
> >
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>



-- 
Editio Princeps
http://www.editioprinceps.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130710/123060df/attachment.html>

More information about the postgis-users mailing list