Introducing our new CEO Don Johnson - Read More

portainer/extract-matomo

Verified Publisher

By Portainer.io

Updated almost 2 years ago

Image
Integration & Delivery
Monitoring & Observability
Web Analytics
0

185

extract-matomo

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 binary

./build/build-binary.sh

Schedule CRON

/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

Environment variables

/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

Metabase

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 Command

docker pull portainer/extract-matomo