Sign inSign up

huzhihui/kingbase-kdts-web

By huzhihui

•Updated about 1 year ago

人大金仓数据迁移工具web端支持 v8r6和v9r1版本

Image
0

606

huzhihui/kingbase-kdts-web repository overview

⁠镜像说明

该镜像封装了人大金仓数据库的数据迁移工具，使用的是KDTS-WEB版本，安装包来源于v8r6版本。

⁠使用说明

该镜像可以挂载/software/KDTS-WEB/conf/h2数据文件夹到本地，防止容器删除数据丢失问题，它内部数据库采用的是h2。

⁠v8r6版本docker-compose.yml
version: '3'
services:
  kingbase-kdts-web-v8r6:
    image: huzhihui/kingbase-kdts-web:v8r6
    container_name: kingbase-kdts-web-v8r6
    networks:
      - default
    volumes:
      - ./db:/software/KDTS-WEB/conf/h2
    ports:
      - 54322:8080
networks:
  default:
    external:
      name: huzhihui
⁠v9r1版本docker-compose.yml
  • 登陆用户名：kingbase
  • 登陆密码：Kb_DI@2019
version: '3'
services:
  kingbase-kdts-web-v9r1:
    image: huzhihui/kingbase-kdts-web:v9r1
    container_name: kingbase-kdts-web-v9r1
    networks:
      - default
    volumes:
      - ./db:/software/KDTS-WEB/conf/h2
    ports:
      - 54523:54523
      - 54524:54524
networks:
  default:
    external:
      name: huzhihui
⁠结果

如果出现如下日志则启动成功

2023-05-08 18:14:23.414  INFO 66 --- [           main] com.kingbase.kdts.datasource.b           :   file:/software/KDTS-WEB/drivers/mysql/mysql-connector-java-8.0.23.jar
2023-05-08 18:14:23.416  INFO 66 --- [           main] c.k.k.console.config.DriverInitListener  : Load Mysql 8.0 driver end
2023-05-08 18:14:23.416  INFO 66 --- [           main] c.k.k.console.config.DriverInitListener  : Load Pg12 driver begin
2023-05-08 18:14:23.416  INFO 66 --- [           main] com.kingbase.kdts.datasource.b           : Load JDBC driver[B] -- postgresql 12:
2023-05-08 18:14:23.416  INFO 66 --- [           main] com.kingbase.kdts.datasource.b           :   file:/software/KDTS-WEB/drivers/postgresql/postgresql-42.2.19.jar
2023-05-08 18:14:23.419  INFO 66 --- [           main] c.k.k.console.config.DriverInitListener  : Load pg12 driver end
2023-05-08 18:14:23.425  INFO 66 --- [           main] c.k.kdts.DataMigrationApplication        : Started DataMigrationApplication in 5.385 seconds (JVM running for 6.206)
2023-05-08 18:14:23.431  INFO 66 --- [           main] c.k.kdts.DataMigrationApplication        : Version: 1.0.1.10 Build Time: 2022-10-21 (Core Version: 1.0.3.71)
2023-05-08 18:14:23.442  INFO 66 --- [           main] c.k.kdts.DataMigrationApplication        : Open 'http://localhost:8080' using a browser to access the application. The default username/password is kingbase/kingbase.
2023-05-08 18:23:17.770  INFO 66 --- [nio-8080-exec-2] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring DispatcherServlet 'dispatcherServlet'
2023-05-08 18:23:17.773  INFO 66 --- [nio-8080-exec-2] o.s.web.servlet.DispatcherServlet        : Initializing Servlet 'dispatcherServlet'
2023-05-08 18:23:17.775  INFO 66 --- [nio-8080-exec-2] o.s.web.servlet.DispatcherServlet        : Completed initialization in 1 ms

访问你映射的端口 http://xxxxx:54322⁠

⁠镜像封装步骤

⁠linux系统完整安装kingbase

完整安装后，可以获得KESRealPro/V008R006C007B0012/ClientTools，这个文件夹，里面包含了大家常用的工具。

⁠获取KDTS-WEB并压缩

这里我把h2文件夹备份了，因为可能要挂载出来，不挂载容器删除数据就丢失了

root@u-180:/opt/Kingbase/ES/V8/KESRealPro/V008R006C007B0012/ClientTools/guitools/KDts/KDTS-WEB/conf# ls
application.properties         enableLegacyTLS.security  h2-back    logback-file-spring.xml  logs           mapping_rule   support-databases-source.xml  support-databases.xml
console-datasource.properties  h2                        log4j.xml  logback-spring.xml       manual_script  reserved_word  support-databases-target.xml  templates
  • 压缩步骤
tar -czvf KDTS-WEB.tar.gz KDTS-WEB/*

root@u-180:/opt/Kingbase/ES/V8/KESRealPro/V008R006C007B0012/ClientTools/guitools/KDts# ls
KDTS-CLI  KDTS-WEB  KDTS-WEB.tar.gz
⁠镜像制作
⁠docker-entrypoint.sh
#! /bin/bash

chmod -R +x /software/KDTS-WEB/bin

if [ ! -e "/software/KDTS-WEB/conf/h2/kdts.mv.db" ];then
  cp -rf /software/KDTS-WEB/conf/h2-back/* /software/KDTS-WEB/conf/h2
fi
bash /software/KDTS-WEB/bin/startup.sh
tail -f /software/KDTS-WEB/logs/kdts-app-console.log
⁠Dockerfile
FROM huzhihui/ubuntu:18.04-fonts
MAINTAINER [email protected]

ADD KDTS-WEB.tar.gz /software
ADD docker-entrypoint.sh /docker-entrypoint.sh
RUN chmod +x /docker-entrypoint.sh

EXPOSE 8080

ENTRYPOINT ["sh","-c","/docker-entrypoint.sh"]
⁠镜像构建
docker build -t huzhihui/kingbase-kdts-web:v8r6 .

Tag summary

Content type

Image

Digest

sha256:6ef26e67a…

Size

491.1 MB

Last updated

about 1 year ago

docker pull huzhihui/kingbase-kdts-web:v9r1