Error from server: code=0100 [Bad credentials] message="Username and/or password are incorrect"'

[Martin Dünkelmann]

Dear Cassandra Juju Charm-Team,

I can't find login data anywhere.
I need the standard username and passwort to login with cqlsh.

"cassandra" "cassandra" are not the preset credentials.
(Like the official cassandra documentation describes)

Greetings

predic8mduenkelmann

[Stuart Bishop (stub)]

As you discovered, the default credentials are changed during installation per best practice.

Relations get given their own private credentials when connected.

If you need to use Cassandra without relations to clients or need administrative access, you can find the superuser credentials on any unit in ~root/.cassandra/cqlshrc

You can also 'juju ssh' into any of the units and run cqlsh, which will connect as an administrative user by default. From here, you can create accounts with whatever password you like per Cassandra documentation.

I'll leave this bug open, as it can be better documented.

[Stuart Bishop (stub)]

To get a cqlsh prompt on unit cassandra/0:

juju ssh cassandra/0 sudo -H cqlsh

(the -H is important, ensuring $HOME is set correctly and credentials located)

[Martin Dünkelmann (nc-duenkekl3-deactivatedaccount)]

Thank you very much.
I used "cqlsh" instead of "sudo -H cqlsh" on the nodes.

And the hint:
"you can find the superuser credentials on any unit in ~root/.cassandra/cqlshrc"
is very usefull!