zl程序教程

您现在的位置是:首页 >  数据库

当前栏目

【docker】docker_dbclient(支持mysql、oracle、postgres、sqlserver客户端)

2023-09-11 14:17:00 时间

docker_dbclient支持mysql、oracle、postgres、sqlserver客户端

安装过程如下

[root@localhost home]# cd /root/temp/
[root@localhost temp]# ll
总用量 56032
-rw-r--r--. 1 root   root   57372185 5月   5 17:10 docker.zip
drwx------. 3 root   root         30 5月   5 17:21 etc
drwxr-xr-x. 5 docker docker       60 2月  20 2020 home
-rwxr-xr-x. 1 docker docker     1433 5月  10 2021 install.sh
[root@localhost temp]# unzip docker.zip
Archive:  docker.zip
   creating: docker/
  inflating: __MACOSX/._docker
   creating: docker/home/
  inflating: __MACOSX/docker/._home
  inflating: docker/install.sh
   creating: docker/etc/
  inflating: __MACOSX/docker/._etc
  inflating: docker/????.txt
  inflating: __MACOSX/docker/._????.txt
  inflating: docker/home/.DS_Store
  inflating: __MACOSX/docker/home/._.DS_Store
   creating: docker/home/bin/
  inflating: __MACOSX/docker/home/._bin
   creating: docker/home/sbin/
  inflating: __MACOSX/docker/home/._sbin
   creating: docker/home/containers/
  inflating: __MACOSX/docker/home/._containers
   creating: docker/etc/bash_completion.d/
  inflating: __MACOSX/docker/etc/._bash_completion.d
   creating: docker/etc/docker/
  inflating: __MACOSX/docker/etc/._docker
   creating: docker/etc/systemd/
  inflating: __MACOSX/docker/etc/._systemd
  inflating: docker/home/bin/docker-containerd-ctr
  inflating: __MACOSX/docker/home/bin/._docker-containerd-ctr
  inflating: docker/home/bin/docker-init
  inflating: __MACOSX/docker/home/bin/._docker-init
  inflating: docker/home/bin/docker
  inflating: __MACOSX/docker/home/bin/._docker
  inflating: docker/home/bin/docker-proxy
  inflating: __MACOSX/docker/home/bin/._docker-proxy
  inflating: docker/home/bin/docker-runc
  inflating: __MACOSX/docker/home/bin/._docker-runc
  inflating: docker/home/bin/docker-containerd-shim
  inflating: __MACOSX/docker/home/bin/._docker-containerd-shim
  inflating: docker/home/bin/docker-containerd
  inflating: __MACOSX/docker/home/bin/._docker-containerd
  inflating: docker/home/bin/dockerd
  inflating: __MACOSX/docker/home/bin/._dockerd
  inflating: docker/home/bin/docker-compose
  inflating: __MACOSX/docker/home/bin/._docker-compose
  inflating: docker/home/sbin/docker.sh
  inflating: __MACOSX/docker/home/sbin/._docker.sh
  inflating: docker/etc/bash_completion.d/docker
  inflating: __MACOSX/docker/etc/bash_completion.d/._docker
  inflating: docker/etc/docker/daemon.json
  inflating: __MACOSX/docker/etc/docker/._daemon.json
   creating: docker/etc/systemd/system/
  inflating: __MACOSX/docker/etc/systemd/._system
  inflating: docker/etc/systemd/system/docker.service
  inflating: __MACOSX/docker/etc/systemd/system/._docker.service
[root@localhost temp]# ll
总用量 56032
drwxr-xr-x. 4 root   root         67 5月  10 2021 docker
-rw-r--r--. 1 root   root   57372185 5月   5 17:10 docker.zip
drwx------. 3 root   root         30 5月   5 17:21 etc
drwxr-xr-x. 5 docker docker       60 2月  20 2020 home
-rwxr-xr-x. 1 docker docker     1433 5月  10 2021 install.sh
drwxr-xr-x. 3 root   root         34 5月   5 17:22 __MACOSX
[root@localhost temp]# rm -rf __MACOSX/
[root@localhost temp]# cd docker/
[root@localhost docker]# ll
总用量 8
drwxr-xr-x. 5 root root   57 10月 31 2019 etc
drwxr-xr-x. 5 root root   60 2月  20 2020 home
-rw-r--r--. 1 root root 1433 5月  10 2021 install.sh
-rwxr-xr-x. 1 root root 1117 4月  10 2020 安装步骤.txt
[root@localhost docker]# chmod 777 install.sh
[root@localhost docker]# ./install.sh
useradd:用户“docker”已存在
1,add user docker success!
2,create docker dir success!
3,copy binary file success!
4,set the completion docker command success!
5,copy file daemon.json success!
6,copy file docker.service success!
ln: 无法创建符号链接"/usr/local/bin/docker": 文件已存在
ln: 无法创建符号链接"/usr/local/bin/docker-compose": 文件已存在
7,create docker link success!
8,reload and restart docker success
ln -s '/etc/systemd/system/docker.service' '/etc/systemd/system/multi-user.target.wants/docker.service'
9,set docker service auto-restart success!
10,set the file success!
[root@localhost docker]# cat 安装步骤.txt
1.create docker user
# useradd docker

