TDengine icon indicating copy to clipboard operation
TDengine copied to clipboard

jdbc connect to docker-compose issue

Open veigara opened this issue 1 year ago • 4 comments

问题:怎么通过jdbc连接集群 通过官网文档部署的docker集群 image

jdbc url:jdbc:TAOS-RS://192.168.2.68:6041/performance_schema 通过查询adapter容器的日志,里面报了Unable to establish connection model=restful 微信截图_20230928112141

但是通过docker-compose exec td-1 taos -s "show dnodes" 是可以正确显示集群的 微信截图_20230928112228

veigara avatar Sep 28 '23 03:09 veigara

版本号是?

yu285 avatar Oct 09 '23 06:10 yu285

版本是3.0.5.0,3.0.0.0 的版本也试过,也连不上报这个错

veigara avatar Oct 09 '23 08:10 veigara

可以尝试在 docker 服务器上对着自己的 6041 端口发送curl做一下测试,看看是否正常返回结果。

yu285 avatar Nov 28 '23 05:11 yu285

我也是一样的问题,在 kline_worker 内无法连上 td-1,但是在 td-1 内和 td-2 内均可正常连接 td-1。

version: '2.3'

services:
  kline_worker:
    image: kline_worker:v1.0
    container_name: kline_worker
    build:
      context: .
      dockerfile: dockerfile
    restart: unless-stopped
    environment:
      - TZ=Asia/Shanghai
      # - http_proxy=http://127.0.0.1:6152
      # - https_proxy=http://127.0.0.1:6152
    volumes:
      - ./logs:/app/logs
      - ./config.toml:/app/config.toml
    networks:
      - td-net
  td-1:
    image: tdengine/tdengine:$VERSION
    container_name: td-1
    hostname: td-1
    environment:
      - TAOS_FQDN=td-1
      - TAOS_FIRST_EP=td-1
    ports:
      - 6041:6041
      - 6030:6030
      - 6043-6049:6043-6049 
      - 6043-6049:6043-6049/udp
    volumes:
      - ~/data/taos/dnode1/data:/var/lib/taos
      - ~/data/taos/dnode1/log:/var/log/taos
    networks:
      - td-net
  td-2:
    image: tdengine/tdengine:$VERSION
    container_name: td-2
    hostname: td-2
    environment:
      - TAOS_FQDN=td-2
      - TAOS_FIRST_EP=td-1
    volumes:
      - ~/data/taos/dnode2/data:/var/lib/taos
      - ~/data/taos/dnode2/log:/var/log/taos
    networks:
      - td-net
  td-3:
    image: tdengine/tdengine:$VERSION
    container_name: td-3
    hostname: td-3
    environment:
      - TAOS_FQDN=td-3
      - TAOS_FIRST_EP=td-1
    volumes:
      - ~/data/taos/dnode3/data:/var/lib/taos
      - ~/data/taos/dnode3/log:/var/log/taos
    networks:
      - td-net

networks:
  td-net:
    driver: bridge
    ipam:
      config:
      - gateway: 8.8.152.1
        subnet: 8.8.152.1/24
      driver: default

这是我的 dockerfile, 在 kline_worker 内可以 ping 通 td-1,taos -h td-1 会卡住连不上

FROM golang:1.21

WORKDIR /app

RUN apt-get update && apt-get install -y tzdata wget

ENV TZ=Asia/Shanghai

ENV TDENGINE_VERSION=3.2.2.0

RUN wget -c https://www.taosdata.com/assets-download/3.0/TDengine-client-${TDENGINE_VERSION}-Linux-x64.tar.gz \
   && tar xvf TDengine-client-${TDENGINE_VERSION}-Linux-x64.tar.gz \
   && cd TDengine-client-${TDENGINE_VERSION} \
   && ./install_client.sh \
   && cd ../ \
   && rm -rf TDengine-client-${TDENGINE_VERSION}-Linux-x64.tar.gz TDengine-client-${TDENGINE_VERSION}

ADD . /app

RUN GOPROXY="https://goproxy.io,direct"

RUN GOOS=linux go build -o kline_worker

CMD ["./kline_worker"]

LydiaCai1203 avatar Feb 05 '24 01:02 LydiaCai1203