Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-19077

N1QL: password protected bucket: Auth failure seen even after editing beer-sample to have no password

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 4.5.0
    • 4.5.0
    • query
    • 4.5.0-2023 macos
    • Untriaged
    • Unknown

    Description

      1. select beer-sample during setup of couchbase on mac.
      2. delete default bucket
      3. create travel-sample through sample buckets.
      4. Make both buckets password-protected.
      5. Issue queries for union and join for beer-sample and travel-sample through curl and cbq with/without credentials, results are correct.
      6. Edit travel-sample and remove password.
      7. Queries in step 5 work correctly.
      8. Edit beer-sample and remove password
      9. Execute this simple query:
      prernamanaktala@couchbases-MacBook-Pro bin $ ./cbq
      No Input Credentials. In order to connect to a server with authentication, please provide credentials.
      Connected to : http://localhost:8093/. Type Ctrl-D to exit.

      cbq> select count as test from `beer-sample`;
      {
      "requestID": "9f2de946-afff-434d-b0fc-dc037e4fd6bc",
      "signature":

      { "test": "number" }

      ,
      "results": [
      ],
      "errors": [

      { "code": 10000, "msg": "Authorization Failed Keyspace beer-sample" }

      ],
      "status": "stopped",
      "metrics":

      { "elapsedTime": "952.679µs", "executionTime": "918.185µs", "resultCount": 0, "resultSize": 0, "errorCount": 1 }

      }

      Same result through curl command.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            johan.larson Johan Larson (Inactive)
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty