Dashboard is complete with most of what I wanted top track with my two hubs:
HI Denny,
I have the same issue(Post of 1 events failed - elapsed time 0.434 seconds - Status: 422, Error: Unprocessable Entity). Latest HPM version of your app (2023-03-18) This is the offending entry:
battery,deviceName=UPS\ Monitor,deviceId=209,hubName=Hubitat-C8,unit=null value="unknown" 1682274188131000000, voltage,deviceName=UPS\ Monitor,deviceId=209,hubName=Hubitat-C8,unit=null value="unknown" 1682274188158000000
Is there a method to clear this, without loosing the queued data?
Update: As it was only two entries I did a replaceAll in the data prior to posting it to the DB. Cleared the issue for now.
Cheers Rene
That's actually two entries. 
The method to get rid of poison data is as described in the link above: Set both the "Batch size limit" and "Backlog size limit" to 1, and let the queue process until empty. Good data will be successfully posted, and bad data will be discarded.
The core issue is that the driver is using a string as the battery and voltage when the values are unknown. I'm guessing that the driver in question is actually mine?
1 Like
Hi Denny,
Aha, ok, I only changed the Batch Size. I'll try next time this happens.
And yes, the NUT upsmon driver is yours too. Only noticed now
Cheers Rene
Yea... sorry about that. Putting 'unknown' in for a numeric field was a silly mistake on my part. I will update the NUT driver shortly to use zero for unknown numerical values rather than a string.
I've pushed the NUT driver update, as well as an update to the logger to suppress null units being sent to InfluxDB.
1 Like
Hi. I dont have any developer knowledge, So I am king of starting from scratch on this. I am trying to get influxdb working with my hubitat hub and I get this error message. "Post of 50 events failed - elapsed time 0.094 seconds - Status: 408, Error: Illegal character in authority at index 7: http://http:\192.168.27.137:8086/write?db=Hubitat, Headers: null, Data: null"
I am not sure what I am supposed to set the host to in the configuration, but i used the ip address for the computer with influxdb. I also have it set to used user/password instead of token, and It is a windows version 2.xx which i also have it selected in the influx app configuration.
I also have a second question. I dont see any settings on influx dashboard regarding storage. To use an external drive as storage for the DB do i just need to install Influxdb in it and run it from there? Also when ran from c:/programs files/influxdbxx/xx where in my computer is this data stored once it starts logging?
thanks in advance for the help and your time and effort spent helping the hubitat community.
At a minimum, it appears you have a backslash that should not be there. Please post a screenshot of the Connection Properties page for the InfluxDB-Logger app.
1 Like
You were right. I had bakcslashes instead for forwardslash. this is the ne error " Post of 50 events failed - elapsed time 0.103 seconds - Status: 408, Error: Illegal character in query at index 70: http://http://192.168.27.137:8086/api/v2/write?org=Home&bucket=Hubitat Logs, Headers: null, Data: null"
and aI am including a snapshot of my configuration
If you are running influxdb 2.x you will likely want to use a token instead of userid and password.
Though it is supported in 2.x, it is a deprecated way and requires a few steps to enable.
1 Like
noted. I have changed it to token.
Could try using the org and bucket uuids instead of name strings (not sure about that space in the bucket name…)
1 Like
Check the first page screen - is it formatted correctly? I see redundant http ' s in the front of the string. also - check for a blank at the beginning of string.
I removed the http, and I also figured out the ip address I was using wasn't the correct one.
After correcting that tjis is the new error: "Post of 50 events failed - elapsed time 60.032 seconds - Status: 408, Error: Connect to 192.168.27.113:8086 [/192.168.27.113] failed: connect timed out, Headers: null, Data: null"
I never successfully got user/pass to work, only tokens. I didn't try very hard but token seemed more simple in the end. the nul nul usually means no response/buckets not verified or something like that.
I want to also add - I learned over time to have 2 tokens - one for your grafana and one for your Hub so you can have kiosk windows etc without log in needed.
Either the host is incorrect, the port is incorrect, the InfluxDB server is not running, or there is a firewall suppressing the connection.
1 Like
Did you setup a custom range for your home network. 192.168.27.x isn't very common for home networks. Most routers that use 192.168.x.x will default to 192.168.1.x. Keyword there is most as mine doesn't, but in 25 years i think i worked on maybe 2 that didn't default to that range.
yes. I did set it up to 192.168.27.xxx but i set up everything accordingly. I created a rule on the firewall to open the port, and after trying that I turned off the firewall and still kept having same issue.
I have a raspberri pi runing octoprint, Can I add influxdb to it?
Yes you can Influxdb on a raspberry pi.
Did you create a bucket in influxdb and a token with read/write abilities to that bucket.
