ncd-mqtt.service

Run from systemd for startup, timestamps and logging

diff --git a/mqtt-pgsql.sh b/mqtt-pgsql.sh
index 2f8c2e8..1d66f99 100755 (executable)
--- a/mqtt-pgsql.sh
+++ b/mqtt-pgsql.sh
@@ -1,8 +1,10 @@
 #!/bin/sh -e
 
+cd /home/dpavlin/eg5120
+
 mosquitto_sub -h localhost -t eg5120 | while read json ; do
        date=$( date +%Y-%m-%dT%H:%M:%S )
-       echo -n $date ' '
+       #echo -n $date ' '
        echo $json | tee data/$date.json | tee /dev/shm/last-eg5120.json
        psql --quiet -c "copy eg5120 (json) from '/dev/shm/last-eg5120.json'" eg5120
 done

diff --git a/systemd/ncd-mqtt.service b/systemd/ncd-mqtt.service
new file mode 100644 (file)
index 0000000..237d027
--- /dev/null
+++ b/systemd/ncd-mqtt.service
@@ -0,0 +1,12 @@
+[Unit]
+Description=NCD MQTT
+
+[Service]
+User=dpavlin
+WorkingDirectory=/home/dpavlin
+ExecStart=/home/dpavlin/eg5120/mqtt-pgsql.sh
+Restart=always
+RestartSec=1s
+
+[Install]
+WantedBy=multi-user.target