HI
i am using ioBroker with the influxab.adapter which exports data to my influxdb wich works fine.
Now i found out, that i cant make the charts i want in grafana, because i cant group by month and year.
Then i saw a Thread where someone mentioned that i should use telegraph with the “Date Processor” which i tried, but it failed.
i am Using influxdb 1.8.3 and Telegraf 1.17.0
i hope you can help me.
following my logs.
my config:
[agent] interval = "10s" round_interval = true metric_batch_size = 1000 metric_buffer_limit = 10000 collection_jitter = "0s" flush_interval = "10s" flush_jitter = "0s" precision = "" debug = true [[inputs.influxdb_listener]] service_address = "localhost:8186" read_timeout = "10s" write_timeout = "10s" max_body_size = "32MiB" [[processors.date]] tag_key = "year" date_format = "2006" timezone = "CET" [[processors.date]] tag_key = "month" date_format = "Jan" timezone = "CET" [[outputs.influxdb]] urls = ["http://127.0.0.1:8086"] database = "iobroker" skip_database_creation = true username = "username" password = "password"
output of telegraf -config telegraf.conf -test
2020-12-26T01:05:36Z I! Starting Telegraf 1.17.0
2020-12-26T01:05:36Z D! [agent] Initializing plugins
2020-12-26T01:05:36Z D! [agent] Starting service inputs
2020-12-26T01:05:36Z I! [inputs.influxdb_listener] Started HTTP listener service on localhost:8186
swap,host=iobroker,month=Dec,year=2020 free=8190947328i,total=8589930496i,used=398983168i,used_percent=4.644777605427554 1608944736000000000
swap,host=iobroker,month=Dec,year=2020 in=2680049664i,out=4602818560i 1608944736000000000
processes,host=iobroker,month=Dec,year=2020 blocked=0i,dead=0i,idle=0i,paging=0i,running=0i,sleeping=55i,stopped=0i,total=55i,total_threads=265i,unknown=0i,zombies=0i 1608944736000000000
mem,host=iobroker,month=Dec,year=2020 active=1938755584i,available=2006478848i,available_percent=47.83818359375,buffered=0i,cached=1413754880i,commit_limit=76129976320i,committed_as=29012176896i,dirty=6893568i,free=592723968i,high_free=0i,high_total=0i,huge_page_size=2097152i,huge_pages_free=0i,huge_pages_total=0i,inactive=1517293568i,low_free=0i,low_total=0i,mapped=375496704i,page_tables=87527424i,shared=380928i,slab=0i,sreclaimable=0i,sunreclaim=0i,swap_cached=0i,swap_free=536870912i,swap_total=536870912i,total=4194304000i,used=2187825152i,used_percent=52.16181640625,vmalloc_chunk=0i,vmalloc_total=35184372087808i,vmalloc_used=4647317504i,write_back=0i,write_back_tmp=0i 1608944736000000000
kernel,host=iobroker,month=Dec,year=2020 boot_time=1608217612i,context_switches=9043748709i,entropy_avail=3820i,interrupts=5767817043i,processes_forked=22897177i 1608944736000000000
2020-12-26T01:05:36Z D! [agent] Stopping service inputs
system,host=iobroker,month=Dec,year=2020 load1=1.12,load15=0.89,load5=0.83,n_cpus=1i,n_users=2i 1608944736000000000
system,host=iobroker,month=Dec,year=2020 uptime=727125i 1608944736000000000
system,host=iobroker,month=Dec,year=2020 uptime_format="8 days, 9:58" 1608944736000000000
2020-12-26T01:05:36Z D! [agent] Input channel closed
2020-12-26T01:05:36Z D! [agent] Processor channel closed
2020-12-26T01:05:36Z D! [agent] Processor channel closed
2020-12-26T01:05:36Z D! [agent] Stopped Successfully`
running “telegraf --config telegraf.conf” shows
2020-12-26T01:29:48Z I! Starting Telegraf 1.17.0 2020-12-26T01:29:48Z I! Loaded inputs: influxdb_listener 2020-12-26T01:29:48Z I! Loaded aggregators: 2020-12-26T01:29:48Z I! Loaded processors: date (2x) 2020-12-26T01:29:48Z I! Loaded outputs: influxdb 2020-12-26T01:29:48Z I! Tags enabled: host=iobroker 2020-12-26T01:29:48Z I! [agent] Config: Interval:10s, Quiet:false, Hostname:"iobroker", Flush Interval:10s 2020-12-26T01:29:48Z D! [agent] Initializing plugins 2020-12-26T01:29:48Z D! [agent] Connecting outputs 2020-12-26T01:29:48Z D! [agent] Attempting connection to [outputs.influxdb] 2020-12-26T01:29:48Z D! [agent] Successfully connected to outputs.influxdb 2020-12-26T01:29:48Z D! [agent] Starting service inputs 2020-12-26T01:29:48Z I! [inputs.influxdb_listener] Started HTTP listener service on localhost:8186 2020-12-26T01:29:58Z D! [outputs.influxdb] Buffer fullness: 0 / 10000 metrics 2020-12-26T01:30:08Z D! [outputs.influxdb] Buffer fullness: 0 / 10000 metrics
journalctl -f
Dec 26 02:29:22 iobroker chronograf[31491]: time="2020-12-26T02:29:22+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="*****" response_time="34.615µs" status=200
Dec 26 02:29:34 iobroker chronograf[31491]: time="2020-12-26T02:29:34+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="*****" response_time="31.389µs" status=200
iobroker log shows
influxdb.0 2020-12-26 02:31:45.004 error (5768) Error: bad response from server influxdb.0 2020-12-26 02:31:44.995 info (5768) Connecting http://localhost:8186
if i run it without telegraf, journalctl shows
Dec 26 02:32:59 iobroker influxd[206]: [httpd] 127.0.0.1 - admin [26/Dec/2020:02:32:59 +0100] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 4975f51c-471a-11eb-a9bc-e2a1554d4b0b 1521 Dec 26 02:33:02 iobroker influxd[206]: [httpd] 127.0.0.1 - admin [26/Dec/2020:02:33:02 +0100] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 204 0 "-" "-" 4b53fea1-471a-11eb-a9bd-e2a1554d4b0b 1124