logseq-old/journals/2023_07_22.md

• mysql docker版本 #docker

  • docker run -d --name mysql -p 3306:3306 \
    -v ~/data/mysql:/var/lib/mysql \
    -e MYSQL_ROOT_HOST=% \
    -e MYSQL_ROOT_PASSWORD=02176174 \
    --restart unless-stopped mysql
    
    #--default-authentication-plugin=mysql_native_password
    

  • druid加密 #mysql #druid

    • java -cp .\druid-1.2.15.jar com.alibaba.druid.filter.config.ConfigTools $password
      
      # get key result #
      #privateKey:MIIBVAIBADANBgkqhkiG9w0BAQEFAASCAT4wggE6AgEAAkEAw39wPej8wTKi2UW2FGVefP/tX+jkUDEN+5IBiQIzIX5CYsKCOMmURe4IDWJma3z1jPI3iE1LTVY5pstdvw6QSQIDAQABAkBcLftJHdIL8KnLo+yiOlfuvaf6GLCKxU6QB7y0kvZz/CXhRyU42TCRdLZ4nkZC/vjZzJf5Oi5ubhhYj2Z7LH/vAiEAyDk5gwQDzkI6rbMF4X4hP64ok9aF5GbTzo5YfVkBST8CIQD59TPUSfb5pDy96GlpJsq+QpYDVLX4ZOEYHAipfkV8dwIgceH6kEaMU5jf/0RAKA2xo6LPeace6NaDyoy0UDd7v8kCIQCtp6/xbc2bFIJqwbvyJNQ4KJSGDeU6hANqN5fBAYwO8wIgSUj+a8hgh5hmMbORahWtstYLJT4zlI3CeuHzaOgrzzo=
      #publicKey:MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAMN/cD3o/MEyotlFthRlXnz/7V/o5FAxDfuSAYkCMyF+QmLCgjjJlEXuCA1iZmt89YzyN4hNS01WOabLXb8OkEkCAwEAAQ==
      #password:c3oCL7yS2OgqQxA6CE1mUXwcvoJYhPNcyHwYwkxQQKjXaq0B46EpMuJXyX/6P4Won9TtCZ1VzMMALfNpgqFcAQ==
      

• docker加速 #docker

  • sudo mkdir -p /etc/docker
    sudo tee /etc/docker/daemon.json <<-'EOF'
    {
      "registry-mirrors": ["https://eg1tjivc.mirror.aliyuncs.com"]
    }
    EOF
    sudo systemctl daemon-reload
    sudo systemctl restart docker
    

• postgresql docker版本 #docker
  • 无法连接，待修复 background-color:: red

  • docker run -d --name postgres -p 5432:5432 \
    -e POSTGRES_PASSWORD=02176174 \
    -v ~/data/postgresql/data:/var/lib/postgresql/data \
     --restart unless-stopped postgres
    

• 禅道zentao docker版本 #docker
  • easysoft/zentao - Docker Image | Docker Hub

  • docker run -d --name zentao -p 8080:80 -p 3307:3306 \
    -v ~/data/zentao/zentaopms:/www/zentaopms \
    -v ~/data/zentao/mysqldata:/var/lib/mysql \
    -e MYSQL_ROOT_PASSWORD=02176174 \
    --restart unless-stopped easysoft/zentao
    
    #--network=zentaonet --ip 172.172.172.173 \
    #--mac-address 02:42:ac:11:00:01 \
    

  • 创建docker网络驱动

  • sudo docker network create --subnet=[ip范围] [网络驱动名]
    sudo docker network create --subnet=172.172.172.0/24 zentaonet
    

  • 启动禅道容器

  • sudo docker run --name [容器名] -p [主机端口]:80 --network=[网络驱动名] --ip [容器IP] --mac-address [mac地址] -v [主机禅道目录]:/www/zentaopms -v [主机mysql目录]:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=[数据库密码] -d easysoft/zentao:[镜像标签]
    

• redis docker版本 #docker

  • docker run -d --name redis -p 6379:6379 \
    -v ~/data/redis/conf/:/usr/local/etc/redis \
    --restart unless-stopped \
    redis redis-server /usr/local/etc/redis/redis.conf
    
    #--appendonly yes
    

  • -d redis redis-server /etc/redis/redis.conf：表示后台启动redis，以配置文件启动redis，加载容器内的conf文件。
  • --appendonly yes：开启redis 持久化。