Setup “wswallet” on Synology NAS

Source: own experience

1. In the Synology “Package Center”, install “Web Station”, “Python 3.9”, “MariaDB 10”, “phpMyAdmin”, “Log Center”.
2. Set a strong root password for MariaDB. Make sure the option “Enable TCP/IP connection” is enabled. Note the Port (3306).
3. Make sure all files are in the right place.
4. Using pypMyAdmin, create a new user “wswallet”. Set a strong password. Then, create empty databases “wswallet” and “wswallet_hist”.
5. Using the “mariadb_***.sql” SQL dump files, import all the tables (with data), routines and views for “wswallet” and “wswallet_hist”.
6. Open the “Log Center”. Create a new Rule with the following parameters:
   • Log format: BSD format
   • Transfer protocol: UDP
   • Port: 514
7. Open “Control Panel” > “Task Scheduler”.
8. Create a new scheduled task with user-defined script with the following parameters:
   • General
     • Task: Export MariaDB wswallet
     • User: root
     • Enabled: Yes
   • Schedule:
     • Run on the following days: Daily
     • Start time: 15:50
   • Task Settings:
     • Send run details by email: <email>
     • Send run details only when the script terminates abnormally: Yes
     • User-defined script: bash /volume1/wswallet/export_mariadb.sh
9. Create a another new scheduled task with user-defined script with the following parameters:
   • General
     • Task: Copy files to wswallet
     • User: root
     • Enabled: Yes
   • Schedule:
     • Run on the following days: Daily
     • Start time: 18:00
   • Task Settings:
     • Send run details by email: <email>
     • Send run details only when the script terminates abnormally: Yes
     • User-defined script: bash /volume1/wswallet/copy.sh