cloudbeaver

 

cloudbeaver官网

https://dbeaver.com/docs/cloudbeaver/Run-Docker-Container/

 

github官网

https://github.com/dbeaver/cloudbeaver

 

 

 

一、项目介绍

CloudBeaver 是一款轻量级的Web应用程序，专为全面的数据管理而设计。它支持各种数据源，包括 SQL、NoSQL 和云数据库，所有的操作都可以通过单一的安全云端解决方案在浏览器中完成。此工具提供了统一的操作界面来交互不同的数据库，支持定制驱动程序，以及编辑已有的驱动程序。

 

安装环境要求:

  • Java环境 (建议版本Java 11或以上)
  • Docker (可选)

 

源码安装

编译Cloudbeaver 和 连接 OpenGauss

一、下载源码
需要两部分源码：cloudbeaver和dbeaver，下载cloudbeaver时会自动下载dbeaver的源码。国内gitee的镜像上的代码是可用的，当然如果能用github更好。git clone 时要注意，根目录命名为小写的cloudbeaver，这个和编译脚本有关:

git clone https://gitee.com/mirrors/CloudBeaver.git cloudbeaver

到deploy目录下执行build.sh，但它会到github下载dbeaver的源码，修改下载地址：

git clone https://gitee.com/mirrors/dbeaver.git

许多人觉得gitee上的代码有问题，但其实是没有指定好分支，选对分支非常非常关键，否则会出现奇怪的编译错误，我之前就在这上面浪费了很多时间。注意，不要用tag，而是要用分支：

cloudbeaver 选分支 origin/release_22_3_1

cd cloudbeaver

git branch -r

git co -b release_22_3_1 --track origin/release_22_3_1

同样 dbeaver 也要选分支 origin/release_22_3_1

cd dbeaver

git br branch -r

git co -b release_22_3_1 --track origin/release_22_3_1

 

二、安装编译构建工具

1、需要 g++ >= 7.3.0，因为有一步有-std=c++14，我用的是7.3.0。

2、我的环境 OPENJDK17，maven-3.8.6，cloudbeaver/beaver更新了22.3.1以后JDK11也不行了，JDK下载地址：

Archived OpenJDK GA Releases (java.net)

3、参考官网Documentation – CloudBeaver，安装npm，但稍有不同，我是sudo yum install npm安装完npm后，用npm安装yarn、lerna和nodejs，我的操作系统是CentOS-7.9，用的是国内的网，没有FQ。

sudo npm install -g yarn nodejs lerna

虽然编译的时候要依赖这么多，但运行时只需要JDK17。

 

三、执行编译构建

到源码cloudbeaver/deploy目录下执行./build.sh，这个过程会下载很多依赖包，建议maven使用国内源，我用的是南京大学的（下面加到maven的conf/settings.xml）：

    <mirror>

      <id>nju_mirror</id>

      <mirrorOf>central</mirrorOf>

      <url>https://repo.nju.edu.cn/repository/maven-public/</url>

    </mirror>

构建完成后，结果在deploy/cloudbeaver下，把这个目录打包，移动到其它Linux服务器上，配置好JDK(环境变量PATH和JAVA_HOME)，执行里面的run-server.sh，后台就运行起来了。

我试过在FQ的情况下构建，没有问题，也试过使用国内的代码库和软件源，全程没有FQ的情况，也可以构建成功，有时不成功，我就多执行了几次build.sh，结果可以了，请相信国内的地址。

 


————————————————

版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
                        
原文链接：https://blog.csdn.net/howard_shooter/article/details/127057250https://blog.csdn.net/howard_shooter/article/details/127057250

 

 

 

 

docker安装

docker pull dbeaver/cloudbeaver

 

 

Docker repositories

CloudBeaver container images are on DockerHub:

Product Docker repository URL
CloudBeaver EE dbeaver/cloudbeaver-ee https://hub.docker.com/r/dbeaver/cloudbeaver-ee
CloudBeaver AWS dbeaver/cloudbeaver-aws https://hub.docker.com/r/dbeaver/cloudbeaver-aws
CloudBeaver Community dbeaver/cloudbeaver https://hub.docker.com/r/dbeaver/cloudbeaver

Each image has following tags:

Tag Description
latest The latest stable product release
22.1.2, 23.0.1, etc Exact product version
ea Early Accesss version
devel Development version, unstable

Examples:

  • dbeaver/cloudbeaver-ee:23.0.0 - CloudBeaver EE version 23.0
  • dbeaver/cloudbeaver-aws:ea - CloudBeaver AWS Early Access version
  • dbeaver/cloudbeaver:latest - latest community release

Notes:

  • We will use repository cloudbeaver-ee as an example in the following instructions. Replace it with proper product repository (see above).
  • To run docker commands your user must be in proper user group or run it as root (e.g. sudo docker ps).

Installation

To install the latest version of CloudBeaver use the following script:

docker pull dbeaver/cloudbeaver-ee:latest
 

Running

To run cloudbaver in the terminal:

docker run --name cloudbeaver-ee --rm -ti -p 8080:8978 -v /var/cloudbeaver/workspace:/opt/cloudbeaver/workspace dbeaver/cloudbeaver-ee:latest
 

Then switch to the browser and open http://localhost:8080/

Daemon mode

Add the following parameters:

-d --restart unless-stopped
 

Accessing databases on the localhost

If you need to access the database server on the host machine, add the following parameter in docker run: (on Linux only)

 --network host
 

Cloudbeaver will work in the host machine network.
If this mode is not suitable for your network environment then you can run the container in the following way:

export CB_LOCAL_HOST_ADDR=$(ifconfig | grep -E "([0-9]{1,3}\.){3}[0-9]{1,3}" | grep -v 127.0.0.1 | awk '{ print $2 }' | cut -f2 -d: | head -n1)

docker run --name cloudbeaver --rm -ti -p 8080:8978 --add-host=host.docker.internal:${CB_LOCAL_HOST_ADDR} -v /var/cloudbeaver/workspace:/opt/cloudbeaver/workspace dbeaver/cloudbeaver-ee:latest
 

or just run script deploy/docker/run-docker-container.sh. It passes the IP address of host machine to the container.

Docker parameters explanation

Parameters explanation:

Parameter Explanation
--name cloudbeaver Assign container ID (cloudbeaver)
--rm Removes container on stop
-ti Enables terminal mode (allows to stop container with CTRL+C)
-p 8080:8978 Maps CloudBeaver public port (8978) to the host machine port (e.g. 8080)
-v local_path:/opt/cloudbeaver/workspace Mounts local folder `/var/cloudbeaver/workspace' to the server workspace. Required to keep CloudBeaver data after container restart.
--add-host=host.docker.internal:IP address Adds host name in the container's /etc/hosts file. This may be needed to access the database server deployed on the host machine.
dbeaver/cloudbeaver-ee:latest Container ID

Run Cloudbeaver server with non-root user

If you want to run CloudBeaver with a non-root user, you have to build your own image with a user inside before the container starts.

Create Dockerfile which contains:

FROM dbeaver/cloudbeaver-ee:latest
RUN groupadd cloudbeaver
RUN useradd -ms /bin/bash -g cloudbeaver cloudbeaver
RUN chown -R cloudbeaver ./
USER cloudbeaver
 

Run this command to build the image from Dockerfile

docker build -t my-cloudbeaver .
 

To run CloudBeaver in the terminal:

docker run --name cloudbeaver --rm -ti -p 8080:8978 -v /var/cloudbeaver/workspace:/opt/cloudbeaver/workspace my-cloudbeaver
 

Offline install

On a host with no internet access you need to download and archve image:

Note: <TAG> is a tag name for docker image (see above). latest is the default.

docker pull dbeaver/cloudbeaver-ee:<TAG>
docker save dbeaver/cloudbeaver-ee:<TAG> | gzip > cloudbeaver-ee.latest.tar.gz
 

Check that the archive exist:

ls -lah
 

Output should looks like:

-rw-r--r-- 1 user users 444M may 5 17:32 cloudbeaver-ee.latest.tar.gz
 

Now copy file cloudbeaver-ee.latest.tar.gz to some external drive and put to server with running cloudbeaver server.

Load image from archve:

docker load < cloudbeaver-ee.latest.tar.gz
 

You will see next output

Loaded image: dbeaver/cloudbeaver-ee:<TAG>
 

Upgrade your cloudbeaver-ee server:

docker stop cloudbeaver-ee
docker rm cloudbeaver-ee
docker run -d --restart unless-stopped -p 8978:8978 -v /var/cloudbeaver-ee/workspace:/opt/cloudbeaver/workspace dbeaver/cloudbeaver-ee:<TAG>
 

Note: some of docker args may differ from your environment.

CloudBeaver - Web Database Manager

 

本安装小节完全引用自 https://github.com/dbeaver/cloudbeaver/wiki/Run-Docker-Container

posted @ 2023-08-11 14:19  苦涩泪滴  阅读(1188)  评论(0)    收藏  举报