InfluxDB+Grafana persistence and graphing

influxdb
graphs
grafana
Tags: #<Tag:0x00007fd310d2ab00> #<Tag:0x00007fd310d2a9c0> #<Tag:0x00007fd310d2a790>

(Christoph Wempe) #488

You need to replace my_measurement with the name if your item.

Like:

SELECT * FROM Garden_Driveway_MotionSensorLux_MotionSTatus

(Mr. Yoinkz) #489

Yes of course! Sorry about that!

When testing with that command I get this:

name: Garden_Driveway_MotionSensorLux_MotionStatus
time                value
----                -----
1520265600159000000 1
1520269200151000000 0
1520272800114000000 0
1520276400025000000 0
1520280000133000000 0
1520283600118000000 0
1520287200077000000 0
1520290800150000000 0
1520294400045000000 0
1520298000075000000 0
1520301600116000000 0
1520305200097000000 0
1520308800102000000 0
1520312400096000000 0
1520316000137000000 0
1520319600091000000 0
1520323200053000000 0
1520326800125000000 0
1520330400115000000 0
1520334000154000000 0
1520337600083000000 0
1520341200057000000 0
1520344800118000000 0
1520348400127000000 0
1520352000090000000 1
1520355600136000000 0
1520359200106000000 0
1520362800123000000 0
1520366400095000000 0
1520370000061000000 0
1520373600064000000 0

So as we can see, it stopped after I updated my Groups, but the “item” is still present.
What will I have to write then to: DELETE Garden_Driveway_MotionSensorLux_MotionStatus ish?


(Vincent Regaud) #490

That sould do the trick

See:

DROP MEASUREMENT Garden_Driveway_MotionSensorLux_MotionStatus

(Mr. Yoinkz) #491

Yes exactly…
That clears up the measurements, but the ITEM is still present:
image

Isn’t it possible to remove it from the item drop down list somehow?


(Vincent Regaud) #492

Try

DROP SERIES Garden_Driveway_MotionSensorLux_MotionStatus

(Mr. Yoinkz) #493

Then it ends up with this error:

DROP SERIES Garden_Driveway_MotionSensorLux_MotionStatus
ERR: error parsing query: found Garden_Driveway_MotionSensorLux_MotionStatus, expected FROM, WHERE at line 1, char 13


(Udo Hartmann) #494

Maybe

DROP SERIES FROM Garden_Driveway_MotionSensorLux_MotionStatus

?


(Sergey M) #495

Have you tried to restart the graphan, the computer?


(Vincent Regaud) #496

Try:

DROP SERIES FROM "Garden_Driveway_MotionSensorLux_MotionStatus"

Notice the quotes!!


(Mr. Yoinkz) #497

Brilliant! This works!


(Udo Hartmann) #498

Finally :slight_smile:


(Vincent Regaud) #499

The quotes are necessary on influxdb 1.5 but not on previous versions


(Mr. Yoinkz) #500

Haha yes -sorry :wink:


(Mr. Yoinkz) #501

Well, one problem fixed and then a new one arises :smiley:.

I added a few extra Groups to my persistent file, but for some reason it doesn’t seem to be pushed into my openhab_db. When I run the show measurement it does not appear.

Can anyone see any problems with this:

Strategies {
    everyMinute : "0 * * * * ?"
    everyHour   : "0 0 * * * ?"
    everyDay    : "0 0 0 * * ?"
}

Items {
        gLux*                           : strategy = everyChange, everyHour
        gTemp*, gAstroElevation*        : strategy = everyChange, everyHour
        gHum*                           : strategy = everyChange, everyHour, everyMinute
}

The other measurements are still running without any problems, still updating the values in my graphs just fine.

EDIT: Fixed! This happens if you haven’t created a Group gHum or gAstroElevation, even though you add the tag under the item.


(Vincent Regaud) #502

I would restart influx AND openHAB
Reboot time?


(Mr. Yoinkz) #503

Hi Vincent,
Did reboot it - still no luck.


(Mr. Yoinkz) #504

Fixed!


(Apache Indian) #505

Hi,
worth adding that in openhab2 (debian atleast) the html folder is /etc/openhab2/html/. spent sometime getting it right. Now to work on the html files. Great post and fantastic tutorial :smile:

Update
aargh. I just realised you have already thought about it. If i use visual studio with the openhab plugin its already visible…


(Daniel N.) #506

Hello together,

how i can delete the border?

.panel-container iframe {
    border: 0;
    padding: 0;
    background-color: #000000;
    border-color: #000000;
    width: 100%;
    height: 450px;
    overflow: hidden;
    margin: 0;
  }
  
  .panel-container {
    width: 100%;
    height: 100%;
    margin: 0;
    padding: 0;
    border: none;
    border-color: #000000;
    background-color: #000000;
  }


greetings Daniel


(derhelge) #507

Can be delete if found my error.