I am assuming the following guide or similar was followed to add JMX authentication:
http://docs.datastax.com/en/cassandra/3.0/cassandra/configuration/secureJmxAuthentication.html <http://docs.datastax.com/en/cassandra/3.0/cassandra/configuration/secureJmxAuthentication.html> > On 23/08/2017, at 9:14 PM, Jonathan Baynes <jonathan.bay...@tradeweb.com> > wrote: > > When trying to connect to CQLSH I get this > > “Cannot achieve consistency level QUORUM” > > 2 of my 3 nodes are down. So this error is correct. But how do I sign into > CQLSH to change this? Or better, how do I get the other 2 nodes back up? > > From: Akhil Mehra [mailto:akhilme...@gmail.com <mailto:akhilme...@gmail.com>] > Sent: 23 August 2017 10:05 > To: user@cassandra.apache.org <mailto:user@cassandra.apache.org> > Subject: Re: C* 3 node issue -Urgent > > The cqlsh image say bad credentials. Just confirming that you have the > correct username/password when logging on. > > By turing on authentication I am assuming you mean using the > PasswordAuthenticator instead of the AllowAllAuthenticator in the yaml. > > Cheers, > Akhil > > On 23/08/2017, at 8:59 PM, Jonathan Baynes <jonathan.bay...@tradeweb.com > <mailto:jonathan.bay...@tradeweb.com>> wrote: > > I will also mention I am on: > > C* 3.0.11 > Linux Oracle red hat 7.1 > Java 1.8.0.31 > Python 2.7 > > From: Jonathan Baynes > Sent: 23 August 2017 09:47 > To: 'user@cassandra.apache.org <mailto:user@cassandra.apache.org>' > Cc: Stewart Allman > Subject: C* 3 node issue -Urgent > > Hi Everyone. > > I need the communities help here. > > I have attempted this morning to turn on JMX authentication for Nodetool. > I’ve gone into the Cassandra-env.sh file and updated the following: > > LOCAL_JMX=No > JVM_OPTS="$JVM_OPTS -Dcom.sun.management.jmxremote.authenticate=true" > JVM_OPTS="$JVM_OPTS > -Dcom.sun.management.jmxremote.password.file=/opt/cassandra/application/jmxremote.password" > > Then I restarted each node, I have 3 of them in a single DC, Single Rack. > 115.63 (seed) > 115.64 > 115.65 (seed) > > Nodetool status shows this > > <image004.png> > > In the Yaml I have Authentication turned ON. > Cassandra has been working flawlessly up until the moment I restarted the > nodes. > > as it stands right now.. > > 115.63 is up, but I cannot connect to CQLSH > I get the following error > <image005.png> > > When I check the logs I on 115.64 and 115.65 I can see this > > WARN [OptionalTasks:1] 2017-08-23 08:37:56,508 CassandraRoleManager.java:355 > - CassandraRoleManager skipped default role setup: some nodes were not ready > INFO [OptionalTasks:1] 2017-08-23 08:37:56,508 CassandraRoleManager.java:394 > - Setup task failed with error, rescheduling > Caused by: java.lang.RuntimeException: > org.apache.cassandra.exceptions.UnavailableException: Cannot achieve > consistency level LOCAL_ONE > at > org.apache.cassandra.auth.CassandraRoleManager.getRole(CassandraRoleManager.java:512) > ~[apache-cassandra-3.0.11.jar:3.0.11] > at > org.apache.cassandra.auth.CassandraRoleManager.collectRoles(CassandraRoleManager.java:480) > ~[apache-cassandra-3.0.11.jar:3.0.11] > at > org.apache.cassandra.auth.CassandraRoleManager.getRoles(CassandraRoleManager.java:284) > ~[apache-cassandra-3.0.11.jar:3.0.11] > at org.apache.cassandra.auth.RolesCache$1.load(RolesCache.java:122) > ~[apache-cassandra-3.0.11.jar:3.0.11] > at org.apache.cassandra.auth.RolesCache$1.load(RolesCache.java:119) > ~[apache-cassandra-3.0.11.jar:3.0.11] > at > com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527) > ~[guava-18.0.jar:na] > at > com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319) > ~[guava-18.0.jar:na] > at > com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282) > ~[guava-18.0.jar:na] > at > com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197) > ~[guava-18.0.jar:na] > ... 38 common frames omitted > Caused by: org.apache.cassandra.exceptions.UnavailableException: Cannot > achieve consistency level LOCAL_ONE > > > I have no idea what to do, so any help would be amazing right now.. > > Thanks > J > > Jonathan Baynes > DBA > Tradeweb Europe Limited > Moor Place • 1 Fore Street Avenue • London EC2Y 9DT > P +44 (0)20 77760988 • F +44 (0)20 7776 3201 • M +44 (0)xxxx xxxxxx > jonathan.bay...@tradeweb.com <mailto:jonathan.bay...@tradeweb.com> > > <image006.jpg> <http://www.tradeweb.com/> follow us: <image007.jpg> > <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_company_tradeweb-3Ftrk-3Dtop-5Fnav-5Fhome&d=DwMFaQ&c=sA0VaJZJFLZREu2pbPeqjXHJ-Wd9NNzgHW3gpUOLSSk&r=CNKccIKIKCVbYTu1VxR8dIOP6NLpf4fYjidpNm-diQ8&m=r8Fr_0dx60l48XrOggPz4OpGpu2K7tEPAmCl14KpBvQ&s=h5M2yR_HjCB_ghUa2rzYYKcwH5VjWUPf_ttbCNUrdqA&e=> > <image008.jpg> > <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.twitter.com_Tradeweb&d=DwMFaQ&c=sA0VaJZJFLZREu2pbPeqjXHJ-Wd9NNzgHW3gpUOLSSk&r=CNKccIKIKCVbYTu1VxR8dIOP6NLpf4fYjidpNm-diQ8&m=r8Fr_0dx60l48XrOggPz4OpGpu2K7tEPAmCl14KpBvQ&s=yzqb445p2cV3fJfSIGPOcGNEkP7zIfxMWNo3jSw7TmM&e=> > ————————————————————————————————————————— > A leading marketplace <http://www.tradeweb.com/About-Us/Awards/> for > electronic fixed income, derivatives and ETF trading > > ________________________________________________________________________ > This e-mail may contain confidential and/or privileged information. If you > are not the intended recipient (or have received this e-mail in error) please > notify the sender immediately and destroy it. Any unauthorized copying, > disclosure or distribution of the material in this e-mail is strictly > forbidden. Tradeweb reserves the right to monitor all e-mail communications > through its networks. If you do not wish to receive marketing emails about > our products / services, please let us know by contacting us, either by email > at contac...@tradeweb.com <mailto:contac...@tradeweb.com> or by writing to us > at the registered office of Tradeweb in the UK, which is: Tradeweb Europe > Limited (company number 3912826), 1 Fore Street Avenue London EC2Y 9DT. To > see our privacy policy, visit our website @ www.tradeweb.com > <http://www.tradeweb.com/>. > > ________________________________________________________________________ > > This e-mail may contain confidential and/or privileged information. If you > are not the intended recipient (or have received this e-mail in error) please > notify the sender immediately and destroy it. Any unauthorized copying, > disclosure or distribution of the material in this e-mail is strictly > forbidden. Tradeweb reserves the right to monitor all e-mail communications > through its networks. If you do not wish to receive marketing emails about > our products / services, please let us know by contacting us, either by email > at contac...@tradeweb.com <mailto:contac...@tradeweb.com> or by writing to us > at the registered office of Tradeweb in the UK, which is: Tradeweb Europe > Limited (company number 3912826), 1 Fore Street Avenue London EC2Y 9DT. To > see our privacy policy, visit our website @ www.tradeweb.com > <http://www.tradeweb.com/>. >