Orga, Bürokraten, Administratoren
792
Bearbeitungen
Seth0r (Diskussion | Beiträge) (influx queries) |
Seth0r (Diskussion | Beiträge) (crontab dokumentiert) |
||
Zeile 181: | Zeile 181: | ||
WHERE time > now() - 3h AND time < now() - 1h | WHERE time > now() - 3h AND time < now() - 1h | ||
GROUP BY time(1m), localIP, remoteIP, remoteHostname, hostname fill(none) | GROUP BY time(1m), localIP, remoteIP, remoteHostname, hostname fill(none) | ||
</pre> | |||
===Crontab=== | |||
Alles, was in der Crontab mit dem Parsen zu tun hat: | |||
<pre> | |||
# parsing | |||
# 0,5,10,... | |||
*/5 * * * * www-data /var/www/monitor.freifunk-potsdam.de/wsgi/ff/parseff1.py /var/ffdata/ >> /var/ffdata/ffdata.log | |||
# 4,9,14,... | |||
4-59/5 * * * * www-data /var/www/monitor.freifunk-potsdam.de/wsgi/ff/parseff2.py | |||
59 * * * * root cat /var/ffdata/ffdata.log && rm /var/ffdata/ffdata.log | |||
1 3 * * * www-data find /var/ffdata/mv/ -type f -ctime +1 -delete | |||
11 3 * * * root /root/backup.sh | |||
*/15 * * * * www-data /var/www/monitor.freifunk-potsdam.de/wsgi/ff/lperf.py | |||
8 * * * * www-data /var/www/monitor.freifunk-potsdam.de/wsgi/ff/routes.py > /dev/null | |||
#* * * * * www-data /var/www/monitor.freifunk-potsdam.de/wsgi/ff/sendmsg.py | |||
* * * * * www-data /var/www/monitor.freifunk-potsdam.de/wsgi/ff/sendtweet.py routermsg | |||
0 8 * * * www-data /var/www/monitor.freifunk-potsdam.de/wsgi/ff/sendtweet.py netstate | |||
#58 * * * * root cat /var/ffdata/tweets.log && rm /var/ffdata/tweets.log | |||
# Influx stuff | |||
3 * * * * root /root/influxdb_cq.sh hour > /dev/null 2>&1 | |||
13 1 * * * root /root/influxdb_cq.sh day > /dev/null 2>&1 | |||
27 4 7 * * freifunk /home/freifunk/influxdump.sh | |||
</pre> | </pre> |