Обсуждение: Installing pgAdmin 4 in Oracle Enterprise Linux 7

On 10/02/2016 10:52 AM, Edson Richter wrote:
> Dear community,
>
>
> I'm trying to install pgAdmin4 in Oracle EL 7.
>
> I've already installed PostgreSQL 9.6 final in same server (have EPEL
> enabled, as well pgdg 9.6 repos).
>
> Running "yum install pgadmin4-web" I get the following result:
>
>
> "[root@backup1 yum.repos.d]# LANG=C yum install pgadmin4-web
>
> Loaded plugins: ulninfo
> Resolving Dependencies
> --> Running transaction check
> ---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
> --> Processing Dependency: python-psycopg2-debug >= 2.6.2 for package:
> pgadmin4-web-1.0-1.rhel7.noarch
> --> Processing Dependency: python-passlib >= 1.6.2 for package:
> pgadmin4-web-1.0-1.rhel7.noarch
> --> Processing Dependency: python-html5lib >= 1.0b3 for package:
> pgadmin4-web-1.0-1.rhel7.noarch
> --> Processing Dependency: python-crypto >= 2.6.1 for package:
> pgadmin4-web-1.0-1.rhel7.noarch
> --> Processing Dependency: python-blinker >= 1.3 for package:
> pgadmin4-web-1.0-1.rhel7.noarch
> --> Processing Dependency: python-click for package:
> pgadmin4-web-1.0-1.rhel7.noarch
> --> Running transaction check
> ---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
> --> Processing Dependency: python-blinker >= 1.3 for package:
> pgadmin4-web-1.0-1.rhel7.noarch
> ---> Package python-click.noarch 0:6.3-1.el7 will be installed
> ---> Package python-html5lib.noarch 1:0.999-5.el7 will be installed
> ---> Package python-passlib.noarch 0:1.6.2-2.el7 will be installed
> ---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be installed
> --> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package:
> python-psycopg2-debug-2.6.2-2.rhel7.x86_64
> ---> Package python2-crypto.x86_64 0:2.6.1-9.el7 will be installed
> --> Processing Dependency: libtomcrypt.so.0()(64bit) for package:
> python2-crypto-2.6.1-9.el7.x86_64
> --> Running transaction check
> ---> Package libtomcrypt.x86_64 0:1.17-23.el7 will be installed
> --> Processing Dependency: libtommath >= 0.42.0 for package:
> libtomcrypt-1.17-23.el7.x86_64
> --> Processing Dependency: libtommath.so.0()(64bit) for package:
> libtomcrypt-1.17-23.el7.x86_64
> ---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
> --> Processing Dependency: python-blinker >= 1.3 for package:
> pgadmin4-web-1.0-1.rhel7.noarch
> ---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be installed
> --> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package:
> python-psycopg2-debug-2.6.2-2.rhel7.x86_64
> --> Running transaction check
> ---> Package libtommath.x86_64 0:0.42.0-4.el7 will be installed
> ---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
> --> Processing Dependency: python-blinker >= 1.3 for package:
> pgadmin4-web-1.0-1.rhel7.noarch
> ---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be installed
> --> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package:
> python-psycopg2-debug-2.6.2-2.rhel7.x86_64
> --> Finished Dependency Resolution
> Error: Package: pgadmin4-web-1.0-1.rhel7.noarch (pgdg96)
>            Requires: python-blinker >= 1.3
> Error: Package: python-psycopg2-debug-2.6.2-2.rhel7.x86_64 (pgdg96)
>            Requires: libpython2.7_d.so.1.0()(64bit)
>  You could try using --skip-broken to work around the problem
>  You could try running: rpm -Va --nofiles --nodigest"
>
> (the "LANG=C" at beginning of the line is to force output in english,
> please ignore it)
>
> Have anyone faced similar issue or know how to correct this error?

First what version of Python is your system default?

Second there seems to be some unfilled dependencies:

python-blinker >= 1.3

libpython2.7_d.so.1.0()(64bit)

At a guess you can try to YUM install python-blinker for the first.


For the second I am thinking you need something along the lines of
python-devel installed.


>
> Thanks in advance,
>
> Edson Richter
>


--
Adrian Klaver
adrian.klaver@aklaver.com

Hi,

On Sun, 2016-10-02 at 17:52 +0000, Edson Richter wrote:
> I'm trying to install pgAdmin4 in Oracle EL 7.
>
> I've already installed PostgreSQL 9.6 final in same server (have EPEL
> enabled, as well pgdg 9.6 repos).
>
> Running "yum install pgadmin4-web" I get the following result:
> Error: Package: pgadmin4-web-1.0-1.rhel7.noarch (pgdg96)
>            Requires: python-blinker >= 1.3

I've tested pgadmin4 RPMs on CentOS 7 so far, it seems even though Fedora git
says something different, blinker does not seem to appear in the RHEL and OEL
repos.

So, just added blinker to PGDG repo, under testing. If you have the latest
repository file, you can test this package with:

yum --enablerepo pgdg96-updates-testing install pgadmin4-web 

(the package will appear in next hour)

> Error: Package: python-psycopg2-debug-2.6.2-2.rhel7.x86_64
> (pgdg96)           Requires: libpython2.7_d.so.1.0()(64bit)
>  You could try using --skip-broken to work around the problem
>  You could try running: rpm -Va --nofiles --nodigest"

This is also something that I need to test, but it is too late in here now,
will look tomorrow.

Regards,
-- 
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

On 02/10/2016 16:05, Adrian Klaver wrote:
> On 10/02/2016 10:52 AM, Edson Richter wrote:
>> Dear community,
>>
>>
>> I'm trying to install pgAdmin4 in Oracle EL 7.
>>
>> I've already installed PostgreSQL 9.6 final in same server (have EPEL
>> enabled, as well pgdg 9.6 repos).
>>
>> Running "yum install pgadmin4-web" I get the following result:
>>
>>
>> "[root@backup1 yum.repos.d]# LANG=C yum install pgadmin4-web
>>
>> Loaded plugins: ulninfo
>> Resolving Dependencies
>> --> Running transaction check
>> ---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
>> --> Processing Dependency: python-psycopg2-debug >= 2.6.2 for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> --> Processing Dependency: python-passlib >= 1.6.2 for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> --> Processing Dependency: python-html5lib >= 1.0b3 for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> --> Processing Dependency: python-crypto >= 2.6.1 for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> --> Processing Dependency: python-blinker >= 1.3 for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> --> Processing Dependency: python-click for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> --> Running transaction check
>> ---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
>> --> Processing Dependency: python-blinker >= 1.3 for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> ---> Package python-click.noarch 0:6.3-1.el7 will be installed
>> ---> Package python-html5lib.noarch 1:0.999-5.el7 will be installed
>> ---> Package python-passlib.noarch 0:1.6.2-2.el7 will be installed
>> ---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be
>> installed
>> --> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package:
>> python-psycopg2-debug-2.6.2-2.rhel7.x86_64
>> ---> Package python2-crypto.x86_64 0:2.6.1-9.el7 will be installed
>> --> Processing Dependency: libtomcrypt.so.0()(64bit) for package:
>> python2-crypto-2.6.1-9.el7.x86_64
>> --> Running transaction check
>> ---> Package libtomcrypt.x86_64 0:1.17-23.el7 will be installed
>> --> Processing Dependency: libtommath >= 0.42.0 for package:
>> libtomcrypt-1.17-23.el7.x86_64
>> --> Processing Dependency: libtommath.so.0()(64bit) for package:
>> libtomcrypt-1.17-23.el7.x86_64
>> ---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
>> --> Processing Dependency: python-blinker >= 1.3 for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> ---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be
>> installed
>> --> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package:
>> python-psycopg2-debug-2.6.2-2.rhel7.x86_64
>> --> Running transaction check
>> ---> Package libtommath.x86_64 0:0.42.0-4.el7 will be installed
>> ---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
>> --> Processing Dependency: python-blinker >= 1.3 for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> ---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be
>> installed
>> --> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package:
>> python-psycopg2-debug-2.6.2-2.rhel7.x86_64
>> --> Finished Dependency Resolution
>> Error: Package: pgadmin4-web-1.0-1.rhel7.noarch (pgdg96)
>>            Requires: python-blinker >= 1.3
>> Error: Package: python-psycopg2-debug-2.6.2-2.rhel7.x86_64 (pgdg96)
>>            Requires: libpython2.7_d.so.1.0()(64bit)
>>  You could try using --skip-broken to work around the problem
>>  You could try running: rpm -Va --nofiles --nodigest"
>>
>> (the "LANG=C" at beginning of the line is to force output in english,
>> please ignore it)
>>
>> Have anyone faced similar issue or know how to correct this error?
>
> First what version of Python is your system default?

