Hi there,
I am trying to set up analytics for my Ghost instance hosted with Coolify. I have a Docker container running Ghost v6, and I want to implement Tinybird for analytics. The Ghost documentation provides instructions for enabling web analytics, but I am having trouble syncing this with my existing setup.
The main difference with Coolify is (like Portainer stack deploys), i don’t touch the terminal, so i can’t really run removable docker containers like
docker compose run --rm tinybird-login or tinybird-sync…
And now… My head is BURNING
My current docker-compose.yml file looks like this:
services:
ghost:
image: 'ghost:6'
volumes:
- 'ghost-content-data:/var/lib/ghost/content'
environment:
- SERVICE_URL_GHOST_2368
- url=$SERVICE_URL_GHOST_2368
- database__client=mysql
- database__connection__host=mysql
- database__connection__user=$SERVICE_USER_MYSQL
- database__connection__password=$SERVICE_PASSWORD_MYSQL
- 'database__connection__database=${MYSQL_DATABASE-ghost}'
- mail__transport=SMTP
- 'mail__options__auth__pass=${MAIL_OPTIONS_AUTH_PASS}'
- 'mail__options__auth__user=${MAIL_OPTIONS_AUTH_USER}'
- 'mail__options__secure=${MAIL_OPTIONS_SECURE:-true}'
- 'mail__options__port=${MAIL_OPTIONS_PORT:-465}'
- 'mail__options__service=${MAIL_OPTIONS_SERVICE:-Mailgun}'
- 'mail__options__host=${MAIL_OPTIONS_HOST}'
- 'mail__options__from=${MAIL_OPTIONS_FROM}'
depends_on:
mysql:
condition: service_healthy
healthcheck:
test:
- CMD
- echo
- ok
interval: 5s
timeout: 20s
retries: 10
mysql:
image: 'mysql:8.0'
volumes:
- 'ghost-mysql-data:/var/lib/mysql'
environment:
- 'MYSQL_USER=${SERVICE_USER_MYSQL}'
- 'MYSQL_PASSWORD=${SERVICE_PASSWORD_MYSQL}'
- 'MYSQL_DATABASE=${MYSQL_DATABASE}'
- 'MYSQL_ROOT_PASSWORD=${SERVICE_PASSWORD_MYSQLROOT}'
healthcheck:
test:
- CMD
- mysqladmin
- ping
- '-h'
- 127.0.0.1
interval: 5s
timeout: 20s
retries: 10
The problem that I am facing is that I am not sure how to sync the necessary files and configurations, as mentioned in the Ghost Docker Documentation with tinybird-sync. Could someone please guide me on how to integrate Tinybird analytics with my existing setup?
It might seem like a stupid question maybe but I am very confused right now ![]()
Thanks !
More info:
- Of course Ghost was installed with coolify with docker