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的情况下如何安装
- 运行命令
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:
- 找到
/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/'
评论区