InfluxDB is an open source time series database built by InfluxData and used in e.g. Openhab for data persistance.
For small computers like raspi’s it is a best practice to compress the database regurlarly.<\/p>\n\n\n\n
Why not using cron ?<\/p>\n\n\n\n
Well, it works.. the only (security)-drawback is to grant \/bin\/bash to the influx-user:<\/p>\n\n\n\n
cat \/etc\/cron.daily\/00influx:<\/p>\n\n\n\n
#!\/bin\/bash\n#execute\n\/home\/pi\/1_influxrepair.sh<\/code><\/pre>\n\n\n\n
cat \/home\/pi\/1_influxrepair.sh:<\/p>\n\n\n\n
#!\/bin\/bash\nservice influxdb stop\necho \"before su\"\nsu influxdb -c \/home\/pi\/1_subscript.sh\necho \"after su\"\nwhoami\nservice influxdb start\n<\/code><\/pre>\n\n\n\ncat \/home\/pi\/1_subscript.sh:<\/p>\n\n\n\n
#!\/bin\/bash\necho \"now in sub shell\"\nwhoami\ncd \/var\/lib\/influxdb\ninflux_inspect buildtsi -compact-series-file -datadir .\/data -waldir .\/wal\nexit\necho \"exiting sub shell\"<\/code><\/pre>\n\n\n\ncat \/etc\/passwd|grep infl:<\/p>\n\n\n
modify influxdb:\/bin\/bash<\/p>\n\n\n\n
<\/p>\n\n\n\n
done!<\/p>\n","protected":false},"excerpt":{"rendered":"