public inbox for [email protected]  

help / color / mirror / Atom feed

From: Erwin de Haan <[email protected]>
To: Christoph Berg <[email protected]>
Cc: [email protected] <[email protected]>
Subject: RE: Postgis raster2pgsql build with libx265-179 for jammy (22.04) but jammy does not ship this version
Date: Fri, 14 Apr 2023 08:56:59 +0000
Message-ID: <AM0PR01MB38431E6F4B7A5BA64EF5CFF0C8999@AM0PR01MB3843.eurprd01.prod.exchangelabs.com> (raw)
In-Reply-To: <[email protected]>
References: <AM0PR01MB38436B40FD14FC64E23A19F5C8989@AM0PR01MB3843.eurprd01.prod.exchangelabs.com>
	<[email protected]>

Hi Christoph,

Thank you for your response, your use of ldd triggered finding my way to my solution.
This was my thought process, in the end it was a custom build libheif (build for a custom imagemagick from before an OS upgrade, still on focal). Maybe this little dump of info is useful for someone who gets here via Google.

Alright I did some digging and this is the output for the ldd command for me. I also noticed that actually loading the postgis_raster extension gives the same error in postgresql 15.

$ ldd /usr/lib/postgresql/15/lib/postgis_raster-3.so | grep libx2
        libx265.so.179 => not found
$ ldd /usr/bin/raster2pgsql | grep libx2
        libx265.so.179 => not found

debsums postgresql-15-postgis-3 and debsums postgis give all OK's

$ md5sum /usr/bin/raster2pgsql
6e2debfe1e7cfc85db6073272081639b  /usr/bin/raster2pgsql
$ md5sum /usr/lib/postgresql/15/lib/postgis_raster-3.so
8b5f432aea770b2d45a3f2e271e398b6  /usr/lib/postgresql/15/lib/postgis_raster-3.so

apt-cache show postgis
gives
MD5sum: 4ece3e079d25e11fb4d998012bbc9222

apt-cache show postgresql-15-postgis-3
gives
MD5sum: 95445f1cbf72629238663b744e69820c

And the live deb files:

$ curl -s http://apt.postgresql.org/pub/repos/apt/pool/main/p/postgis/postgresql-15-postgis-3_3.3.2+dfsg-1.pgd... | md5sum
95445f1cbf72629238663b744e69820c  -

$ curl -s http://apt.postgresql.org/pub/repos/apt/pool/main/p/postgis/postgis_3.3.2+dfsg-1.pgdg22.04+1_amd64.d... | md5sum
4ece3e079d25e11fb4d998012bbc9222  -

So that seems to match. The files did come from the official deb http://apt.postgresql.org/pub/repos/apt/ jammy-pgdg main source.

So I went to dig further (lddtree was very helpful here), and I think I found the culprit in lib-heif installed by imei (imagemagick builder script) pre distro upgrade. So libgdal30.so loaded that one before the one build for jammy from the package repos.

Because all the hashes seemed to match, I didn't think to go look deeper until the very last moment. I'm sorry for coming to my conclusion so quickly before. lddtree and dpkg -S were really helpful in finding the actual culprit package (imei-libheif in my case). I did want to write a final message because maybe this helps someone who is searching in the future.

Kind regards,

---
Erwin de Haan

-----Original Message-----
From: Christoph Berg <[email protected]> 
Sent: donderdag 13 april 2023 20:39
To: Erwin de Haan <[email protected]>
Cc: [email protected]
Subject: Re: Postgis raster2pgsql build with libx265-179 for jammy (22.04) but jammy does not ship this version

[You don't often get email from [email protected]. Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ]

Re: Erwin de Haan
> > raster2pgsql
> raster2pgsql: error while loading shared libraries: libx265.so.179: 
> cannot open shared object file: No such file or directory

Hi Erwin,

works for me:

[email protected]:~ $ raster2pgsql
RELEASE: 3.3.2 GDAL_VERSION=34 (4975da8)

[email protected]:~ $ ldd /usr/bin/raster2pgsql | grep libx2
        libx265.so.199 => /lib/x86_64-linux-gnu/libx265.so.199 (0x00007fb0b8631000)

Do you perhaps have a locally compiled postgis in /usr/local or the like?

Christoph

view thread (3+ messages)

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: Postgis raster2pgsql build with libx265-179 for jammy (22.04) but jammy does not ship this version
  In-Reply-To: <AM0PR01MB38431E6F4B7A5BA64EF5CFF0C8999@AM0PR01MB3843.eurprd01.prod.exchangelabs.com>

* 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