cancel
Showing results for 
Search instead for 
Did you mean: 

Install Postgresql Enterprise Manager for trial error v. 7.9

Adventurer

Install Postgresql Enterprise Manager for trial error v. 7.9

Dear all,

 

I want to use the PEM to monitor my postgresql database, then I tried to install the trial software on redhat and got error below:

=====

root@dba2 yum.repos.d]# yum install edb-pem-server --skip-broken
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.hosting.in.th
* centos-sclo-rh: mirrors.hosting.in.th
* centos-sclo-sclo: mirrors.hosting.in.th
* epel: hkg.mirror.rackspace.com
* extras: mirrors.hosting.in.th
* updates: mirrors.hosting.in.th
Resolving Dependencies
--> Running transaction check
---> Package edb-pem-server.x86_64 0:7.9.0-3.rhel7 will be installed
--> Processing Dependency: edb-pem-agent = 7.9.0 for package: edb-pem-server-7.9.0-3.rhel7.x86_64
--> Processing Dependency: edb-pem = 7.9.0 for package: edb-pem-server-7.9.0-3.rhel7.x86_64
--> Running transaction check
---> Package edb-pem.x86_64 0:7.9.0-3.rhel7 will be installed
--> Processing Dependency: edb-pem-docs for package: edb-pem-7.9.0-3.rhel7.x86_64
---> Package edb-pem-agent.x86_64 0:7.9.0-3.rhel7 will be installed
--> Processing Dependency: postgresql-libs >= 10 for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
--> Running transaction check
---> Package edb-pem-agent.x86_64 0:7.9.0-3.rhel7 will be installed
--> Processing Dependency: postgresql-libs >= 10 for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
---> Package edb-pem-docs.x86_64 0:7.9.0-3.rhel7 will be installed

Packages skipped because of dependency problems:
edb-pem-7.9.0-3.rhel7.x86_64 from enterprisedb-tools
edb-pem-agent-7.9.0-3.rhel7.x86_64 from enterprisedb-tools
edb-pem-docs-7.9.0-3.rhel7.x86_64 from enterprisedb-tools
edb-pem-server-7.9.0-3.rhel7.x86_64 from enterprisedb-tools
[root@dba2 yum.repos.d]#

==

 

Does anyone know the root cause of these error? Could you please to solve it?

 

Best Regards,

Phanny

10 REPLIES 10
EDB Team Member

Re: Install Postgresql Enterprise Manager for trial error v. 7.9

Hi phannyphok,

 

Can you check whether epel-release packages are installed with edb.repo configured.

Having the epel packages will resolve the dependencies required for the installation.

The installation details have the packages that are been skipped due to dependencies.

We were able to install the desired version of PEM Server on Centos -7.Though this should not be an issue as compared to RHEL 7 which you have used.

Adventurer

Re: Install Postgresql Enterprise Manager for trial error v. 7.9

HI,

 

I have already checked epel-release packages.

[root@redhat1 ~]# rpm -qa | grep epel-release
epel-release-7-11.noarch

Do you have any step to check this packages?

 

Do you have any more solution?

 

Thanks,

Phanny

Adventurer

Re: Install Postgresql Enterprise Manager for trial error v. 7.9

[root@redhat1 ]# cd /etc/yum.repos.d

[root@redhat1 yum.repos.d]# ls -lrt
total 16
-rw-r--r--. 1 root root 1050 Oct 3 2017 epel-testing.repo
-rw-r--r--. 1 root root 951 Oct 3 2017 epel.repo
-rw-r--r--. 1 root root 358 Aug 22 10:22 redhat.repo
-rw-r--r--. 1 root root 2984 Aug 22 13:47 edb.repo
[root@redhat1 yum.repos.d]#

--------

[root@redhat1 yum.repos.d]# cat epel.repo
[epel]
name=Extra Packages for Enterprise Linux 7 - $basearch
#baseurl=http://download.fedoraproject.org/pub/epel/7/$basearch
metalink=https://mirrors.fedoraproject.org/metalink?repo=epel-7&arch=$basearch
failovermethod=priority
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-7

