Where can I write my questio for couchbase

SQL++
1

I used to practice on Couchbase queries on N1Q1 which is already provided with sample data

I mean that usually, I open this folder
couchbase-query_dev_preview3_x86_64_win
and then I run the start_tutorial.bat and start learning

now I have got a Couchbase server and I have some queries
my questions

where can I find the place in Coucbase server to write my queries ?

thanks

2

To use the command-line interactive query tool ./cbq -engine=http://:8093/

3

To use the command-line interactive query tool ./cbq -engine=http://–couchbase-query-engine-server-name–:8093/

4

Hello,

You need to connect your query engine to your Couchbase server. After that, you can use the cbq command-line shell to issue queries. Here are the instructions from query.couchbase.com:

Step 1. Expand the package archive
Step 2. Run ./start_tutorial.sh (On Windows start_tutorial.bat)
Step 3. Open http://localhost:8093/tutorial in your browser
To connect to a Couchbase Server ./cbq-engine -couchbase http://–couchbase-server-name–:8091/

Please comment here if you need more help.

5

Thanks for your answer but I still didn’t get it.

I tried your code ./cbq-engine -couchbase http://–couchbase-server-name–:8091/ but putting it into the web page that I got when opening the start tutorial.bat , but I got error, I tried put my server link in the start tutorial instead of the local host link, but that didn’t work. could you tell me please where should I put the cbq command? plus the server has a username and a password, where should I put them. thanks for the efforts

6

Hello, N1QL DP3 does not work with password-protected buckets.

The following command applies to the command-line, not your browser:

./cbq-engine -couchbase http://–couchbase-server-name–:8091/

Replace --couchbase-server-name-- with the actual name or IP address of your Couchbase server host.

cbq-engine and cbq are command-line programs.

7

Hello, I was able to query password-protected buckets by using the following command:

./cbq-engine -couchbase http://username:password@servername:8091/

where username/password are the credentials to log in the Couchbase console.

Hope it helps!

8

Thanks for sharing this!

9

That might be a separate issue. One of our engineers will troubleshoot that with you.

Thanks.

10

Unfortunately, it only works with empty buckets. If you try to query a bucket with a single document, it returns an error and you cannot even query buckets without password :frowning:

11

Thanks a lot!