Hi
Has anyone managed to get openhab 1.8.1 persistence influxdb 1.8.1 to work with influxdb 0.10.1.
I can get openhab to connect to the database and write measurements but no tag keys or tag values.
Cheers
Tony
Hi
Has anyone managed to get openhab 1.8.1 persistence influxdb 1.8.1 to work with influxdb 0.10.1.
I can get openhab to connect to the database and write measurements but no tag keys or tag values.
Cheers
Tony
As I tripped over this a few days ago, openHAB does not set any tags (even in influxdb 0.9.x) but stores the data and you can query the data with SELECT * FROM ‘itemname’; I didn’t set up grafana yet, but I think grafana will work that way.
EDIT: tested with grafana 2.6.0 and influxdb 0.9.6 -> works as expected. I will test the current influxdb version later, now time for a cup of coffee
What is the best way to set this up under armhf? I tried a few tutorials but those are often not working…
for influxdb and grafana you should use the official instructions to install the software - https://influxdata.com/ and http://grafana.org/ - for Influx, the latest stable version would be https://s3.amazonaws.com/influxdb/influxdb_0.10.1-1_arm.deb (simply download and dpkg -i for debian-like distro)
for Grafana (I did not test this as I use amd64) there is a installscript, which seems to fit for Raspbian: curl -s https://packagecloud.io/install/repositories/grafana/stable/script.deb.sh | sudo bash
should do the trick.
Bear in mind, that grafana will install it’s own webserver, listening at port 3000 as default.
I tried the following command SELECT * FROM ‘itemname’; and no data was shown. Is there anyway of seeing what openhab is writing is writing?
SHOW MEASUREMENTS is the command to see the list of persisted Data
When I do the show measurements command I can see the list below, but no data within any of them.
cpu_temp
router_total_memory
router_used_memory
Here are the logs from openhab with influxdb trace level logging
2016-03-02 11:17:29.035 [TRACE] [i.i.InfluxDBPersistenceService] - Tried to get item from item class class org.openhab.core.library.items.NumberItem, state is 16240
2016-03-02 11:17:29.036 [TRACE] [i.i.InfluxDBPersistenceService] - found no fractional part
2016-03-02 11:17:29.036 [DEBUG] [i.i.InfluxDBPersistenceService] - got DecimalType value 16240
2016-03-02 11:17:29.038 [TRACE] [i.i.InfluxDBPersistenceService] - storing router_used_memory in influxdb value 16240, router_used_memory (Type=NumberItem, State=16240)
Anyone know why it is not storing the value in influxdb? @Udo_Hartmann
Openhab can connect to influx and has added the measurements but there is no data within the measurements.
Here is my config
** openhab.cfg**
############################ InfluxDB Persistence Service #############################
influxdb:url=http://127.0.0.1:8086
influxdb:user=openhab
influxdb:password=**************
influxdb:db=openhab
influxdb.persist
Strategies {
default = everyUpdate
}
Items {
PersistentChart* : strategy = default, restoreOnStartup
}
snmp.items
Group PersistentChart
Number cpu_temp “Temperature [%s °C]” (PersistentChart) {snmp="<[127.0.0.1:public:.1.3.6.1.4.1.2021.13.16.2.1.3.1:100000]"}
/* router */
String router_name “Name [%s]” {snmp="<[192.168.20.1:public:.1.3.6.1.2.1.1.1.0:1000000000]"}
String router_uptime “Uptime [%s]” {snmp="<[192.168.20.1:public:.1.3.6.1.2.1.25.1.1.0:10000000]"}
Group router_memory
Number router_total_memory “Memory [%s]” (router_memory, PersistentChart) {snmp="<[192.168.20.1:public:.1.3.6.1.2.1.25.2.3.1.5.101:100000]"}
Number router_used_memory “Memory Used [%s]” (router_memory, PersistentChart) {snmp="<[192.168.20.1:public:.1.3.6.1.2.1.25.2.3.1.6.101:100000]"}
I experience the same with OpenHAB 1.8.3 using InfluxDB 1.0
It gives me 500 responses:
[httpd] 192.168.2.57 - openhab [05/Nov/2016:06:33:05 +0000] "POST /write?consistency=one&db=openhab&p=%5BREDACTED%5D&precision=n&rp=default&u=openhab HTTP/1.1" 500 72 "-" "okhttp/2.4.0" b59e4d1e-a321-11e6-8029-000000000000 1966