sql/pgwire: TestAuthenticationAndHBARules failed

[cockroach-teamcity]

sql/pgwire.TestAuthenticationAndHBARules failed with artifacts on release-24.3 @ 0cdee993a38a8e058af6440c6ea48fcb4237a024:

    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/14307/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/pgwire/pgwire_test_/pgwire_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/pgwire/testdata/auth/empty_hba:16:
        config [1 args]
        <no input to command>
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/14307/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/pgwire/pgwire_test_/pgwire_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/pgwire/testdata/auth/empty_hba:20:
        set_hba [0 args]
        <no input to command>
        ----
        # Active authentication configuration on this node:
        # Original configuration:
        # host  all root all cert-password # CockroachDB mandatory rule
        # loopback all all all trust       # built-in CockroachDB default
        # host     all all all cert-password # built-in CockroachDB default
        # local    all all     password      # built-in CockroachDB default
        #
        # Interpreted configuration:
        # TYPE   DATABASE USER ADDRESS METHOD        OPTIONS
        host     all      root all     cert-password
        loopback all      all  all     trust
        host     all      all  all     cert-password
        local    all      all          password
    panic.go:626: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/9df7e2b43c6703c48b37b40add1a12cd/logTestAuthenticationAndHBARules_insecure=false_empty_hba3591639318
        --- FAIL: TestAuthenticationAndHBARules/insecure=false/empty_hba (0.72s)
=== RUN   TestAuthenticationAndHBARules/insecure=false/empty_hba/root
    datadriven.go:259: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/14307/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/pgwire/pgwire_test_/pgwire_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/pgwire/testdata/auth/empty_hba:39:
        connect [1 args]
        <no input to command>
        ----
        ok defaultdb
    datadriven.go:259: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/14307/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/pgwire/pgwire_test_/pgwire_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/pgwire/testdata/auth/empty_hba:45:
        connect_unix [1 args]
        <no input to command>
        ----
        ERROR: password authentication failed for user root (SQLSTATE 28P01)
    datadriven.go:259: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/14307/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/pgwire/pgwire_test_/pgwire_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/pgwire/testdata/auth/empty_hba:51:
         
        expected:
        ERROR: password authentication failed for user root (SQLSTATE 28P01)
        
        found:
        ERROR: pq: SSL is not enabled on the server
            --- FAIL: TestAuthenticationAndHBARules/insecure=false/empty_hba/root (0.02s)
=== RUN   TestAuthenticationAndHBARules/insecure=false
    --- FAIL: TestAuthenticationAndHBARules/insecure=false (19.31s)

Help

See also: How To Investigate a Go Test Failure (internal)

Same failure on other branches

• sql/pgwire: TestAuthenticationAndHBARules failed #132769 sql/pgwire: TestAuthenticationAndHBARules failed [C-test-failure O-robot T-product-security branch-release-23.2.13-rc]
• sql/pgwire: TestAuthenticationAndHBARules failed #131978 sql/pgwire: TestAuthenticationAndHBARules failed [C-test-failure O-robot T-product-security branch-release-23.1.28-rc]
• sql/pgwire: TestAuthenticationAndHBARules failed #131532 sql/pgwire: TestAuthenticationAndHBARules failed [C-test-failure O-robot P-2 T-product-security branch-master]
• sql/pgwire: TestAuthenticationAndHBARules failed #131110 sql/pgwire: TestAuthenticationAndHBARules failed [C-test-failure O-robot P-2 T-product-security branch-release-23.2]
• sql/pgwire: TestAuthenticationAndHBARules failed #130253 sql/pgwire: TestAuthenticationAndHBARules failed [C-test-failure O-robot P-2 T-product-security branch-release-23.1.26-rc]
• sql/pgwire: TestAuthenticationAndHBARules failed #127745 sql/pgwire: TestAuthenticationAndHBARules failed [C-test-failure O-robot P-2 T-product-security branch-release-23.1]

/cc @cockroachdb/sql-foundations @cockroachdb/server @cockroachdb/product-security

This test on roachdash | Improve this report!

Jira issue: CRDB-43555

[rafiss]

Unfortunately this last failure was on a commit from before #133229 was merged, so we don't have the extra logs

[blathers-crl]

Based on the specified backports for linked PR #135086, I applied the following new label(s) to this issue: branch-release-23.1, branch-release-23.2, branch-release-24.1, branch-release-24.2. Please adjust the labels as needed to match the branches actually affected by this issue, including adding any known older branches.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}