Day 16: Mixpost Lite – Self-Hosted Social Media Management – 7 Days of Docker

In today’s digital landscape, managing social media presence efficiently is crucial for businesses and content creators. While several cloud-based solutions exist, they often come with subscription fees and data privacy concerns. Enter Mixpost – an open-source, self-hosted social media management tool that puts you in control of your content and data. In this article, we’ll focus particularly on Mixpost Lite, the free community version that makes professional social media management accessible to everyone.

What is Mixpost Lite?

Mixpost Lite is the free, community version of Mixpost – a robust, self-hosted alternative to services like Buffer and Hootsuite. As an open-source project, Mixpost Lite allows you to easily create, schedule, publish, and manage social media content in one place, without monthly subscription fees.

Designed specifically for beginners and those new to self-hosted solutions, Mixpost Lite offers essential features to get started with professional social media management. As a self-hosted solution, you maintain complete ownership of your data while enjoying powerful social media management capabilities.

Mixpost is available in three versions:

• Mixpost Lite – Free, community version with essential features (what we’re focusing on)
• Mixpost Pro – Extended features for professional use
• Mixpost Enterprise – Advanced capabilities for large teams and agencies

Key Features of Mixpost

Content Management & Scheduling

1. Calendar Interface
   Mixpost’s intuitive calendar helps streamline work management by displaying and organizing posts on a visual calendar, making it easy to plan your content strategy.
2. Post First Comment/Thread
   Automatically add impactful first comments to your posts to boost engagement and extend conversations, a crucial strategy for platforms like Instagram and Twitter.
3. Post Conditions (Coming Soon)
   Automate follow-up comments on posts that perform well based on key metrics such as likes and engagement rate.
4. Post Templates
   Create and save templates for recurring content types to maintain consistency and save time when creating new posts.
5. Queue System
   Build the habit of creating content for your audience with a queue system that makes posting times more natural and less robotic.

Organization & Workflow

1. Hashtag Groups
   Enhance your social media strategy with organized hashtag groups that you can quickly insert into your posts.
2. Best Time to Post
   Analyze when your audience is most active and schedule posts accordingly to maximize engagement.
3. Media Library
   Store and organize your images, videos, and other media assets in one centralized location for easy access when creating posts.
4. Workspaces
   Manage several brands and businesses by organizing social accounts, team members, posts, and assets into dedicated spaces.
5. Team Collaboration
   Work seamlessly with team members by assigning roles and permissions, and implement approval workflows for content quality control.

Platform Compatibility

Mixpost Lite supports several major social media platforms including:

• Facebook (Pages and Groups)
• Twitter/X
• Mastodon

Note: The Pro and Enterprise versions offer additional platform support including Instagram, LinkedIn, and Google Business Profile.

Why Choose Mixpost Lite?

• Completely Free: The community version costs nothing to use
• Open Source: Community-driven development and transparency
• Own Your Data: Complete control over your information
• Beginner-Friendly: Designed for those new to self-hosted applications
• No Limits: Schedule as many posts as you need without artificial constraints
• Upgrade Path: Start with Lite and migrate to Pro or Enterprise as your needs grow

Mixpost Lite serves as an excellent entry point for individuals, small businesses, or content creators who want to test the waters of self-hosted social media management without financial commitment. The Lite version is actively maintained with regular updates and improvements from both the developers and the open-source community.

Features Specific to Mixpost Lite

Mixpost Lite includes the following core features:

1. Social Account Management
2. Content Creation & Scheduling
3. Organization Tools

While Mixpost Lite is free, it provides a solid foundation of essential tools needed for effective social media management. The code is available on GitHub under the MIT license, allowing for community contributions and customizations.

Docker Installation Guide for Mixpost Lite

Installing Mixpost Lite with Docker offers several advantages:

• Clean, isolated environment
• Simplified setup process
• Consistent environment across different operating systems

Let’s walk through the Docker installation process specifically for Mixpost Lite:

Prerequisites

• A server with Docker and Docker Compose installed
• Domain or subdomain pointing to your server
• Basic command line knowledge

Step 1: DNS Setup

Point your domain/subdomain to your server by adding an A record:

Step 2: Install Docker

If you haven’t installed Docker yet, here’s how to do it on Ubuntu:

Step 3: Create Docker Compose File

Create a file named docker-compose.yml and paste the following configuration:

