Hi that's very likely because of: > > empty the listen_address entry and
# Leaving it blank leaves it up to InetAddress.getLocalHost(). This # will always do the Right Thing _if_ the node is properly configured # (hostname, name resolution, etc), and the Right Thing is to use the # address associated with the hostname (it might not be). You probably have na /etc/hosts line that is 127.0.1.1 myhostname Nodes can not communicate if bound to loopback interface Best, On Mon, Aug 22, 2016 at 6:22 PM, Raimund Klein <chessra...@gmail.com> wrote: > 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 >>> >> >> >> -- >> >> >> >> >
