AW: BUG #16859: PostGIS 30 and 31 installation on SLES15 SP2 missing package SFCGAL or gmp

Hello Devrim,

we have updated our SUSE Manager with the latest package versions of your download repositories.
But we still have the issue about missing gmp package when installing PostGIS 30 for PostgreSQL 11 or PostGIS 30 for PostgreSQL 13
Can you inform us about a possible solution or workaround for this BUG ID, please.

Many thanks
Kind regards
Heiko

-----Ursprüngliche Nachricht-----
Von: Kämpf, Heiko (OWL-IT)
Gesendet: Dienstag, 16. März 2021 09:18
An: Devrim Gündüz <devrim(at)gunduz(dot)org>
Betreff: AW: BUG #16859: PostGIS 30 and 31 installation on SLES15 SP2 missing package SFCGAL or gmp

Hello Devrim,

is there a chance to solve the issue about missing gmp when installing PostGIS 30 for PostgreSQL 11 or PostGIS 30 for PostgreSQL 13?
Or can we ignore the dependency while installing the packages and these software version are working fine without gmp?

Many thanks
Kind regards
Heiko

-----Ursprüngliche Nachricht-----
Von: Kämpf, Heiko (OWL-IT) <h(dot)kaempf2(at)owl-it(dot)de>
Gesendet: Montag, 22. Februar 2021 10:38
An: Devrim Gündüz <devrim(at)gunduz(dot)org>; Kämpf, Heiko (OWL-IT) <h(dot)kaempf(at)owl-it(dot)de>
Betreff: AW: AW: AW: AW: BUG #16859: PostGIS 30 and 31 installation on SLES15 SP2 missing package SFCGAL or gmp

Hello Devrim,

