Hi,
I’m having trouble getting my iotawatt to log to influxdb. There seems to be an error with the query, but I can’t figure out what it is or why it is happening. Looking at termshark, I see the error as:
invalid character 'd' looking for beginning of value
The query from iotawatt is:
db=iotawatt&epoch=s&q=SELECT LAST(Watts) FROM IotaWatt
My influxdb version is 1.8.10
Here are the relevent settings from my iotawatt
Here are my logs since the last restart
SD initialized.
3/23/23 16:20:51z Real Time Clock is running. Unix time 1679588451
3/23/23 16:20:51z Reset reason: Software/System restart
3/23/23 16:20:51z Trace: 1:2[2], 9:0[2], 9:0, 9:1, 8:4, 8:6, 8:8, 9:3, 9:5, 9:9, 1:3, 1:3, 1:3, 1:3, 1:3, 1:3, 1:3, 1:3, 1:1[2], 1:2[3], 9:0[3], 9:0, 9:1, 8:4, 8:6, 8:8, 9:3, 9:5, 9:9, 1:3, 10:2, 10:3
3/23/23 16:20:51z ESP8266 ID: 15844538, RTC PCF8523 (68)
3/23/23 16:20:51z IoTaWatt 5.0, Firmware version 02_08_02
3/23/23 16:20:51z SPIFFS mounted.
3/23/23 12:20:51 Local time zone: -5:00, using DST/BST when in effect.
3/23/23 12:20:51 device name: IotaWatt
3/23/23 12:20:51 HTTP server started
3/23/23 12:20:51 influxDB_v1: Starting, interval:5, url:http://192.168.0.50:8086/api/v2
3/23/23 12:20:51 timeSync: service started.
3/23/23 12:20:51 statService: started.
3/23/23 12:20:51 dataLog: service started.
3/23/23 12:20:51 dataLog: Last log entry 03/23/23 12:20:45
3/23/23 12:20:55 WiFi connected. SSID=tmktmk, IP=192.168.0.103, channel=2, RSSI -44db
3/23/23 12:20:55 Updater: service started. Auto-update class is MINOR
3/23/23 12:20:56 historyLog: service started.
3/23/23 12:20:56 historyLog: Last log entry 03/23/23 12:20:00
3/23/23 12:20:56 Grid: Started
3/23/23 12:20:56 Grid: Last log entry 03/23/23 12:20:45
3/23/23 12:20:57 Updater: Auto-update is current for class MINOR.
3/23/23 12:30:48 influxDB_v1: stopped, Last post 02/06/06 01:28:16
3/23/23 12:52:01 influxDB_v1: stopped, Last post 02/06/06 01:28:16
3/23/23 12:53:06 influxDB_v1: Start posting at 03/23/23 12:53:10
3/23/23 12:55:46 influxDB_v1: stopped, Last post 03/23/23 12:53:05
3/23/23 13:08:09 influxDB_v1: stopped, Last post 02/06/06 01:28:16
3/23/23 13:20:34 influxDB_v1: stopped, Last post 02/06/06 01:28:16
Any help that anyone could provide would be very much appreciated. Thank you!