[epel-debuginfo]
name=Extra Packages for Enterprise Linux 7 - $basearch - Debug
#baseurl=http://download.fedoraproject.org/pub/epel/7/$basearch/debug
metalink=https://mirrors.fedoraproject.org/metalink?repo=epel-debug-7&arch=$basearch
failovermethod=priority
enabled=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-7
gpgcheck=1

[epel-source]
name=Extra Packages for Enterprise Linux 7 - $basearch - Source
#baseurl=http://download.fedoraproject.org/pub/epel/7/SRPMS
metalink=https://mirrors.fedoraproject.org/metalink?repo=epel-source-7&arch=$basearch
failovermethod=priority
enabled=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-7
gpgcheck=1
[root@redhat1 yum.repos.d]#

-------

 

EDB Team Member

Re: Install Postgresql Enterprise Manager for trial error v. 7.9

Hi phannyphok,

 

To further analyze can you share below details

yum install edb-pem-server (without --skip-broken) and the informational messages follwed after this.
Would like to know why you had to use the --skip-broken option while installation.

Can you also share the output of edb.repo

Highlighted
Adventurer

Re: Install Postgresql Enterprise Manager for trial error v. 7.9

Hi Sir,

Please kindly check the below:

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

[root@dba2 ~]# yum install edb-pem-server
Loaded plugins: fastestmirror
base | 3.6 kB 00:00:00
centos-sclo-rh | 3.0 kB 00:00:00
centos-sclo-sclo | 2.9 kB 00:00:00
edb-repos | 2.4 kB 00:00:00
enterprisedb-dependencies | 2.5 kB 00:00:00
enterprisedb-tools | 2.5 kB 00:00:00
epel/x86_64/metalink | 7.9 kB 00:00:00
epel | 5.3 kB 00:00:00
extras | 3.4 kB 00:00:00
updates | 3.4 kB 00:00:00
epel/x86_64/primary_db FAILED
http://mirrors.nipa.cloud/epel/7/x86_64/repodata/53fc8cfd63713020d57c1607cf3cb099c7708a2809bcd3f242f...: [Errno 14] HTTP Error 404 - Not Found
Trying other mirror.
To address this issue please refer to the below knowledge base article

https://access.redhat.com/articles/1320623

If above article doesn't help to resolve this issue please create a bug on https://bugs.centos.org/

