Bug 2143703 - RHEL 8 Postgis 3.3.2 requires gdal35-libs >= 3.5.2
Summary: RHEL 8 Postgis 3.3.2 requires gdal35-libs >= 3.5.2
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Fedora EPEL
Classification: Fedora
Component: gdal
Version: epel8
Hardware: x86_64
OS: Linux
unspecified
medium
Target Milestone: ---
Assignee: markusN
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2022-11-17 15:24 UTC by Marcelo Marques
Modified: 2022-12-09 23:42 UTC (History)
9 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2022-12-09 23:42:38 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Github fedora-infra bodhi issues 4832 0 None open RHEL 8 Postgis 3.3.2 requires gdal35-libs >= 3.5.2 2022-11-17 15:24:11 UTC

Description Marcelo Marques 2022-11-17 15:24:11 UTC
root@lnx8pg12 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux release 8.6 (Ootpa)

[root@lnx8pg12 ~]# yum install postgis33_13
Updating Subscription Management repositories.
Red Hat Enterprise Linux 8 for x86_64 - BaseOS (RPMs) 17 kB/s | 2.4 kB 00:00
Red Hat Enterprise Linux 8 for x86_64 - AppStream (RPMs) 19 kB/s | 2.8 kB 00:00
EPEL8 x86_64 18 kB/s | 2.7 kB 00:00
Error:
Problem: package postgis33_13-3.3.2-1.rhel8.x86_64 requires gdal35-libs >= 3.5.2, but none of the providers can be installed

package postgis33_13-3.3.2-1.rhel8.x86_64 requires libgdal.so.31()(64bit), but none of the providers can be installed
cannot install the best candidate for the job
nothing provides libqhull_r.so.7()(64bit) needed by gdal35-libs-3.5.2-3.rhel8.x86_64
nothing provides libqhull_r.so.7()(64bit) needed by gdal35-libs-3.5.3-1.rhel8.x86_64
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)
[root@lnx8pg12 ~]# yum install postgis33_12
Updating Subscription Management repositories.
Red Hat Enterprise Linux 8 for x86_64 - BaseOS (RPMs) 15 kB/s | 2.4 kB 00:00
Red Hat Enterprise Linux 8 for x86_64 - AppStream (RPMs) 18 kB/s | 2.8 kB 00:00
EPEL8 x86_64 22 kB/s | 2.7 kB 00:00
Error:
Problem: package postgis33_12-3.3.2-1.rhel8.x86_64 requires gdal35-libs >= 3.5.2, but none of the providers can be installed

package postgis33_12-3.3.2-1.rhel8.x86_64 requires libgdal.so.31()(64bit), but none of the providers can be installed
cannot install the best candidate for the job
nothing provides libqhull_r.so.7()(64bit) needed by gdal35-libs-3.5.2-3.rhel8.x86_64
nothing provides libqhull_r.so.7()(64bit) needed by gdal35-libs-3.5.3-1.rhel8.x86_64
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)

[root@lnx8pg12 ~]# subscription-manager repos --list-enable
+----------------------------------------------------------+
    Available Repositories in /etc/yum.repos.d/redhat.repo
