Using cqlsh with authentication
How to create a cqlshrc file to default to set credentials when launching cqlsh.
Typically, after configuring authentication, logging into cqlsh requires the
-u and -p options to the
cqlsh
command. To set credentials for use when launching
cqlsh
, create or modify the
.cassandra/cqlshrc file. When present, this file passes
default login information to cqlsh
. The
cqlshrc.sample file provides an example.
The location of the
cqlshrc.sample file depends on the type of installation:
Cassandra package installations | /etc/cassandra/cqlshrc.sample |
Cassandra tarball installations | install_location/conf/cqlshrc.sample |
Procedure
-
Create or modify the cqlshrc file that specifies a role
name and password.
[authentication] username = fred password = !!bang!!$
- Save the file in home/.cassandra directory and name it cqlshrc.
-
Set permissions on the file to prevent unauthorized access, as the password is
stored in plain text. The file must be readable by the user that starts
cassandra
.chmod 440 home/.cassandra/cqlshrc
- Check the permissions on home/.cassandra/cqlshrc_history to ensure that plain text passwords are not compromised.