RE: system_auth permissions issue C* 2.0.14

2017-11-07 Thread Chandan Goel
Hi Avinash,

Please see if you have given permissions to the user (logged in) on the table 
and all related Materialized Views.

Thanks
Chandan

From: pabbireddy avinash [mailto:pabbireddyavin...@gmail.com]
Sent: Friday, November 03, 2017 3:06 PM
To: user@cassandra.apache.org
Subject: system_auth permissions issue C* 2.0.14

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  so that all nodes will have system_auth data .


Please help me understand this issue .

Regards,
Avinash.



Re: system_auth permissions issue C* 2.0.14

2017-11-03 Thread pabbireddy avinash
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  -p 

Traceback (most recent call last):
  File "/opt/xcal/apps/cassandra/bin/cqlsh", line 2094, in 
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  -p 
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  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= so that all nodes will have
> system_auth data .
>
>
> Please help me understand this issue .
>
> Regards,
> Avinash.
>
>