CODEWITHSUNDEEP
cassandra
mikcutu
mikcutu

Reputation: 1092

Authentication via username and password in Cassandra

In order to create a DBLink from Oracle to Cassandra, I am trying to have a connection in Cassandra via username and password. By default, the installation of Cassandra does not ask for username. Searching here, I found a topic where it is described the steps for that. unfortunately, when I modify the authenticator and authorizer parameters, the Cassandra CQL Shell opens and immediately closes.

Cassandra Installer version: datastax-ddc-64bit-3.9.0.msi

OS: Windows 7

Can someone tell me how to solve this, please?

Thank you,

Upvotes: 0

Views: 1906

Answers (1)

undefined_variable
undefined_variable

Reputation: 6218

To Solve CQL Shell error edit cqlshrc file.

Default location in windows is C:\Users\USER\.cassandra where USER is windows username.

In cqlshrc file edit following:

[authentication]
;; If Cassandra has auth enabled, fill out these options
username = cassandra
password = cassandra

Note cassandra is default username & password which is also a superuser.

Upvotes: 1

Related Questions