python.x86_64 2.7.5-39.0.1.el7_2     @ol7_latest


>
> Second there seems to be some unfilled dependencies:
>
> python-blinker >= 1.3

[root@backup1 yum.repos.d]# yum search python-blinker
Plugins carregados: ulninfo
=========================================== Encontrado: python-blinker
============================================
python-flask-principal.noarch : Identity management for Flask applications


>
> libpython2.7_d.so.1.0()(64bit)
>
> At a guess you can try to YUM install python-blinker for the first.
>

Not sure if I did it right, but python-flask-principal.noarch is already
installed - would be a dependency problem? The package is not where it
is supposed to be?

>
> For the second I am thinking you need something along the lines of
> python-devel installed.
>

That was my first thought:

[root@backup1 yum.repos.d]# LANG=C yum install python-devel
Loaded plugins: ulninfo
Package python-devel-2.7.5-39.0.1.el7_2.x86_64 already installed and
latest version
Nothing to do


So it is already installed.

Regards,

Edson Richter


>
>>
>> Thanks in advance,
>>
>> Edson Richter
>>
>
>

On 02/10/2016 17:04, Devrim Gündüz wrote:
> Hi,
>
> On Sun, 2016-10-02 at 17:52 +0000, Edson Richter wrote:
>> I'm trying to install pgAdmin4 in Oracle EL 7.
>>
>> I've already installed PostgreSQL 9.6 final in same server (have EPEL
>> enabled, as well pgdg 9.6 repos).
>>
>> Running "yum install pgadmin4-web" I get the following result:
>> Error: Package: pgadmin4-web-1.0-1.rhel7.noarch (pgdg96)
>>             Requires: python-blinker >= 1.3
> I've tested pgadmin4 RPMs on CentOS 7 so far, it seems even though Fedoragit
> says something different, blinker does not seem to appear in the RHEL andOEL
> repos.
>
> So, just added blinker to PGDG repo, under testing. If you have the latest
> repository file, you can test this package with:
>
> yum --enablerepo pgdg96-updates-testing install pgadmin4-web
>
> (the package will appear in next hour)

It is not working, I get the following error:

[root@backup1 yum.repos.d]# LANG=C yum install pgadmin4 pgadmin4-web
Loaded plugins: ulninfo
epel/x86_64/metalink | 2.6 kB  00:00:00
ol7_UEKR3 | 1.2 kB  00:00:00
ol7_latest | 1.4 kB  00:00:00
pgdg96 | 4.1 kB  00:00:00
https://download.postgresql.org/pub/repos/yum/testing/9.6/redhat/rhel-7Server-x86_64/repodata/repomd.xml: 
[Errno 14] HTTPS Error 404 - Not Found
Trying other mirror.


  One of the configured repositories failed (PostgreSQL 9.6 7Server - 
x86_64),
  and yum doesn't have enough cached data to continue. At this point the 
only
  safe thing yum can do is fail. There are a few ways to work "fix" this:

      1. Contact the upstream for the repository and get them to fix the 
problem.

      2. Reconfigure the baseurl/etc. for the repository, to point to a 
working
         upstream. This is most often useful if you are using a newer
         distribution release than is supported by the repository (and the
         packages for the previous distribution release still work).

      3. Disable the repository, so yum won't use it by default. Yum 
will then
         just ignore the repository until you permanently enable it 
again or use
         --enablerepo for temporary usage:

             yum-config-manager --disable pgdg96-updates-testing

      4. Configure the failing repository to be skipped, if it is 
unavailable.
         Note that yum will try to contact the repo. when it runs most 
commands,
         so will have to try and fail each time (and thus. yum will be 
be much
         slower). If it is a very temporary problem though, this is 
