Influxdb 0.10.1 with openhab 1.8.1

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 :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 :slightly_smiling:

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