#ssl

PostgreSQL "no pg_hba.conf entry for host": allow this connection, the safe way

Fix PostgreSQL "FATAL: no pg_hba.conf entry for host": read the host, user and SSL in the message, add a narrow rule to pg_hba.conf, reload it, and handle Docker and SSL.

Intermediate · 4 min read

certificate has expired

Security

"Certificate has expired": check the dates, renew it, and find out why it didn't renew

Fix "certificate has expired" and NET::ERR_CERT_DATE_INVALID: check the dates with openssl, renew with Certbot, reload the server, and fix why renewal or clock failed.

Beginner · 4 min read

SSL certificate problem: unable to get local issuer certificate

Security

"SSL certificate problem: unable to get local issuer certificate": fix the chain, not the check

Fix "unable to get local issuer certificate" in curl, git, pip, npm and Docker: find the broken link with openssl, then fix the server chain or add the missing CA.

Intermediate · 4 min read