如何使用DBeaver连接到本地kubernetes CockroachDB? [英] How do I connect to my local kubernetes CockroachDB with DBeaver?
问题描述
我有一个Minikube Kubernetes集群,该集群运行的cockroachdb如下所示:
I have a Minikube Kubernetes cluster running a cockroachdb which looks like:
kubectl get pods
test-cockroachdb-0 1/1 Running 17 95m
test-cockroachdb-1 1/1 Running 190 2d
test-cockroachdb-2 1/1 Running 160 2d
test-cockroachdb-init-m8rzp 0/1 Completed 0 2d
cockroachdb-client-secure 1/1 Running 0 2d
我想要一个可以在我的应用程序中使用的连接字符串.
I want to get a connection string that I can use in my application.
要验证我的连接字符串,我正在使用工具DBeaver.
To verify my connection string, I am using the tool DBeaver.
我的数据库名称配置为群集上存在的'defaultdb',并且用户具有相关密码.该端口也准确(默认的cockroachdb minikube端口).
My database name is configured to 'defaultdb' which exists on my cluster, and the user with the relevant password. The port is accurate as well (default cockroachdb minikube port).
但是,关于连接的证书方面,我很茫然.如何生成/收集成功连接到群集所需的证书?如何使用DBeaver连接到集群?
However as to the certificate aspect of connecting I am at a loss. How do I generate/gather the certificates I need to successfully connect to my cluster? How do I connect to my cluster using DBeaver?
$ kubectl get all
NAME READY STATUS RESTARTS AGE
pod/myname-cockroachdb-0 1/1 Running 27 156m
pod/myname-cockroachdb-1 1/1 Running 197 2d1h
pod/myname-cockroachdb-2 1/1 Running 167 2d1h
pod/myname-cockroachdb-init-m8rzp 0/1 Completed 0 2d1h
pod/myname-client-secure 1/1 Running 0 2d1h
NAME TYPE CLUSTER-IP EXTERNAL-IP PORT(S) AGE
service/myname-cockroachdb ClusterIP None <none> 26257/TCP,8080/TCP 2d1h
service/myname-cockroachdb-public ClusterIP 10.xxx.xxx.xx <none> 26257/TCP,8080/TCP 2d1h
service/kubernetes ClusterIP 10.xx.0.1 <none> 443/TCP 2d1h
NAME READY AGE
statefulset.apps/myname-cockroachdb 3/3 2d1h
NAME COMPLETIONS DURATION AGE
job.batch/myname-cockroachdb-init 1/1 92s 2d1h
推荐答案
您可以使用 kubectl端口转发服务/myname-cockroachdb 26257
,而在DBeaver中只需使用 localhost:26257
作为连接字符串.
You can use kubectl port-forward service/myname-cockroachdb 26257
and in DBeaver just use localhost:26257
as a connection string.
这篇关于如何使用DBeaver连接到本地kubernetes CockroachDB?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!