github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/pgwire/testdata/auth/hba_syntax (about)

     1  set_hba
     2  local
     3  ----
     4  ERROR: line 1: end-of-line before database specification (SQLSTATE F0000)
     5  
     6  set_hba
     7  #empty
     8  ----
     9  ERROR: no entries
    10  HINT: To use the default configuration, assign the empty string ('').
    11  
    12  set_hba
    13  host all all 1.1.1/0 cert
    14  ----
    15  ERROR: line 1: invalid CIDR address: 1.1.1/0 (SQLSTATE F0000)
    16  
    17  set_hba
    18  host all all 0.0.0.0/0 invalid
    19  ----
    20  ERROR: unimplemented: unknown auth method "invalid" (SQLSTATE 0A000)
    21  HINT: You have attempted to use a feature that is not yet implemented.<STANDARD REFERRAL>
    22  --
    23  Supported methods: cert, cert-password, password, reject, trust
    24  
    25  
    26  # CockroachDB does not (yet?) support per-db HBA rules.
    27  set_hba
    28  host db all 0.0.0.0/0 cert
    29  ----
    30  ERROR: unimplemented: per-database HBA rules are not supported (SQLSTATE 0A000)
    31  HINT: You have attempted to use a feature that is not yet implemented.<STANDARD REFERRAL>
    32  --
    33  Use the special value 'all' (without quotes) to match all databases.
    34  
    35  
    36  # quoted "all" isn't ok since it strips the special meaning.
    37  set_hba
    38  host "all" all 0.0.0.0/0 cert
    39  ----
    40  ERROR: unimplemented: per-database HBA rules are not supported (SQLSTATE 0A000)
    41  HINT: You have attempted to use a feature that is not yet implemented.<STANDARD REFERRAL>
    42  --
    43  Use the special value 'all' (without quotes) to match all databases.
    44  
    45  
    46  # CockroachDB does not (yet?) support hostname-based HBA rules.
    47  set_hba
    48  host all all hostname cert
    49  ----
    50  ERROR: unimplemented: hostname-based HBA rules are not supported (SQLSTATE 0A000)
    51  HINT: You have attempted to use a feature that is not yet implemented.<STANDARD REFERRAL>
    52  --
    53  List the numeric CIDR notation instead, for example: 127.0.0.1/8.
    54  Alternatively, use 'all' (without quotes) for any IPv4/IPv6 address.