"ut" rule error

Setup, Configuration and Use Scripts & Rules
1

Hello,
I’m using influxdb for persistence. Ever since I started using influxdb which is a few months ago I’ve had the following entries in the log:

[ERROR] [ntime.internal.engine.ExecuteRuleJob] - Error during the execution of rule 'ut': {"error":"error authorizing query: openhab not authorized to execute statement 'SELECT value FROM autogen.Weather_Temperature WHERE time \u003e 17551d LIMIT 2147483647', requires READ on openhab"}

The ‘ut’ rule is basically the default rule which works out the minimum and maximum temperatures for the day. The rule itself is below

rule “ut”
when
Item Weather_Temperature changed or
Time cron “0 0 0 * * ?” or
System started
then
postUpdate(Weather_Temp_Max, Weather_Temperature.maximumSince(now.withTimeAtStartOfDay).state)
postUpdate(Weather_Temp_Min, Weather_Temperature.minimumSince(now.withTimeAtStartOfDay).state)
end

How can I fix this?

2

I think your Openhab User has not the right Permissions on influxDB …

influx -execute 'CREATE DATABASE openhab2_db'
influx -execute "CREATE USER dadmin WITH PASSWORD '<PASSWORD>' WITH ALL PRIVILEGES"
influx -execute "CREATE USER openhab2 WITH PASSWORD '<PASSWORD>'"
influx -execute 'GRANT ALL ON openhab2_db TO openhab2'

This are the Commands you need to config a influxDB for Openhab. I think the last Command will fix your Problems … (if you fill it out with your Data :wink: )