[21:07:05.488](0.015s) # setting up data directory # Checking port 57341 # Found port 57341 Name: primary Data directory: /tmp/cirrus-ci-build/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/archives Connection string: port=57341 host=/tmp/lS7JJS98ZV Log file: /tmp/cirrus-ci-build/build/testrun/ssl/002_scram/log/002_scram_primary.log [21:07:05.491](0.003s) # initializing database system by copying initdb template # Running: cp -RPp /tmp/cirrus-ci-build/build/tmp_install/initdb-template /tmp/cirrus-ci-build/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata ### Starting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/ssl/002_scram/log/002_scram_primary.log -o --cluster-name=primary start pg_ctl: another server might be running; trying to start server anyway waiting for server to start.... done server started # Postmaster PID for node "primary" is 33647 psql: error: connection to server on socket "/tmp/lS7JJS98ZV/.s.PGSQL.57341" failed: FATAL: database "postgres" does not exist psql: error: connection to server on socket "/tmp/lS7JJS98ZV/.s.PGSQL.57341" failed: FATAL: database "postgres" does not exist psql: error: connection to server on socket "/tmp/lS7JJS98ZV/.s.PGSQL.57341" failed: FATAL: database "postgres" does not exist psql: error: connection to server on socket "/tmp/lS7JJS98ZV/.s.PGSQL.57341" failed: FATAL: database "postgres" does not exist psql: error: connection to server on socket "/tmp/lS7JJS98ZV/.s.PGSQL.57341" failed: FATAL: database "postgres" does not exist psql: error: connection to server on socket "/tmp/lS7JJS98ZV/.s.PGSQL.57341" failed: FATAL: database "postgres" does not exist psql: error: connection to server on socket "/tmp/lS7JJS98ZV/.s.PGSQL.57341" failed: FATAL: database "postgres" does not exist psql: error: connection to server on socket "/tmp/lS7JJS98ZV/.s.PGSQL.57341" failed: FATAL: database "postgres" does not exist psql: error: connection to server on socket "/tmp/lS7JJS98ZV/.s.PGSQL.57341" failed: FATAL: database "postgres" does not exist psql: error: connection to server on socket "/tmp/lS7JJS98ZV/.s.PGSQL.57341" failed: FATAL: database "postgres" does not exist psql: error: connection to server on socket "/tmp/lS7JJS98ZV/.s.PGSQL.57341" failed: FATAL: database "postgres" does not exist psql: error: connection to server on socket "/tmp/lS7JJS98ZV/.s.PGSQL.57341" failed: FATAL: database "postgres" does not exist psql: error: connection to server on socket "/tmp/lS7JJS98ZV/.s.PGSQL.57341" failed: FATAL: database "postgres" does not exist psql: error: connection to server on socket "/tmp/lS7JJS98ZV/.s.PGSQL.57341" failed: FATAL: database "postgres" does not exist ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/ssl/002_scram/log/002_scram_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 33778 ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/ssl/002_scram/log/002_scram_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 33827 [21:07:06.691](1.200s) not ok 1 - Basic SCRAM authentication with SSL [21:07:06.691](0.000s) # Failed test 'Basic SCRAM authentication with SSL' # at /tmp/cirrus-ci-build/src/test/ssl/t/002_scram.pl line 82. [21:07:06.691](0.000s) # got: '2' # expected: '0' [21:07:06.691](0.000s) not ok 2 - Basic SCRAM authentication with SSL: no stderr [21:07:06.691](0.000s) # Failed test 'Basic SCRAM authentication with SSL: no stderr' # at /tmp/cirrus-ci-build/src/test/ssl/t/002_scram.pl line 82. [21:07:06.692](0.000s) # got: 'psql: error: connection to server at "127.0.0.1", port 57341 failed: FATAL: password authentication failed for user "ssltestuser"' # expected: '' [21:07:06.698](0.007s) ok 3 - SCRAM with SSL and channel_binding=invalid_value [21:07:06.699](0.000s) ok 4 - SCRAM with SSL and channel_binding=invalid_value: matches [21:07:06.712](0.014s) not ok 5 - SCRAM with SSL and channel_binding=disable [21:07:06.713](0.000s) # Failed test 'SCRAM with SSL and channel_binding=disable' # at /tmp/cirrus-ci-build/src/test/ssl/t/002_scram.pl line 91. [21:07:06.713](0.000s) # got: '2' # expected: '0' [21:07:06.713](0.000s) not ok 6 - SCRAM with SSL and channel_binding=disable: no stderr [21:07:06.713](0.000s) # Failed test 'SCRAM with SSL and channel_binding=disable: no stderr' # at /tmp/cirrus-ci-build/src/test/ssl/t/002_scram.pl line 91. [21:07:06.713](0.000s) # got: 'psql: error: connection to server at "127.0.0.1", port 57341 failed: FATAL: password authentication failed for user "ssltestuser"' # expected: '' [21:07:06.726](0.013s) not ok 7 - SCRAM with SSL and channel_binding=require [21:07:06.727](0.000s) # Failed test 'SCRAM with SSL and channel_binding=require' # at /tmp/cirrus-ci-build/src/test/ssl/t/002_scram.pl line 93. [21:07:06.727](0.000s) # got: '2' # expected: '0' [21:07:06.727](0.000s) not ok 8 - SCRAM with SSL and channel_binding=require: no stderr [21:07:06.727](0.000s) # Failed test 'SCRAM with SSL and channel_binding=require: no stderr' # at /tmp/cirrus-ci-build/src/test/ssl/t/002_scram.pl line 93. [21:07:06.727](0.000s) # got: 'psql: error: connection to server at "127.0.0.1", port 57341 failed: FATAL: password authentication failed for user "ssltestuser"' # expected: '' [21:07:06.727](0.000s) ok 9 # skip MD5 not supported [21:07:06.741](0.013s) ok 10 - Cert authentication and channel_binding=require [21:07:06.741](0.000s) ok 11 - Cert authentication and channel_binding=require: matches [21:07:06.758](0.017s) not ok 12 - SCRAM with clientcert=verify-full [21:07:06.758](0.000s) # Failed test 'SCRAM with clientcert=verify-full' # at /tmp/cirrus-ci-build/src/test/ssl/t/002_scram.pl line 128. [21:07:06.758](0.000s) # got: '2' # expected: '0' [21:07:06.758](0.000s) not ok 13 - SCRAM with clientcert=verify-full: no stderr [21:07:06.758](0.000s) # Failed test 'SCRAM with clientcert=verify-full: no stderr' # at /tmp/cirrus-ci-build/src/test/ssl/t/002_scram.pl line 128. [21:07:06.758](0.000s) # got: 'psql: error: connection to server at "127.0.0.1", port 57341 failed: FATAL: password authentication failed for user "ssltestuser" # connection to server at "127.0.0.1", port 57341 failed: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "ssltestuser", database "verifydb", no encryption' # expected: '' [21:07:06.759](0.000s) not ok 14 - SCRAM with clientcert=verify-full: log matches [21:07:06.759](0.000s) # Failed test 'SCRAM with clientcert=verify-full: log matches' # at /tmp/cirrus-ci-build/src/test/perl/PostgreSQL/Test/Cluster.pm line 2350. [21:07:06.759](0.000s) # '2024-03-04 21:07:06.747 UTC [33865][not initialized] [[unknown]][:0] LOG: connection received: host=localhost port=44200 # 2024-03-04 21:07:06.755 UTC [33865][client backend] [[unknown]][4/1:0] FATAL: password authentication failed for user "ssltestuser" # 2024-03-04 21:07:06.755 UTC [33865][client backend] [[unknown]][4/1:0] DETAIL: Role "ssltestuser" does not exist. # Connection matched file "/tmp/cirrus-ci-build/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf" line 4: "hostssl verifydb ssltestuser 127.0.0.1/32 scram-sha-256 clientcert=verify-full" # 2024-03-04 21:07:06.756 UTC [33868][not initialized] [[unknown]][:0] LOG: connection received: host=localhost port=44206 # 2024-03-04 21:07:06.756 UTC [33868][client backend] [[unknown]][5/1:0] FATAL: no pg_hba.conf entry for host "127.0.0.1", user "ssltestuser", database "verifydb", no encryption # 2024-03-04 21:07:06.756 UTC [33868][client backend] [[unknown]][5/1:0] DETAIL: Client IP address resolved to "localhost", forward lookup not checked. # ' # doesn't match '(?^:connection authenticated: identity="ssltestuser" method=scram-sha-256)' [21:07:06.772](0.013s) not ok 15 - SCRAM with SSL, channel_binding=disable, and require_auth=scram-sha-256 [21:07:06.772](0.000s) # Failed test 'SCRAM with SSL, channel_binding=disable, and require_auth=scram-sha-256' # at /tmp/cirrus-ci-build/src/test/ssl/t/002_scram.pl line 136. [21:07:06.772](0.000s) # got: '2' # expected: '0' [21:07:06.773](0.000s) not ok 16 - SCRAM with SSL, channel_binding=disable, and require_auth=scram-sha-256: no stderr [21:07:06.773](0.000s) # Failed test 'SCRAM with SSL, channel_binding=disable, and require_auth=scram-sha-256: no stderr' # at /tmp/cirrus-ci-build/src/test/ssl/t/002_scram.pl line 136. [21:07:06.773](0.000s) # got: 'psql: error: connection to server at "127.0.0.1", port 57341 failed: FATAL: password authentication failed for user "ssltestuser"' # expected: '' [21:07:06.773](0.000s) ok 17 # skip MD5 not supported [21:07:06.788](0.015s) not ok 18 - SCRAM with SSL, channel_binding=require, and require_auth=scram-sha-256 [21:07:06.788](0.000s) # Failed test 'SCRAM with SSL, channel_binding=require, and require_auth=scram-sha-256' # at /tmp/cirrus-ci-build/src/test/ssl/t/002_scram.pl line 151. [21:07:06.789](0.000s) # got: '2' # expected: '0' [21:07:06.789](0.000s) not ok 19 - SCRAM with SSL, channel_binding=require, and require_auth=scram-sha-256: no stderr [21:07:06.789](0.000s) # Failed test 'SCRAM with SSL, channel_binding=require, and require_auth=scram-sha-256: no stderr' # at /tmp/cirrus-ci-build/src/test/ssl/t/002_scram.pl line 151. [21:07:06.789](0.000s) # got: 'psql: error: connection to server at "127.0.0.1", port 57341 failed: FATAL: password authentication failed for user "ssltestuser"' # expected: '' ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/ssl/002_scram/log/002_scram_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 33901 [21:07:07.077](0.288s) not ok 20 - SCRAM with SSL and channel_binding=require, server certificate uses 'rsassaPss' [21:07:07.078](0.000s) # Failed test 'SCRAM with SSL and channel_binding=require, server certificate uses 'rsassaPss'' # at /tmp/cirrus-ci-build/src/test/ssl/t/002_scram.pl line 161. [21:07:07.078](0.000s) # got: '2' # expected: '0' [21:07:07.078](0.000s) not ok 21 - SCRAM with SSL and channel_binding=require, server certificate uses 'rsassaPss': no stderr [21:07:07.078](0.000s) # Failed test 'SCRAM with SSL and channel_binding=require, server certificate uses 'rsassaPss': no stderr' # at /tmp/cirrus-ci-build/src/test/ssl/t/002_scram.pl line 161. [21:07:07.078](0.000s) # got: 'psql: error: connection to server at "127.0.0.1", port 57341 failed: FATAL: password authentication failed for user "ssltestuser"' # expected: '' [21:07:07.078](0.000s) not ok 22 - SCRAM with SSL and channel_binding=require, server certificate uses 'rsassaPss': log matches [21:07:07.079](0.000s) # Failed test 'SCRAM with SSL and channel_binding=require, server certificate uses 'rsassaPss': log matches' # at /tmp/cirrus-ci-build/src/test/perl/PostgreSQL/Test/Cluster.pm line 2350. [21:07:07.079](0.000s) # '2024-03-04 21:07:07.070 UTC [33923][not initialized] [[unknown]][:0] LOG: connection received: host=localhost port=44230 # 2024-03-04 21:07:07.076 UTC [33923][client backend] [[unknown]][0/1:0] FATAL: password authentication failed for user "ssltestuser" # 2024-03-04 21:07:07.076 UTC [33923][client backend] [[unknown]][0/1:0] DETAIL: Role "ssltestuser" does not exist. # Connection matched file "/tmp/cirrus-ci-build/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf" line 3: "hostssl trustdb all 127.0.0.1/32 scram-sha-256" # ' # doesn't match '(?^:connection authenticated: identity="ssltestuser" method=scram-sha-256)' [21:07:07.079](0.000s) 1..22 ### Stopping node "primary" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "primary" [21:07:07.182](0.103s) # Looks like you failed 16 tests of 22.