(1/2): epel/x86_64/updateinfo | 997 kB 00:00:04
(2/2): epel/x86_64/primary_db | 6.8 MB 00:01:24
Loading mirror speeds from cached hostfile
* base: mirrors.hosting.in.th
* centos-sclo-rh: mirrors.hosting.in.th
* centos-sclo-sclo: mirrors.hosting.in.th
* epel: mirror1.ku.ac.th
* extras: mirrors.hosting.in.th
* updates: mirrors.hosting.in.th
Resolving Dependencies
--> Running transaction check
---> Package edb-pem-server.x86_64 0:7.9.0-3.rhel7 will be installed
--> Processing Dependency: edb-pem-agent = 7.9.0 for package: edb-pem-server-7.9.0-3.rhel7.x86_64
--> Processing Dependency: edb-pem = 7.9.0 for package: edb-pem-server-7.9.0-3.rhel7.x86_64
--> Processing Dependency: libtk8.5.so()(64bit) for package: edb-pem-server-7.9.0-3.rhel7.x86_64
--> Processing Dependency: libtcl8.5.so()(64bit) for package: edb-pem-server-7.9.0-3.rhel7.x86_64
--> Processing Dependency: libX11.so.6()(64bit) for package: edb-pem-server-7.9.0-3.rhel7.x86_64
--> Processing Dependency: libTix.so()(64bit) for package: edb-pem-server-7.9.0-3.rhel7.x86_64
--> Running transaction check
---> Package edb-pem.x86_64 0:7.9.0-3.rhel7 will be installed
--> Processing Dependency: snmp++ >= 3.3.7 for package: edb-pem-7.9.0-3.rhel7.x86_64
--> Processing Dependency: libcurl-pem >= 7.61.1 for package: edb-pem-7.9.0-3.rhel7.x86_64
--> Processing Dependency: mod_wsgi for package: edb-pem-7.9.0-3.rhel7.x86_64
--> Processing Dependency: edb-pem-docs for package: edb-pem-7.9.0-3.rhel7.x86_64
---> Package edb-pem-agent.x86_64 0:7.9.0-3.rhel7 will be installed
--> Processing Dependency: postgresql-libs >= 10 for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
--> Processing Dependency: boost-system for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
--> Processing Dependency: boost-regex for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
--> Processing Dependency: boost-program-options for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
--> Processing Dependency: boost-filesystem for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
--> Processing Dependency: boost-date-time for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
--> Processing Dependency: boost-chrono for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
--> Processing Dependency: boost-atomic for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
--> Processing Dependency: libboost_thread-mt.so.1.53.0()(64bit) for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
--> Processing Dependency: libboost_system.so.1.53.0()(64bit) for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
--> Processing Dependency: libboost_system-mt.so.1.53.0()(64bit) for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
--> Processing Dependency: libboost_regex.so.1.53.0()(64bit) for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
--> Processing Dependency: libboost_program_options.so.1.53.0()(64bit) for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
--> Processing Dependency: libboost_filesystem.so.1.53.0()(64bit) for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
--> Processing Dependency: libboost_date_time.so.1.53.0()(64bit) for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
--> Processing Dependency: libboost_chrono.so.1.53.0()(64bit) for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
--> Processing Dependency: libboost_atomic-mt.so.1.53.0()(64bit) for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
---> Package libX11.x86_64 0:1.6.5-2.el7 will be installed
--> Processing Dependency: libX11-common >= 1.6.5-2.el7 for package: libX11-1.6.5-2.el7.x86_64
--> Processing Dependency: libxcb.so.1()(64bit) for package: libX11-1.6.5-2.el7.x86_64
---> Package tcl.x86_64 1:8.5.13-8.el7 will be installed
---> Package tix.x86_64 1:8.4.3-12.el7 will be installed
---> Package tk.x86_64 1:8.5.13-6.el7 will be installed
--> Processing Dependency: libXft.so.2()(64bit) for package: 1:tk-8.5.13-6.el7.x86_64
--> Running transaction check
---> Package boost-atomic.x86_64 0:1.53.0-27.el7 will be installed
---> Package boost-chrono.x86_64 0:1.53.0-27.el7 will be installed
---> Package boost-date-time.x86_64 0:1.53.0-27.el7 will be installed
---> Package boost-filesystem.x86_64 0:1.53.0-27.el7 will be installed
---> Package boost-program-options.x86_64 0:1.53.0-27.el7 will be installed
---> Package boost-regex.x86_64 0:1.53.0-27.el7 will be installed
--> Processing Dependency: libicuuc.so.50()(64bit) for package: boost-regex-1.53.0-27.el7.x86_64
--> Processing Dependency: libicui18n.so.50()(64bit) for package: boost-regex-1.53.0-27.el7.x86_64
--> Processing Dependency: libicudata.so.50()(64bit) for package: boost-regex-1.53.0-27.el7.x86_64
---> Package boost-system.x86_64 0:1.53.0-27.el7 will be installed
---> Package boost-thread.x86_64 0:1.53.0-27.el7 will be installed
---> Package edb-pem-agent.x86_64 0:7.9.0-3.rhel7 will be installed
--> Processing Dependency: postgresql-libs >= 10 for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
---> Package edb-pem-docs.x86_64 0:7.9.0-3.rhel7 will be installed
---> Package libX11-common.noarch 0:1.6.5-2.el7 will be installed
---> Package libXft.x86_64 0:2.3.2-2.el7 will be installed
--> Processing Dependency: fontconfig >= 2.2-1 for package: libXft-2.3.2-2.el7.x86_64
--> Processing Dependency: libfontconfig.so.1()(64bit) for package: libXft-2.3.2-2.el7.x86_64
--> Processing Dependency: libXrender.so.1()(64bit) for package: libXft-2.3.2-2.el7.x86_64
---> Package libcurl-pem.x86_64 0:7.61.1-2.rhel7 will be installed
---> Package libxcb.x86_64 0:1.13-1.el7 will be installed
--> Processing Dependency: libXau.so.6()(64bit) for package: libxcb-1.13-1.el7.x86_64
---> Package mod_wsgi.x86_64 0:3.4-18.el7 will be installed
---> Package snmp++.x86_64 0:3.3.7-3.rhel7 will be installed
--> Running transaction check
---> Package edb-pem-agent.x86_64 0:7.9.0-3.rhel7 will be installed
--> Processing Dependency: postgresql-libs >= 10 for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
---> Package fontconfig.x86_64 0:2.13.0-4.3.el7 will be installed
--> Processing Dependency: freetype >= 2.8-7 for package: fontconfig-2.13.0-4.3.el7.x86_64
--> Processing Dependency: fontpackages-filesystem for package: fontconfig-2.13.0-4.3.el7.x86_64
--> Processing Dependency: dejavu-sans-fonts for package: fontconfig-2.13.0-4.3.el7.x86_64
---> Package libXau.x86_64 0:1.0.8-2.1.el7 will be installed
---> Package libXrender.x86_64 0:0.9.10-1.el7 will be installed
---> Package libicu.x86_64 0:50.1.2-17.el7 will be installed
--> Running transaction check
---> Package dejavu-sans-fonts.noarch 0:2.33-6.el7 will be installed
--> Processing Dependency: dejavu-fonts-common = 2.33-6.el7 for package: dejavu-sans-fonts-2.33-6.el7.noarch
---> Package edb-pem-agent.x86_64 0:7.9.0-3.rhel7 will be installed
--> Processing Dependency: postgresql-libs >= 10 for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
---> Package fontpackages-filesystem.noarch 0:1.44-8.el7 will be installed
---> Package freetype.x86_64 0:2.4.11-15.el7 will be updated
---> Package freetype.x86_64 0:2.8-12.el7_6.1 will be an update
--> Processing Dependency: libpng15.so.15(PNG15_0)(64bit) for package: freetype-2.8-12.el7_6.1.x86_64
--> Processing Dependency: libpng15.so.15()(64bit) for package: freetype-2.8-12.el7_6.1.x86_64
--> Running transaction check
---> Package dejavu-fonts-common.noarch 0:2.33-6.el7 will be installed
---> Package edb-pem-agent.x86_64 0:7.9.0-3.rhel7 will be installed
--> Processing Dependency: postgresql-libs >= 10 for package: edb-pem-agent-7.9.0-3.rhel7.x86_64
---> Package libpng.x86_64 2:1.5.13-7.el7_2 will be installed
--> Finished Dependency Resolution
Error: Package: edb-pem-agent-7.9.0-3.rhel7.x86_64 (enterprisedb-tools)
Requires: postgresql-libs >= 10
Installed: postgresql-libs-9.2.24-1.el7_5.x86_64 (@base)
postgresql-libs = 9.2.24-1.el7_5
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
[root@dba2 ~]#

----

 

Thanks,

Phanny

Adventurer

Re: Install Postgresql Enterprise Manager for trial error v. 7.9

Hi Sir,

 

Here is the output of edb.repo:

---

[root@dba1 yum.repos.d]# cat edb.repo
[edbas11]
name=EnterpriseDB Advanced Server 11 $releasever - $basearch
baseurl=https://<username>:<password>@yum.enterprisedb.com/11/redhat/rhel-$relea sever-$basearch
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/ENTERPRISEDB-GPG-KEY

[edbas10]
name=EnterpriseDB Advanced Server 10 $releasever - $basearch
baseurl=https://<username>:<password>@yum.enterprisedb.com/10/redhat/rhel-$relea sever-$basearch
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/ENTERPRISEDB-GPG-KEY

[edbas96]
name=EnterpriseDB Advanced Server 9.6 $releasever - $basearch
baseurl=https://phannyphok:WGaVeVu2sXfVfvGA@yum.enterprisedb.com/9.6/redhat/rhel -$releasever-$basearch
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/ENTERPRISEDB-GPG-KEY

[ppas95]
name=Postgres Plus Advanced Server 9.5 $releasever - $basearch
baseurl=https://<username>:<password>@yum.enterprisedb.com/9.5/redhat/rhel-$rele asever-$basearch
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/ENTERPRISEDB-GPG-KEY

[ppas94]
name=Postgres Plus Advanced Server 9.4 $releasever - $basearch
baseurl=https://<username>:<password>@yum.enterprisedb.com/9.4/redhat/rhel-$rele asever-$basearch
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/ENTERPRISEDB-GPG-KEY

[ppas93]
name=Postgres Plus Advanced Server 9.3 $releasever - $basearch
baseurl=https://<username>:<password>@yum.enterprisedb.com/9.3/redhat/rhel-$rele asever-$basearch
enabled=0
gpgcheck=0


[ppas92]
name=Postgres Plus Advanced Server 9.2 $releasever - $basearch
baseurl=https://<username>:<password>@yum.enterprisedb.com/9.2/redhat/rhel-$rele asever-$basearch
enabled=0
gpgcheck=0


[ppas91]
name=Postgres Plus Advanced Server 9.1 $releasever - $basearch
baseurl=https://<username>:<password>@yum.enterprisedb.com/9.1/redhat/rhel-$rele asever-$basearch
enabled=0
gpgcheck=0


[enterprisedb-tools]
name=EnterpriseDB Tools $releasever - $basearch
baseurl=https://phannyphok:WGaVeVu2sXfVfvGA@yum.enterprisedb.com/tools/redhat/rh el-$releasever-$basearch
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/ENTERPRISEDB-GPG-KEY

[enterprisedb-tools-testing]
name=EnterpriseDB Tools Testing - Not For Production $releasever - $basearch
baseurl=https://<username>:<password>@yum.enterprisedb.com/tools-testing/redhat/ rhel-$releasever-$basearch
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/ENTERPRISEDB-GPG-KEY

[enterprisedb-dependencies]
name=EnterpriseDB Dependencies $releasever - $basearch
baseurl=https://phannyphok:WGaVeVu2sXfVfvGA@yum.enterprisedb.com/dependencies/re dhat/rhel-$releasever-$basearch
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/ENTERPRISEDB-GPG-KEY

[enterprisedb-xdb60]
name=EnterpriseDB XDB 6.0 $releasever - $basearch
baseurl=https://<username>:<password>@yum.enterprisedb.com/xdb60/redhat/rhel-$re leasever-$basearch
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/ENTERPRISEDB-GPG-KEY

[edb-repos]
name=EnterpriseDB Repos $releasever - $basearch
baseurl=https://<username>:<password>@yum.enterprisedb.com/edbrepos
enabled=1
gpgcheck=0


[root@dba1 yum.repos.d]#

----

Hope you help us.

Thanks,

Phanny

Adventurer

Re: Install Postgresql Enterprise Manager for trial error v. 7.9

Hi,

 

Have you checked it? Hope you can help us. I am waiting your answer.

 

Thanks,

Phanny

EDB Team Member

Re: Install Postgresql Enterprise Manager for trial error v. 7.9

Hi phannyphok,

 

There are some syntactical mistakes in the edb.repo.Like as below

baseurl=https://phannyphok:WGaVeVu2sXfVfvGA@yum.enterprisedb.com/dependencies/re dhat/rhel-$releasever-$basearch

Can you update the baseurl for edb.repos.

 

The data shared from your end is from different machines.Can you check if that you have issues with installing.

 

Verify the below things

1.Check the baseurl and
2.Check yumrepolist all
3.You can also go for reinstalling epel-repo.

 

There is error message in the details shared from one of the machine

http://mirrors.nipa.cloud/epel/7/x86_64/repodata/53fc8cfd63713020d57c1607cf3cb099c7708a2809bcd3f242f...: [Errno 14] HTTP Error 404 - Not Found

Please check the os dependency if any at your end.

You can raise request with the support@enterprisedb.com

Adventurer

Re: Install Postgresql Enterprise Manager for trial error v. 7.9

Dear

 

Hi phannyphok,

 

baseurl=https://phannyphok:WGaVeVu2sXfVfvGA@yum.enterprisedb.com/dependencies/re dhat/rhel-$releasever-$basearch

=> Already changed this baseurl, but not work.

 

Verify the below things

1.Check the baseurl and

=> Check and changed but not work. Or you have any way to change this baseurl?
2.Check yumrepolist all

=> How?
3.You can also go for reinstalling epel-repo.

 

Could you provide another solution?

 

Thanks,

Phanny