we have installed libjson-c.so.5()(64bit from the openSUSE repository that you have recommended to us.

Installation of PostGIS 30 for PostgreSQL 11 and PostGIS 30 for PostgreSQL 13 still have the issuue with missing gmp package.
But installation of PostGIS 30 for PostgreSQL 12 and PostGIS 31 for PostgreSQL 11, 12 and 13 is working now.
Please find below the output of our testing from today.

Many thanks
Kind regards
Heiko

# zypper in postgis30_11
Refreshing service 'spacewalk'.
Loading repository data...
Reading installed packages...
Resolving package dependencies...

Problem: nothing provides gmp needed by postgis30_11-3.0.3-4.sles15.x86_64
Solution 1: do not install postgis30_11-3.0.3-4.sles15.x86_64
Solution 2: break postgis30_11-3.0.3-4.sles15.x86_64 by ignoring some of its dependencies

Choose from above solutions by number or cancel [1/2/c/d/?] (c): 1 Resolving dependencies...
Resolving package dependencies...
Nothing to do.

# zypper in postgis30_12
Refreshing service 'spacewalk'.
Loading repository data...
Reading installed packages...
Resolving package dependencies...

The following 17 NEW packages are going to be installed:
CGAL SFCGAL SFCGAL-libs geos39 libboost_atomic1_75_0 libboost_chrono1_75_0 libboost_date_time1_75_0 libboost_serialization1_75_0 libboost_system1_75_0
libgeotiff16 libjpeg62 libprotobuf-c1 libxerces-c-3_1 postgis30_12 proj72 sqlite33 sqlite33-libs

The following 14 packages have no support information from their vendor:
CGAL SFCGAL SFCGAL-libs geos39 libboost_atomic1_75_0 libboost_chrono1_75_0 libboost_date_time1_75_0 libboost_serialization1_75_0 libboost_system1_75_0
libgeotiff16 postgis30_12 proj72 sqlite33 sqlite33-libs

17 new packages to install.
Overall download size: 31.9 MiB. Already cached: 0 B. After the operation, additional 163.3 MiB will be used.
Continue? [y/n/v/...? shows all options] (y): n

# zypper in postgis30_13
Refreshing service 'spacewalk'.
Loading repository data...
Reading installed packages...
Resolving package dependencies...

Problem: nothing provides gmp needed by postgis30_13-3.0.3-4.sles15.x86_64
Solution 1: do not install postgis30_13-3.0.3-4.sles15.x86_64
Solution 2: break postgis30_13-3.0.3-4.sles15.x86_64 by ignoring some of its dependencies

Choose from above solutions by number or cancel [1/2/c/d/?] (c): 1 Resolving dependencies...
Resolving package dependencies...
Nothing to do.

# zypper in postgis31_11
Refreshing service 'spacewalk'.
Loading repository data...
Reading installed packages...
Resolving package dependencies...

The following 16 NEW packages are going to be installed:
CGAL SFCGAL SFCGAL-libs geos39 libboost_atomic1_75_0 libboost_chrono1_75_0 libboost_date_time1_75_0 libboost_serialization1_75_0 libboost_system1_75_0
libgeotiff16 libjpeg62 libxerces-c-3_1 postgis31_11 proj72 sqlite33 sqlite33-libs

The following 14 packages have no support information from their vendor:
CGAL SFCGAL SFCGAL-libs geos39 libboost_atomic1_75_0 libboost_chrono1_75_0 libboost_date_time1_75_0 libboost_serialization1_75_0 libboost_system1_75_0
libgeotiff16 postgis31_11 proj72 sqlite33 sqlite33-libs

16 new packages to install.
Overall download size: 32.0 MiB. Already cached: 0 B. After the operation, additional 163.8 MiB will be used.
Continue? [y/n/v/...? shows all options] (y): n

# zypper in postgis31_12
Refreshing service 'spacewalk'.
Loading repository data...
Reading installed packages...
Resolving package dependencies...

The following 16 NEW packages are going to be installed:
CGAL SFCGAL SFCGAL-libs geos39 libboost_atomic1_75_0 libboost_chrono1_75_0 libboost_date_time1_75_0 libboost_serialization1_75_0 libboost_system1_75_0
libgeotiff16 libjpeg62 libxerces-c-3_1 postgis31_12 proj72 sqlite33 sqlite33-libs

The following 14 packages have no support information from their vendor:
CGAL SFCGAL SFCGAL-libs geos39 libboost_atomic1_75_0 libboost_chrono1_75_0 libboost_date_time1_75_0 libboost_serialization1_75_0 libboost_system1_75_0
libgeotiff16 postgis31_12 proj72 sqlite33 sqlite33-libs

16 new packages to install.
Overall download size: 32.1 MiB. Already cached: 0 B. After the operation, additional 163.9 MiB will be used.
Continue? [y/n/v/...? shows all options] (y): n

# zypper in postgis31_13
Refreshing service 'spacewalk'.
Loading repository data...
Reading installed packages...
Resolving package dependencies...

The following 16 NEW packages are going to be installed:
CGAL SFCGAL SFCGAL-libs geos39 libboost_atomic1_75_0 libboost_chrono1_75_0 libboost_date_time1_75_0 libboost_serialization1_75_0 libboost_system1_75_0
libgeotiff16 libjpeg62 libxerces-c-3_1 postgis31_13 proj72 sqlite33 sqlite33-libs

The following 14 packages have no support information from their vendor:
CGAL SFCGAL SFCGAL-libs geos39 libboost_atomic1_75_0 libboost_chrono1_75_0 libboost_date_time1_75_0 libboost_serialization1_75_0 libboost_system1_75_0
libgeotiff16 postgis31_13 proj72 sqlite33 sqlite33-libs

16 new packages to install.
Overall download size: 32.1 MiB. Already cached: 0 B. After the operation, additional 163.9 MiB will be used.
Continue? [y/n/v/...? shows all options] (y): n ..........
......
...
.

-----Ursprüngliche Nachricht-----
Von: Devrim Gündüz <devrim(at)gunduz(dot)org>
Gesendet: Dienstag, 16. Februar 2021 16:29
An: Kämpf, Heiko (OWL-IT) <h(dot)kaempf2(at)owl-it(dot)de>; Kämpf, Heiko (OWL-IT) <h(dot)kaempf(at)owl-it(dot)de>
Betreff: Re: AW: AW: AW: BUG #16859: PostGIS 30 and 31 installation on SLES15 SP2 missing package SFCGAL or gmp

Hi Heiko,

Let me know if you encounter issues.

Regards, Devrim

On Tue, 2021-02-16 at 06:39 +0000, Kämpf, Heiko (OWL-IT) wrote:
> Hello Devrim,
>
> thanks for the information.
> We will try to implement the repository with the needed library in our
> environment and will keep you informed about the result if the
> installatiin of PostGIS is possible then.
>
> Kind regards
> Heiko
>
> -----Ursprüngliche Nachricht-----
> Von: Devrim Gündüz <devrim(at)gunduz(dot)org>
> Gesendet: Montag, 15. Februar 2021 15:48
> An: Kämpf, Heiko (OWL-IT) <h(dot)kaempf2(at)owl-it(dot)de>; Kämpf, Heiko (OWL-
> IT) <h(dot)kaempf(at)owl-it(dot)de>; pgsql-bugs(at)lists(dot)postgresql(dot)org
> Betreff: Re: AW: AW: BUG #16859: PostGIS 30 and 31 installation on
> SLES15 SP2 missing package SFCGAL or gmp
>
>
> Hi,
>
> On Mon, 2021-02-15 at 13:59 +0000, Kämpf, Heiko (OWL-IT) wrote:
> > many thanks for the last statement about providing opensuse
> > libjson-
> > c5 package.
> > We are aware on how to get software packages from opensuse in
> > general.
> > But we don't want to povide any package from opensuse by it's own to
> > our SUSE Manager environment that is normally used for SUSE Linux
> > Enterprise Software channels.
> > that is provided on the offical PostgreSQL download sites, we expect
> > the library is included to the relevant repositories that are
> > released for SLES15 SP2.
> > PostgreSQL download sites.
>
> If I don't rely on those external repos, we would have half of the
> available packages, maybe even more. I'm not in favor of those repos,
> but that is the fact. SLES does not have an EPEL-like repo, so...
>
> The amount of time that I spent on SLES is already a lot, and I don't
> think I'll maintain another package in the repo for SLES. Sorry about
> that.
>
> Regards,
> --
> Devrim Gündüz
> Open Source Solution Architect, Red Hat Certified Engineer
> Twitter: @DevrimGunduz , @DevrimGunduzTR

--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR