search

kdcro101 / vscode-cassandra

Design and query Apache Cassandra database with help of generated templates, autocomplete and inline code decorations in Visual Studio Code
GNU General Public License v3.0
22 stars 6 forks source link

Cassandra keyspace dropdown does not list values #1

Closed kashif-khan closed 5 years ago

kashif-khan commented 5 years ago

I have the following Cassandra workbench configuration. All the details are correct but the cql workbench does not work. The select keyspace dropdown never shows any values. Also, I am unable to execute queries via cql command use mykeyspacename

[
    {
        "name": "localhost",
        "contactPoints": ["127.0.0.1"],
        "authProvider": {
            "class": "PasswordAuthenticator",
            "username": "myusername",
            "password": "mypassword"
        }
    }
]
kdcro101 commented 5 years ago

@kashif-khan ,

Thank you for your feedback

Please provide following:

  1. What version of OS and Cassandra are you using?
  2. Any errors thrown? Please check Help->Toggle Developer Tools
  3. Does keyspaces show in Cassandra workbench: Explorer view?
  4. Did you ever connected successfully with other tools/clients?
kashif-khan commented 5 years ago

@kdcro101 Please find the reply inline

  1. What version of OS and Cassandra are you using? => Microsoft Windows 10 Enterprise [Version 10.0.16299.726], apache-cassandra-2.2.13, Visual studio code 1.28.2 (user setup)
  2. Any errors thrown? Please check Help->Toggle Developer Tools ==> PFA screenshot of the errors
  3. Does keyspaces show in Cassandra workbench: Explorer view? ==> No
  4. Did you ever connected successfully with other tools/clients? ==> Yes I can still connect via Datastax DevCenter

screenshot 199

kdcro101 commented 5 years ago

@kashif-khan ,

Does user, you are using to connect, have access to system keyspace? Try using superuser account.

It breaks trying to read cluster structure (keyspaces,tables, etc).

Let me know how it went.

kashif-khan commented 5 years ago

@kdcro101 ,

I have tried with following queries on the other application and I was able to successfully execute them without any issues. I tried local Cassandra and I faced the same issue. 

select * from system.schema_keyspaces;
select * from system.schema_columnfamilies;
kdcro101 commented 5 years ago

@kashif-khan ,

Cassandra 2.2 has totally different system keyspaces structure. Need to write structure collectors for 2.2. I will keep you posted here.

kdcro101 commented 5 years ago

@kashif-khan ,

Please update to version 0.2.0. Problem should be fixed. Let me know how it went.

If you run into any problems, open issue.

kashif-khan commented 5 years ago

After the update, it is working. Thank you for such a wonderful tool and for a quick fix.

kecondezo commented 5 years ago

Hi, I am having the same issue. I can connect an run queryes but the explorer does not list the keyspaces. What version of OS and Cassandra are you using? Windows7 Any errors thrown? Please check Help->Toggle Developer Tools Yes, it show a message as if cannot connect (but it does because I can run select * from system_schema.keyspaces; succesfully) image

Does keyspaces show in Cassandra workbench: Explorer view? No Did you ever connected successfully with other tools/clients? Yes

image