[
https://issues.apache.org/jira/browse/CASSANDRA-14386?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
venky updated CASSANDRA-14386:
------------------------------
Description:
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
-----------++--------------+---------
user | False | False | {}
user1 | False | False | {}
user2 | False | False | {}
cassandra | True | True | {}
user3 | False | True | {}
user4 | True | True | {}
user5 | False | True | {}
user6 | 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
-----------++-------------------------++-------------------------------------------------------------------------
user | True | False | null |
$2a$10$mXJYFpGGAoX/Cc6xAsbideVrN14eE3mB4prsc2C5DS4NVg4MjjiJi
user1 | True | True | null |
$2a$10$yS6/mWev4KsDIm14kj8mrOjlhEbxthsDbuc/erd2DlcvqentJJ.Wu
cassandra | True | True | null |
$2a$10$FEAbfdEKW7Zh6PyxSEFYXuZCf9eHVRi55hG/BVz57XjUcVdwk2xQG
user2 | True | True | null |
$2a$10$7fKa8SZ0DMCn.Aat33Qhr.I3yVafMln/jhTqbmYGx7UG8Klv97rWW
user3 | True | True | null |
$2a$10$9tNRhH84YZjPRLrmaMY5MulS/1N53aB.ZLwEKHbjz0NBjZE/CvyRy
user4 | True | False | null |
$2a$10$4rjlX7pVnfQbCJVf/RPEGOqslxZTCylb4FjLBo8GtcjvBGP1eZWNW
user5 | True | False | null |
$2a$10$zczy9A.1iBciDQgqtAtk/.zdn.kdXr7QiqfMoiYV9TECWz21Iy2I2
user6 | 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
was:
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
> 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
> -----------++--------------+---------
> user | False | False | {}
> user1 | False | False | {}
> user2 | False | False | {}
> cassandra | True | True | {}
> user3 | False | True | {}
> user4 | True | True | {}
> user5 | False | True | {}
> user6 | 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
>
> -----------++-------------------------++-------------------------------------------------------------------------
> user | True | False | null |
> $2a$10$mXJYFpGGAoX/Cc6xAsbideVrN14eE3mB4prsc2C5DS4NVg4MjjiJi
> user1 | True | True | null |
> $2a$10$yS6/mWev4KsDIm14kj8mrOjlhEbxthsDbuc/erd2DlcvqentJJ.Wu
> cassandra | True | True | null |
> $2a$10$FEAbfdEKW7Zh6PyxSEFYXuZCf9eHVRi55hG/BVz57XjUcVdwk2xQG
> user2 | True | True | null |
> $2a$10$7fKa8SZ0DMCn.Aat33Qhr.I3yVafMln/jhTqbmYGx7UG8Klv97rWW
> user3 | True | True | null |
> $2a$10$9tNRhH84YZjPRLrmaMY5MulS/1N53aB.ZLwEKHbjz0NBjZE/CvyRy
> user4 | True | False | null |
> $2a$10$4rjlX7pVnfQbCJVf/RPEGOqslxZTCylb4FjLBo8GtcjvBGP1eZWNW
> user5 | True | False | null |
> $2a$10$zczy9A.1iBciDQgqtAtk/.zdn.kdXr7QiqfMoiYV9TECWz21Iy2I2
> user6 | 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-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
