46#include <openssl/bn.h>
47#include <openssl/conf.h>
48#include <openssl/dh.h>
49#ifndef OPENSSL_NO_ECDH
50#include <openssl/ec.h>
52#include <openssl/x509v3.h>
68static int verify_cb(
int ok, X509_STORE_CTX *ctx);
71 const unsigned char **out,
72 unsigned char *outlen,
73 const unsigned char *in,
78static const char *
SSLerrmessageExt(
unsigned long ecode,
const char *replacement);
101 int ssl_ver_min = -1;
102 int ssl_ver_max = -1;
114 context = SSL_CTX_new(SSLv23_method());
118 (
errmsg(
"could not create SSL context: %s",
127 SSL_CTX_set_mode(
context, SSL_MODE_ACCEPT_MOVING_WRITE_BUFFER);
132 (*openssl_tls_init_hook) (
context, isServerStart);
143 (
errcode(ERRCODE_CONFIG_FILE_ERROR),
144 errmsg(
"could not load server certificate file \"%s\": %s",
157 if (SSL_CTX_use_PrivateKey_file(
context,
159 SSL_FILETYPE_PEM) != 1)
163 (
errcode(ERRCODE_CONFIG_FILE_ERROR),
164 errmsg(
"private key file \"%s\" cannot be reloaded because it requires a passphrase",
168 (
errcode(ERRCODE_CONFIG_FILE_ERROR),
169 errmsg(
"could not load private key file \"%s\": %s",
174 if (SSL_CTX_check_private_key(
context) != 1)
177 (
errcode(ERRCODE_CONFIG_FILE_ERROR),
178 errmsg(
"check of private key failed: %s",
187 if (ssl_ver_min == -1)
191 (
errmsg(
"\"%s\" setting \"%s\" not supported by this build",
192 "ssl_min_protocol_version",
198 if (!SSL_CTX_set_min_proto_version(
context, ssl_ver_min))
201 (
errmsg(
"could not set minimum SSL protocol version")));
210 if (ssl_ver_max == -1)
214 (
errmsg(
"\"%s\" setting \"%s\" not supported by this build",
215 "ssl_max_protocol_version",
221 if (!SSL_CTX_set_max_proto_version(
context, ssl_ver_max))
224 (
errmsg(
"could not set maximum SSL protocol version")));
237 if (ssl_ver_min > ssl_ver_max)
240 (
errcode(ERRCODE_CONFIG_FILE_ERROR),
241 errmsg(
"could not set SSL protocol version range"),
242 errdetail(
"\"%s\" cannot be higher than \"%s\"",
243 "ssl_min_protocol_version",
244 "ssl_max_protocol_version")));
258#ifdef HAVE_SSL_CTX_SET_NUM_TICKETS
259 SSL_CTX_set_num_tickets(
context, 0);
261 SSL_CTX_set_options(
context, SSL_OP_NO_TICKET);
264 SSL_CTX_set_session_cache_mode(
context, SSL_SESS_CACHE_OFF);
267 SSL_CTX_set_options(
context, SSL_OP_NO_COMPRESSION);
277#ifdef SSL_OP_NO_RENEGOTIATION
278 SSL_CTX_set_options(
context, SSL_OP_NO_RENEGOTIATION);
280#ifdef SSL_OP_NO_CLIENT_RENEGOTIATION
281 SSL_CTX_set_options(
context, SSL_OP_NO_CLIENT_RENEGOTIATION);
294 (
errcode(ERRCODE_CONFIG_FILE_ERROR),
295 errmsg(
"could not set the TLSv1.2 cipher list (no valid ciphers available)")));
309 (
errcode(ERRCODE_CONFIG_FILE_ERROR),
310 errmsg(
"could not set the TLSv1.3 cipher suites (no valid ciphers available)")));
317 SSL_CTX_set_options(
context, SSL_OP_CIPHER_SERVER_PREFERENCE);
324 STACK_OF(X509_NAME) * root_cert_list;
327 (root_cert_list = SSL_load_client_CA_file(
ssl_ca_file)) == NULL)
330 (
errcode(ERRCODE_CONFIG_FILE_ERROR),
331 errmsg(
"could not load root certificate file \"%s\": %s",
343 SSL_CTX_set_client_CA_list(
context, root_cert_list);
352 SSL_VERIFY_CLIENT_ONCE),
363 X509_STORE *cvstore = SSL_CTX_get_cert_store(
context);
368 if (X509_STORE_load_locations(cvstore,
373 X509_STORE_set_flags(cvstore,
374 X509_V_FLAG_CRL_CHECK | X509_V_FLAG_CRL_CHECK_ALL);
379 (
errcode(ERRCODE_CONFIG_FILE_ERROR),
380 errmsg(
"could not load SSL certificate revocation list file \"%s\": %s",
387 (
errcode(ERRCODE_CONFIG_FILE_ERROR),
388 errmsg(
"could not load SSL certificate revocation list directory \"%s\": %s",
395 (
errcode(ERRCODE_CONFIG_FILE_ERROR),
396 errmsg(
"could not load SSL certificate revocation list file \"%s\" or directory \"%s\": %s",
416 ssl_loaded_verify_locations =
true;
418 ssl_loaded_verify_locations =
false;
435 ssl_loaded_verify_locations =
false;
445 bool give_proto_hint;
453 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
454 errmsg(
"could not initialize SSL connection: SSL context not set up")));
467 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
468 errmsg(
"could not initialize SSL connection: %s",
475 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
476 errmsg(
"could not set SSL socket: %s",
480 port->ssl_in_use =
true;
494 r = SSL_accept(
port->ssl);
497 err = SSL_get_error(
port->ssl, r);
507 ecode = ERR_get_error();
510 case SSL_ERROR_WANT_READ:
511 case SSL_ERROR_WANT_WRITE:
520 if (
err == SSL_ERROR_WANT_READ)
526 WAIT_EVENT_SSL_OPEN_SERVER);
528 case SSL_ERROR_SYSCALL:
529 if (r < 0 && errno != 0)
532 errmsg(
"could not accept SSL connection: %m")));
535 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
536 errmsg(
"could not accept SSL connection: EOF detected")));
539 switch (ERR_GET_REASON(ecode))
554 case SSL_R_NO_PROTOCOLS_AVAILABLE:
555 case SSL_R_UNSUPPORTED_PROTOCOL:
556 case SSL_R_BAD_PROTOCOL_VERSION_NUMBER:
557 case SSL_R_UNKNOWN_PROTOCOL:
558 case SSL_R_UNKNOWN_SSL_VERSION:
559 case SSL_R_UNSUPPORTED_SSL_VERSION:
560 case SSL_R_WRONG_SSL_VERSION:
561 case SSL_R_WRONG_VERSION_NUMBER:
562 case SSL_R_TLSV1_ALERT_PROTOCOL_VERSION:
563#ifdef SSL_R_VERSION_TOO_HIGH
564 case SSL_R_VERSION_TOO_HIGH:
566#ifdef SSL_R_VERSION_TOO_LOW
567 case SSL_R_VERSION_TOO_LOW:
569 give_proto_hint =
true;
572 give_proto_hint =
false;
576 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
577 errmsg(
"could not accept SSL connection: %s",
581 errhint(
"This may indicate that the client does not support any SSL protocol version between %s and %s.",
584 MIN_OPENSSL_TLS_VERSION,
587 MAX_OPENSSL_TLS_VERSION) : 0));
590 case SSL_ERROR_ZERO_RETURN:
592 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
593 errmsg(
"could not accept SSL connection: EOF detected")));
597 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
598 errmsg(
"unrecognized SSL error code: %d",
606 port->alpn_used =
false;
608 const unsigned char *selected;
611 SSL_get0_alpn_selected(
port->ssl, &selected, &
len);
614 if (selected != NULL)
619 port->alpn_used =
true;
625 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
626 errmsg(
"received SSL connection request with unexpected ALPN protocol")));
632 port->peer = SSL_get_peer_certificate(
port->ssl);
635 port->peer_cn = NULL;
636 port->peer_dn = NULL;
637 port->peer_cert_valid =
false;
638 if (
port->peer != NULL)
641 X509_NAME *x509name = X509_get_subject_name(
port->peer);
644 BUF_MEM *bio_buf = NULL;
646 len = X509_NAME_get_text_by_NID(x509name, NID_commonName, NULL, 0);
652 r = X509_NAME_get_text_by_NID(x509name, NID_commonName, peer_cn,
666 if (
len != strlen(peer_cn))
669 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
670 errmsg(
"SSL certificate's common name contains embedded null")));
675 port->peer_cn = peer_cn;
678 bio = BIO_new(BIO_s_mem());
681 if (
port->peer_cn != NULL)
684 port->peer_cn = NULL;
696 if (X509_NAME_print_ex(bio, x509name, 0, XN_FLAG_RFC2253) == -1 ||
697 BIO_get_mem_ptr(bio, &bio_buf) <= 0)
700 if (
port->peer_cn != NULL)
703 port->peer_cn = NULL;
708 memcpy(peer_dn, bio_buf->data, bio_buf->length);
709 len = bio_buf->length;
712 if (
len != strlen(peer_dn))
715 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
716 errmsg(
"SSL certificate's distinguished name contains embedded null")));
718 if (
port->peer_cn != NULL)
721 port->peer_cn = NULL;
726 port->peer_dn = peer_dn;
728 port->peer_cert_valid =
true;
739 SSL_shutdown(
port->ssl);
742 port->ssl_in_use =
false;
747 X509_free(
port->peer);
754 port->peer_cn = NULL;
760 port->peer_dn = NULL;
773 n = SSL_read(
port->ssl, ptr,
len);
774 err = SSL_get_error(
port->ssl, n);
775 ecode = (
err != SSL_ERROR_NONE || n < 0) ? ERR_get_error() : 0;
781 case SSL_ERROR_WANT_READ:
786 case SSL_ERROR_WANT_WRITE:
791 case SSL_ERROR_SYSCALL:
793 if (n != -1 || errno == 0)
801 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
806 case SSL_ERROR_ZERO_RETURN:
812 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
813 errmsg(
"unrecognized SSL error code: %d",
832 n = SSL_write(
port->ssl, ptr,
len);
833 err = SSL_get_error(
port->ssl, n);
834 ecode = (
err != SSL_ERROR_NONE || n < 0) ? ERR_get_error() : 0;
840 case SSL_ERROR_WANT_READ:
845 case SSL_ERROR_WANT_WRITE:
850 case SSL_ERROR_SYSCALL:
858 if (n != -1 || errno == 0)
866 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
871 case SSL_ERROR_ZERO_RETURN:
882 (
errcode(ERRCODE_PROTOCOL_VIOLATION),
883 errmsg(
"unrecognized SSL error code: %d",
920 BIO_clear_retry_flags(h);
921 port->last_read_was_eof =
res == 0;
927 BIO_set_retry_read(h);
941 BIO_clear_retry_flags(h);
947 BIO_set_retry_write(h);
991 my_bio_index = BIO_get_new_index();
992 if (my_bio_index == -1)
994 my_bio_index |= BIO_TYPE_SOURCE_SINK;
1014 BIO_METHOD *bio_method;
1017 if (bio_method == NULL)
1020 bio = BIO_new(bio_method);
1024 BIO_set_data(bio,
port);
1025 BIO_set_init(bio, 1);
1027 SSL_set_bio(
port->ssl, bio, bio);
1050 errmsg(
"could not open DH parameters file \"%s\": %m",
1055 dh = PEM_read_DHparams(fp, NULL, NULL, NULL);
1061 (
errcode(ERRCODE_CONFIG_FILE_ERROR),
1062 errmsg(
"could not load DH parameters file: %s",
1068 if (DH_check(dh, &codes) == 0)
1071 (
errcode(ERRCODE_CONFIG_FILE_ERROR),
1072 errmsg(
"invalid DH parameters: %s",
1077 if (codes & DH_CHECK_P_NOT_PRIME)
1080 (
errcode(ERRCODE_CONFIG_FILE_ERROR),
1081 errmsg(
"invalid DH parameters: p is not prime")));
1085 if ((codes & DH_NOT_SUITABLE_GENERATOR) &&
1086 (codes & DH_CHECK_P_NOT_SAFE_PRIME))
1089 (
errcode(ERRCODE_CONFIG_FILE_ERROR),
1090 errmsg(
"invalid DH parameters: neither suitable generator or safe prime")));
1111 bio = BIO_new_mem_buf(buffer,
len);
1114 dh = PEM_read_bio_DHparams(bio, NULL, NULL, NULL);
1131 const char *prompt =
"Enter PEM pass phrase:";
1167 size_t namelen = strlen(
name);
1168 char *truncated =
name;
1185 truncated[0] = truncated[1] = truncated[2] =
'.';
1209 const char *errstring;
1220 depth = X509_STORE_CTX_get_error_depth(ctx);
1221 errcode = X509_STORE_CTX_get_error(ctx);
1222 errstring = X509_verify_cert_error_string(
errcode);
1226 _(
"Client certificate verification failed at depth %d: %s."),
1229 cert = X509_STORE_CTX_get_current_cert(ctx);
1257 sn = X509_get_serialNumber(cert);
1258 b = ASN1_INTEGER_to_BN(sn, NULL);
1259 serialno = BN_bn2dec(
b);
1263 _(
"Failed certificate data (unverified): subject \"%s\", serial number %s, issuer \"%s\"."),
1264 sub_prepared, serialno ? serialno :
_(
"unknown"),
1268 OPENSSL_free(serialno);
1269 pfree(iss_prepared);
1270 pfree(sub_prepared);
1288 desc = SSL_state_string_long(ssl);
1292 case SSL_CB_HANDSHAKE_START:
1296 case SSL_CB_HANDSHAKE_DONE:
1300 case SSL_CB_ACCEPT_LOOP:
1304 case SSL_CB_ACCEPT_EXIT:
1308 case SSL_CB_CONNECT_LOOP:
1312 case SSL_CB_CONNECT_EXIT:
1316 case SSL_CB_READ_ALERT:
1320 case SSL_CB_WRITE_ALERT:
1336 const unsigned char **out,
1337 unsigned char *outlen,
1338 const unsigned char *in,
1349 Assert(userdata != NULL);
1354 retval = SSL_select_next_proto((
unsigned char **) out, outlen,
1357 if (*out == NULL || *outlen >
sizeof(
alpn_protos) || *outlen <= 0)
1358 return SSL_TLSEXT_ERR_NOACK;
1360 if (retval == OPENSSL_NPN_NEGOTIATED)
1361 return SSL_TLSEXT_ERR_OK;
1368 return SSL_TLSEXT_ERR_ALERT_FATAL;
1391 SSL_CTX_set_options(
context, SSL_OP_SINGLE_DH_USE);
1400 (
errcode(ERRCODE_CONFIG_FILE_ERROR),
1401 errmsg(
"DH: could not load DH parameters")));
1405 if (SSL_CTX_set_tmp_dh(
context, dh) != 1)
1408 (
errcode(ERRCODE_CONFIG_FILE_ERROR),
1409 errmsg(
"DH: could not set DH parameters: %s",
1427#ifndef OPENSSL_NO_ECDH
1438 errcode(ERRCODE_CONFIG_FILE_ERROR),
1439 errmsg(
"failed to set group names specified in ssl_groups: %s",
1441 _(
"No valid groups found"))),
1442 errhint(
"Ensure that each group name is spelled correctly and supported by the installed version of OpenSSL"));
1484 const char *errreason;
1485 static char errbuf[36];
1488 return _(
"no SSL error reported");
1489 errreason = ERR_reason_error_string(ecode);
1490 if (errreason != NULL)
1500#ifdef ERR_SYSTEM_ERROR
1501 if (ERR_SYSTEM_ERROR(ecode))
1502 return strerror(ERR_GET_REASON(ecode));
1506 snprintf(errbuf,
sizeof(errbuf),
_(
"SSL error code %lu"), ecode);
1517 SSL_get_cipher_bits(
port->ssl, &bits);
1528 return SSL_get_version(
port->ssl);
1537 return SSL_get_cipher(
port->ssl);
1565 ASN1_INTEGER *serial;
1569 serial = X509_get_serialNumber(
port->peer);
1570 b = ASN1_INTEGER_to_BN(serial, NULL);
1586 const EVP_MD *algo_type = NULL;
1587 unsigned char hash[EVP_MAX_MD_SIZE];
1588 unsigned int hash_size;
1592 server_cert = SSL_get_certificate(
port->ssl);
1593 if (server_cert == NULL)
1601#if HAVE_X509_GET_SIGNATURE_INFO
1602 if (!X509_get_signature_info(server_cert, &algo_nid, NULL, NULL, NULL))
1604 if (!OBJ_find_sigid_algs(X509_get_signature_nid(server_cert),
1607 elog(
ERROR,
"could not determine server certificate signature algorithm");
1619 algo_type = EVP_sha256();
1622 algo_type = EVP_get_digestbynid(algo_nid);
1623 if (algo_type == NULL)
1624 elog(
ERROR,
"could not find digest for NID %s",
1625 OBJ_nid2sn(algo_nid));
1630 if (!X509_digest(server_cert, algo_type,
hash, &hash_size))
1631 elog(
ERROR,
"could not generate server certificate hash");
1633 cert_hash =
palloc(hash_size);
1634 memcpy(cert_hash,
hash, hash_size);
1647 BIO *membuf = BIO_new(BIO_s_mem());
1650 count = X509_NAME_entry_count(
name);
1653 const char *field_name;
1662 (
errcode(ERRCODE_OUT_OF_MEMORY),
1663 errmsg(
"could not create BIO")));
1665 (void) BIO_set_close(membuf, BIO_CLOSE);
1666 for (
i = 0;
i < count;
i++)
1668 e = X509_NAME_get_entry(
name,
i);
1669 nid = OBJ_obj2nid(X509_NAME_ENTRY_get_object(
e));
1670 if (nid == NID_undef)
1672 (
errcode(ERRCODE_INVALID_PARAMETER_VALUE),
1673 errmsg(
"could not get NID for ASN1_OBJECT object")));
1674 v = X509_NAME_ENTRY_get_data(
e);
1675 field_name = OBJ_nid2sn(nid);
1676 if (field_name == NULL)
1677 field_name = OBJ_nid2ln(nid);
1678 if (field_name == NULL)
1680 (
errcode(ERRCODE_INVALID_PARAMETER_VALUE),
1681 errmsg(
"could not convert NID %d to an ASN1_OBJECT structure", nid)));
1682 BIO_printf(membuf,
"/%s=", field_name);
1683 ASN1_STRING_print_ex(membuf, v,
1684 ((ASN1_STRFLGS_RFC2253 & ~ASN1_STRFLGS_ESC_MSB)
1685 | ASN1_STRFLGS_UTF8_CONVERT));
1690 BIO_write(membuf, &nullterm, 1);
1691 size = BIO_get_mem_data(membuf, &sp);
1697 if (BIO_free(membuf) != 1)
1698 elog(
ERROR,
"could not free OpenSSL BIO structure");
1725 return TLS1_VERSION;
1727#ifdef TLS1_1_VERSION
1728 return TLS1_1_VERSION;
1733#ifdef TLS1_2_VERSION
1734 return TLS1_2_VERSION;
1739#ifdef TLS1_3_VERSION
1740 return TLS1_3_VERSION;
1769 return "(unrecognized)";
bool check_ssl_key_file_permissions(const char *ssl_key_file, bool isServerStart)
int run_ssl_passphrase_command(const char *prompt, bool is_server_start, char *buf, int size)
const char * be_tls_get_version(Port *port)
static const char * ssl_protocol_version_to_string(int v)
static const char * cert_errdetail
static void info_cb(const SSL *ssl, int type, int args)
static const char * SSLerrmessage(unsigned long ecode)
void be_tls_destroy(void)
int be_tls_init(bool isServerStart)
static long port_bio_ctrl(BIO *h, int cmd, long num, void *ptr)
openssl_tls_init_hook_typ openssl_tls_init_hook
int be_tls_get_cipher_bits(Port *port)
int be_tls_open_server(Port *port)
char * be_tls_get_certificate_hash(Port *port, size_t *len)
static int alpn_cb(SSL *ssl, const unsigned char **out, unsigned char *outlen, const unsigned char *in, unsigned int inlen, void *userdata)
const char * be_tls_get_cipher(Port *port)
static const char * SSLerrmessageExt(unsigned long ecode, const char *replacement)
static DH * load_dh_buffer(const char *buffer, size_t len)
static int dummy_ssl_passwd_cb(char *buf, int size, int rwflag, void *userdata)
static void default_openssl_tls_init(SSL_CTX *context, bool isServerStart)
static int ssl_set_port_bio(Port *port)
void be_tls_get_peer_serial(Port *port, char *ptr, size_t len)
static int ssl_protocol_version_to_openssl(int v)
static bool initialize_dh(SSL_CTX *context, bool isServerStart)
void be_tls_close(Port *port)
void be_tls_get_peer_issuer_name(Port *port, char *ptr, size_t len)
ssize_t be_tls_read(Port *port, void *ptr, size_t len, int *waitfor)
static char * X509_NAME_to_cstring(X509_NAME *name)
ssize_t be_tls_write(Port *port, void *ptr, size_t len, int *waitfor)
static BIO_METHOD * port_bio_method(void)
static int ssl_external_passwd_cb(char *buf, int size, int rwflag, void *userdata)
static char * prepare_cert_name(char *name)
static SSL_CTX * SSL_context
static bool ssl_is_server_start
static int verify_cb(int ok, X509_STORE_CTX *ctx)
static BIO_METHOD * port_bio_method_ptr
static bool initialize_ecdh(SSL_CTX *context, bool isServerStart)
static int port_bio_read(BIO *h, char *buf, int size)
static int port_bio_write(BIO *h, const char *buf, int size)
static bool dummy_ssl_passwd_cb_called
static DH * load_dh_file(char *filename, bool isServerStart)
static const unsigned char alpn_protos[]
void be_tls_get_peer_subject_name(Port *port, char *ptr, size_t len)
char * ssl_dh_params_file
int ssl_min_protocol_version
ssize_t secure_raw_read(Port *port, void *ptr, size_t len)
bool SSLPreferServerCiphers
int ssl_max_protocol_version
char * ssl_passphrase_command
bool ssl_passphrase_command_supports_reload
ssize_t secure_raw_write(Port *port, const void *ptr, size_t len)
#define Assert(condition)
static void PGresult * res
int errcode_for_socket_access(void)
int errmsg_internal(const char *fmt,...)
int errdetail_internal(const char *fmt,...)
int errcode_for_file_access(void)
int errdetail(const char *fmt,...)
int errhint(const char *fmt,...)
int errcode(int sqlerrcode)
int errmsg(const char *fmt,...)
#define ereport(elevel,...)
void err(int eval, const char *fmt,...)
FILE * AllocateFile(const char *name, const char *mode)
const char * GetConfigOption(const char *name, bool missing_ok, bool restrict_privileged)
int WaitLatchOrSocket(Latch *latch, int wakeEvents, pgsocket sock, long timeout, uint32 wait_event_info)
#define WL_SOCKET_READABLE
#define WL_EXIT_ON_PM_DEATH
#define WL_SOCKET_WRITEABLE
char * pg_any_to_server(const char *s, int len, int encoding)
void * MemoryContextAlloc(MemoryContext context, Size size)
char * pstrdup(const char *in)
void pfree(void *pointer)
MemoryContext TopMemoryContext
size_t strlcpy(char *dst, const char *src, size_t siz)
#define PG_ALPN_PROTOCOL_VECTOR
static unsigned hash(unsigned *uv, int n)
static pg_noinline void Size size
char * pg_clean_ascii(const char *str, int alloc_flags)
void appendStringInfo(StringInfo str, const char *fmt,...)
void appendStringInfoChar(StringInfo str, char ch)
void initStringInfo(StringInfo str)