Nutzer anlegen

CREATE USER lemoer WITH PASSWORD '...';
GRANT ALL ON "database" TO lemoer;

DB anlegen

CREATE DATABASE dbname;

Passwort ändern

SET PASSWORD FOR perftest  = '...'

Daten erstellen via curl

curl -i -XPOST 'http://stats.ffh.zone:8086/write?db=$DB' -u "$USER:PASSWORD" --data-binary "speedtest,host=perf-test,dest=sn10 mbps=56.0 $(date +%s)00000000"

Beta Router

select "firmware_release", "model", "hostname", "owner", "nodeid" from (select "owner", last("load"), "model", "nodeid", "hostname", "firmware_release" from node where "autoupdater"='beta' and time > now() - 1h group by "nodeid" order by time desc) order by time desc;