services:
  traefik:
    image: "traefik"
    restart: unless-stopped
    command:
      - "--api=true"
      - "--api.insecure=true"
      - "--providers.docker=true"
      - "--providers.docker.exposedbydefault=false"
      - "--entrypoints.web.address=:80"
      - "--entrypoints.web.http.redirections.entryPoint.to=websecure"
      - "--entrypoints.web.http.redirections.entrypoint.scheme=https"
      - "--entrypoints.websecure.address=:443"
      - "--certificatesresolvers.mytlschallenge.acme.tlschallenge=true"
      - "--certificatesresolvers.mytlschallenge.acme.email=${SSL_EMAIL}"
      - "--certificatesresolvers.mytlschallenge.acme.storage=/letsencrypt/acme.json"
    ports:
      - "80:80"
      - "443:443"
    volumes:
      - traefik_data:/letsencrypt
      - /var/run/docker.sock:/var/run/docker.sock:ro
    depends_on:
      - mixpost
    labels:
      - traefik.enable=true
      - traefik.http.routers.mixpost.rule=Host(${APP_DOMAIN})
      - traefik.http.routers.mixpost.tls=true
      - traefik.http.routers.mixpost.entrypoints=web,websecure
      - traefik.http.routers.mixpost.tls.certresolver=mytlschallenge
      - traefik.http.middlewares.mixpost.headers.SSLRedirect=true
      - traefik.http.middlewares.mixpost.headers.STSSeconds=315360000
      - traefik.http.middlewares.mixpost.headers.browserXSSFilter=true
      - traefik.http.middlewares.mixpost.headers.contentTypeNosniff=true
      - traefik.http.middlewares.mixpost.headers.forceSTSHeader=true
      - traefik.http.middlewares.mixpost.headers.SSLHost=${APP_DOMAIN}
      - traefik.http.middlewares.mixpost.headers.STSIncludeSubdomains=true
      - traefik.http.middlewares.mixpost.headers.STSPreload=true
      - traefik.http.routers.mixpost.middlewares=mixpost@docker
  
  mixpost:
    image: "inovector/mixpost:latest"
    volumes:
      - storage:/var/www/html/storage/app
      - logs:/var/www/html/storage/logs
    depends_on:
      - mysql
      - redis
    restart: unless-stopped

  mysql:
    image: 'mysql/mysql-server:8.0'
    environment:
      MYSQL_DATABASE: ${DB_DATABASE}
      MYSQL_USER: ${DB_USERNAME}
      MYSQL_PASSWORD: ${DB_PASSWORD}
    volumes:
      - mysql:/var/lib/mysql
    healthcheck:
      test: ["CMD", "mysqladmin", "ping", "-p${DB_PASSWORD}"]
      retries: 3
      timeout: 5s
    restart: unless-stopped

  redis:
    image: 'redis:latest'
    command: redis-server --appendonly yes --replica-read-only no
    volumes:
      - 'redis:/data'
    healthcheck:
      test: ["CMD", "redis-cli", "ping"]
      retries: 3
      timeout: 5s
    restart: unless-stopped

volumes:
  traefik_data:
    driver: local
  mysql:
    driver: local
  redis:
    driver: local
  storage:
    driver: local
  logs:
    driver: local

Step 4: Create .env File

Create a .env file in the same directory and add the following configuration:

# The name of your application.
APP_NAME=Mixpost

# A randomly generated key used for security.
APP_KEY=

# Debug mode setting. Set to 'false' for production environments.
APP_DEBUG=false

# Your app's domain or subdomain, without the 'http://' or 'https://' prefix.
APP_DOMAIN=example.com

# Full application URL is automatically configured; no modification required.
APP_URL=https://${APP_DOMAIN}

# MySQL connection setup.
DB_DATABASE=mixpost_db
DB_USERNAME=mixpost_user
DB_PASSWORD=

# Specify the email address to be used for SSL certificate registration and notifications.
SSL_EMAIL=user@example.com

Make sure to replace:

• example.com with your actual domain
• Set a secure password for DB_PASSWORD
• Use a valid email for SSL_EMAIL
• Leave APP_KEY blank as it will be auto-generated

Step 5: Start Docker Compose

Start Mixpost with the following command:

docker compose up -d

The initial connection might take a moment as Docker sets up all the containers and Mixpost initializes its database.

Monitoring and Management

To view the logs in real-time:

docker compose logs -f

To stop the containers:

docker compose stop

To start them again:

docker compose start

First-Time Setup

Once Docker setup is complete, navigate to your domain in a browser to access Mixpost. During the first login, you’ll be prompted to create an admin account and configure your initial settings.

Cloudflare Configuration

If you’re using Cloudflare, you might encounter SSL connection issues. To fix this:

1. Under SSL/TLS, select “Off (not secure)”
2. Ensure the DNS records for your domain/subdomain are proxied (orange cloud icon)

Updating Mixpost

To update to the latest version of Mixpost:

docker compose pull
docker compose up -d

System Requirements for Mixpost Lite

Mixpost Lite has modest system requirements, making it accessible for most hosting environments:

• PHP 8.1 or higher
• MySQL 5.7+ or MariaDB 10.3+
• Redis server
• Composer
• Web server (Apache or Nginx)

The Docker installation method handles these dependencies automatically, making it the easiest way to get started.

Community and Support

As an open-source project, Mixpost Lite benefits from community support and contributions. If you encounter issues or have questions, you can:

1. Check the official documentation at docs.mixpost.app
2. Submit issues on the GitHub repository
3. Participate in discussions with other users

Thoughts

Mixpost Lite offers a powerful, free alternative to subscription-based social media management tools. With its essential feature set and Docker-based installation, you can quickly set up a functional social media management system that gives you complete control over your data and workflow.

By managing your social media presence with Mixpost Lite, you’ll save on subscription costs while enjoying a tool that focuses on the core features needed for effective social media management. The open-source nature of the software means continuous improvements and community support.

Whether you’re an individual creator, a small business, or simply someone looking to organize their social media presence more effectively, Mixpost Lite provides the tools you need to get started. And as your needs grow, the upgrade path to Pro or Enterprise versions ensures you won’t outgrow the platform.

Start your social media management journey with Mixpost Lite today – a no-cost, no-risk way to take control of your social media strategy!