pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcannot reach repository pgdg94/7Server/x86_64
3+ messages / 2 participants
[nested] [flat]
* cannot reach repository pgdg94/7Server/x86_64
@ 2018-12-17 21:16 Davenport, Julie <JDavenport@ctcd.edu>
2018-12-18 09:40 ` Re: cannot reach repository pgdg94/7Server/x86_64 Magnus Hagander <magnus@hagander.net>
0 siblings, 1 reply; 3+ messages in thread
From: Davenport, Julie @ 2018-12-17 21:16 UTC (permalink / raw)
To: pgsql-admin
Hello,
Last week I had to renew a self-signed certificate on when of my RHEL 7 servers that uses Postgresql 9.4, and since then I am not able to reach the pgdg94/7Server/x86_64 repository when I try to check for yum updates. We had installed postgres on this server using yum and all updates to it since then using yum, and never had an issue before. Now I get this error:
https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-7Server-x86_64/repodata/repomd.xml: [Errno 14] curl#77 - "Problem with the SSL CA cert (path? access rights?)"
Trying other mirror.
I consulted with Redhat and they said there's likely a certificate that got removed during my renewal process that needs to be reimported, but since it's not Red Hat's repository they can't help with the certificate or process to reinstall it.
I'm searching in the postgres maillists on the repository name and but I cannot find documentation on how to reach this repository or what is required, or the certificate issue. Any suggestions?
Thanks much,
Julie
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: cannot reach repository pgdg94/7Server/x86_64
2018-12-17 21:16 cannot reach repository pgdg94/7Server/x86_64 Davenport, Julie <JDavenport@ctcd.edu>
@ 2018-12-18 09:40 ` Magnus Hagander <magnus@hagander.net>
2018-12-18 16:02 ` RE: cannot reach repository pgdg94/7Server/x86_64 Davenport, Julie <JDavenport@ctcd.edu>
0 siblings, 1 reply; 3+ messages in thread
From: Magnus Hagander @ 2018-12-18 09:40 UTC (permalink / raw)
To: Davenport, Julie <JDavenport@ctcd.edu>; +Cc: pgsql-admin
On Tue, Dec 18, 2018 at 10:38 AM Davenport, Julie <JDavenport@ctcd.edu>
wrote:
> Hello,
>
> Last week I had to renew a self-signed certificate on when of my RHEL 7
> servers that uses Postgresql 9.4, and since then I am not able to reach the
> pgdg94/7Server/x86_64 repository when I try to check for yum updates. We
> had installed postgres on this server using yum and all updates to it since
> then using yum, and never had an issue before. Now I get this error:
>
>
>
>
> https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-7Server-x86_64/repodata/repomd.xml:
> [Errno 14] curl#77 - "Problem with the SSL CA cert (path? access rights?)"
>
> Trying other mirror.
>
>
>
> I consulted with Redhat and they said there's likely a certificate that
> got removed during my renewal process that needs to be reimported, but
> since it's not Red Hat's repository they can’t help with the certificate or
> process to reinstall it.
>
>
>
> I’m searching in the postgres maillists on the repository name and but I
> cannot find documentation on how to reach this repository or what is
> required, or the certificate issue. Any suggestions?
>
>
>
Hi!
This repository uses a standard public LetsEncrypt certificate. You can try
accessing that URL in your browser and you will see that it works. You may
be missing a root certificate in your system somewhere - there is no
PostgreSQL specific root or cert required.
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/;
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/;
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: cannot reach repository pgdg94/7Server/x86_64
2018-12-17 21:16 cannot reach repository pgdg94/7Server/x86_64 Davenport, Julie <JDavenport@ctcd.edu>
2018-12-18 09:40 ` Re: cannot reach repository pgdg94/7Server/x86_64 Magnus Hagander <magnus@hagander.net>
@ 2018-12-18 16:02 ` Davenport, Julie <JDavenport@ctcd.edu>
0 siblings, 0 replies; 3+ messages in thread
From: Davenport, Julie @ 2018-12-18 16:02 UTC (permalink / raw)
To: Magnus Hagander <magnus@hagander.net>; +Cc: pgsql-admin
Hello Magnus, and thank you for your reply. You are correct, I was missing a certificate on my server. Two automatically created CA certificate bundle files (.pem and .crt) had somehow been wiped out by my renewal process. I restored them from a similar server and now I have no problem reaching the postgres repository. Happy days! Julie
From: Magnus Hagander [mailto:magnus@hagander.net]
Sent: Tuesday, December 18, 2018 3:40 AM
To: Davenport, Julie <JDavenport@ctcd.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: cannot reach repository pgdg94/7Server/x86_64
On Tue, Dec 18, 2018 at 10:38 AM Davenport, Julie <JDavenport@ctcd.edu<mailto:JDavenport@ctcd.edu>> wrote:
Hello,
Last week I had to renew a self-signed certificate on when of my RHEL 7 servers that uses Postgresql 9.4, and since then I am not able to reach the pgdg94/7Server/x86_64 repository when I try to check for yum updates. We had installed postgres on this server using yum and all updates to it since then using yum, and never had an issue before. Now I get this error:
https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-7Server-x86_64/repodata/repomd.xml: [Errno 14] curl#77 - "Problem with the SSL CA cert (path? access rights?)"
Trying other mirror.
I consulted with Redhat and they said there's likely a certificate that got removed during my renewal process that needs to be reimported, but since it's not Red Hat's repository they can’t help with the certificate or process to reinstall it.
I’m searching in the postgres maillists on the repository name and but I cannot find documentation on how to reach this repository or what is required, or the certificate issue. Any suggestions?
Hi!
This repository uses a standard public LetsEncrypt certificate. You can try accessing that URL in your browser and you will see that it works. You may be missing a root certificate in your system somewhere - there is no PostgreSQL specific root or cert required.
--
Magnus Hagander
Me: https://www.hagander.net/<http://www.hagander.net/;
Work: https://www.redpill-linpro.com/<http://www.redpill-linpro.com/;
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2018-12-18 16:02 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-12-17 21:16 cannot reach repository pgdg94/7Server/x86_64 Davenport, Julie <JDavenport@ctcd.edu>
2018-12-18 09:40 ` Magnus Hagander <magnus@hagander.net>
2018-12-18 16:02 ` Davenport, Julie <JDavenport@ctcd.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox