Synology: Install Assetgrid Using MySQL as Database

Do you remember my article on how to install Assetgrid on your Synology NAS? Today I will show you how to install Assetgrid on your Synology NAS using MySQL as database instead of SQLite. Assetgrid is a personal finance platform. It is our aim to make a tool that is flexible and powerful and can accommodate many use-cases with a UI that doesn’t get in your way. Assetgrid will support budgets in an upcoming release, but Assetgrid is not built around budgets. Assetgrid is meant to be a tool to organize and extract information from personal finance data, whether you want to make a budget, keep track of unpaid bills, keep track of receipts, investments, extract random statistics about your spending habits or all that at once.

💡Note: This guide works perfectly with the latest Assetgrid v0.2.2 release.

STEP 1

Please Support My work by Making a Donation.

STEP 2

Install Portainer using my step by step guide. If you already have Portainer installed on your Synology NAS, skip this STEP. Attention: Make sure you have installed the latest Portainer version.

STEP 3

Go to File Station and open the docker folder. Inside the docker folder, create one new folder and name it assetgridb. Follow the instructions in the image below.
Note: Be careful to enter only lowercase, not uppercase letters.

STEP 4

Log into Portainer using your username and password. On the left sidebar in Portainer, click on Stacks then + Add stack. Follow the instructions in the image below.

STEP 5

In the Name field type in assetgrid. Follow the instructions in the image below.

Note: Copy Paste the code below in the Portainer Stacks Web editor.

version: "3.9"
services:
  db:
    image: mariadb:11.3-jammy
    container_name: Assetgrid-DB
    restart: always
    volumes:
      - /volume1/docker/assetgridb:/var/lib/mysql:rw
    environment:
      MYSQL_ROOT_PASSWORD: secret
      MYSQL_PASSWORD: secret
      MYSQL_DATABASE: assetgrid
      MYSQL_USER: assetgrid
  assetgrid:
    image: assetgrid/assetgrid
    container_name: Assetgrid
    restart: always
    depends_on:
      - db
    environment:
      Provider: MySQL
      "ConnectionStrings:MySQL": server=db;Database=assetgrid;Uid=assetgrid;Pwd=secret
    ports:
      - 5160:8080

STEP 6

Scroll down on the page until you see a button named Deploy the stack. Click on it. Follow the instructions in the image below. The installation process can take up to a few minutes. It will depend on your Internet speed connection.

STEP 7

If everything goes right, you will see the following message at the top right of your screen: “Success Stack successfully deployed“.

STEP 8

Go back to STEP 1 or you will deal with karma 🙂

STEP 9

The installation process can take up to a few seconds/minutes. It will depend on your Internet speed connection. Now open your browser and type in http://Synology-ip-address:5160 Type in your own credentials, Email and Password, then click Sign up. Follow the instructions in the image below.