[06:19:27.716](0.045s) # setting up data directory # Checking port 55446 # Found port 55446 Name: primary Data directory: /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata Backup directory: /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/backup Archive directory: /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/archives Connection string: port=55446 host=/tmp/pV7wVwL6Zz Log file: /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log [06:19:27.729](0.013s) # initializing database system by copying initdb template # Running: cp -RPp /tmp/cirrus-ci-build/tmp_install/initdb-template /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata # Running: /tmp/cirrus-ci-build/src/test/ssl/../../../src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata ### Starting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log -o --cluster-name=primary start waiting for server to start.... done server started # Postmaster PID for node "primary" is 30227 [06:19:27.980](0.251s) ok 1 - ssl_library parameter ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 30467 [06:19:29.028](1.048s) # testing password-protected keys ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... stopped waiting pg_ctl: could not start server Examine the log output. # pg_ctl restart failed; see logfile for details: /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log # No postmaster PID for node "primary" [06:19:29.245](0.217s) ok 2 - restart fails with password-protected key file with wrong password ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart pg_ctl: PID file "/tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata/postmaster.pid" does not exist Is server running? trying to start server anyway waiting for server to start.... done server started # Postmaster PID for node "primary" is 30535 [06:19:29.458](0.213s) ok 3 - restart succeeds with password-protected key file ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... stopped waiting pg_ctl: could not start server Examine the log output. # pg_ctl restart failed; see logfile for details: /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log # No postmaster PID for node "primary" [06:19:29.666](0.208s) ok 4 - restart fails with incorrect SSL protocol bounds ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart pg_ctl: PID file "/tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata/postmaster.pid" does not exist Is server running? trying to start server anyway waiting for server to start.... done server started # Postmaster PID for node "primary" is 30625 [06:19:29.780](0.114s) ok 5 - restart succeeds with correct SSL protocol bounds [06:19:29.780](0.000s) # running client tests ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 30693 [06:19:30.047](0.268s) ok 6 - server doesn't accept non-SSL connections [06:19:30.048](0.000s) ok 7 - server doesn't accept non-SSL connections: matches [06:19:30.112](0.065s) ok 8 - connect without server root cert sslmode=require [06:19:30.112](0.000s) ok 9 - connect without server root cert sslmode=require: no stderr [06:19:30.130](0.018s) ok 10 - connect without server root cert sslmode=verify-ca [06:19:30.130](0.000s) ok 11 - connect without server root cert sslmode=verify-ca: matches [06:19:30.152](0.022s) ok 12 - connect without server root cert sslmode=verify-full [06:19:30.152](0.000s) ok 13 - connect without server root cert sslmode=verify-full: matches [06:19:30.174](0.022s) ok 14 - connect with wrong server root cert sslmode=require [06:19:30.175](0.000s) ok 15 - connect with wrong server root cert sslmode=require: matches [06:19:30.202](0.027s) ok 16 - connect with wrong server root cert sslmode=verify-ca [06:19:30.202](0.000s) ok 17 - connect with wrong server root cert sslmode=verify-ca: matches [06:19:30.230](0.028s) ok 18 - connect with wrong server root cert sslmode=verify-full [06:19:30.232](0.002s) ok 19 - connect with wrong server root cert sslmode=verify-full: matches [06:19:30.256](0.024s) ok 20 - connect with server CA cert, without root CA [06:19:30.256](0.000s) ok 21 - connect with server CA cert, without root CA: matches [06:19:30.308](0.052s) ok 22 - connect with correct server CA cert file sslmode=require [06:19:30.308](0.000s) ok 23 - connect with correct server CA cert file sslmode=require: no stderr [06:19:30.345](0.037s) ok 24 - connect with correct server CA cert file sslmode=verify-ca [06:19:30.346](0.000s) ok 25 - connect with correct server CA cert file sslmode=verify-ca: no stderr [06:19:30.391](0.045s) ok 26 - connect with correct server CA cert file sslmode=verify-full [06:19:30.391](0.000s) ok 27 - connect with correct server CA cert file sslmode=verify-full: no stderr [06:19:30.471](0.080s) ok 28 - cert root file that contains two certificates, order 1 [06:19:30.471](0.000s) ok 29 - cert root file that contains two certificates, order 1: no stderr [06:19:30.530](0.058s) ok 30 - cert root file that contains two certificates, order 2 [06:19:30.530](0.000s) ok 31 - cert root file that contains two certificates, order 2: no stderr [06:19:30.577](0.047s) ok 32 - connect with sslcertmode=disable [06:19:30.578](0.000s) ok 33 - connect with sslcertmode=disable: no stderr [06:19:30.627](0.050s) ok 34 - connect with sslcertmode=allow [06:19:30.627](0.000s) ok 35 - connect with sslcertmode=allow: no stderr [06:19:30.666](0.039s) ok 36 - connect with sslcertmode=require fails without a client certificate [06:19:30.666](0.000s) ok 37 - connect with sslcertmode=require fails without a client certificate: matches [06:19:30.718](0.052s) ok 38 - sslcrl option with invalid file name [06:19:30.718](0.000s) ok 39 - sslcrl option with invalid file name: no stderr [06:19:30.769](0.050s) ok 40 - CRL belonging to a different CA [06:19:30.769](0.000s) ok 41 - CRL belonging to a different CA: matches [06:19:30.809](0.040s) ok 42 - directory CRL belonging to a different CA [06:19:30.809](0.000s) ok 43 - directory CRL belonging to a different CA: matches [06:19:30.854](0.045s) ok 44 - CRL with a non-revoked cert [06:19:30.854](0.000s) ok 45 - CRL with a non-revoked cert: no stderr [06:19:30.926](0.072s) ok 46 - directory CRL with a non-revoked cert [06:19:30.926](0.000s) ok 47 - directory CRL with a non-revoked cert: no stderr [06:19:31.000](0.074s) ok 48 - mismatch between host name and server certificate sslmode=require [06:19:31.000](0.000s) ok 49 - mismatch between host name and server certificate sslmode=require: no stderr [06:19:31.062](0.062s) ok 50 - mismatch between host name and server certificate sslmode=verify-ca [06:19:31.062](0.000s) ok 51 - mismatch between host name and server certificate sslmode=verify-ca: no stderr [06:19:31.116](0.054s) ok 52 - mismatch between host name and server certificate sslmode=verify-full [06:19:31.117](0.000s) ok 53 - mismatch between host name and server certificate sslmode=verify-full: matches ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 31006 [06:19:31.416](0.299s) ok 54 - IP address in the Common Name [06:19:31.416](0.000s) ok 55 - IP address in the Common Name: no stderr [06:19:31.449](0.033s) ok 56 - mismatch between host name and server certificate IP address [06:19:31.449](0.000s) ok 57 - mismatch between host name and server certificate IP address: matches ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 31095 [06:19:31.827](0.378s) ok 58 - IP address in a dNSName [06:19:31.828](0.000s) ok 59 - IP address in a dNSName: no stderr ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 31154 [06:19:32.136](0.309s) ok 60 - host name matching with X.509 Subject Alternative Names 1 [06:19:32.137](0.000s) ok 61 - host name matching with X.509 Subject Alternative Names 1: no stderr [06:19:32.177](0.040s) ok 62 - host name matching with X.509 Subject Alternative Names 2 [06:19:32.177](0.000s) ok 63 - host name matching with X.509 Subject Alternative Names 2: no stderr [06:19:32.217](0.040s) ok 64 - host name matching with X.509 Subject Alternative Names wildcard [06:19:32.217](0.000s) ok 65 - host name matching with X.509 Subject Alternative Names wildcard: no stderr [06:19:32.254](0.036s) ok 66 - host name not matching with X.509 Subject Alternative Names [06:19:32.254](0.000s) ok 67 - host name not matching with X.509 Subject Alternative Names: matches [06:19:32.309](0.055s) ok 68 - host name not matching with X.509 Subject Alternative Names wildcard [06:19:32.309](0.000s) ok 69 - host name not matching with X.509 Subject Alternative Names wildcard: matches ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 31256 [06:19:32.607](0.298s) ok 70 - host name matching with a single X.509 Subject Alternative Name [06:19:32.607](0.000s) ok 71 - host name matching with a single X.509 Subject Alternative Name: no stderr [06:19:32.645](0.037s) ok 72 - host name not matching with a single X.509 Subject Alternative Name [06:19:32.645](0.000s) ok 73 - host name not matching with a single X.509 Subject Alternative Name: matches [06:19:32.706](0.061s) ok 74 - host name not matching with a single X.509 Subject Alternative Name wildcard [06:19:32.706](0.000s) ok 75 - host name not matching with a single X.509 Subject Alternative Name wildcard: matches ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 31347 [06:19:33.101](0.395s) ok 76 - host matching an IPv4 address (Subject Alternative Name 1) [06:19:33.101](0.000s) ok 77 - host matching an IPv4 address (Subject Alternative Name 1): no stderr [06:19:33.158](0.056s) ok 78 - host matching an IPv4 address in alternate form (Subject Alternative Name 1) [06:19:33.158](0.000s) ok 79 - host matching an IPv4 address in alternate form (Subject Alternative Name 1): no stderr [06:19:33.216](0.058s) ok 80 - host not matching an IPv4 address (Subject Alternative Name 1) [06:19:33.217](0.000s) ok 81 - host not matching an IPv4 address (Subject Alternative Name 1): matches [06:19:33.265](0.049s) ok 82 - host matching an IPv6 address (Subject Alternative Name 2) [06:19:33.265](0.000s) ok 83 - host matching an IPv6 address (Subject Alternative Name 2): no stderr [06:19:33.322](0.057s) ok 84 - host matching an IPv6 address in alternate form (Subject Alternative Name 2) [06:19:33.323](0.000s) ok 85 - host matching an IPv6 address in alternate form (Subject Alternative Name 2): no stderr [06:19:33.349](0.027s) ok 86 - host matching an IPv6 address in mixed form (Subject Alternative Name 2) [06:19:33.350](0.000s) ok 87 - host matching an IPv6 address in mixed form (Subject Alternative Name 2): no stderr [06:19:33.389](0.040s) ok 88 - host not matching an IPv6 address (Subject Alternative Name 2) [06:19:33.389](0.000s) ok 89 - host not matching an IPv6 address (Subject Alternative Name 2): matches [06:19:33.435](0.045s) ok 90 - IPv6 host with CIDR mask does not match [06:19:33.435](0.000s) ok 91 - IPv6 host with CIDR mask does not match: matches ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 31486 [06:19:33.709](0.274s) ok 92 - certificate with both a CN and SANs 1 [06:19:33.709](0.000s) ok 93 - certificate with both a CN and SANs 1: no stderr [06:19:33.772](0.063s) ok 94 - certificate with both a CN and SANs 2 [06:19:33.773](0.000s) ok 95 - certificate with both a CN and SANs 2: no stderr [06:19:33.842](0.070s) ok 96 - certificate with both a CN and SANs ignores CN [06:19:33.842](0.000s) ok 97 - certificate with both a CN and SANs ignores CN: matches ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 31561 [06:19:34.140](0.297s) ok 98 - certificate with both a CN and IP SANs matches CN [06:19:34.140](0.000s) ok 99 - certificate with both a CN and IP SANs matches CN: no stderr [06:19:34.202](0.062s) ok 100 - certificate with both a CN and IP SANs matches SAN 1 [06:19:34.202](0.000s) ok 101 - certificate with both a CN and IP SANs matches SAN 1: no stderr [06:19:34.243](0.041s) ok 102 - certificate with both a CN and IP SANs matches SAN 2 [06:19:34.243](0.000s) ok 103 - certificate with both a CN and IP SANs matches SAN 2: no stderr ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 31651 [06:19:34.546](0.302s) ok 104 - certificate with both an IP CN and IP SANs 1 [06:19:34.546](0.000s) ok 105 - certificate with both an IP CN and IP SANs 1: no stderr [06:19:34.600](0.054s) ok 106 - certificate with both an IP CN and IP SANs 2 [06:19:34.601](0.000s) ok 107 - certificate with both an IP CN and IP SANs 2: no stderr [06:19:34.636](0.036s) ok 108 - certificate with both an IP CN and IP SANs ignores CN [06:19:34.637](0.000s) ok 109 - certificate with both an IP CN and IP SANs ignores CN: matches ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 31710 [06:19:34.946](0.310s) ok 110 - certificate with both an IP CN and DNS SANs matches CN [06:19:34.947](0.000s) ok 111 - certificate with both an IP CN and DNS SANs matches CN: no stderr [06:19:34.996](0.049s) ok 112 - certificate with both an IP CN and DNS SANs matches SAN 1 [06:19:34.996](0.000s) ok 113 - certificate with both an IP CN and DNS SANs matches SAN 1: no stderr [06:19:35.059](0.063s) ok 114 - certificate with both an IP CN and DNS SANs matches SAN 2 [06:19:35.059](0.000s) ok 115 - certificate with both an IP CN and DNS SANs matches SAN 2: no stderr ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 31783 [06:19:35.356](0.297s) ok 116 - server certificate without CN or SANs sslmode=verify-ca [06:19:35.356](0.000s) ok 117 - server certificate without CN or SANs sslmode=verify-ca: no stderr [06:19:35.395](0.039s) ok 118 - server certificate without CN or SANs sslmode=verify-full [06:19:35.395](0.000s) ok 119 - server certificate without CN or SANs sslmode=verify-full: matches ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 31827 [06:19:35.672](0.276s) ok 120 - sslrootcert=system does not connect with private CA [06:19:35.672](0.000s) ok 121 - sslrootcert=system does not connect with private CA: matches [06:19:35.702](0.030s) ok 122 - sslrootcert=system only accepts sslmode=verify-full [06:19:35.702](0.000s) ok 123 - sslrootcert=system only accepts sslmode=verify-full: matches [06:19:35.776](0.074s) ok 124 - sslrootcert=system connects with overridden SSL_CERT_FILE [06:19:35.776](0.000s) ok 125 - sslrootcert=system connects with overridden SSL_CERT_FILE: no stderr [06:19:35.822](0.046s) ok 126 - sslrootcert=system defaults to sslmode=verify-full [06:19:35.822](0.000s) ok 127 - sslrootcert=system defaults to sslmode=verify-full: matches ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 31894 [06:19:36.088](0.265s) ok 128 - connects without client-side CRL [06:19:36.088](0.000s) ok 129 - connects without client-side CRL: no stderr [06:19:36.122](0.035s) ok 130 - does not connect with client-side CRL file [06:19:36.123](0.000s) ok 131 - does not connect with client-side CRL file: matches [06:19:36.159](0.036s) ok 132 - does not connect with client-side CRL directory [06:19:36.159](0.000s) ok 133 - does not connect with client-side CRL directory: matches # Running: psql -X -A -F , -P null=_null_ -d sslkey=invalid sslcert=invalid sslrootcert=invalid sslcrl=invalid sslcrldir=invalid user=ssltestuser dbname=trustdb hostaddr=127.0.0.1 host=common-name.pg-ssltest.test sslrootcert=invalid -c SELECT * FROM pg_stat_ssl WHERE pid = pg_backend_pid() [06:19:36.219](0.060s) ok 134 - pg_stat_ssl view without client certificate: exit code 0 [06:19:36.219](0.000s) ok 135 - pg_stat_ssl view without client certificate: no stderr [06:19:36.220](0.000s) ok 136 - pg_stat_ssl view without client certificate: matches [06:19:36.276](0.056s) ok 137 - connection success with correct range of TLS protocol versions [06:19:36.276](0.000s) ok 138 - connection success with correct range of TLS protocol versions: no stderr [06:19:36.312](0.036s) ok 139 - connection failure with incorrect range of TLS protocol versions [06:19:36.312](0.000s) ok 140 - connection failure with incorrect range of TLS protocol versions: matches [06:19:36.331](0.019s) ok 141 - connection failure with an incorrect SSL protocol minimum bound [06:19:36.331](0.000s) ok 142 - connection failure with an incorrect SSL protocol minimum bound: matches [06:19:36.352](0.021s) ok 143 - connection failure with an incorrect SSL protocol maximum bound [06:19:36.353](0.000s) ok 144 - connection failure with an incorrect SSL protocol maximum bound: matches [06:19:36.353](0.000s) # running server tests [06:19:36.392](0.039s) ok 145 - certificate authorization fails without client cert [06:19:36.393](0.000s) ok 146 - certificate authorization fails without client cert: matches [06:19:36.475](0.082s) ok 147 - certificate authorization succeeds with correct client cert in PEM format [06:19:36.475](0.000s) ok 148 - certificate authorization succeeds with correct client cert in PEM format: no stderr [06:19:36.543](0.068s) ok 149 - certificate authorization succeeds with correct client cert in DER format [06:19:36.543](0.000s) ok 150 - certificate authorization succeeds with correct client cert in DER format: no stderr [06:19:36.612](0.069s) ok 151 - certificate authorization succeeds with correct client cert in encrypted PEM format [06:19:36.613](0.000s) ok 152 - certificate authorization succeeds with correct client cert in encrypted PEM format: no stderr [06:19:36.666](0.053s) ok 153 - certificate authorization succeeds with correct client cert in encrypted DER format [06:19:36.666](0.000s) ok 154 - certificate authorization succeeds with correct client cert in encrypted DER format: no stderr [06:19:36.747](0.081s) ok 155 - certificate authorization succeeds with correct client cert and sslcertmode=require [06:19:36.748](0.000s) ok 156 - certificate authorization succeeds with correct client cert and sslcertmode=require: no stderr [06:19:36.797](0.049s) ok 157 - certificate authorization succeeds with correct client cert and sslcertmode=allow [06:19:36.797](0.000s) ok 158 - certificate authorization succeeds with correct client cert and sslcertmode=allow: no stderr [06:19:36.852](0.055s) ok 159 - certificate authorization fails with correct client cert and sslcertmode=disable [06:19:36.852](0.000s) ok 160 - certificate authorization fails with correct client cert and sslcertmode=disable: matches [06:19:36.888](0.036s) ok 161 - certificate authorization fails with correct client cert and wrong password in encrypted PEM format [06:19:36.888](0.000s) ok 162 - certificate authorization fails with correct client cert and wrong password in encrypted PEM format: matches [06:19:36.935](0.047s) ok 163 - certificate authorization succeeds with DN mapping [06:19:36.936](0.000s) ok 164 - certificate authorization succeeds with DN mapping: no stderr [06:19:36.936](0.000s) ok 165 - certificate authorization succeeds with DN mapping: log matches [06:19:36.976](0.040s) ok 166 - certificate authorization succeeds with DN regex mapping [06:19:36.976](0.000s) ok 167 - certificate authorization succeeds with DN regex mapping: no stderr [06:19:37.042](0.066s) ok 168 - certificate authorization succeeds with CN mapping [06:19:37.042](0.000s) ok 169 - certificate authorization succeeds with CN mapping: no stderr [06:19:37.042](0.000s) ok 170 - certificate authorization succeeds with CN mapping: log matches [06:19:37.043](0.000s) not ok 171 # TODO & SKIP Need Pty support [06:19:37.043](0.000s) not ok 172 # TODO & SKIP Need Pty support [06:19:37.043](0.000s) not ok 173 # TODO & SKIP Need Pty support [06:19:37.043](0.000s) not ok 174 # TODO & SKIP Need Pty support # Running: psql -X -A -F , -P null=_null_ -d sslkey=invalid sslcert=invalid sslrootcert=invalid sslcrl=invalid sslcrldir=invalid sslrootcert=ssl/root+server_ca.crt sslmode=require dbname=certdb hostaddr=127.0.0.1 host=localhost user=ssltestuser sslcert=ssl/client.crt sslkey=/tmp/cirrus-ci-build/src/test/ssl/tmp_check/tmp_test_1EAA/client.key -c SELECT * FROM pg_stat_ssl WHERE pid = pg_backend_pid() [06:19:37.130](0.087s) ok 175 - pg_stat_ssl with client certificate: exit code 0 [06:19:37.130](0.000s) ok 176 - pg_stat_ssl with client certificate: no stderr [06:19:37.130](0.000s) ok 177 - pg_stat_ssl with client certificate: matches [06:19:37.189](0.059s) ok 178 - certificate authorization fails because of file permissions [06:19:37.190](0.000s) ok 179 - certificate authorization fails because of file permissions: matches [06:19:37.263](0.074s) ok 180 - certificate authorization fails with client cert belonging to another user [06:19:37.264](0.000s) ok 181 - certificate authorization fails with client cert belonging to another user: matches [06:19:37.307](0.043s) ok 182 - certificate authorization fails with revoked client cert [06:19:37.307](0.000s) ok 183 - certificate authorization fails with revoked client cert: matches [06:19:37.307](0.000s) ok 184 - certificate authorization fails with revoked client cert: log does not match [06:19:37.378](0.071s) ok 185 - auth_option clientcert=verify-full succeeds with matching username and Common Name [06:19:37.378](0.000s) ok 186 - auth_option clientcert=verify-full succeeds with matching username and Common Name: no stderr [06:19:37.378](0.000s) ok 187 - auth_option clientcert=verify-full succeeds with matching username and Common Name: log matches [06:19:37.429](0.050s) ok 188 - auth_option clientcert=verify-full fails with mismatching username and Common Name [06:19:37.429](0.000s) ok 189 - auth_option clientcert=verify-full fails with mismatching username and Common Name: matches [06:19:37.429](0.000s) ok 190 - auth_option clientcert=verify-full fails with mismatching username and Common Name: log does not match [06:19:37.498](0.069s) ok 191 - auth_option clientcert=verify-ca succeeds with mismatching username and Common Name [06:19:37.498](0.000s) ok 192 - auth_option clientcert=verify-ca succeeds with mismatching username and Common Name: no stderr [06:19:37.498](0.000s) ok 193 - auth_option clientcert=verify-ca succeeds with mismatching username and Common Name: log matches ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 32146 [06:19:37.762](0.264s) ok 194 - intermediate client certificate is provided by client [06:19:37.763](0.000s) ok 195 - intermediate client certificate is provided by client: no stderr [06:19:37.805](0.042s) ok 196 - intermediate client certificate is missing [06:19:37.805](0.000s) ok 197 - intermediate client certificate is missing: matches [06:19:37.873](0.068s) ok 198 - logged client certificate Subjects are truncated if they're too long [06:19:37.873](0.000s) ok 199 - logged client certificate Subjects are truncated if they're too long: matches ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 32210 [06:19:38.248](0.374s) ok 200 - intermediate client certificate is untrusted [06:19:38.248](0.000s) ok 201 - intermediate client certificate is untrusted: matches ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 32266 [06:19:38.502](0.254s) ok 202 - certificate authorization fails with revoked client cert with server-side CRL directory [06:19:38.502](0.000s) ok 203 - certificate authorization fails with revoked client cert with server-side CRL directory: matches [06:19:38.549](0.047s) ok 204 - certificate authorization fails with revoked UTF-8 client cert with server-side CRL directory [06:19:38.550](0.000s) ok 205 - certificate authorization fails with revoked UTF-8 client cert with server-side CRL directory: matches ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 32323 [06:19:38.813](0.264s) not ok 206 - connect with valid stapled ocsp response when sslocspstapling=1 [06:19:38.813](0.000s) [06:19:38.814](0.000s) # Failed test 'connect with valid stapled ocsp response when sslocspstapling=1' # at t/001_ssltests.pl line 923. [06:19:38.814](0.000s) # got: '2' # expected: '0' [06:19:38.814](0.000s) not ok 207 - connect with valid stapled ocsp response when sslocspstapling=1: no stderr [06:19:38.814](0.000s) [06:19:38.814](0.000s) # Failed test 'connect with valid stapled ocsp response when sslocspstapling=1: no stderr' # at t/001_ssltests.pl line 923. [06:19:38.814](0.000s) # got: 'psql: error: connection to server at "127.0.0.1", port 55446 failed: server closed the connection unexpectedly # This probably means the server terminated abnormally # before or while processing the request. # SSL SYSCALL error: Connection reset by peer' # expected: '' [06:19:38.938](0.124s) ok 208 - connect without requesting ocsp response when sslocspstapling=0 [06:19:38.938](0.000s) ok 209 - connect without requesting ocsp response when sslocspstapling=0: no stderr ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 32380 [06:19:39.191](0.253s) ok 210 - failed with a revoked ocsp response when sslocspstapling=1 [06:19:39.264](0.073s) ok 211 - connect without requesting ocsp response when sslocspstapling=0 [06:19:39.264](0.000s) ok 212 - connect without requesting ocsp response when sslocspstapling=0: no stderr ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 32445 [06:19:39.629](0.365s) ok 213 - failed with a revoked ocsp response when sslocspstapling=1 [06:19:39.715](0.086s) ok 214 - connect without requesting ocsp response when sslocspstapling=0 [06:19:39.716](0.000s) ok 215 - connect without requesting ocsp response when sslocspstapling=0: no stderr ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 32524 [06:19:40.069](0.353s) ok 216 - failed with an expired ocsp response when sslocspstapling=1 [06:19:40.120](0.051s) ok 217 - connect without requesting ocsp response when sslocspstapling=0 [06:19:40.120](0.000s) ok 218 - connect without requesting ocsp response when sslocspstapling=0: no stderr ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 32581 [06:19:40.497](0.377s) not ok 219 - connect with valid stapled ocsp response when sslocspstapling=1 [06:19:40.498](0.000s) [06:19:40.498](0.000s) # Failed test 'connect with valid stapled ocsp response when sslocspstapling=1' # at t/001_ssltests.pl line 1001. [06:19:40.498](0.000s) # got: '2' # expected: '0' [06:19:40.498](0.000s) not ok 220 - connect with valid stapled ocsp response when sslocspstapling=1: no stderr [06:19:40.498](0.000s) [06:19:40.498](0.000s) # Failed test 'connect with valid stapled ocsp response when sslocspstapling=1: no stderr' # at t/001_ssltests.pl line 1001. [06:19:40.498](0.000s) # got: 'psql: error: connection to server at "127.0.0.1", port 55446 failed: server closed the connection unexpectedly # This probably means the server terminated abnormally # before or while processing the request. # SSL SYSCALL error: Connection reset by peer' # expected: '' [06:19:40.579](0.081s) ok 221 - connect without requesting ocsp response when sslocspstapling=0 [06:19:40.580](0.000s) ok 222 - connect without requesting ocsp response when sslocspstapling=0: no stderr ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 32668 [06:19:40.855](0.275s) ok 223 - failed with a revoked ocsp response when sslocspstapling=1 [06:19:40.901](0.046s) ok 224 - connect without requesting ocsp response when sslocspstapling=0 [06:19:40.901](0.000s) ok 225 - connect without requesting ocsp response when sslocspstapling=0: no stderr ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 32732 [06:19:41.184](0.282s) ok 226 - failed with a revoked ocsp response when sslocspstapling=1 [06:19:41.266](0.083s) ok 227 - connect without requesting ocsp response when sslocspstapling=0 [06:19:41.267](0.000s) ok 228 - connect without requesting ocsp response when sslocspstapling=0: no stderr ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 32810 [06:19:41.535](0.268s) ok 229 - failed with an expired ocsp response when sslocspstapling=1 [06:19:41.580](0.045s) ok 230 - connect without requesting ocsp response when sslocspstapling=0 [06:19:41.580](0.000s) ok 231 - connect without requesting ocsp response when sslocspstapling=0: no stderr ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 32875 [06:19:41.775](0.194s) ok 232 - failed with an expired ocsp response when sslocspstapling=1 [06:19:41.846](0.071s) ok 233 - connect without requesting ocsp response when sslocspstapling=0 [06:19:41.846](0.000s) ok 234 - connect without requesting ocsp response when sslocspstapling=0: no stderr ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/ssl/tmp_check/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... stopped waiting pg_ctl: could not start server Examine the log output. # pg_ctl restart failed; see logfile for details: /tmp/cirrus-ci-build/src/test/ssl/tmp_check/log/001_ssltests_primary.log # No postmaster PID for node "primary" [06:19:42.071](0.225s) Bail out! pg_ctl restart failed # No postmaster PID for node "primary"