InfluxDB+Grafana persistence and graphing

Tutorials & Examples
, ,
488

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

Like:

SELECT * FROM Garden_Driveway_MotionSensorLux_MotionSTatus
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?

490

That sould do the trick

See:

DROP MEASUREMENT Garden_Driveway_MotionSensorLux_MotionStatus
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?

492

Try

DROP SERIES Garden_Driveway_MotionSensorLux_MotionStatus
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

494

Maybe

DROP SERIES FROM Garden_Driveway_MotionSensorLux_MotionStatus

?

495

Have you tried to restart the graphan, the computer?

496

Try:

DROP SERIES FROM "Garden_Driveway_MotionSensorLux_MotionStatus"

Notice the quotes!!

497

Brilliant! This works!

498

Finally :slight_smile:

499

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

500

Haha yes -sorry :wink:

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.

502

I would restart influx AND openHAB
Reboot time?

503

Hi Vincent,
Did reboot it - still no luck.

504

Fixed!

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


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;
  }

Screenshot_20180504-172904_openHAB
Screenshot_20180504-172904_openHAB.jpg1440×2960 370 KB

greetings Daniel

507

Can be delete if found my error.