Hi guys, Thanks for the responses. I'm running the cqlsh commands directly on one of the nodes, so should that really make a difference?
Anyway, as for Carlos' questions: - We're using Cassandra 2.2.6. - nodetool status on first node: Datacenter: datacenter1 ======================= Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns (effective) Host ID Rack UN 127.0.1.1 168.6 KB 256 100.0% 7217530d-1db4-4208-b181-f627546ed386 rack1 - nodetool status on second node: Datacenter: datacenter1 ======================= Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns (effective) Host ID Rack UN 127.0.1.1 128.35 KB 256 100.0% 46917945-6f5d-4f94-b48a-d7cbbd94110f rack1 Cheers Riamund 2016-08-22 16:23 GMT+01:00 Carlos Rolo <r...@pythian.com>: > 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 >> > > > -- > > > >