sql/pgwire: TestAuthenticationAndHBARules failed

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.

Other

30.05k stars 3.8k forks source link

config [1 args] <no input to command> ---- datadriven.go:144: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1318/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/pgwire/pgwire_test_/pgwire_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/pgwire/testdata/auth/hba_default_equivalence:12: set_hba [0 args] host all root all cert-password host all all all cert-password local all all password ---- # Active authentication configuration on this node: # Original configuration: # loopback all all all trust # built-in CockroachDB default # host all root all cert-password # host all all all cert-password # local all all password # # Interpreted configuration: # TYPE DATABASE USER ADDRESS METHOD OPTIONS loopback all all all trust host all root all cert-password host all all all cert-password local all all password panic.go:523: -- test log scope end -- test logs left over in: /artifacts/tmp/_tmp/28616e575ae934b92eba220441c7ca42/logTestAuthenticationAndHBARules_insecure=false_hba_default_equivalence1610180880 --- FAIL: TestAuthenticationAndHBARules/insecure=false/hba_default_equivalence (1.23s) === RUN TestAuthenticationAndHBARules/insecure=false/hba_default_equivalence/root datadriven.go:259: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1318/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/pgwire/pgwire_test_/pgwire_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/pgwire/testdata/auth/hba_default_equivalence:34: connect [1 args] <no input to command> ---- ok defaultdb datadriven.go:259: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1318/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/pgwire/pgwire_test_/pgwire_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/pgwire/testdata/auth/hba_default_equivalence:40: 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/1318/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/pgwire/pgwire_test_/pgwire_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/pgwire/testdata/auth/hba_default_equivalence:46: expected: ERROR: password authentication failed for user root (SQLSTATE 28P01) found: ERROR: pq: SSL is not enabled on the server --- FAIL: TestAuthenticationAndHBARules/insecure=false/hba_default_equivalence/root (0.03s) === RUN TestAuthenticationAndHBARules/insecure=false --- FAIL: TestAuthenticationAndHBARules/insecure=false (24.10s)

sql/pgwire.TestAuthenticationAndHBARules failed with artifacts on release-23.2 @ 77237763413fff744e598f85a8b554ac3de66c38:

        HINT: consider using .ApplicationLayer().GetAdminHTTPClient() instead.
    conditional_wrap.go:189: TIP: consider replacing the test server initialization from:
            ts, ... := serverutils.StartServer(t, ...)
            defer ts.Stopper().Stop(...)
        to:
            srv, ... := serverutils.StartServer(t, ...)
            defer srv.Stopper().Stop(...)
            ts := srv.ApplicationLayer()

        See also: https://go.crdb.dev/p/testserver-and-cluster-virtualization
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/19/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/pgwire/pgwire_test_/pgwire_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/pgwire/testdata/auth/special_cases:3:
        config [1 args]
        <no input to command>
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/19/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/pgwire/pgwire_test_/pgwire_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/pgwire/testdata/auth/special_cases:6:
        sql [0 args]
        CREATE USER passworduser WITH PASSWORD 'pass'
        ----
        ok
    panic.go:523: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/28616e575ae934b92eba220441c7ca42/logTestAuthenticationAndHBARules_insecure=false_special_cases2614998304
        --- FAIL: TestAuthenticationAndHBARules/insecure=false/special_cases (1.39s)
=== RUN   TestAuthenticationAndHBARules/insecure=false/special_cases/root_user_cannot_use_password
    datadriven.go:259: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/19/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/pgwire/pgwire_test_/pgwire_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/pgwire/testdata/auth/special_cases:17:
        set_hba [0 args]
        host all root 0.0.0.0/0 password
        ----
        # Active authentication configuration on this node:
        # Original configuration:
        # loopback all all all trust       # built-in CockroachDB default
        # host  all root all cert-password # CockroachDB mandatory rule
        # host all root 0.0.0.0/0 password
        #
        # Interpreted configuration:
        # TYPE   DATABASE USER ADDRESS   METHOD        OPTIONS
        loopback all      all  all       trust
        host     all      root all       cert-password
        host     all      root 0.0.0.0/0 password
    datadriven.go:259: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/19/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/pgwire/pgwire_test_/pgwire_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/pgwire/testdata/auth/special_cases:32:

        expected:
        ERROR: password authentication failed for user root (SQLSTATE 28P01)

        found:
        ERROR: pq: SSL is not enabled on the server
            --- FAIL: TestAuthenticationAndHBARules/insecure=false/special_cases/root_user_cannot_use_password (0.02s)

Parameters:

TAGS=bazel,gss
stress=true
Help

Same failure on other branches

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

This test on roachdash | Improve this report!

cockroachdb / cockroach

sql/pgwire: TestAuthenticationAndHBARules failed #131110