cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pinak Pani <nishant.has.a.quest...@gmail.com>
Subject Re: Authentication is failing.
Date Sun, 28 Sep 2014 23:50:22 GMT
Hi Jens,

> Just making sure, have you set authenticator and authoriser in
cassandra.yml?

Yes.

Hi Philip,

I guess you are right. I will test that tomorrow morning, and confirm.

Thanks for the help guys.

On Mon, Sep 29, 2014 at 2:10 AM, Philip Thompson <
philip.thompson@datastax.com> wrote:

> You are running into https://issues.apache.org/jira/browse/CASSANDRA-7967
> . This is fixed in 2.0.11 and 2.1.1, until then I believe you will need to
> explicitly grant select permission onto system.schema_triggers to the user
> as a workaround.
>
> On Sun, Sep 28, 2014 at 12:53 PM, Jens Rantil <jens.rantil@tink.se> wrote:
>
>> Hi Pinak,
>>
>> Just making sure, have you set authenticator and authoriser in
>> cassandra.yml?
>>
>> Cheers,
>> Jens
>>
>> ——— Jens Rantil Backend engineer Tink AB Email: jens.rantil@tink.se
>> Phone: +46 708 84 18 32 Web: www.tink.se Facebook Linkedin Twitter
>>
>>
>> On Sun, Sep 28, 2014 at 11:08 AM, Pinak Pani <
>> nishant.has.a.question@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> I have been toying around with CQL. I realized when I GRANT SELECT I
>>> lose authentication. Here is the process: Can someone point out what is
>>> wrong?
>>>
>>>  ➜  apache-cassandra-2.1.0  bin/cqlsh -u cassandra -p cassandra
>>>
>>> Connected to Test Cluster at 127.0.0.1:9042.
>>> [cqlsh 5.0.1 | Cassandra 2.1.0 | CQL spec 3.2.0 | Native protocol v3]
>>> Use HELP for help.
>>>
>>>  cqlsh> CREATE USER testuser WITH PASSWORD 'abc';
>>> cqlsh> GRANT SELECT ON demo_cql.grant_test TO testuser;
>>> cqlsh> exit
>>> ➜  apache-cassandra-2.1.0  bin/cqlsh -u testuser -p abc -k demo_cql -e
>>> 'select * from grant_test'
>>> Connection error: ('Unable to connect to any servers', {'127.0.0.1':
>>> Unauthorized(u'code=2100 [Unauthorized] message="User testuser has no
>>> SELECT permission on <table system.schema_triggers> or any of its
>>> parents"',)})
>>>
>>> Thanks,
>>> Pinak
>>>
>>
>>
>

Mime
View raw message