RE: pgadmin4 Installation (Dependency?) Issue on RHEL 8

Hi all —

I’m going to try asking Red Hat about this too to see if there’s something really weird we are doing on our end, but checking to see if there were any issues found on the repo side?

Thanks,
Krunal

From: Krunal Desai <kdesai(at)FirstMode(dot)com>
Sent: Tuesday, January 21, 2020 15:02
To: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>; Devrim Gunduz <devrim(dot)gunduz(at)enterprisedb(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: RE: pgadmin4 Installation (Dependency?) Issue on RHEL 8

Hi Akshay, Devrim —

Is there any other information I can provide that would in identifying the issue? I’d imagine others would be running into this on RHEL 8, so maybe I have a local configuration problem? I have been able to replicate this error on two RHEL machines.

Thanks,
Krunal

From: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com<mailto:akshay(dot)joshi(at)enterprisedb(dot)com>>
Sent: Sunday, January 12, 2020 21:30
To: Devrim Gunduz <devrim(dot)gunduz(at)enterprisedb(dot)com<mailto:devrim(dot)gunduz(at)enterprisedb(dot)com>>
Cc: pgadmin-support(at)postgresql(dot)org<mailto:pgadmin-support(at)postgresql(dot)org>; Krunal Desai <kdesai(at)FirstMode(dot)com<mailto:kdesai(at)FirstMode(dot)com>>
Subject: Re: pgadmin4 Installation (Dependency?) Issue on RHEL 8

Hi Devrim

Can you please look into it.

On Sat, Jan 11, 2020 at 10:27 PM Krunal Desai <kdesai(at)firstmode(dot)com<mailto:kdesai(at)firstmode(dot)com>> wrote:
Hi all -

I have a fresh RHEL 8 installation that I am trying to install pgadmin4 on. I have added the PGDG repos and have successfully installed and started PostegreSQL 11. My repos are as such:

[kdesai(at)leebo ~]$ sudo yum repolist
Updating Subscription Management repositories.
Last metadata expiration check: 0:00:04 ago on Fri 10 Jan 2020 05:35:28 PM PST.
repo id repo name status
*epel Extra Packages for Enterprise Linux 8 - x86_64 4,401
*epel-modular Extra Packages for Enterprise Linux Modular 8 - x86_64 0
pgdg11 PostgreSQL 11 for RHEL/CentOS 8 - x86_64 750
rhel-8-for-x86_64-appstream-rpms Red Hat Enterprise Linux 8 for x86_64 - AppStream (RPMs) 8,406
rhel-8-for-x86_64-baseos-rpms Red Hat Enterprise Linux 8 for x86_64 - BaseOS (RPMs) 3,378

To confirm what versions of packages are available (snipped some irrelevant ones):

[kdesai(at)leebo ~]$ sudo yum --disablerepo="*" --enablerepo="pgdg11" list available
Updating Subscription Management repositories.
Last metadata expiration check: 0:09:03 ago on Fri 10 Jan 2020 04:18:56 PM PST.
Modular dependency problems:

Problem 1: conflicting requests
- nothing provides module(perl:5.26) needed by module perl-DBD-SQLite:1.58:8010020190322125518:073fa5fe-0.x86_64
Problem 2: conflicting requests
- nothing provides module(perl:5.26) needed by module perl-DBI:1.641:8010020190322130042:16b3ab4d-0.x86_64
Available Packages
CGAL.x86_64 4.14-1.rhel8 pgdg11
CGAL-debuginfo.x86_64 4.14-1.rhel8 pgdg11
CGAL-debugsource.x86_64 4.14-1.rhel8 pgdg11
CGAL-demos-source.x86_64 4.14-1.rhel8 pgdg11
CGAL-devel.x86_64 4.14-1.rhel8 pgdg11
<snip>
pgadmin4.x86_64 4.16-2.rhel8 pgdg11
pgadmin4-desktop-common.x86_64 4.16-2.rhel8 pgdg11
pgadmin4-desktop-gnome.noarch 4.16-2.rhel8 pgdg11
pgadmin4-docs.noarch 4.16-2.rhel8 pgdg11
pgadmin4-python3-Flask-Mail.noarch 0.9.1-4.rhel8.1 pgdg11
pgadmin4-python3-brotli.x86_64 1.0.7-9.rhel8 pgdg11
pgadmin4-python3-brotli-debuginfo.x86_64 1.0.7-9.rhel8 pgdg11
pgadmin4-python3-brotli-debugsource.x86_64 1.0.7-9.rhel8 pgdg11
pgadmin4-python3-dateutil.noarch 1:2.8.0-1.rhel8 pgdg11
pgadmin4-python3-dateutil-doc.noarch 1:2.8.0-1.rhel8 pgdg11
pgadmin4-python3-flask.noarch 1:1.0.2-1.rhel8 pgdg11
pgadmin4-python3-flask-babel.noarch 0.11.1-4.rhel8.1 pgdg11
pgadmin4-python3-flask-babelex.noarch 0.9.3-1.rhel8.1 pgdg11
pgadmin4-python3-flask-compress.noarch 1.4.0-1.rhel8 pgdg11
pgadmin4-python3-flask-gravatar.noarch 0.5.0-1.rhel8.1 pgdg11
pgadmin4-python3-flask-htmlmin.noarch 1.5.0-1.rhel8 pgdg11
pgadmin4-python3-flask-login.noarch 0.4.1-1.rhel8 pgdg11
pgadmin4-python3-flask-migrate.noarch 2.4.0-1.rhel8 pgdg11
pgadmin4-python3-flask-paranoid.noarch 0.2-1.rhel8.1 pgdg11
pgadmin4-python3-flask-principal.noarch 0.4.0-14.rhel8.1 pgdg11
pgadmin4-python3-flask-security.noarch 3.0.0-1.rhel8.1 pgdg11
pgadmin4-python3-flask-sqlalchemy.noarch 2.3.2-1.rhel8.1 pgdg11
pgadmin4-python3-flask-wtf.noarch 0.14.2-1.rhel8.1 pgdg11
pgadmin4-python3-htmlmin.noarch 0.1.12-1.rhel8.1 pgdg11
pgadmin4-python3-paramiko.noarch 2.6.0-3.rhel8 pgdg11
pgadmin4-python3-passlib.noarch 1.7.1-1.rhel8.1 pgdg11
pgadmin4-python3-psutil.x86_64 5.5.1-1.rhel8 pgdg11
pgadmin4-python3-psutil-debuginfo.x86_64 5.5.1-1.rhel8 pgdg11
pgadmin4-python3-psutil-debugsource.x86_64 5.5.1-1.rhel8 pgdg11
pgadmin4-python3-simplejson.x86_64 3.16.0-1.rhel8 pgdg11
pgadmin4-python3-simplejson-debuginfo.x86_64 3.16.0-1.rhel8 pgdg11
pgadmin4-python3-simplejson-debugsource.x86_64 3.16.0-1.rhel8 pgdg11
pgadmin4-python3-six.noarch 1.12.0-3.rhel8 pgdg11
pgadmin4-python3-speaklater.noarch 1.3-3.rhel8.1 pgdg11
pgadmin4-python3-sqlalchemy.x86_64 1.2.18-1.rhel8 pgdg11
pgadmin4-python3-sqlalchemy-debuginfo.x86_64 1.2.18-1.rhel8 pgdg11
pgadmin4-python3-sqlalchemy-debugsource.x86_64 1.2.18-1.rhel8 pgdg11
pgadmin4-python3-sqlparse.noarch 0.2.4-1.rhel8.1 pgdg11
pgadmin4-python3-sshtunnel.noarch 0.1.4-1.rhel8 pgdg11
pgadmin4-python3-werkzeug.noarch 0.15.4-1.rhel8 pgdg11
pgadmin4-python3-wtforms.noarch 2.2.1-1.rhel8 pgdg11
pgadmin4-pytz.noarch 2018.9-1.rhel8 pgdg11
pgadmin4-web.noarch 4.16-2.rhel8 pgdg11
<snip>
postgresql-jdbc.noarch 42.2.9-1.rhel8 pgdg11
postgresql-jdbc-javadoc.noarch 42.2.9-1.rhel8 pgdg11
postgresql-unit11.x86_64 7.2-1.rhel8 pgdg11
postgresql-unit11-debuginfo.x86_64 7.2-1.rhel8 pgdg11
postgresql-unit11-debugsource.x86_64 7.2-1.rhel8 pgdg11
postgresql11-contrib.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-contrib-debuginfo.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-debuginfo.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-debugsource.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-devel.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-devel-debuginfo.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-docs.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-libs-debuginfo.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-llvmjit.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-llvmjit-debuginfo.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-odbc.x86_64 12.00.0000-1PGDG.rhel8 pgdg11
postgresql11-plperl.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-plperl-debuginfo.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-plpython.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-plpython-debuginfo.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-plpython3.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-plpython3-debuginfo.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-pltcl.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-pltcl-debuginfo.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-server-debuginfo.x86_64 11.6-2PGDG.rhel8 pgdg11
postgresql11-tcl.x86_64 2.4.0-2.rhel8.1 pgdg11
<snip>
timescaledb_11.x86_64 1.5.1-1.rhel8 pgdg11
timescaledb_11-debuginfo.x86_64 1.5.1-1.rhel8 pgdg11
timescaledb_11-debugsource.x86_64 1.5.1-1.rhel8 pgdg11
topn_11.x86_64 2.3.0-1.rhel8 pgdg11
topn_11-debuginfo.x86_64 2.3.0-1.rhel8 pgdg11
topn_11-debugsource.x86_64 2.3.0-1.rhel8 pgdg11
wal2json11.x86_64 2.0-2.rhel8 pgdg11
wal2json11-debuginfo.x86_64 2.0-2.rhel8 pgdg11
wal2json11-debugsource.x86_64 2.0-2.rhel8 pgdg11

The specific error I get:

[kdesai(at)leebo ~]$ sudo yum install pgadmin4*
Updating Subscription Management repositories.
Last metadata expiration check: 0:02:36 ago on Fri 10 Jan 2020 05:35:28 PM PST.
Error:
Problem 1: cannot install the best candidate for the job
- nothing provides python3-unittest2 needed by pgadmin4-web-4.16-2.rhel8.noarch
Problem 2: cannot install the best candidate for the job
- nothing provides qt >= 5.1 needed by pgadmin4-desktop-common-4.16-2.rhel8.x86_64
Problem 3: cannot install the best candidate for the job
- nothing provides qt >= 5.1 needed by pgadmin4-desktop-gnome-4.16-2.rhel8.noarch
- nothing provides gnome-shell-extension-topicons-plus needed by pgadmin4-desktop-gnome-4.16-2.rhel8.noarch
Problem 4: package pgadmin4-4.16-2.rhel8.x86_64 requires pgadmin4-web, but none of the providers can be installed
- cannot install the best candidate for the job
- nothing provides python3-flask-sqlalchemy >= 2.3.2 needed by pgadmin4-web-4.13-1.rhel8.noarch
- nothing provides python3-crypto >= 2.6.1 needed by pgadmin4-web-4.13-1.rhel8.noarch
- nothing provides python3-unittest2 needed by pgadmin4-web-4.13-1.rhel8.noarch
- nothing provides python3-flask-sqlalchemy >= 2.3.2 needed by pgadmin4-web-4.16-1.rhel8.noarch
- nothing provides pgadmin4-python3-unittest2 needed by pgadmin4-web-4.16-1.rhel8.noarch
- nothing provides python3-unittest2 needed by pgadmin4-web-4.16-2.rhel8.noarch
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)
[kdesai(at)leebo ~]$

I was trying to install this back in October and ran into the same issue; am I just missing something silly here? I notice that the packages it claims it can't find don't have the pgadmin4- prefix in front of them.

Thanks,
Krunal

--
Thanks & Regards
Akshay Joshi
Sr. Software Architect
EnterpriseDB Software India Private Limited
Mobile: +91 976-788-8246