0

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,

undefined_variable
  • 6,180
  • 2
  • 22
  • 37
mikcutu
  • 1,013
  • 2
  • 17
  • 34

1 Answers1

1

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.

undefined_variable
  • 6,180
  • 2
  • 22
  • 37
  • It is working but what about if I want to connect with other user? Should I connect to Cassandra with default login credentials and create the new user from there? – mikcutu Jul 11 '18 at 13:16
  • create a new role in cassandra and use that user.. Other option is to run cqlsh from command line.... `\bin\cqlsh -u -p ` – undefined_variable Jul 12 '18 at 05:57