Hi Team:
theowl@c-node2:/etc/dse/cassandra$ cqlsh 192.168.56.101 -u cassandra -p cassandra Connected to KillrVideoCluster at 192.168.56.101:9042.[cqlsh 5.0.1 | DSE 6.7.8 | CQL spec 3.4.5 | DSE protocol v2]Use HELP for help. cassandra@cqlsh> list roles; Unauthorized: Error from server: code=2100 [Unauthorized] message="Anonymous users are not authorized to perform this request" cassandra@cqlsh> CREATE ROLE theowl with SUPERUSER = true AND LOGIN = true and PASSWORD = 'Zangetsu'; Unauthorized: Error from server: code=2100 [Unauthorized] message="Anonymous users are not authorized to perform this request" cassandra@cqlsh> show version; [cqlsh 5.0.1 | DSE 6.7.8 | CQL spec 3.4.5 | DSE protocol v2] cassandra@cqlsh> show host; Connected to KillrVideoCluster at 192.168.56.101:9042.
I have installed DSE 6.7 as instructed in the installation docs. tried doing LIST ROLES which failed with the above error. So I thought of creating another superuser connecting to Cassandra as user cassandra. Even the user creation is failing with the same error.
I used the following instructions to create a superuser as suggested in the installation page:
https://docs.datastax.com/en/security/6.7/security/Auth/secCreateRootAccount.html
Is this something related to "DSE Unified Authentication"? Or did I miss something super obvious with configuration?