If Ryan answer doesn't help, post Cassandra version. There is a bug with cql and some python version that would lead to that error.
Also, please post "nodetool status". Regards, Carlos Juzarte Rolo Cassandra Consultant / Datastax Certified Architect / Cassandra MVP Pythian - Love your data rolo@pythian | Twitter: @cjrolo | Skype: cjr2k3 | Linkedin: *linkedin.com/in/carlosjuzarterolo <http://linkedin.com/in/carlosjuzarterolo>* Mobile: +351 918 918 100 www.pythian.com On Mon, Aug 22, 2016 at 4:08 PM, Ryan Svihla <r...@foundev.pro> wrote: > instead of 127.0.0.1 have you tried just passing the IP of the one of the > nodes. > > On Mon, Aug 22, 2016 at 9:45 AM Raimund Klein <chessra...@gmail.com> > wrote: > >> Hello all, >> >> Sorry for reposting this, but I didn't receive any response. Can someone >> help please? >> >> ---------- Forwarded message ---------- >> From: Raimund Klein <chessra...@gmail.com> >> Date: 2016-08-15 12:07 GMT+01:00 >> Subject: Failure when setting up cassandra in cluster >> To: user@cassandra.apache.org >> >> >> Hi all, >> >> Sorry if this is a fairly stupid question, but we've all only been >> exposed to Cassandra very recently. >> >> We're trying to configure a 2-node cluster with non-default credentials. >> Here's what I've been doing so far based on my understanding of the >> documentation. The platform is RHEL 7: >> >> >> 1. Use an RPM I found with Datastax to perform a basic cassandra >> installation. >> 2. Change the temporary directory in cassandra-env.sh, because nobody >> is allowed to execute anything in /tmp. >> 3. In cassandra.yaml, >> - change the cluster_name >> - empty the listen_address entry >> - define both VMs as seeds >> 4. Open port 7000 in the firewall. >> 5. Start cassandra. >> 6. In the cassandra.yaml, change to PasswordAuthenticator. >> 7. Run cqlsh -u cassandra -p cassandra -e "ALTER KEYSPACE system_auth >> WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 2 >> };" >> 8. Restart cassandra >> 9. Perform 1-8 on the second node >> 10. To create a new user, run cqlsh -u cassandra -p cassandra >> -e "CREATE USER ${CASSANDRA_USERNAME} WITH PASSWORD >> '${CASSANDRA_PASSWORD}' >> SUPERUSER;" >> >> Step 10 fails with this error: >> >> Connection error: ('Unable to connect to any servers', {'127.0.0.1': >> AuthenticationFailed(u'Failed to authenticate to 127.0.0.1: code=0100 >> [Bad credentials] >> message="org.apache.cassandra.exceptions.UnavailableException: >> Cannot achieve consistency level QUORUM"',)}) >> >> >> What am I missing? >> >> >> Cheers >> >> Raimund >> >> >> -- > Regards, > > Ryan Svihla > -- --