public inbox for [email protected]  
help / color / mirror / Atom feed
From: Justin Pryzby <[email protected]>
To: Devrim Gündüz <[email protected]>
Cc: [email protected]
Subject: Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
Date: Tue, 19 Dec 2017 15:30:13 -0600
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

On Mon, Dec 18, 2017 at 08:56:35AM -0600, Justin Pryzby wrote:
> On Sat, Dec 16, 2017 at 01:01:01PM -0600, Justin Pryzby wrote:
> > On Fri, Dec 15, 2017 at 06:05:51AM +0300, Devrim Gündüz wrote:
> > 
> > > >  proj
> > > 
> > > Please grab this from EPEL:
> > > 
> > > https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/p/
> > 
> > For centos6, I think there's an issue with the version of proj in EPEL combined
> > with postgis10_24:
> > 
> > [pryzbyj@db ~]$ psql 3rivers -f /usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql 2>&1 |head
> ...
> > psql:/usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql:94: ERROR:  could not load library "/usr/pgsql-10/lib/postgis-2.4.so": /usr/pgsql-10/lib/postgis-2.4.so: undefined symbol: pj_get_spheroid_defn
> 
> I meant to also say:
> I think that indicates a missing dependency version in the postgis package.  I
> know that in debian, this kind of thing is handled by dpkg-shlibdeps.

I was doing another deployment (ansible) and again ran into same issue (I
think):

TASK: [legacy_appserver | create postgis environment] ************************* 
failed: [new.gta] => {"failed": true, "item": ""}
msg: Database query failed: could not load library "/usr/pgsql-10/lib/postgis-2.4.so": /usr/pgsql-10/lib/postgis-2.4.so: undefined symbol: geod_init

gdal-libs.x86_64                            1.9.2-8.rhel6                @pgdg10
geos.x86_64                                 3.5.0-1.rhel6                @pgdg10
geos36.x86_64                               3.6.2-2.rhel6                @pgdg10
geos36-devel.x86_64                         3.6.2-2.rhel6                @pgdg10

libgeotiff.x86_64                           1.4.0-1.rhel6                @pgdg96
postgis24_10.x86_64                         2.4.2-3.rhel6                @pgdg10
proj.x86_64                                 4.8.0-2.rhel6                @pgdg10
libspatialite.x86_64                   2.4.0-0.6.RC4.el6                   @epel

I see:
https://trac.osgeo.org/postgis/ticket/3142

[pryzbyj@gta-mtx-telsa ~]$ yum list --showdu proj
Loaded plugins: etckeeper, fastestmirror, security
Loading mirror speeds from cached hostfile
 * base: centos.mirror.ndchost.com
 * epel: mirror.sjc02.svwh.net
 * extras: mirror.lax.hugeserver.com
 * ius: mirror.team-cymru.org
 * updates: mirrors.usc.edu
Installed Packages
proj.x86_64                        4.8.0-2.rhel6                         @pgdg10
Available Packages
proj.i686                          4.7.0-1.el6                           epel   
proj.x86_64                        4.7.0-1.el6                           epel   
proj.x86_64                        4.8.0-2.rhel6                         pgdg10 
proj.x86_64                        4.8.0-2.rhel6                         pgdg96 

I was able to work around by doing:
sudo yum downgrade postgis24_10{,-client,-utils}-2.4.2-1.rhel6

Was the postgis24_10 built against a proj from centos7 or not available in
repo?

-- 
Justin Pryzby
System Administrator
Telsasoft
+1-952-707-8581




view thread (12+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox