Open Mercato

Stack

Open Mercato - the MIT "AI-engineering foundation framework": multi-tenant CRM/ERP/commerce modules on Next.js with RBAC, dynamic entities, and an agent-ready repo layout (specs + skills checked in). Start business apps at "80% done".

Configuration

Type

Compose

Platform

linux

Env vars

APP_URL=http://localhost:5000JWT_SECRET=''MEILISEARCH_MASTER_KEY=''[email protected]OM_INIT_SUPERADMIN_PASSWORD=''TENANT_DATA_ENCRYPTION_KEY=''

Source

Repo

Template by deployable-sh·Source

Report issue

Services

app

Configuration

Command

/bin/sh,-lc,export MEILISEARCH_API_KEY="$MEILI_MASTER_KEY"
INIT_COMMAND='yarn mercato init' sh /app/docker/scripts/init-or-migrate.sh
yarn start

Ports

5000:5000

Volumes

/tmp/init-marker : initmarker/app/apps/mercato/storage : attachments

Env vars

PORT=5000NODE_ENV=productionNODE_OPTIONS=--max-old-space-size=2560APP_URL=${APP_URL:-http://localhost:5000}JWT_SECRET=${JWT_SECRET}DATABASE_URL=postgres://mercato:mercato-local-only@db:5432/mercatoCACHE_STRATEGY=redisCACHE_REDIS_URL=redis://cache:6379MEILISEARCH_HOST=http://search:7700MEILI_MASTER_KEY=${MEILI_MASTER_KEY:?Meilisearch master key required}OM_INIT_SUPERADMIN_EMAIL=${OM_INIT_SUPERADMIN_EMAIL}OM_INIT_SUPERADMIN_PASSWORD=${OM_INIT_SUPERADMIN_PASSWORD}TENANT_DATA_ENCRYPTION=trueTENANT_DATA_ENCRYPTION_KEY=${TENANT_DATA_ENCRYPTION_KEY}DEMO_MODE=falseSELF_SERVICE_ONBOARDING_ENABLED=false

Restart

unless-stopped

Build

https://github.com/open-mercato/open-mercato.git

db

Configuration

Image

pgvector/pgvector:pg17-trixie

Ports

5432

Volumes

/var/lib/postgresql/data : dbdata

Env vars

POSTGRES_USER=mercatoPOSTGRES_PASSWORD=mercato-local-onlyPOSTGRES_DB=mercatoPGDATA=/var/lib/postgresql/data/pgdata

Restart

unless-stopped

Image details

Pulls: 200.9M

User: pgvector

Created: Jan 29, 2024

Updated: 1 month ago

Status: active

cache

Configuration

Ports

6379

Restart

unless-stopped

Build

./cache

search

Configuration

Image

getmeili/meilisearch:v1.11

Ports

7700

Volumes

/meili_data : searchdata

Env vars

MEILI_ENV=productionMEILI_MASTER_KEY=${MEILI_MASTER_KEY:?Meilisearch master key required}MEILI_DB_PATH=/meili_data/data.msMEILI_NO_ANALYTICS=true

Restart

unless-stopped

Image details

Pulls: 55.0M

User: getmeili

Created: Nov 22, 2019

Updated: 4 hours ago

Status: active

Standalone Install

Select an install method, to see config/commands for deploying Open Mercato

Installation method

Docker Run

Docker Compose

Install on Portainer

Import all app templates into your Portainer instance, for easy 1-click deploys

Ensure both Docker and Portainer are installed, and up-to-date
Log into your Portainer web UI
Under Settings → App Templates, paste the below URL
Head to Home → App Templates, and the list of apps will show up
Select Open Mercato, fill in any config options, and hit Deploy

Template Import URL

https://raw.githubusercontent.com/Lissy93/portainer-templates/main/templates.json

Show Me

Original stackfile

The compose file this template deploys, straight from its repo:

name: open-mercato

services:
  app:
    build:
      context: https://github.com/open-mercato/open-mercato.git
      args:
        CONTAINER_PORT: "5000"
    restart: unless-stopped
    user: "0"
    working_dir: /app/apps/mercato
    command:
      - /bin/sh
      - -lc
      - |
        export MEILISEARCH_API_KEY="$MEILI_MASTER_KEY"
        INIT_COMMAND='yarn mercato init' sh /app/docker/scripts/init-or-migrate.sh
        yarn start
    environment:
      PORT: "5000"
      NODE_ENV: production
      NODE_OPTIONS: --max-old-space-size=2560
      APP_URL: ${APP_URL:-http://localhost:5000}
      JWT_SECRET: ${JWT_SECRET}
      DATABASE_URL: postgres://mercato:mercato-local-only@db:5432/mercato
      CACHE_STRATEGY: redis
      CACHE_REDIS_URL: redis://cache:6379
      MEILISEARCH_HOST: http://search:7700
      MEILI_MASTER_KEY: ${MEILI_MASTER_KEY:?Meilisearch master key required}
      OM_INIT_SUPERADMIN_EMAIL: ${OM_INIT_SUPERADMIN_EMAIL}
      OM_INIT_SUPERADMIN_PASSWORD: ${OM_INIT_SUPERADMIN_PASSWORD}
      TENANT_DATA_ENCRYPTION: "true"
      TENANT_DATA_ENCRYPTION_KEY: ${TENANT_DATA_ENCRYPTION_KEY}
      DEMO_MODE: "false"
      SELF_SERVICE_ONBOARDING_ENABLED: "false"
    ports:
      - "5000:5000"
    volumes:
      - initmarker:/tmp/init-marker
      - attachments:/app/apps/mercato/storage
    depends_on:
      - db
      - cache
      - search

  db:
    ports:
    - "5432"
    image: pgvector/pgvector:pg17-trixie
    restart: unless-stopped
    environment:
      POSTGRES_USER: mercato
      POSTGRES_PASSWORD: mercato-local-only
      POSTGRES_DB: mercato
      PGDATA: /var/lib/postgresql/data/pgdata
    volumes:
      - dbdata:/var/lib/postgresql/data

  cache:
    build: ./cache
    restart: unless-stopped
    ports:
      - "6379"

  search:
    image: getmeili/meilisearch:v1.11
    restart: unless-stopped
    environment:
      MEILI_ENV: production
      MEILI_MASTER_KEY: ${MEILI_MASTER_KEY:?Meilisearch master key required}
      MEILI_DB_PATH: /meili_data/data.ms
      MEILI_NO_ANALYTICS: "true"
    ports:
      - "7700"
    volumes:
      - searchdata:/meili_data

volumes:
  dbdata:
  searchdata:
  attachments:
  initmarker:

Or deploy it directly from the source:

git clone https://github.com/deployable-sh/stacks
cd stacks
docker compose -f open-mercato/compose.yaml up -d

More install options in our documentation.

Container Documentation

db Documentation

Open-source vector similarity search for Postgres

Serve Open Mercato on your own domain behind Caddy, Nginx or Traefik. Fill in your domain and copy the result. It's a starting point, some apps need their own base URL or extra headers set too.

Proxy Domain App port Upstream

Proxying open-mercato.example.com to http://app:5000

Add this to your Caddyfile

open-mercato.example.com {
	reverse_proxy http://app:5000
}

Check the logs first

Nine times out of ten the logs tell you exactly what went wrong.

In Portainer, go to Containers, click the container, then Logs. Or run docker logs <container>
Exit codes help too: 137 means killed, usually out of memory. 126 or 127 means the command inside the image is broken.

Port already in use

If deployment fails with "Bind for 0.0.0.0:5000 failed: port is already allocated", something else on your server is using that port.

Find what's using it: sudo ss -tlnp | grep :5000
Stop the other service, or pick a different host port. In 5000:5000 only the left number is yours to change, the right one belongs to the app.

Published on a random port

This template exposes 5432 without setting a host port, so Docker picks a random free one on every deploy.

Find it in the Ports column of Portainer's container list, or with docker port <container>

Running but the page won't load

The container is up but nothing appears in your browser.

Use your server's real IP: http://your-server-ip:5000. The 0.0.0.0 link Portainer shows isn't a real address.
Give it a minute after first deploy, open-mercato can take a while to initialise.
Make sure your firewall allows the port, e.g. sudo ufw allow 5000

Image won't pull

Test the pull directly on the host: docker pull pgvector/pgvector:pg17-trixie

"manifest unknown" means the tag no longer exists.
"toomanyrequests" is the Docker Hub rate limit. Log in with docker login to raise it.
"no space left on device" means a full disk. Reclaim space with docker system prune

"exec format error"

This means the image was built for a different CPU architecture than your server.

Check yours with uname -m: x86_64 is amd64, aarch64 is arm64. Raspberry Pi and other ARM boards are the usual culprits.

Container keeps restarting

The unless-stopped restart policy relaunches the app after every crash, so the real error can scroll past.

Check the logs right after a restart, the last few lines before it died are the useful ones.
Get the exit code with docker inspect <container> --format '{{.State.ExitCode}}'
Still stuck? Redeploy once with the restart policy set to no so the failure stays visible.

Stack won't deploy

Compose stacks fail fast on small mistakes, and Portainer shows the reason just above the editor.

YAML only accepts spaces for indentation, a single tab breaks the whole file.

Raise an issue

Found something which isn't working as it should? Here's how to report it.

Bug within the app: Open an issue within open-mercato's repo
Template not working: Open an issue on deployable-sh/stacks
This website not working: Open an issue on lissy93/portainer-templates

A Compose stack

Open Mercato is a Compose stack, a set of containers (4 of them) defined in one file and brought up together by Portainer, then started and stopped as a single app.

The services

This stack is built from 4 containers that run side by side. Here's each one, with the image it runs and anything it waits for first:

app, starts after db, cache, search
db runs pgvector/pgvector:pg17-trixie
cache
search runs getmeili/meilisearch:v1.11

Ports

A port is the door the app answers on. A mapping like 5000:5000 means it's reachable on port 5000 of your server, where the left number is yours to change and the right one belongs to the app. It opens:

5000:5000
5432, published on a random host port
6379, published on a random host port
7700, published on a random host port

Volumes

A volume is where Open Mercato keeps its files so they survive an update or a restart. Without one, anything it saves would sit inside the container and vanish the moment it's recreated. This template mounts:

/tmp/init-marker kept in the initmarker volume Docker manages
/app/apps/mercato/storage kept in the attachments volume Docker manages
/var/lib/postgresql/data kept in the dbdata volume Docker manages
/meili_data kept in the searchdata volume Docker manages

Environment variables

Environment variables are the settings you hand over when you deploy, things like a password or a timezone. Open Mercato takes 23 of them, and one needs a value before it'll start properly:

PORT, defaults to 5000
NODE_ENV, defaults to production
NODE_OPTIONS, defaults to --max-old-space-size=2560
APP_URL, defaults to http://localhost:5000
JWT_SECRET, pulled from your own environment
DATABASE_URL, defaults to postgres://mercato:mercato-local-only@db:5432/mercato
CACHE_STRATEGY, defaults to redis
CACHE_REDIS_URL, defaults to redis://cache:6379
MEILISEARCH_HOST, defaults to http://search:7700
MEILI_MASTER_KEY, needs a value
OM_INIT_SUPERADMIN_EMAIL, pulled from your own environment
OM_INIT_SUPERADMIN_PASSWORD, pulled from your own environment
TENANT_DATA_ENCRYPTION, defaults to true
TENANT_DATA_ENCRYPTION_KEY, pulled from your own environment
DEMO_MODE, defaults to false
SELF_SERVICE_ONBOARDING_ENABLED, defaults to false
POSTGRES_USER, defaults to mercato
POSTGRES_PASSWORD, defaults to mercato-local-only
POSTGRES_DB, defaults to mercato
PGDATA, defaults to /var/lib/postgresql/data/pgdata
MEILI_ENV, defaults to production
MEILI_DB_PATH, defaults to /meili_data/data.ms
MEILI_NO_ANALYTICS, defaults to true

Restart policy

The restart policy here is unless-stopped, so Docker restarts Open Mercato after a crash or reboot, but leaves it off when you stop it on purpose. You can change this on the deploy screen. The choices are no (never restart), on-failure (only after a crash), unless-stopped (restart unless you stop it), and always (bring it back no matter what).

Networking

Portainer puts these services on one shared private network, so they can find each other by name (like app) while only the ports above are open to you.

Platform

The platform is linux, the kind of system the container is built to run on. Docker and Portainer handle this on a normal Linux server.

Portainer app templates

Zooming out, this whole page comes from a Portainer app template: a short recipe telling Portainer how to set Open Mercato up. Add the template list to Portainer once, then deploying Open Mercato is a click rather than a wall of config.

Open Mercato

Configuration

Services

app

Configuration

db

Configuration

Image details

cache

Configuration

search

Configuration

Image details

Standalone Install

Install on Portainer

Template Import URL

Container Documentation

db Documentation

Proxy configurator

Troubleshooting

Check the logs first

Port already in use

Published on a random port

Running but the page won't load

Image won't pull

"exec format error"

Container keeps restarting

Stack won't deploy

Raise an issue

Config glossary

A Compose stack

The services

Ports

Volumes

Environment variables

Restart policy

Networking

Platform

Portainer app templates