Unable to post to InfluxDB - Resolved

Support
1

I am not able to post to InfluxDB. I keep getting message such as this…

** Restart **

SD initialized.
1/02/20 22:01:39z Real Time Clock is running. Unix time 1578002499
1/02/20 22:01:39z Reset reason: Exception
1/02/20 22:01:39z Trace: 15:3, 15:0[6], 15:2[6], 15:3, 15:0[6], 15:2[6], 15:3, 15:0[6], 15:2[6], 15:3, 15:0[6], 15:2[6], 15:3, 15:0[6], 15:2[6], 15:3, 15:0[6], 15:2[6], 15:3, 15:0[6], 15:2[6], 15:3, 15:0[6], 15:2[6], 15:3, 15:0[6], 15:2[6], 15:3, 15:0[6], 15:2[6], 15:3, 15:0[6]
1/02/20 22:01:39z ESP8266 ChipID: 2518186
1/02/20 22:01:39z IoTaWatt 5.0, Firmware version 02_05_02
1/02/20 22:01:39z SPIFFS mounted.
1/02/20 16:01:40 Local time zone: -6:00
1/02/20 16:01:40 Using Daylight Saving Time (BST) when in effect.
1/02/20 16:01:40 device name: IotaWatt
1/02/20 16:01:40 MDNS responder started for hostname IotaWatt
1/02/20 16:01:40 LLMNR responder started for hostname IotaWatt
1/02/20 16:01:40 HTTP server started
1/02/20 16:01:40 timeSync: service started.
1/02/20 16:01:40 statService: started.
1/02/20 16:01:40 dataLog: service started.
1/02/20 16:01:40 dataLog: Last log entry 01/02/20 16:01:35
1/02/20 16:01:41 WiFi connected. SSID=ATT8P9qck9, IP=192.168.1.71, channel=1, RSSI -57db
1/02/20 16:01:41 Updater: service started. Auto-update class is MINOR
1/02/20 16:01:43 Updater: Auto-update is current for class MINOR.
1/02/20 16:01:45 influxDB: started, url=localhost:8086, db=jenziotawatt, interval=10
1/02/20 16:02:40 historyLog: service started.
1/02/20 16:02:40 historyLog: Last log entry 01/02/20 16:01:00
1/02/20 16:08:45 influxDB: last entry query failed: -4, retrying.
1/02/20 16:27:33 influxDB: Restart. Last post 12/31/19 00:00:00
1/02/20 16:27:33 influxDB: started, url=localhost:8086, db=jenziotawatt, interval=10
1/02/20 16:34:33 influxDB: last entry query failed: -4, retrying.
1/02/20 16:40:38 influxDB: Restart. Last post 12/31/19 00:00:00
1/02/20 16:40:38 influxDB: started, url=localhost:8086, db=jenziotawatt, interval=10
1/02/20 16:44:18 influxDB: Restart. Last post 12/31/19 00:00:00
1/02/20 16:44:18 influxDB: started, url=localhost:8086, db=jenziotawatt, interval=10
1/02/20 16:51:17 influxDB: last entry query failed: -4, retrying.
1/02/20 16:58:06 influxDB: Restart. Last post 01/02/20 00:00:00
1/02/20 16:58:06 influxDB: started, url=localhost:8086, db=jenziotawatt, interval=10
1/02/20 17:05:05 influxDB: last entry query failed: -4, retrying.

I tried changing the date from 12/31/19 to 1/2/20 since I really didn’t get it up and running until today, but still have the same issue. Sometimes Iotawatt seems to timeout when trying to access it and it has also had several restarts, not by me. It is a new install and I just got it to autoupdate the firmware yesterday.

2

You need to use the IP address of your influx server, not localhost.

3

I changed it to the ip address, but now I get this error:
1/02/20 17:41:39 influxDB: started, url=192.168.1.80:8086, db=jenziotawatt, interval=10
1/02/20 17:41:39 influxDB: last entry query failed 200 database not found: jenziotawatt
1/02/20 17:41:39 influxDB: Stopped. Last post 01/02/20 00:00:00
1/02/20 17:42:34 historyLog: service started.
1/02/20 17:42:34 historyLog: Last log entry 01/02/20 17:41:00
1/02/20 17:44:29 influxDB: started, url=192.168.1.80:8086, db=jenziotawatt, interval=10
1/02/20 17:44:29 influxDB: last entry query failed 200 database not found: jenziotawatt
1/02/20 17:44:29 influxDB: Stopped. Last post 01/02/20 00:00:100:

4

Can you convince me that the database does indeed exist?

5

Okay, for some reason I had the db created, then when I changed from local to ip address it appears to have disappeared. I re-created the db and now its working!! Thanks.

1 Like