如何使用DBeaver连接到本地kubernetes CockroachDB? [英] How do I connect to my local kubernetes CockroachDB with DBeaver?

查看:89
本文介绍了如何使用DBeaver连接到本地kubernetes CockroachDB?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一个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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