Synology: Install Assetgrid Using MySQL as Database

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 assetgridatabase. Follow the instructions in the image below.
Note: Be careful to enter only lowercase, not uppercase letters.

Assetgrid MySQL Synology NAS Set up 1

  • 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.

1 Synology Portainer Add Stack

  • 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.1"
services:
  db:
    image: mariadb:latest
    container_name: Assetgrid-DB
    restart: always
    volumes:
      - /volume1/docker/assetgridatabase:/var/lib/mysql
    environment:
      MYSQL_ROOT_PASSWORD: secret
      MYSQL_PASSWORD: secret
      MYSQL_DATABASE: assetgrid
      MYSQL_USER: assetgrid
  assetgrid:
    image: assetgrid/assetgrid
    container_name: Assetgrid
    restart: always
    links:
      - db:db
    environment:
      Provider: MySQL
      "ConnectionStrings:MySQL": server=db;Database=assetgrid;Uid=assetgrid;Pwd=secret
    ports:
      - 5160:8080

Assetgrid MySQL Synology NAS Set up 2

  • 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.

Assetgrid MySQL Synology NAS Set up 3

  • STEP 7

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

Assetgrid MySQL Synology NAS Set up 4

  • 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.

Assetgrid MySQL Synology NAS Set up 5

  • STEP 10

Type in your own Email and Password that you have previously created at STEP 9. Follow the instructions in the image below.

Assetgrid MySQL Synology NAS Set up 6

Enjoy Assetgrid!

Assetgrid MySQL Synology NAS Set up 7

Note: If you want to run the Assetgrid container over HTTPS, check my guide on How to Run Docker Containers Over HTTPS.

Note: Can I run Docker on my Synology NAS? See the supported models.
Note: Find out how to update the Assetgrid container with the latest image.
Note: How to Free Disk Space on Your NAS if You Run Docker.
Note: How to Schedule Start & Stop For Docker Containers.
Note: How to Activate Email Notifications.
Note: How to Add Access Control Profile on Your NAS.
Note: How to Change Docker Containers Restart Policy.
Note: How to Use Docker Containers With VPN.
Note: Convert Docker Run Into Docker Compose.
Note: How to Clean Docker.
Note: How to Clean Docker Automatically.
Note: Best Practices When Using Docker and DDNS.
Note: Some Docker Containers Need WebSocket.

This post was updated on Saturday / October 22nd, 2022 at 10:58 PM