Hi We are seeing this issue on some nodes where even if we are providing correct credentials we are seeing incorrect username/password exception & when we try again with same credentials we are able to login .
[hostname ~ ]$ ./cqlsh -u <username> -p <XXX> Traceback (most recent call last): File "/opt/xcal/apps/cassandra/bin/cqlsh", line 2094, in <module> main(*read_options(sys.argv[1:], os.environ)) File "/opt/xcal/apps/cassandra/bin/cqlsh", line 2077, in main single_statement=options.execute) File "/opt/xcal/apps/cassandra/bin/cqlsh", line 492, in __init__ password=password, cql_version=cqlver, transport=transport) File "/opt/xcal/apps/apache-cassandra-2.0.14/bin/../lib/cql-internal-only-1.4.1.zip/cql-1.4.1/cql/connection.py", line 143, in connect File "/opt/xcal/apps/apache-cassandra-2.0.14/bin/../lib/cql-internal-only-1.4.1.zip/cql-1.4.1/cql/connection.py", line 59, in __init__ File "/opt/xcal/apps/apache-cassandra-2.0.14/bin/../lib/cql-internal-only-1.4.1.zip/cql-1.4.1/cql/thrifteries.py", line 157, in establish_connection File "/opt/xcal/apps/apache-cassandra-2.0.14/bin/../lib/cql-internal-only-1.4.1.zip/cql-1.4.1/cql/cassandra/Cassandra.py", line 465, in login File "/opt/xcal/apps/apache-cassandra-2.0.14/bin/../lib/cql-internal-only-1.4.1.zip/cql-1.4.1/cql/cassandra/Cassandra.py", line 486, in recv_login cql.cassandra.ttypes.AuthenticationException: AuthenticationException(why='Username and/or password are incorrect') [hostname ~ ]~ ]$ ./cqlsh -u <username> -p <XXX> Connected to Cluster at host:9160. [cqlsh 4.1.1 | Cassandra 2.0.14 | CQL spec 3.1.1 | Thrift protocol 19.39.0] Use HELP for help. cqlsh> exit; Regards, Avinash. On Fri, Nov 3, 2017 at 11:05 AM, pabbireddy avinash < pabbireddyavin...@gmail.com> wrote: > Hi, > We are seeing system_auth related exceptions from application side on > cassandra 2.0.14 . > > > at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) > [jersey-common-2.14.jar:na] > at org.glassfish.jersey.internal.Errors.process(Errors.java:315) > [jersey-common-2.14.jar:na] > at org.glassfish.jersey.internal.Errors.process(Errors.java:297) > [jersey-common-2.14.jar:na] > ... 33 lines omitted ... > Caused by: com.datastax.driver.core.exceptions.UnauthorizedException:* > User has no MODIFY permission on <table Keyspace.columnfamily or any of its > parents* > at > com.datastax.driver.core.Responses$Error.asException(Responses.java:101) > ~[cassandra-driver-core-2.1.7.jar:na] > > When we check permissions on all the hosts we did not find any issues all > the nodes have modify , select permissions for the user . We repaired > system_auth on all the nodes but still we are seeing this issue time to > time .We have RF=<number of nodes in DC > so that all nodes will have > system_auth data . > > > Please help me understand this issue . > > Regards, > Avinash. > >