[jira] [Commented] (CASSANDRA-14386) Authentication issue

["venky (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-14386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16439756#comment-16439756 ] 

venky commented on CASSANDRA-14386:
-----------------------------------

Thank you Sam. It's working.

> Authentication issue
> --------------------
>
>                 Key: CASSANDRA-14386
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-14386
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: venky
>            Priority: Major
>
> Hi,
> I am having an issue while I'm creating the users/roles in Cassandra Version 3.11.0 (DataStax 5.1.2).
> ``` 
> cassandra@cqlsh> list ROLES ;
> role | super | login | options
> -----------+-------+-------+---------
>  appuser | False | False | {}
>  appuser1 | False | False | {}
>  appuser2 | False | False | {}
>  cassandra | True | True | {}
>  odpuser | False | True | {}
>  odpuser2 | True | True | {}
>  readuser | False | True | {}
>  sparkuser | False | False | {}
> Here, I am getting `Login=False` and I tried with the option `Login = True` but still I am getting false. And When I select the system_auth> SELECT * FROM roles; and there I am seeing `login = True` 
> cassandra@cqlsh:system_auth> SELECT * FROM roles;
> ```
> role | can_login | is_superuser | member_of | salted_hash
> -----------+-----------+--------------+-----------+--------------------------------------------------------------
>  odpuser | True | False | null | $2a$10$mXJYFpGGAoX/Cc6xAsbideVrN14eE3mB4prsc2C5DS4NVg4MjjiJi
>  appuser2 | True | True | null | $2a$10$yS6/mWev4KsDIm14kj8mrOjlhEbxthsDbuc/erd2DlcvqentJJ.Wu
>  cassandra | True | True | null | $2a$10$FEAbfdEKW7Zh6PyxSEFYXuZCf9eHVRi55hG/BVz57XjUcVdwk2xQG
>  odpuser2 | True | True | null | $2a$10$7fKa8SZ0DMCn.Aat33Qhr.I3yVafMln/jhTqbmYGx7UG8Klv97rWW
>  appuser1 | True | True | null | $2a$10$9tNRhH84YZjPRLrmaMY5MulS/1N53aB.ZLwEKHbjz0NBjZE/CvyRy
>  sparkuser | True | False | null | $2a$10$4rjlX7pVnfQbCJVf/RPEGOqslxZTCylb4FjLBo8GtcjvBGP1eZWNW
>  readuser | True | False | null | $2a$10$zczy9A.1iBciDQgqtAtk/.zdn.kdXr7QiqfMoiYV9TECWz21Iy2I2
>  appuser | True | True | null | $2a$10$Fdhz9qriq952hJs2D23uuOdMldJJg5jauxjVtJMrCNUBAef.vLcci
> (8 rows)
> ```
> And I tried to drop that user (which is having Login = False)  but it is also not working.
> ```
> cassandra@cqlsh:system_auth> DROP USER sparkuser;
> InvalidRequest: Error from server: code=2200 [Invalid query] message="sparkuser doesn't exist"
> cassandra@cqlsh:system_auth> drop role sparkuser;
> InvalidRequest: Error from server: code=2200 [Invalid query] message="sparkuser doesn't exist"
> ```
> Can anyone help me to solve this issue ASAP.
> Thank you
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org