用 docker-compose 部署了metabase,导出的excel和csv打开都有点异常,问题和解决方法如下:
1、导出csv文件乱码,几台电脑测试,用wps打开正常、office打开有乱码;
2、导出excel文件失败,下载的文件中提示错误
“{"via":[{"type":"java.lang.RuntimeException","message":"java.io.IOException: Could not create temporary directory '/tmp/poifiles'","at"”....
解决方法:在映射的volumes中把tmp目录权限放开,如下:
-bash-4.2# chmod -R 777 tmp
-bash-4.2# ll
total 580244
-rw-r--r-- 1 root root 471 Feb 16 17:16 docker-compose.yml
-rw-r--r-- 1 root root 322478080 Nov 24 2022 metabase.db.mv.db
drwxrwxrwx 2 root root 6 Nov 24 2022 tmp
再次下载后,文件内容正常。
附件:docker-compose.yml
version: '1'
services:
metabase:
image: metabase/metabase:latest
ports:
- "8091:3000"
volumes:
- /data/docker/data/metabase/tmp:/tmp
environment:
- MB_DB_TYPE=mysql
- MB_DB_DBNAME=metabase
- MB_DB_USER=metabase
- MB_DB_PASS=x.sf&123
- MB_DB_HOST=192.168.1.12
- MB_DB_PORT=3306