+----------------------------------------------------------+
Repo ID:   rhel-8-for-x86_64-appstream-rpms
Repo Name: Red Hat Enterprise Linux 8 for x86_64 - AppStream (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/rhel8/$releasever/x86_64/appstream/os
Enabled:   1

Repo ID:   rhel-8-for-x86_64-baseos-rpms
Repo Name: Red Hat Enterprise Linux 8 for x86_64 - BaseOS (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/rhel8/$releasever/x86_64/baseos/os
Enabled:   1

Repo ID:   ESRI_EPEL_8_EPEL8_x86_64
Repo Name: EPEL8 x86_64
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/custom/EPEL_8/EPEL8_x86_64
Enabled:   1

-----------------------------------------------------------------------------------------------------------------

CAUSE: RHEL 8 EPEL 8 is missing gdal35-libs >= 3.5.2

NOTE: RHEL 7 works fine to install Postgis 3.3.2 !!! EPEL 7 has all the packages !!!

NOTE: issue was also logged with Redhat Bugzilla and Postgis trac.osgeo

"RHEL 8 Postgis 3.3.2 requires gdal35-libs >= 3.5.2"

RedHat Bugzilla https://bugzilla.redhat.com/show_bug.cgi?id=2143703

Fedora Bodhi https://github.com/fedora-infra/bodhi/issues/4832

PostGIS https://trac.osgeo.org/postgis/ticket/5290#ticket

Comment 1 Devrim Gündüz 2022-11-17 16:17:08 UTC
You are trying to install an RPM via PostgreSQL official RPM repository, and for some reason did not enable common repo. This has nothing to do with Fedora, PostGIS or Red Hat.

Regards, 
Devrim (PostgreSQL RPM packager)

Comment 2 Marcelo Marques 2022-11-17 16:31:03 UTC
(In reply to Devrim Gündüz from comment #1)
> You are trying to install an RPM via PostgreSQL official RPM repository, and
> for some reason did not enable common repo. This has nothing to do with
> Fedora, PostGIS or Red Hat.
> 
> Regards, 
> Devrim (PostgreSQL RPM packager)

I have the repos below enabled.

Repo Name: Red Hat Enterprise Linux 8 for x86_64 - AppStream (RPMs)
Repo Name: Red Hat Enterprise Linux 8 for x86_64 - BaseOS (RPMs)
Repo ID:   ESRI_EPEL_8_EPEL8_x86_64  <== this repo is refreshed daily by the IT department, need the EPEL 8 to install PostgreSQL and Postgis.
Repo Name: EPEL8 x86_64

These are all the repos that are listed for me.

Which one am I missing to enable ??? Thanks in advance.

[root@lnx8pg12 ~]# subscription-manager repos --list
+----------------------------------------------------------+
    Available Repositories in /etc/yum.repos.d/redhat.repo
+----------------------------------------------------------+
Repo ID:   rhocp-4.10-for-rhel-8-x86_64-rpms
Repo Name: Red Hat OpenShift Container Platform 4.10 for RHEL 8 x86_64 (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/layered/rhel8/x86_64/rhocp/4.10/os
Enabled:   0

Repo ID:   ansible-2.8-for-rhel-8-x86_64-rpms
Repo Name: Red Hat Ansible Engine 2.8 for RHEL 8 x86_64 (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/layered/rhel8/x86_64/ansible/2.8/os
Enabled:   0

Repo ID:   satellite-tools-6.6-for-rhel-8-x86_64-rpms
Repo Name: Red Hat Satellite Tools 6.6 for RHEL 8 x86_64 (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/layered/rhel8/x86_64/sat-tools/6.6/os
Enabled:   0

Repo ID:   satellite-tools-6.7-for-rhel-8-x86_64-rpms
Repo Name: Red Hat Satellite Tools 6.7 for RHEL 8 x86_64 (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/layered/rhel8/x86_64/sat-tools/6.7/os
Enabled:   0

Repo ID:   codeready-builder-for-rhel-8-x86_64-rpms
Repo Name: Red Hat CodeReady Linux Builder for RHEL 8 x86_64 (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/rhel8/$releasever/x86_64/codeready-builder/os
Enabled:   0

Repo ID:   rhocp-4.6-for-rhel-8-x86_64-rpms
Repo Name: Red Hat OpenShift Container Platform 4.6 for RHEL 8 x86_64 (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/layered/rhel8/x86_64/rhocp/4.6/os
Enabled:   0

Repo ID:   rhocp-4.8-for-rhel-8-x86_64-rpms
Repo Name: Red Hat OpenShift Container Platform 4.8 for RHEL 8 x86_64 (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/layered/rhel8/x86_64/rhocp/4.8/os
Enabled:   0

Repo ID:   rhel-8-for-x86_64-highavailability-rpms
Repo Name: Red Hat Enterprise Linux 8 for x86_64 - High Availability (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/rhel8/$releasever/x86_64/highavailability/os
Enabled:   0

Repo ID:   rhel-8-for-x86_64-resilientstorage-rpms
Repo Name: Red Hat Enterprise Linux 8 for x86_64 - Resilient Storage (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/rhel8/$releasever/x86_64/resilientstorage/os
Enabled:   0

Repo ID:   rhel-8-for-x86_64-sap-solutions-rpms
Repo Name: Red Hat Enterprise Linux 8 for x86_64 - SAP Solutions (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/rhel8/$releasever/x86_64/sap-solutions/os
Enabled:   0

Repo ID:   rhel-8-for-x86_64-rt-rpms
Repo Name: Red Hat Enterprise Linux 8 for x86_64 - Real Time (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/rhel8/$releasever/x86_64/rt/os
Enabled:   0

Repo ID:   rhel-8-for-x86_64-appstream-rpms
Repo Name: Red Hat Enterprise Linux 8 for x86_64 - AppStream (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/rhel8/$releasever/x86_64/appstream/os
Enabled:   1

Repo ID:   rhel-8-for-x86_64-sap-netweaver-rpms
Repo Name: Red Hat Enterprise Linux 8 for x86_64 - SAP NetWeaver (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/rhel8/$releasever/x86_64/sap/os
Enabled:   0

Repo ID:   satellite-tools-6.8-for-rhel-8-x86_64-rpms
Repo Name: Red Hat Satellite Tools 6.8 for RHEL 8 x86_64 (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/layered/rhel8/x86_64/sat-tools/6.8/os
Enabled:   0

Repo ID:   rhel-8-for-x86_64-baseos-rpms
Repo Name: Red Hat Enterprise Linux 8 for x86_64 - BaseOS (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/rhel8/$releasever/x86_64/baseos/os
Enabled:   1

Repo ID:   rhel-8-for-x86_64-appstream-source-rpms
Repo Name: Red Hat Enterprise Linux 8 for x86_64 - AppStream (Source RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/rhel8/$releasever/x86_64/appstream/source/SRPMS
Enabled:   0

Repo ID:   ESRI_EPEL_8_EPEL8_x86_64
Repo Name: EPEL8 x86_64
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/custom/EPEL_8/EPEL8_x86_64
Enabled:   1

Repo ID:   ansible-2.9-for-rhel-8-x86_64-rpms
Repo Name: Red Hat Ansible Engine 2.9 for RHEL 8 x86_64 (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/layered/rhel8/x86_64/ansible/2.9/os
Enabled:   0

Repo ID:   satellite-tools-6.10-for-rhel-8-x86_64-rpms
Repo Name: Red Hat Satellite Tools 6.10 for RHEL 8 x86_64 (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/layered/rhel8/x86_64/sat-tools/6.10/os
Enabled:   0

Repo ID:   satellite-tools-6.5-for-rhel-8-x86_64-rpms
Repo Name: Red Hat Satellite Tools 6.5 for RHEL 8 x86_64 (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/layered/rhel8/x86_64/sat-tools/6.5/os
Enabled:   0

Repo ID:   rhel-8-for-x86_64-supplementary-rpms
Repo Name: Red Hat Enterprise Linux 8 for x86_64 - Supplementary (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/rhel8/$releasever/x86_64/supplementary/os
Enabled:   0

Repo ID:   satellite-tools-6.9-for-rhel-8-x86_64-rpms
Repo Name: Red Hat Satellite Tools 6.9 for RHEL 8 x86_64 (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/dist/layered/rhel8/x86_64/sat-tools/6.9/os
Enabled:   0

Repo ID:   codeready-builder-for-rhel-8-x86_64-eus-rpms
Repo Name: Red Hat CodeReady Linux Builder for RHEL 8 x86_64 - Extended Update Support (RPMs)
Repo URL:  https://red-inf-cap-p01.esri.com/pulp/repos/ESRI/LEP_Patch/cv_patch/content/eus/rhel8/$releasever/x86_64/codeready-builder/os
Enabled:   0

[root@lnx8pg12 ~]#


-----------------------------------------------------------------------------------------------------------------

Comment 3 Marcelo Marques 2022-12-09 23:42:38 UTC
-----------------------------------------------------------------------------------------------------------------------------
--WORKAROUND !!!
-----------------------------------------------------------------------------------------------------------------------------
https://www.postgresql.org/download/linux/redhat/
# Install the repository RPM:
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# ls -la /etc/yum.repos.d

# yum install gdal35-libs*
Updating Subscription Management repositories.
Red Hat Enterprise Linux 8 for x86_64 - BaseOS (RPMs)                                                                                                   14 kB/s | 2.4 kB     00:00
Red Hat Enterprise Linux 8 for x86_64 - AppStream (RPMs)                                                                                                15 kB/s | 2.8 kB     00:00
EPEL8 x86_64                                                                                                                                            14 kB/s | 2.7 kB     00:00
Error:
 Problem: cannot install the best candidate for the job
  - nothing provides libqhull_r.so.7()(64bit) needed by gdal35-libs-3.5.3-1.rhel8.x86_64
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)
[root@lnx8pg12 ~]#

--NOTE: Many packages, including libqhull, live in the "CodeReady Linux Builder" repo

# subscription-manager repos --enable=codeready-builder-for-rhel-8-x86_64-rpms
# subscription-manager repos --list-enable

# yum install gdal35-libs*  <== works fine this time!!!

--These work fine now!!!
# yum install postgis33_12
# yum install postgis33_13


Note You need to log in before you can comment on or make changes to this bug.