目 录CONTENT

文章目录

SeaTable 安装,更新……

JomBarry
2023-11-19 / 0 评论 / 0 点赞 / 119 阅读 / 0 字 / 正在检测是否收录...

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

安装

这里使用 docker 安装

官方安装说明:跳转

1. 执行命令

官方默认安装

services:
  db:
    image: mariadb:10.11
    container_name: seatable-mysql
    environment:
      - MYSQL_ROOT_PASSWORD=PASSWORD  # 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-developer: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=PASSWORD  # 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=example.seatable.com # 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:

自定义安装

存在对应的数据库和redis的情况下如何安装

  1. 运行命令
services:
    memcached:
        image: memcached:1.5.6
        container_name: seatable-memcached
        entrypoint: memcached -m 256
        networks:
          - seatable-net
    seatable:
        image: seatable/seatable-developer: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=PASSWORD  # 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=example.seatable.com # Specifies your host name.
          - TIME_ZONE=Asia/Shanghai # Optional, default is UTC. Should be uncomment and set to your local time zone.
        depends_on:
          - memcached
        networks:
          - seatable-net
networks:
  seatable-
  net:
  1. 找到 /opt/seatable/seatable-data/conf 下对应的配置文件(.conf),根据需要修改即可。

2. 启动和创建管理用户

# 启动 SeaTable 服务
docker exec -d seatable /shared/seatable/scripts/seatable.sh start

# 创建一个管理员帐户
docker exec -it seatable /shared/seatable/scripts/seatable.sh superuser 

3. 测试是否成功

直接打开后查看是否可以进入正常使用

问题与解决办法

安装/更新过程中遇到的问题与解决

注意:修改完成后需要重启

docker exec -d seatable /shared/seatable/scripts/seatable.sh stop
docker exec -d seatable /shared/seatable/scripts/seatable.sh start

问:表格加载的显示 Network error
答:用 Chrome 的 debug 模式看看哪个网络请求出错。一般是配置文件 (dtable_web_settings.py) 中的 URL 相关的配置项没有写对。这是因为 SeaTable 服务器是由多个组件构成的。必须通过配置文件来告诉不同的组件它服务的外部 URL 是什么。配置文件中的配置只在首次启动的时候从 docker-compose 中读取和写入。如果你之后修改了地址,需要手工修改配置文件。
主要是下面四个地址:

DTABLE_SERVER_URL = 'https://seatable.yourdomain.com/dtable-server/'
DTABLE_SOCKET_URL = 'https://seatable.yourdomain.com/'

# 供用户访问SeaTable服务器的 dtable web的URL
DTABLE_WEB_SERVICE_URL = 'https://seatable.yourdomain.com/'

# 文件服务器URL
FILE_SERVER_ROOT = 'https://seatable.yourdomain.com/seafhttp/'
0
  1. 支付宝打赏

    qrcode alipay
  2. 微信打赏

    qrcode weixin
Traffmonetizer VPS 回血赚取额外收益

评论区