often a nice
         compromise:

             yum-config-manager --save 
--setopt=pgdg96-updates-testing.skip_if_unavailable=true

failure: repodata/repomd.xml from pgdg96-updates-testing: [Errno 256] No 
more mirrors to try.
https://download.postgresql.org/pub/repos/yum/testing/9.6/redhat/rhel-7Server-x86_64/repodata/repomd.xml: 
[Errno 14] HTTPS Error 404 - Not Found


>
>> Error: Package: python-psycopg2-debug-2.6.2-2.rhel7.x86_64
>> (pgdg96)           Requires: libpython2.7_d.so.1.0()(64bit)
>>   You could try using --skip-broken to work around the problem
>>   You could try running: rpm -Va --nofiles --nodigest"
> This is also something that I need to test, but it is too late in here now,
> will look tomorrow.

I have several machines with OEL 7, I'll be delighted to help debug. I 
can even provide root access to a virtual machine with OEL 7 for if you 
need one.

Regards,

Edson Richter


>
> Regards,
> --
> Devrim GÜNDÜZ
> EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
> Twitter: @DevrimGunduz , @DevrimGunduzTR

Hi Edson,

On Mon, 2016-10-03 at 00:18 +0000, Edson Richter wrote:
> https://download.postgresql.org/pub/repos/yum/testing/9.6/redhat/rhel-7Server
> -x86_64/repodata/repomd.xml: 
> [Errno 14] HTTPS Error 404 - Not Found
> Trying other mirror.

Fixed this error, sorry for that.

> >
> >> Error: Package: python-psycopg2-debug-2.6.2-2.rhel7.x86_64
> >> (pgdg96)           Requires: libpython2.7_d.so.1.0()(64bit)
> >>   You could try using --skip-broken to work around the problem
> >>   You could try running: rpm -Va --nofiles --nodigest"
> > This is also something that I need to test, but it is too late in here now,
> > will look tomorrow.

Hmm, AFAICS, RHEL and OEL do not have python-debug package. I'll take a look.

Regards,
-- 
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

On 03/10/2016 10:12, Devrim Gündüz wrote:
> Hi Edson,
>
> On Mon, 2016-10-03 at 00:18 +0000, Edson Richter wrote:
>> https://download.postgresql.org/pub/repos/yum/testing/9.6/redhat/rhel-7Server
>> -x86_64/repodata/repomd.xml:
>> [Errno 14] HTTPS Error 404 - Not Found
>> Trying other mirror.
> Fixed this error, sorry for that.
Thanks OK, this one is working - but I still get the following error:


[root@backup1 yum.repos.d]# LANG=C yum install pgadmin4-web
Loaded plugins: ulninfo
Resolving Dependencies
--> Running transaction check
---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
--> Processing Dependency: python-psycopg2-debug >= 2.6.2 for package: 
pgadmin4-web-1.0-1.rhel7.noarch
--> Processing Dependency: python-passlib >= 1.6.2 for package: 
pgadmin4-web-1.0-1.rhel7.noarch
--> Processing Dependency: python-html5lib >= 1.0b3 for package: 
pgadmin4-web-1.0-1.rhel7.noarch
--> Processing Dependency: python-crypto >= 2.6.1 for package: 
pgadmin4-web-1.0-1.rhel7.noarch
--> Processing Dependency: python-blinker >= 1.3 for package: 
pgadmin4-web-1.0-1.rhel7.noarch
--> Processing Dependency: python-click for package: 
pgadmin4-web-1.0-1.rhel7.noarch
--> Running transaction check
---> Package python-blinker.noarch 0:1.4-1.rhel7 will be installed
---> Package python-click.noarch 0:6.3-1.el7 will be installed
---> Package python-html5lib.noarch 1:0.999-5.el7 will be installed
---> Package python-passlib.noarch 0:1.6.2-2.el7 will be installed
---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be installed
--> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package: 
python-psycopg2-debug-2.6.2-2.rhel7.x86_64
---> Package python2-crypto.x86_64 0:2.6.1-9.el7 will be installed
--> Processing Dependency: libtomcrypt.so.0()(64bit) for package: 
python2-crypto-2.6.1-9.el7.x86_64
--> Running transaction check
---> Package libtomcrypt.x86_64 0:1.17-23.el7 will be installed
--> Processing Dependency: libtommath >= 0.42.0 for package: 
libtomcrypt-1.17-23.el7.x86_64
--> Processing Dependency: libtommath.so.0()(64bit) for package: 
libtomcrypt-1.17-23.el7.x86_64
---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be installed
--> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package: 
python-psycopg2-debug-2.6.2-2.rhel7.x86_64
--> Running transaction check
---> Package libtommath.x86_64 0:0.42.0-4.el7 will be installed
---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be installed
--> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package: 
python-psycopg2-debug-2.6.2-2.rhel7.x86_64
--> Finished Dependency Resolution
Error: Package: python-psycopg2-debug-2.6.2-2.rhel7.x86_64 (pgdg96)
            Requires: libpython2.7_d.so.1.0()(64bit)
  You could try using --skip-broken to work around the problem
  You could try running: rpm -Va --nofiles --nodigest

