AW: BUG #16859: PostGIS 30 and 31 installation on SLES15 SP2 missing package SFCGAL or gmp - Mailing list pgsql-bugs
| From | Kämpf, Heiko (OWL-IT) |
|---|---|
| Subject | AW: BUG #16859: PostGIS 30 and 31 installation on SLES15 SP2 missing package SFCGAL or gmp |
| Date | |
| Msg-id | 1d4fdaedbfe349adbad3342209554b8a@owl-it.de Whole thread Raw |
| In response to | Re: BUG #16859: PostGIS 30 and 31 installation on SLES15 SP2 missing package SFCGAL or gmp (Devrim Gündüz <devrim@gunduz.org>) |
| Responses |
Re: AW: BUG #16859: PostGIS 30 and 31 installation on SLES15 SP2 missing package SFCGAL or gmp
(Devrim Gündüz <devrim@gunduz.org>)
|
| List | pgsql-bugs |
Dear Devrim Gündüz,
many thanks for updating the repositories.
The problem about SFCGAL and gmp seems to be solved, but library libjson-c.so.5()(64bit) is missing, also.
In SLES 15 SP2 there is just version 3 of this library included, it seems.
Please find below detailed information:
.
....
.......
# zypper in postgis30_11
Refreshing service 'spacewalk'.
Loading repository data...
Reading installed packages...
Resolving package dependencies...
Problem: nothing provides libjson-c.so.5()(64bit) 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 postgis31_12
Refreshing service 'spacewalk'.
Loading repository data...
Reading installed packages...
Resolving package dependencies...
Problem: nothing provides libjson-c.so.5()(64bit) needed by postgis31_12-3.1.1-1.sles15.x86_64
Solution 1: do not install postgis31_12-3.1.1-1.sles15.x86_64
Solution 2: break postgis31_12-3.1.1-1.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 lr
Refreshing service 'spacewalk'.
Repository priorities are without effect. All enabled repositories share the same priority.
# | Alias | Name
| Enabled | GPG Check | Refresh
---+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------+---------+-----------+--------
1 | spacewalk:dev-gkdzen-postgresql11-for-sle15-sp2-packages-x86_64 | DEV - GKDZEN - PostgreSQL11 for
SLES15-SP2-packages-x86_64 | Yes | ( p) Yes | Yes
2 | spacewalk:dev-gkdzen-postgresql12-for-sle15-sp2-packages-x86_64 | DEV - GKDZEN - PostgreSQL12 for
SLES15-SP2-packages-x86_64 | Yes | ( p) Yes | Yes
3 | spacewalk:dev-gkdzen-postgresql13-for-sle15-sp2-packages-x86_64 | DEV - GKDZEN - PostgreSQL13 for
SLES15-SP2-packages-x86_64 | Yes | ( p) Yes | Yes
4 | spacewalk:dev-gkdzen-sle-manager-tools15-updates-x86_64-sp2 | DEV - GKDZEN -
SLE-Manager-Tools15-Updatesfor x86_64 SP2 | Yes | ( p) Yes | Yes
5 | spacewalk:dev-gkdzen-sle-module-basesystem15-sp2-updates-x86_64 | DEV - GKDZEN -
SLE-Module-Basesystem15-SP2-Updatesfor x86_64 | Yes | ( p) Yes | Yes
6 | spacewalk:dev-gkdzen-sle-module-devtools15-sp2-updates-x86_64 | DEV - GKDZEN -
SLE-Module-DevTools15-SP2-Updatesfor x86_64 | Yes | ( p) Yes | Yes
7 | spacewalk:dev-gkdzen-sle-module-packagehub-subpackages15-sp2-pool-x86_64 | DEV - GKDZEN -
SLE-Module-Packagehub-Subpackages15-SP2-Poolfor x86_64 | Yes | ( p) Yes | Yes
8 | spacewalk:dev-gkdzen-sle-module-packagehub-subpackages15-sp2-updates-x86_64 | DEV - GKDZEN -
SLE-Module-Packagehub-Subpackages15-SP2-Updatesfor x86_64 | Yes | ( p) Yes | Yes
9 | spacewalk:dev-gkdzen-sle-module-server-applications15-sp2-updates-x86_64 | DEV - GKDZEN -
SLE-Module-Server-Applications15-SP2-Updatesfor x86_64 | Yes | ( p) Yes | Yes
10 | spacewalk:dev-gkdzen-sle-product-sles15-sp2-updates-x86_64 | DEV - GKDZEN -
SLE-Product-SLES15-SP2-Updatesfor x86_64 | Yes | ( p) Yes | Yes
11 | spacewalk:dev-gkdzen-suse-packagehub-15-sp2-backports-pool-x86_64 | DEV - GKDZEN -
SUSE-PackageHub-15-SP2-Backports-Poolfor x86_64 | Yes | ( p) Yes | Yes
12 | spacewalk:dev-gkdzen-suse-packagehub-15-sp2-pool-x86_64 | DEV - GKDZEN -
SUSE-PackageHub-15-SP2-Poolfor x86_64 | Yes | ( p) Yes | Yes
13 | spacewalk:gkdzen-sle-manager-tools15-pool-x86_64-sp2 | GKDZEN - SLE-Manager-Tools15-Pool
forx86_64 SP2 | Yes | ( p) Yes | Yes
14 | spacewalk:gkdzen-sle-module-basesystem15-sp2-pool-x86_64 | GKDZEN -
SLE-Module-Basesystem15-SP2-Poolfor x86_64 | Yes | ( p) Yes | Yes
15 | spacewalk:gkdzen-sle-module-devtools15-sp2-pool-x86_64 | GKDZEN -
SLE-Module-DevTools15-SP2-Poolfor x86_64 | Yes | ( p) Yes | Yes
16 | spacewalk:gkdzen-sle-module-server-applications15-sp2-pool-x86_64 | GKDZEN -
SLE-Module-Server-Applications15-SP2-Poolfor x86_64 | Yes | ( p) Yes | Yes
17 | spacewalk:gkdzen-sle-product-sles15-sp2-pool-x86_64 | GKDZEN - SLE-Product-SLES15-SP2-Pool
forx86_64 | Yes | ( p) Yes | Yes
18 | spacewalk:security-asap-gkdzen-sle-product-sles15-sp2-updates-x86_64 | Security-ASAP Exceptions - GKDZEN
SLE-Product-SLES15-SP2-Updatesfor x86_64 | Yes | ( p) Yes | Yes
# zypper se libjson
Refreshing service 'spacewalk'.
Loading repository data...
Reading installed packages...
S | Name | Summary | Type
--+-----------------------+--------------------------------------------------+--------
| libjson-c-devel | Development headers and libraries for json-c | package
i | libjson-c3 | JSON-C shared library | package
| libjson-c3-32bit | JSON-C shared library | package
| libjson-glib-1_0-0 | Library for JavaScript Object Notation format | package
| libjsoncpp19 | Shared library for jsoncpp | package
| libjsonrpc-glib-1_0-1 | Library to communicate with JSON-RPC based peers | package
| libjsonrpc_glib-1_0-0 | Library to communicate with JSON-RPC based peers | package
# rpm -qli libjson-c3
Name : libjson-c3
Version : 0.13
Release : 1.19
Architecture: x86_64
Install Date: Tue Feb 2 08:28:43 2021
Group : System/Libraries
Size : 66413
License : MIT
Signature : RSA/SHA256, Fri May 25 20:12:59 2018, Key ID 70af9e8139db7c82
Source RPM : json-c-0.13-1.19.src.rpm
Build Date : Fri May 25 20:12:50 2018
Build Host : sheep66
Relocations : (not relocatable)
Packager : https://www.suse.com/
Vendor : SUSE LLC <https://www.suse.com/>
URL : https://github.com/json-c/json-c/wiki
Summary : JSON-C shared library
Description :
JSON-C implements a reference counting object model that allows you to
easily construct JSON objects in C, output them as JSON formatted
strings and parse JSON formatted strings back into the C
representation of JSON objects.
This package includes the JSON library.
Distribution: SUSE Linux Enterprise 15
/usr/lib64/libjson-c.so.3
/usr/lib64/libjson-c.so.3.0.1
/usr/share/doc/packages/libjson-c3
/usr/share/doc/packages/libjson-c3/COPYING
........
.....
..
.
Kind regards
Heiko
-----Ursprüngliche Nachricht-----
Von: Devrim Gündüz <devrim@gunduz.org>
Gesendet: Freitag, 12. Februar 2021 02:10
An: Kämpf, Heiko (OWL-IT) <h.kaempf@owl-it.de>; pgsql-bugs@lists.postgresql.org
Betreff: Re: BUG #16859: PostGIS 30 and 31 installation on SLES15 SP2 missing package SFCGAL or gmp
Hi,
Thanks for the report. Looks like I fixed the gmp issue in the spec files already, but did not update the repo.
SFCGAL issue was about a sync problem, which I fixed (which affected a few more packages). Sorry for the
inconvenience.
Used this opportunity to release 3.1.1 on SLES 15 as well. The new packages (3.1.1-1 and 3.0.3-5) are now in the repo.
Pleaserun
zypper refresh
to make sure that the metadata is up2date.
Let me know if you see more issues.
Regards, Devrim
On Wed, 2021-02-10 at 07:24 +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 16859
> Logged by: heiko kaempf
> Email address: h.kaempf@owl-it.de PostgreSQL version: 12.0
> Operating system: SUSE Linux Enterprise Server 15 SP2
> Description:
>
> Dear PostgreSQL developer team,
>
> we have just incuded repositories of PostgreSQL 11, 12 and 13 for
> SLES15 SP2 to our SUSE Manager environment from the following download
> links:
> https://download.postgresql.org/pub/repos/zypp/11/suse/sles-15.2-x86_6
> 4/
> https://download.postgresql.org/pub/repos/zypp/12/suse/sles-15.2-x86_6
> 4/
> https://download.postgresql.org/pub/repos/zypp/13/suse/sles-15.2-x86_6
> 4/
>
> When trying to install PostGIS version 30 or 31 for PostgreSQL 11, 12
> or
> 13
> there is a dependency to missing packages SFCGAL or gmp.
>
> Please find below detailed version of our Linux version and the error
> messages:
>
> # cat /etc/os-release
> NAME="SLES"
> VERSION="15-SP2"
> VERSION_ID="15.2"
> PRETTY_NAME="SUSE Linux Enterprise Server 15 SP2"
> ID="sles"
> ID_LIKE="suse"
> ANSI_COLOR="0;32"
> CPE_NAME="cpe:/o:suse:sles:15:sp2"
>
> # zypper in postgis30_11
> Refreshing service 'spacewalk'.
> Loading repository data...
> Reading installed packages...
> Resolving package dependencies...
>
> Problem: nothing provides SFCGAL 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...
>
> Problem: nothing provides gmp needed by postgis30_12-3.0.3-
> 4.sles15.x86_64
> Solution 1: do not install postgis30_12-3.0.3-4.sles15.x86_64
> Solution 2: break postgis30_12-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_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...
>
> Problem: nothing provides SFCGAL needed by
> postgis31_11-3.1.0-2.sles15.x86_64
> Solution 1: do not install postgis31_11-3.1.0-2.sles15.x86_64
> Solution 2: break postgis31_11-3.1.0-2.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_12
> Refreshing service 'spacewalk'.
> Loading repository data...
> Reading installed packages...
> Resolving package dependencies...
>
> Problem: nothing provides gmp needed by postgis31_12-3.1.0-
> 2.sles15.x86_64
> Solution 1: do not install postgis31_12-3.1.0-2.sles15.x86_64
> Solution 2: break postgis31_12-3.1.0-2.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_13
>
> Loading repository data...
> Reading installed packages...
> Resolving package dependencies...
>
> Problem: nothing provides gmp needed by postgis31_13-3.1.0-
> 2.sles15.x86_64
> Solution 1: do not install postgis31_13-3.1.0-2.sles15.x86_64
> Solution 2: break postgis31_13-3.1.0-2.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.
>
> Many thanks
> Kind regard
> Heiko Kaempf
>
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
pgsql-bugs by date: