نوشته اصلی توسط
NINJA
نمام مشکلات سر این repository است
کد:
[root@IBSng ~]# wget https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm --2020-08-30 22:51:22-- https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Resolving download.postgresql.org... 147.75.85.69, 217.196.149.55, 72.32.157.246, ...
Connecting to download.postgresql.org|147.75.85.69|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 6672 (6.5K) [application/x-redhat-package-manager]
Saving to: “pgdg-redhat-repo-latest.noarch.rpm”
100%[===================================================================================================================================================================================================>] 6,672 --.-K/s in 0s
2020-08-30 22:51:22 (159 MB/s) - “pgdg-redhat-repo-latest.noarch.rpm” saved [6672/6672]
[root@IBSng ~]# rpm -Uvh pgdg-redhat-repo-latest.noarch.rpm
warning: pgdg-redhat-repo-latest.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
Preparing... ########################################### [100%]
1:pgdg-redhat-repo ########################################### [100%]
[root@IBSng ~]# yum install pgadmin4
Loaded plugins: fastestmirror, priorities, replace
Setting up Install Process
Loading mirror speeds from cached hostfile
* base: mirror.softaculous.com
* extras: linux.darkpenguin.net
* rpmforge: mirror1.hs-esslingen.de
* updates: mirror.alpix.eu
* webtatic: uk.repo.webtatic.com
Webmin | 2.9 kB 00:00
base | 3.7 kB 00:00
extras | 3.4 kB 00:00
https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-6-x86_64/repodata/repomd.xml: [Errno 14] problem making ssl connection
Trying other mirror.
Error: Cannot retrieve repository metadata (repomd.xml) for repository: pgdg-common. Please verify its path and try again
گویا مشکل توی ارتباط ssl هست احتمالا ارتباط با سرور tls1.2 باشه و توی سیستم عامل داره از tls1.0 یا tls1.1 استفاده میشه
نسخه centos چند هست؟ به آخرین نسخه آپدیتش کنید
این هم تست کنید
yum install ca-certificates openssl nss
الان چک کردم سرور postgresql فقط از tls1.2 پشتیبانی میکنه برای اینکه بتونید بهش وصل بشید باید آپدیت کنید چون tls1.0 1.1 قدیمی شده
کد:
Starting Nmap 6.40 ( http://nmap.org ) at 2020-08-30 23:41 +0430
Nmap scan report for download.postgresql.org (147.75.85.69)
Host is up (0.0067s latency).
Other addresses for download.postgresql.org (not scanned): 217.196.149.55 72.32.157.246 87.238.57.227
rDNS record for 147.75.85.69: fendaus.postgresql.org
PORT STATE SERVICE
443/tcp open https
| ssl-enum-ciphers:
| SSLv3: No supported ciphers found
| TLSv1.2:
| ciphers:
| TLS_DHE_RSA_WITH_AES_128_CBC_SHA - strong
| TLS_DHE_RSA_WITH_AES_128_CBC_SHA256 - strong
| TLS_DHE_RSA_WITH_AES_128_GCM_SHA256 - strong
| TLS_DHE_RSA_WITH_AES_256_CBC_SHA - strong
| TLS_DHE_RSA_WITH_AES_256_CBC_SHA256 - strong
| TLS_DHE_RSA_WITH_AES_256_GCM_SHA384 - strong
| TLS_RSA_WITH_AES_128_CBC_SHA - strong
| TLS_RSA_WITH_AES_128_CBC_SHA256 - strong
| TLS_RSA_WITH_AES_128_GCM_SHA256 - strong
| TLS_RSA_WITH_AES_256_CBC_SHA - strong
| TLS_RSA_WITH_AES_256_CBC_SHA256 - strong
| TLS_RSA_WITH_AES_256_GCM_SHA384 - strong
| compressors:
| NULL
|_ least strength: strong
Nmap done: 1 IP address (1 host up) scanned in 1.15 seconds
پاسخ : مشکل در نصب pgadmin در centos
پاسخ با نقل قول