ActivityHub database always empty

thorque · August 22, 2025, 3:18pm

This is the - hopefully - last issue to get ActivityPub running on my server. How is the process for this? Tried to restart ActivityPub, then the ghost container. But I don’t see anything that looks like creation of tables.

Has anyone any hint for me?

Thanks
Thorsten

jannis · August 22, 2025, 3:33pm

Are you running migrations?

github.com/TryGhost/ghost-docker

compose.yml

fb6040fd0


      
          activitypub-migrate:
            image: ghcr.io/tryghost/activitypub-migrations:1.1.0@sha256:b3ab20f55d66eb79090130ff91b57fe93f8a4254b446c2c7fa4507535f503662
            environment:
              MYSQL_DB: mysql://${DATABASE_USER:-ghost}:${DATABASE_PASSWORD:?DATABASE_PASSWORD environment variable is required}@tcp(db:3306)/activitypub
            networks:
              - ghost_network
            depends_on:
              db:
                condition: service_healthy
            profiles: [activitypub]
            restart: no

This should get the database set up to the proper state.

thorque · August 22, 2025, 3:34pm

F*ck, overseen this. Thanks a lot.

Topic		Replies	Views
Activity pub mysql table empty Self-hosting	8	47	September 18, 2025
Where the data is for ghost? like: posts, users etc Developer help	3	1345	January 18, 2019
Reinstalling and rescuing a database Installation	3	819	September 24, 2018
Inconsistent database state Installation	5	1872	April 15, 2021
Database Migrations News	1	574	October 13, 2021

ActivityHub database always empty

Related topics