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.
Assetgrid v0.2.2 release.This guide works perfectly with the latest
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.
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.
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.
In the Name field type in assetgrid. Follow the instructions in the image below.
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
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.
If everything goes right, you will see the following message at the top right of your screen: “Success Stack successfully deployed“.
Go back to STEP 1 or you will deal with karma 🙂
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.
Type in your own Email and Password that you have previously created at STEP 9. Follow the instructions in the image below.
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