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

[cbq parameters] \set -creds test:'pass:123' in cbq shell:Authorization Failed Keyspace test - cause: Expecting 200 or 401 from ns_server auth endpoint. Got: 500 Internal Server Error"

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 4.6.3, 5.0.0
    • 4.6.3
    • query
    • None
    • 4.6.3.-4055
    • Untriaged
    • Unknown

    Description

      Found this bug while verifying MB-25167.

      1. Install 4.6.3.-4055
      2. create a bucket test with password as pass:123,create primary index on it through UI.
      3. connect to cbq as:

      cbq> [root@localhost bin]# ./cbq
       No input credentials. In order to connect to a server with authentication, please provide credentials.
       ERROR 100 : N1QL: Connection failure Requested resource not found.
       
       
       
       Path to history file for the shell : /root/.cbq_history 
      cbq> \connect http://localhost:8091;
       
       Couchbase query shell not connected to any endpoint. Use \CONNECT command to connect.
       ERROR 100 : N1QL: Connection failure Requested resource not found.
       
       
      cbq> \connect http://localhost:8093;
       Connected to : http://localhost:8093. Type Ctrl-D or \QUIT to exit.
      cbq> 
      
      

      4. set creds for the bucket:
      \set -creds test:'pass:123';

      5. Try to query this bucket.
      cbq> select * from test;
      {
      "requestID": "ed40c8df-658c-430c-9fcd-27b06d45db7c",
      "signature":

      { "*": "*" }

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

      { "code": 10000, "msg": "Authorization Failed Keyspace test - cause: Expecting 200 or 401 from ns_server auth endpoint. Got: 500 Internal Server Error" }

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

      { "elapsedTime": "3.120383ms", "executionTime": "3.062727ms", "resultCount": 0, "resultSize": 0, "errorCount": 1 }

      }

      6. If I have another bucket bucket0 with password as password then the above steps work for it.

      cbq> \set -creds bucket0:password;
      cbq> select * from bucket0;
      {
      "requestID": "9c05e259-d587-4887-a05a-c675632af876",
      "signature":

      { "*": "*" }

      ,
      "results": [
      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "12.647742ms", "executionTime": "12.602162ms", "resultCount": 0, "resultSize": 0 }

      }

      Attachments

        Issue Links

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

          Activity

            People

              ajay.bhullar Ajay Bhullar
              Prerna.Manaktala Prerna Manaktala (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty