Bug 2143703

Summary: RHEL 8 Postgis 3.3.2 requires gdal35-libs >= 3.5.2
Product: [Fedora] Fedora EPEL Reporter: Marcelo Marques <mmarques>
Component: gdalAssignee: markusN <neteler>
Status: CLOSED NOTABUG QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: medium Docs Contact:
Priority: unspecified    
Version: epel8CC: alex, devrim, jmlich83, manisandro, neteler, oliver, pavel.lisy, pertusus, praiskup
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2022-12-09 23:42:38 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

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