2.create dir
# mkdir -p /etc/docker
# mkdir -p /home/docker/containers

3.upload the binary file and sh file
* upload local:/home/docker/bin,local:/home/docker/sbin to the server:/home/docker/*

4.set the completion docker command
* upload local:/etc/bash_completion.d/docker to server:/etc/bash_completion.d

5.upload the file daemon.json
* upload local:/etc/docker/daemon.json to server:/etc/docker/

6.upload the file docker.service
* upload local:/etc/systemd/system/docker.service to server:/etc/systemd/system

7.create link to docker command
# ln -s /home/docker/bin/docker /usr/local/bin/docker
# ln -s /home/docker/bin/docker-compose /usr/local/bin/docker-compose

8.reload and restart docker
# systemctl daemon-reload && systemctl restart docker

9.set the docker auto-restart
# systemctl disable docker
# systemctl enable docker

10.set the auth
# chown -R docker:docker /etc/docker
# chown -R docker:docker /home/docker
# chmod -R 755 /home/docker

11.new user in docker
# useradd user1
# passwd user1
# usermod -aG docker user1[root@localhost docker]#
[root@localhost docker]#
[root@localhost docker]#
[root@localhost docker]# ll
总用量 8
drwxr-xr-x. 5 root root   57 10月 31 2019 etc
drwxr-xr-x. 5 root root   60 2月  20 2020 home
-rwxrwxrwx. 1 root root 1433 5月  10 2021 install.sh
-rwxr-xr-x. 1 root root 1117 4月  10 2020 安装步骤.txt
[root@localhost docker]# cd ..
[root@localhost temp]# cd /home/
[root@localhost home]# ll
总用量 1336828
drwxr-xr-x.  5 docker   docker           61 5月   5 17:24 docker
-rw-r--r--.  1 root     root     1364172800 5月   5 17:23 docker_dbclient.tar
drwxr-xr-x.  3 root     root             34 5月   5 17:18 __MACOSX
drwxr-xr-x.  2 root     root             17 8月  17 2021 nmon
[root@localhost home]# df -h
文件系统                 容量  已用  可用 已用% 挂载点
/dev/mapper/centos-root   50G   13G   38G   26% /
devtmpfs                 5.9G     0  5.9G    0% /dev
tmpfs                    5.9G   80K  5.9G    1% /dev/shm
tmpfs                    5.9G  129M  5.8G    3% /run
tmpfs                    5.9G     0  5.9G    0% /sys/fs/cgroup
/dev/mapper/centos-home   44G  2.5G   42G    6% /home
/dev/sda1                497M  122M  376M   25% /boot
[root@localhost docker]# ps -ef|grep docker
root     567521      1  1 17:24 ?        00:00:03 /home/docker/bin/dockerd
root     567533 567521  0 17:24 ?        00:00:01 docker-containerd --config /var/run/docker/containerd/containerd.toml
root     568107 567205  0 17:26 pts/0    00:00:00 grep --color=auto docker
[root@localhost docker]# cd bin/
[root@localhost bin]# ll
总用量 135832
-rwxr-xr-x. 1 docker docker 37698064 5月   5 17:24 docker
-rwxr-xr-x. 1 docker docker  8479184 5月   5 17:24 docker-compose
-rwxr-xr-x. 1 docker docker 15355928 5月   5 17:24 docker-containerd
-rwxr-xr-x. 1 docker docker 12683608 5月   5 17:23 docker-containerd-ctr
-rwxr-xr-x. 1 docker docker  4328352 5月   5 17:24 docker-containerd-shim
-rwxr-xr-x. 1 docker docker 49618008 5月   5 17:24 dockerd
-rwxr-xr-x. 1 docker docker   760048 5月   5 17:23 docker-init
-rwxr-xr-x. 1 docker docker  2639191 5月   5 17:24 docker-proxy
-rwxr-xr-x. 1 docker docker  7509696 5月   5 17:24 docker-runc
[root@localhost bin]# cd /home/
[root@localhost home]# ll
总用量 1336828
drwxr-xr-x.  5 docker   docker           61 5月   5 17:24 docker
-rw-r--r--.  1 root     root     1364172800 5月   5 17:23 docker_dbclient.tar
drwxr-xr-x.  3 root     root             34 5月   5 17:18 __MACOSX
drwxr-xr-x.  2 root     root             17 8月  17 2021 nmon
[root@localhost home]# cat docker_dbclient.tar| docker import - docker_dbclient:1.0
sha256:538dcae9577418f8fb8413bf73bd19f7f361239d4ad04765c435eddc8d363903
[root@localhost home]# docker run -idt docker_dbclient:1.0 /bin/bash
d05746c0a57f19725553102b87904cea8c8d63a2d595f32bff5c8fbfa7181a36
[root@localhost home]#