Install python script on Synology

After the installation of DSM 6.2.3-25426 on my Synology, the script to listen and log mqtt messages to a database was no longer running. Time to fix the problem!

As MQTT server I installed Mosquitto via the Synology Add-on manager. Currently the latest version distributed by the SynoCommunity is 1.4.14-9 (http://packages.synocommunity.com/).

The python script to listen and log mqtt messages needs the Paho MQTT client and a mysql-connector. Install these packages with PIP, the package installer for Python.

SSH to synology server as admin, p.e. using putty

Check the python version:
>python3 -V
Python 3.5.1

Install PIP:
>mkdir /volume1/homes/admin/pip
>cd /volume1/homes/admin/pip
>wget https://bootstrap.pypa.io/get-pip.py
>sudo python3 get-pip.py
The scripts pip, pip3 and pip3.5 are installed in '/volume1/@appstore/py3k/usr/local/bin' which is not on PATH.
Successfully installed pip-20.1.1
>rm /volume1/homes/admin/pip -r

Install paho:
>sudo /volume1/@appstore/py3k/usr/local/bin/pip3 install paho-mqtt
Successfully installed paho-mqtt-1.5.0

Install mysql-connector:
>sudo /volume1/@appstore/py3k/usr/local/bin/pip3 install mysql-connector-python
Successfully installed mysql-connector-python-8.0.20 protobuf-3.11.3 six-1.15.0

You can schedule the python script as Task:
General, Task: Python MQTT Logger
General, User: root
Task Settings, Send run details my email: <you@domain>
Task Settings, User-defined script:
/volume1/@appstore/py3k/usr/local/bin/python3 /volume1/homes/admin/mqtt_logger.py