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

Assetgrid MySQL Synology NAS Set up 1 new 2024

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

Assetgrid-MySQL-Synology-NAS-Set-up-2-new-2026

  • 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 new 2024

  • 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: How to Back Up Docker Containers on your Synology NAS.
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.
Note: Find out the Best NAS Models For Docker.
Note: Activate Gmail SMTP For Docker Containers.

This post was updated on Friday / September 20th, 2024 at 4:13 PM