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

🟢Please Support My work by Making a Donation. Almost 99,9% of the people that install something using my guides forget to support my work, or just ignore STEP 1. I’ve been very honest about this aspect of my work since the beginning: I don’t run any ADS, I don’t require subscriptions, paid or otherwise, I don’t collect IPs, emails, and I don’t have any referral links from Amazon or other merchants. I also don’t have any POP-UPs or COOKIES. I have repeatedly been told over the years how much I have contributed to the community. It’s something I love doing and have been honest about my passion since the beginning. But I also Need The Community to Support me Back to be able to continue doing this work.

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.