question

laxmi.dba_184449 avatar image
laxmi.dba_184449 asked djatnieks answered

What GUI clients are available to connect to a DSE cluster?

Hello All,

I am looking for the solution to connect to DSE 6.7 cluster using client tool with GUI. The DSE cluster is configured with Kerberos authentication and LDAP for role management.

I have tried Datastax studio and it can connect only using local account. Does any one have succeeded to connect using LDAP? If this can be achieved, then can you please provide some guidance.

If not what are the available client tools that the developers can use to query the cassandra(DSE) keyspaces/tables using GUI interface?

dsestudio
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Erick Ramirez avatar image
Erick Ramirez answered Erick Ramirez commented

DataStax Studio is the only tool with a graphical interface available from DataStax. It can connect to any DSE cluster with or without authentication enabled.

Specifically on LDAP enabled clusters, Studio does not process the authentication itself since it is just a client/app like other clients such as cqlsh. Studio simply sends the credentials you configured to the DSE cluster and it is the DSE nodes which handle the authentication. Cheers!

4 comments Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

laxmi.dba_184449 avatar image laxmi.dba_184449 commented ·

But somehow , we are unable to login when we provide "username" as ADaccount@domain.com. Are we missing any steps? Also we are trying on windows.

However we can connect using cqlsh from Linux.

0 Likes 0 ·
Erick Ramirez avatar image Erick Ramirez ♦♦ laxmi.dba_184449 commented ·

What error are you getting?

0 Likes 0 ·
laxmi.dba_184449 avatar image laxmi.dba_184449 Erick Ramirez ♦♦ commented ·

Here is the screenshot of the error.

username is adaccount@domain.com


1613692465781.png

0 Likes 0 ·
1613692465781.png (41.6 KiB)
Show more comments
djatnieks avatar image
djatnieks answered

DataStax Studio version 6.8.15 now supports Kerberos authentication for CQL connections, using either a kerberos keytab file or ticket cache.


Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.