Problem writing data with OH2 + GRAFANA + INFLUXDB in WIN10


(Marco Galvan) #1

Goodmorning everyone. I need help. I do not sleep at night anymore … :slight_smile: I have OH2 with persistence Influxdb and Grafana. Nothing works. The DB is not written and I also receive an error from Grafana. Ah, everything is on windows …
My file influxdb.cfg is this:

# The database URL, e.g. http://127.0.0.1:8086 or https://127.0.0.1:8084 .

url=http://127.0.0.1:8086
# The name of the database user, e.g. openhab.

# Defaults to: openhab

user=merk
# The password of the database user.

password=merk
# The name of the database, e.g. openhab.

# Defaults to: openhab

db=MarcoOpenhab
retentionPolicy=autogen
My file influxdb.persist is this:
Strategies {
    everyMinute : "0 * * * * ?"
    everyHour   : "0 0 * * * ?"
    everyDay    : "0 0 0 * * ?"
}

Items {
    TemperaturaOra_12715* : strategy = everyChange
}

The declaration of this item in file myhome.items is most simple as possible:

Number   TemperaturaOra_12715		"12715 Temperatura Corrente"

Grafana reply :" InfluxDB Error: error parsing query: found ON, expected identifier at line 1, char 25 "

Openhab log is:

2018-11-10 11:51:10.807 [INFO ] [.internal.GenericScriptEngineFactory] - Activated scripting support for ECMAScript
2018-11-10 11:51:10.893 [INFO ] [rt.modbus.internal.ModbusManagerImpl] - Modbus manager activated
2018-11-10 11:51:11.308 [INFO ] [panel.internal.HABPanelDashboardTile] - Started HABPanel at /habpanel
2018-11-10 11:51:11.335 [INFO ] [ebuilder.internal.HomeBuilderServlet] - Started Home Builder at /homebuilder
2018-11-10 11:51:11.840 [INFO ] [.core.internal.i18n.I18nProviderImpl] - Time zone set to ‘Europe/Rome’.
2018-11-10 11:51:11.842 [INFO ] [.core.internal.i18n.I18nProviderImpl] - Location set to ‘45.762333299999995,11.690976’.
2018-11-10 11:51:11.845 [INFO ] [.core.internal.i18n.I18nProviderImpl] - Locale set to ‘it_IT’.
2018-11-10 11:51:12.687 [INFO ] [io.openhabcloud.internal.CloudClient] - Connected to the openHAB Cloud service (UUID = 94a67c39-2a80-4da9-8ac5-7da3a422094c, base URL = http://localhost:8080)
2018-11-10 11:51:14.801 [INFO ] [el.core.internal.ModelRepositoryImpl] - Validation issues found in configuration model ‘casa.items’, using it anyway:
Duplicate ModelItem ‘FF_Garage’
Duplicate ModelItem ‘FF_Garage’
2018-11-10 11:51:14.806 [INFO ] [el.core.internal.ModelRepositoryImpl] - Loading model ‘casa.items’
2018-11-10 11:51:15.042 [INFO ] [el.core.internal.ModelRepositoryImpl] - Loading model ‘influxdb.persist’
2018-11-10 11:51:15.691 [INFO ] [thome.model.lsp.internal.ModelServer] - Started Language Server Protocol (LSP) service on port 5007
2018-11-10 11:51:16.539 [INFO ] [el.core.internal.ModelRepositoryImpl] - Validation issues found in configuration model ‘ModbusConversion.rules’, using it anyway:
The use of wildcard imports is deprecated.
The use of wildcard imports is deprecated.
The use of wildcard imports is deprecated.
The import ‘java.lang.String’ is never used.
2018-11-10 11:51:16.542 [INFO ] [el.core.internal.ModelRepositoryImpl] - Loading model ‘ModbusConversion.rules’
2018-11-10 11:51:19.643 [INFO ] [el.core.internal.ModelRepositoryImpl] - Validation issues found in configuration model ‘OHSchedulerHVAC.rules’, using it anyway:
The value of the local variable timeNow is not used
2018-11-10 11:51:19.645 [INFO ] [el.core.internal.ModelRepositoryImpl] - Loading model ‘OHSchedulerHVAC.rules’
2018-11-10 11:51:19.835 [INFO ] [el.core.internal.ModelRepositoryImpl] - Loading model ‘default.sitemap’
2018-11-10 11:51:20.051 [INFO ] [g.discovery.internal.PersistentInbox] - Added new thing ‘harmonyhub:hub:Hub’ to inbox.
2018-11-10 11:51:20.245 [WARN ] [lipse.smarthome.io.net.exec.ExecUtil] - Execution failed (Exit value: -559038737. Caused by java.io.IOException: Cannot run program “arping” (in directory “.”): CreateProcess error=2, Impossibile trovare il file specificato)
2018-11-10 11:51:20.252 [INFO ] [ternal.dhcp.DHCPPacketListenerServer] - DHCP request packet listener online
2018-11-10 11:51:20.819 [INFO ] [.handler.FlashBriefingProfileHandler] - FlashBriefingProfileHandler initialized
2018-11-10 11:51:21.076 [INFO ] [.dashboard.internal.DashboardService] - Started Dashboard at http://192.127.0.70:8080
2018-11-10 11:51:21.084 [INFO ] [.dashboard.internal.DashboardService] - Started Dashboard at https://192.127.0.70:8443
2018-11-10 11:51:21.453 [INFO ] [arthome.ui.paper.internal.PaperUIApp] - Started Paper UI at /paperui
2018-11-10 11:51:21.937 [INFO ] [g.discovery.internal.PersistentInbox] - Added new thing ‘openweathermap:hourly-forecast:api:local’ to inbox.
2018-11-10 11:51:21.960 [INFO ] [ui.habmin.internal.servlet.HABminApp] - Started HABmin servlet at /habmin

Thank’s at everyone


(Vincent Regaud) #3

First: Please use the codes fences
Second: Read the docs

Strategies {
everyMinute : “0 * * * * ?”
everyHour : “0 0 * * * ?”
everyDay : “0 0 0 * * ?”
}

Items {
TemperaturaOra_12715 : strategy = everyChange
}

(Marco Galvan) #4

I apologize for the codes fences. I hope it’s right now. I’m a beginners in this too.