CODEWITHSUNDEEP
couchbasesql++
Carlos F
Carlos F

Reputation: 4981

Get Couchbase nodes and indexes through N1QL in Community Edition?

I've been looking for a way to get in the server nodes in a cluster through N1QL.

The role query_system_catalog can be used to get the nodes through 

SELECT * FROM system:node

But this role is only available, from what I can see, in the Enterprise edition. Is there a way to get them through n1ql in Community Edition?

Edit:

This is the error shown

<N1QL Execution failed, OBJ={u'msg': u'User does not have credentials to run queries accessing the system tables. Add role query_system_catalog to allow the query to run.', u'code': 13014}>```

Upvotes: 1

Views: 106

Answers (2)

Johan Larson
Johan Larson

Reputation: 1890

The Administrator role should be available in CE. Try running the query as Administrator.

Upvotes: 1

vsr
vsr

Reputation: 7414

RBAC roles are supported in EE only https://www.couchbase.com/products/editions.

In CE there is no roles. Once user is logged in, the following command should work

select * from system:nodes;

Upvotes: 1

Related Questions