使用 Astra JDBC 驱动程序从 D Beaver 连接返回“ 无效证书 ”
原标题：Connecting from DBeaver using Astra JDBC driver returns "Invalid Credentials"
I need to connect to Astra using DBeaver. I m following guide https://awesome-astra.github.io/docs/pages/data/explore/dbeaver/#astra-community-jdbc-drivers (exactly "Astra Community JDBC Drivers" section as Simba driver does not support some cqlsh features like describe tables and display some specific tables incorrectly).
I have astra bundle (zip file) and clientId, secret and token
The problem is that I cannot connect any way:
using "token" as username and token value as the password - I m getting error Error Code=401, (HTTP_UNAUTHORIZED) Invalid Credentials Check your token: null
using "clientId" as username and "secret" as the passwprd - error is Error Code=401, (HTTP_UNAUTHORIZED) Invalid Credentials Check your token: {"errors":[{"ID":340002,"message":"no bearer token in request"}]}
Connection URL is like this:
jdbc:astra://some-long-aws-url.com:29080/my_keyspace;AuthMech=2;TunableConsistency=6;SecureConnectionBundlePath=/Users/user/astra/astra-bundle.zip
Also I ve tried to use AuthMech as 1 / 2 / 3, do not set URL(as it exists in bundle) like jdbc:astra://;AuthMech=... but nothing helps.
It s not network issue as I can connect using commandline cqlsh-astra package as well as using Simba drivers.
问题回答
It looks like you have configured the wrong JDBC URL, probably because you tried using the Astra JDBC driver and run into issues then you tried using the Simba driver which uses a completely different JDBC URL.
I managed to connect to my Astra DB instance using the Astra JDBC driver by following the instructions on the Awesome Astra document you linked in your post.
Please try to configure a new DB connection but this time using the JDBC URL with the form:
jdbc:astra://db_name/keyspace_name
To use mine as an example, my database is named community and I have a keyspace named stackoverflow so my JDBC URL is:
jdbc:astra://community/stackoverflow
As a side note, I was able to replicate the issue you had by deleting the first character in my token to get the errors:
Unexpected driver error occurred while connecting to the database
Error in HTTP Request: Error Code=401, (HTTP_UNAUTHORIZED) Invalid Credentials Check your token: {"errors":[{"ID":340002,"message":"no bearer token in request"}]}
Error in HTTP Request: Error Code=401, (HTTP_UNAUTHORIZED) Invalid Credentials Check your token: {"errors":[{"ID":340002,"message":"no bearer token in request"}]}
Error Code=401, (HTTP_UNAUTHORIZED) Invalid Credentials Check your token: {"errors":[{"ID":340002,"message":"no bearer token in request"}]}
Verify that you have entered your token correctly. It should be the of the form AstraCS:AbC...XYz:123...edf0. Cheers!
相关问题
How does Voldemort compare to Cassandra?
How does Voldemort compare to Cassandra?
I m not talking about size of community and only want to hear from people who have actually used both.
Especially I m interested in:
How they dynamically ...
How does Cassandra rebalance when nodes go down?
Does anyone have experience with Cassandra when nodes go down or are unavailable? I am mostly interested in whether the cluster rebalances and what happens when the nodes come online, or are replaced ...
Cassandra time series data
We are looking at using Cassandra to store a stream of information coming from various sources.
One issue we are facing is the best way to query between two dates.
For example we will need to ...
Picking a database technology
We re setting out to build an online platform (API, Servers, Data, Wahoo!). For context, imagine that we need to build something like twitter, but with the comments (tweets) organized around a live ...
Row count of a column family in Cassandra
Is there a way to get a row count (key count) of a single column family in Cassandra? get_count can only be used to get the column count.
For instance, if I have a column family containing users and ...
Update an existing column value
What happens when a new value for an existing column is added? Will the older value be overwritten by the new value? Or the older value will also retain and can be retrieved (similar to simpleDB)?
Cassandra Vs Amazon SimpleDB
I m working on an application where data size and SQL queries are going to be heavy. I am thinking between Cassandra or Amazon SimpleDB. Can you please suggest which is more suitable in this kind of ...
Cassandra load balancing with an ordered partitioner?
So I see here that Cassandra does not have automatic load balancing, which comes into view when using the ordered partitioner (a certain common range of values of a group of rows would be stored on a ...
