Docker部署Seatable记录

2021 年 06 月 26 日

3721 次浏览

2569字数

SeaTable 是一款新型的在线协同表格和信息管理工具。它支持“文件”、“图片”、“单选项”、“协作人”、“计算公式”等丰富的数据类型。它帮助你用表格的形式来方便的组织和管理各类信息，同时又和专门的软件系统一样强大。它还可以按照你的需要进行扩展，实现数据处理的自动化和业务流程的自动化。

先占一个坑，打个草稿。

参考资料：使用 Docker 部署 SeaTable 开发者版

Docker-compose文件

其中数据库密码需要在宝塔面板新建一个数据库并允许所有用户访问

version: '2.0'
services:
  db:
    image: mariadb:10.5
    container_name: seatable-mysql
    environment:
      - MYSQL_ROOT_PASSWORD=xxxxxxxx  # Requested, set the root's password of MySQL service.
      - MYSQL_LOG_CONSOLE=true
    volumes:
      - /opt/seatable/mysql-data:/var/lib/mysql  # Requested, specifies the path to MySQL data persistent store.
    networks:
      - seatable-net

  memcached:
    image: memcached:1.5.6
    container_name: seatable-memcached
    entrypoint: memcached -m 256
    networks:
      - seatable-net

  redis:
    image: redis:5.0.7
    container_name: seatable-redis
    networks:
      - seatable-net
          
  seatable:
    image: seatable/seatable:latest
    container_name: seatable
    ports:
      - "80:80"
    #   - "443:443"  # If https is enabled, cancel the comment.
    volumes:
      - /opt/seatable/seatable-data:/shared  # Requested, specifies the path to Seafile data persistent store.
    environment:
      - DB_HOST=db
      - DB_ROOT_PASSWD=xxxxxxxx  # Requested, the value shuold be root's password of MySQL service.
      - SEATABLE_SERVER_LETSENCRYPT=False # Default is False. Whether to use let's encrypt certificate.
      - SEATABLE_SERVER_HOSTNAME=服务器IP地址 # Specifies your host name.
      - TIME_ZONE=Asia/Shanghai # Optional, default is UTC. Should be uncomment and set to your local time zone.
    depends_on:
      - db
      - memcached
      - redis
    networks:
      - seatable-net

networks:
  seatable-net:

可能遇到的坑

如服务器已安装宝塔面板，务必暂停宝塔面板的Nignx服务，释放80端口
再运行docker-compose up
如果Access denied
再运行docker-compose down
运行 mysql -u -p
输入密码，然后

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'i6ECRJkzH77wpBfW' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.25.0.5' IDENTIFIED BY 'xxxxxxxxx' WITH GRANT OPTION;
root'@'172.25.0.5'
FLUSH PRIVILEGES;

运行docker-compose up -d