Invoice Ninja Docker on Windows 10 Setup "account table not found"

Hi guys,

Was trying to install invoice ninja docker on Windows 10, however keep redirecting me to Welcome to nginx page. after a while, it bring me to 500 Server Error Any idea what’s going on? no error log, seems like everything is working

version: '3.7'

services:
  server:
    image: nginx
    restart: always
    environment: 
      - APP_URL=https://localhost
    volumes:
      # Vhost configuration
      - ./config/nginx/in-vhost.conf:/etc/nginx/conf.d/in-vhost.conf:ro

      # Configure your mounted directories, make sure the folder 'public' and 'storage'
      # exist, before mounting them
      # -  public:/C/invoiceninja5/public
      # -  storage:/C/invoiceninja5/storage
      # you may use a bind-mounted host directory instead, so that it is harder to accidentally remove the volume and lose all your data!
      - ./docker/app/public:/C/invoiceninja5/public:rw,delegated
      - ./docker/app/storage:/C/invoiceninja5/storage:rw,delegated
    depends_on:
      - app
    # Run webserver nginx on port 80
    # Feel free to modify depending what port is already occupied
    ports: 
      - "3000:80"
      - "443:443"
    networks:
      - invoiceninja

  app:
    image: invoiceninja/invoiceninja:5
    restart: always
    cap_add:
      - SYS_ADMIN
    environment: 
      - APP_URL=https://localhost
      - APP_KEY={mykey}
      - MULTI_DB_ENABLED=false
      - DB_HOST1=db
      - DB_USERNAME1=ninja
      - DB_PASSWORD1=ninja
      - DB_DATABASE1=ninja
      - PHANTOMJS_PDF_GENERATION=false
    volumes:
      # Configure your mounted directories, make sure the folder 'public' and 'storage'
      # exist, before mounting them
      # -  public:/C/invoiceninja5/public
      # -  storage:/C/invoiceninja5/storage
      # you may use a bind-mounted host directory instead, so that it is harder to accidentally remove the volume and lose all your data!
      - ./docker/app/public:/C/invoiceninja5/public:rw,delegated
      - ./docker/app/storage:/C/invoiceninja5/storage:rw,delegated
    depends_on:
      - db
    networks: 
      - invoiceninja  

  db:
    image: mysql:5
    restart: always
    environment: 
      - MYSQL_ROOT_PASSWORD=ninjaAdm1nPassword
      - MYSQL_USER=ninja
      - MYSQL_PASSWORD=ninja
      - MYSQL_DATABASE=ninja
    volumes:
      - mysql-data:/var/lib/mysql:rw
      # you may use a bind-mounted host directory instead, so that it is harder to accidentally remove the volume and lose all your data!
      # - ./docker/mysql/data:/var/lib/mysql:rw,delegated
    networks:
      - invoiceninja

  # THIS IS ONLY A VALID CONFIGURATION FOR IN 4. DO NOT USE FOR IN 5.
  # cron:
  #   image: invoiceninja/invoiceninja:alpine-4
  #   volumes:
  #     -  storage:/var/www/app/storage
  #     -  logo:/var/www/app/public/logo
  #     -  public:/var/www/app/public
  #   entrypoint: |
  #     /bin/sh -c 'sh -s <<EOF
  #     trap "break;exit" SIGHUP SIGINT SIGTERM
  #     sleep 300s
  #     while /bin/true; do
  #       ./artisan ninja:send-invoices
  #       ./artisan ninja:send-reminders
  #       sleep 1d
  #     done
  #     EOF'
  #   networks:
  #     - invoiceninja

volumes:
  mysql-data:
  public:
  storage:
  # This is needed for letting th cron run correctly
  # logo:

networks:
  invoiceninja:

My Log

Hi,

Sorry, hard to say. All I can suggest is to compare it to our default sample:

https://invoiceninja.github.io/selfhost.html#installing-invoice-ninja

just managed to visit the log.

apparent it stated account table not found.

Try running php artisan migrate to run the database migrations

1 Like

thanks fixed. Wasn’t aware of it when using docker.

1 Like