portainer/extract-matomo
185
Tool to export matomo content into Postgres
Note that this tool is using a bulk load from file, so this tool needs to reside on the same machine as PostgreSQL.
./build/build-binary.sh
/etc/cron.d/extract-jira
:
SHELL=/bin/sh
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
0 9 * * * portainer /home/portainer/extract-matomo/extract-matomo.sh > /home/portainer/extract-matomo/log/extract-matomo.log 2>&1
extract-matomo.sh
:
#!/bin/sh
cd /home/portainer/extract-matomo/
. /home/portainer/.profile
./extract-matomo
/home/portainer/.profile
:
export MATOMO_TOKEN_AUTH=f2xxxx57
export PG_DB_SERVER=localhost
export PG_DB_PORT=5432
export PG_DB_USER=admin
export PG_DB_PASSWORD=xxxx
export PG_DB_NAME=jira
Deploy Metabase as a BI Dashboard:
docker run -d -p 3000:3000 \
--name metabase \
--restart=always \
-e "MB_DB_TYPE=postgres" \
-e "MB_DB_DBNAME=metabase" \
-e "MB_DB_PORT=5432" \
-e "MB_DB_USER=admin" \
-e "MB_DB_PASS=xxxx" \
-e "MB_DB_HOST=172.17.0.1" \
metabase/metabase:latest
Log in
http://localhost:3000
docker pull portainer/extract-matomo