Regards,

Edson

>
>>>> Error: Package: python-psycopg2-debug-2.6.2-2.rhel7.x86_64
>>>> (pgdg96)           Requires: libpython2.7_d.so.1.0()(64bit)
>>>>     You could try using --skip-broken to work around the problem
>>>>     You could try running: rpm -Va --nofiles --nodigest"
>>> This is also something that I need to test, but it is too late in here now,
>>> will look tomorrow.
> Hmm, AFAICS, RHEL and OEL do not have python-debug package. I'll take a look.
>
> Regards,
> -- 
> Devrim GÜNDÜZ
> EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
> Twitter: @DevrimGunduz , @DevrimGunduzTR

Hi again,

On Mon, 2016-10-03 at 00:18 +0000, Edson Richter wrote:
> It is not working, I get the following error:
>
> [root@backup1 yum.repos.d]# LANG=C yum install pgadmin4 pgadmin4-web
> Loaded plugins: ulninfo
> epel/x86_64/metalink | 2.6 kB  00:00:00
> ol7_UEKR3 | 1.2 kB  00:00:00
> ol7_latest | 1.4 kB  00:00:00
> pgdg96 | 4.1 kB  00:00:00
> https://download.postgresql.org/pub/repos/yum/testing/9.6/redhat/rhel-7Server
> -x86_64/repodata/repomd.xml: 
> [Errno 14] HTTPS Error 404 - Not Found
> Trying other mirror.

Can you please try again with this?

yum --enablerepo pgdg96-updates-testing install pgadmin4 pgadmin4-web 

Just tested on:
$ cat /etc/oracle-release 
Oracle Linux Server release 7.2

If it also works for you, I'll push the updated packages to updates repo.

Regards,

--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

---- Devrim Gündüz escreveu ----

> Hi again,
>
> On Mon, 2016-10-03 at 00:18 +0000, Edson Richter wrote:
> > It is not working, I get the following error:
> >
> > [root@backup1 yum.repos.d]# LANG=C yum install pgadmin4 pgadmin4-web
> > Loaded plugins: ulninfo
> > epel/x86_64/metalink | 2.6 kB  00:00:00
> > ol7_UEKR3 | 1.2 kB  00:00:00
> > ol7_latest | 1.4 kB  00:00:00
> > pgdg96 | 4.1 kB  00:00:00
> > https://download.postgresql.org/pub/repos/yum/testing/9.6/redhat/rhel-7Server ;
> > -x86_64/repodata/repomd.xml: 
> > [Errno 14] HTTPS Error 404 - Not Found
> > Trying other mirror.
>
> Can you please try again with this?
>
> yum --enablerepo pgdg96-updates-testing install pgadmin4 pgadmin4-web 
>
> Just tested on:
> $ cat /etc/oracle-release 
> Oracle Linux Server release 7.2
>
> If it also works for you, I'll push the updated packages to updates repo.

The command runs without errors! Thanks.

After install, I'll let you know if there is additional issues.

Thank you!

Regards,

Edson Richter

>
> Regards,
>
> --
> Devrim GÜNDÜZ
> EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
> Twitter: @DevrimGunduz , @DevrimGunduzTR