# InfluxDB+Grafana persistence and graphing

**URL:** <https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761>\
**Category:** Tutorials & Examples\
**Tags:** influxdb, graphs, grafana\
**Created:** [September 1, 2016, 5:56pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761 "2016-09-01T17:56:35Z")\
**Posts on this page:** 20\
**Page:** 41

<div class="post-metadata">

**Author:** ![BrutalBirdie](https://community.openhab.org/user_avatar/community.openhab.org/brutalbirdie/32/47907_2.png) [@BrutalBirdie](https://community.openhab.org/u/BrutalBirdie)\
**Post date:** [October 7, 2019, 3:18pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/815 "2019-10-07T15:18:41Z")

</div>

My knowledge is the following:

- All items can be defined by the \* operator with a strategy
- A Single item can be defined with a strategy
- A Item-list can be defined with a strategy
- A Group\* with all items in that group can be defined with a strategy

I would have to read the docs again to know if things\* can be defined too. (Maybe you should read them as well 😉 )

---

<div class="post-metadata">

**Author:** ![Stbowling](https://community.openhab.org/letter_avatar_proxy/v4/letter/s/65b543/32.png) [@Stbowling](https://community.openhab.org/u/Stbowling)\
**Post date:** [October 7, 2019, 3:22pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/816 "2019-10-07T15:22:37Z")

</div>

I will dive back into the docs.  
The influx docs don’t address OH .persist directly.  
I am willing to put in the time and will keep plodding along.

Again Thank you very much and I hope God The Father shows favor to you and yours

---

<div class="post-metadata">

**Author:** ![Udo\_Hartmann](https://community.openhab.org/user_avatar/community.openhab.org/udo_hartmann/32/70871_2.png) [@Udo\_Hartmann](https://community.openhab.org/u/Udo_Hartmann)\
**Post date:** [October 8, 2019, 5:22pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/817 "2019-10-08T17:22:01Z")

</div>

Please be aware of the following things:

1. The configuration file for InfluxDB Database is `influxdb.cfg`, not `Influxdb.cfg` or `Influxdb.persist`
2. You have to install the influxdb persistence service. This will result in the correct configuration file, mentioned in point 1.
3. The persistence configuration is independent from the persistence itself, therefor there is no need for explanation in [InfluxDB (0.9 and newer) - Persistence Services | openHAB](https://www.openhab.org/addons/persistence/influxdb/). Please take a look at [Persistence | openHAB](https://www.openhab.org/docs/configuration/persistence.html) for this part of configuration.
4. The name of this file must be named `influxdb.persist`, as there is no other link to the persistence service, other than the file name.
5. Obviously, you have to install InfluxDB1.x Database Server to use it. 😉

---

<div class="post-metadata">

**Author:** ![Gad\_Ofir](https://community.openhab.org/user_avatar/community.openhab.org/gad_ofir/32/19861_2.png) [@Gad\_Ofir](https://community.openhab.org/u/Gad_Ofir)\
**Post date:** [October 8, 2019, 6:02pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/818 "2019-10-08T18:02:18Z")

</div>

> [@Udo\_Hartmann](#):
>
> - mentioned in point 1.
> - The persistence configuration is independent from the persistence itself, therefor there is no need for explanation in [InfluxDB (0.9 and newer) - Persistence Services | openHAB](https://www.openhab.org/addons/persistence/influxdb/). Please take a look at

just got all up and working it was some strech but now i have Influx for all my items

what is you opinion for a home with 300+ items that is saving all to influx once an hour and on every change, can this be an issue to system preformance?

its not that i am lazy to tag my items… some of them or created with paper UI and cannot be tagged with group item …(not sure why its like this )  
but if found it useful to have all items show up in Influx\Grafna

just a litle worried with preformance  
but to tell the turth looking at system moniter with Proxmox tools(Web GUI)  
i dont see any spikes when influx is doing the once an hour update for all items  
so i think i am ok

 ![image](https://community-openhab-org.s3.dualstack.eu-central-1.amazonaws.com/original/3X/1/4/143b1852d7345bbf644642b58aabab24b169dd36.png)

---

<div class="post-metadata">

**Author:** ![rlkoshak](https://community.openhab.org/user_avatar/community.openhab.org/rlkoshak/32/75251_2.png) [@rlkoshak](https://community.openhab.org/u/rlkoshak)\
**Post date:** [October 8, 2019, 7:38pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/819 "2019-10-08T19:38:08Z")

</div>

> [@Gad\_Ofir](#):
>
> can this be an issue to system preformance?

Not likely. It could be a lot of needless data though so I would only save those Items for which you actually care about it’s past states.

> [@Gad\_Ofir](#):
>
> its not that i am lazy to tag my items… some of them or created with paper UI and cannot be tagged with group item …(not sure why its like this )

Not true.

 ![image](https://community-openhab-org.s3.dualstack.eu-central-1.amazonaws.com/original/3X/a/e/aea2c117a5fac068cc0ed32a64ad9f24b18dc454.png)

---

<div class="post-metadata">

**Author:** ![Gad\_Ofir](https://community.openhab.org/user_avatar/community.openhab.org/gad_ofir/32/19861_2.png) [@Gad\_Ofir](https://community.openhab.org/u/Gad_Ofir)\
**Post date:** [October 8, 2019, 7:51pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/820 "2019-10-08T19:51:20Z")

</div>

![image](https://community-openhab-org.s3.dualstack.eu-central-1.amazonaws.com/original/3X/d/7/d788515d189c525d2e9b09c692f437d9dd575d92.png)

not sure if you can see but i am not able to change anythiong there  
it is grayed out

maybe its the link mode…  
but at this point i am not going to change it

---

<div class="post-metadata">

**Author:** ![rlkoshak](https://community.openhab.org/user_avatar/community.openhab.org/rlkoshak/32/75251_2.png) [@rlkoshak](https://community.openhab.org/u/rlkoshak)\
**Post date:** [October 8, 2019, 8:59pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/821 "2019-10-08T20:59:07Z")

</div>

You have Simple Mode turned on? If so that’s why. Turn off simple Mode. It’s a terrible option and should never be enabled.

---

<div class="post-metadata">

**Author:** ![Gad\_Ofir](https://community.openhab.org/user_avatar/community.openhab.org/gad_ofir/32/19861_2.png) [@Gad\_Ofir](https://community.openhab.org/u/Gad_Ofir)\
**Post date:** [October 8, 2019, 9:24pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/822 "2019-10-08T21:24:00Z")

</div>

i know now… but i already did my enitre setup with paper UI this way with no clue to what i was doing at that time…  
and it works … so lets keep it that way 🙂

as i said i did \* for all items and i dont see my VM going crazy or even streching for that so i am ok with that for now , but thanks for the heads up, i saw you say it in some other topics and i will not configr my home that way for next time

---

<div class="post-metadata">

**Author:** ![rlkoshak](https://community.openhab.org/user_avatar/community.openhab.org/rlkoshak/32/75251_2.png) [@rlkoshak](https://community.openhab.org/u/rlkoshak)\
**Post date:** [October 9, 2019, 9:47pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/823 "2019-10-09T21:47:56Z")

</div>

For anyone who comes across this, I’ve posted the new way to render png image charts from Grafana as of version 6.4.x.

> [@Grafana Image Renderer](https://community.openhab.org/t/grafana-image-renderer/83350):
>
> We have all had issues with Grafana generating static png charts for some time now. The root cause is PhantomJS. According to the docs on [Grafana’s website](https://grafana.com/docs/administration/image_rendering/#image-rendering): PhantomJS is deprecated since Grafana v6.4 and will be removed in a future release. Please migrate to Grafana image renderer plugin or remote rendering service. For at least a year now rendering the images on an RPi has been unavailable as PhantomJS would run amok and consume all the resources until openHAB itself was killed by the kerne…

---

<div class="post-metadata">

**Author:** ![Woogi](https://community.openhab.org/letter_avatar_proxy/v4/letter/w/dfb087/32.png) [@Woogi](https://community.openhab.org/u/Woogi)\
**Post date:** [October 14, 2019, 7:18pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/824 "2019-10-14T19:18:34Z")

</div>

did you found a solution for your problem? facing the exact same issue. Only read [here](https://github.com/CWempe/rest2influxdb) that there are problems with " \* The timestamps cannot be calculated correctly on macOS".

Not sure whether it is working or not when working with the terminal at a mac…

---

<div class="post-metadata">

**Author:** ![Woogi](https://community.openhab.org/letter_avatar_proxy/v4/letter/w/dfb087/32.png) [@Woogi](https://community.openhab.org/u/Woogi)\
**Post date:** [October 30, 2019, 9:07pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/825 "2019-10-30T21:07:00Z")

</div>

@christoph_wempe any idea how I can fix the issue with the timestamp problem using mac terminal to execute the script?

---

<div class="post-metadata">

**Author:** ![christoph\_wempe](https://community.openhab.org/user_avatar/community.openhab.org/christoph_wempe/32/70848_2.png) [@christoph\_wempe](https://community.openhab.org/u/christoph_wempe)\
**Post date:** [October 30, 2019, 11:35pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/826 "2019-10-30T23:35:33Z")

</div>

Sorry.

I haven’t done anything related to this topic in the last two years and I don’t know if the new openhab version behaving any different than before.  
And I don’t know anything about MacOS.

---

<div class="post-metadata">

**Author:** ![controlc](https://community.openhab.org/letter_avatar_proxy/v4/letter/c/f1d935/32.png) [@controlc](https://community.openhab.org/u/controlc)\
**Post date:** [October 31, 2019, 9:29am UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/827 "2019-10-31T09:29:43Z")

</div>

@Woogi: I don´t use the script but I´ve a mac - please write me the problem including the needed output an I will have a look at it. I can´t promise anything but I will try.

---

<div class="post-metadata">

**Author:** ![Woogi](https://community.openhab.org/letter_avatar_proxy/v4/letter/w/dfb087/32.png) [@Woogi](https://community.openhab.org/u/Woogi)\
**Post date:** [November 1, 2019, 1:50pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/828 "2019-11-01T13:50:10Z")

</div>

Hi @controlc,

thank you.

Problem:  
I run openhabian on a raspberry and access the system by a terminal session from my mac. I wanted to transfer my data from rrd4j to influxDB with the script. e.g. for item Klima\_hum\_wz

```csv
### timestamps
item: Klima_hum_wz
10y: 2009-11-01T14:36:44+01:00
1y: 2018-10-04T15:36:44+02:00
1m: 2019-10-03T15:36:44+02:00
1w: 2019-10-25T15:37:44+02:00
1d: 2019-10-31T14:37:44+01:00
8h: 2019-11-01T06:37:44+01:00
  % Total % Received % Xferd Average Speed Time Time Time Current
                                 Dload Upload Total Spent Left Speed
100 338 100 338 0 0 2624 0 --:--:-- --:--:-- --:--:-- 2640
  % Total % Received % Xferd Average Speed Time Time Time Current
                                 Dload Upload Total Spent Left Speed
100 338 100 338 0 0 14382 0 --:--:-- --:--:-- --:--:-- 14695
  % Total % Received % Xferd Average Speed Time Time Time Current
                                 Dload Upload Total Spent Left Speed
100 338 100 338 0 0 16197 0 --:--:-- --:--:-- --:--:-- 16900
  % Total % Received % Xferd Average Speed Time Time Time Current
                                 Dload Upload Total Spent Left Speed
100 338 100 338 0 0 15557 0 --:--:-- --:--:-- --:--:-- 16095
  % Total % Received % Xferd Average Speed Time Time Time Current
                                 Dload Upload Total Spent Left Speed
100 338 100 338 0 0 14368 0 --:--:-- --:--:-- --:--:-- 14695
  % Total % Received % Xferd Average Speed Time Time Time Current
                                 Dload Upload Total Spent Left Speed
100 338 100 338 0 0 17425 0 --:--:-- --:--:-- --:--:-- 18777

### found values: 0
Warning: Couldn't read data from file "Klima_hum_wz-*", this makes an empty 
Warning: POST.
HTTP/1.1 204 No Content
Content-Type: application/json
Request-Id: a57b457c-fcac-11e9-b4c9-b827eb33e913
X-Influxdb-Build: OSS
X-Influxdb-Version: 1.7.8
X-Request-Id: a57b457c-fcac-11e9-b4c9-b827eb33e913
Date: Fri, 01 Nov 2019 13:36:45 GMT

Sleep for 5 seconds to let InfluxDB process the data...

### delete temporary files

```

So no values that have been transferred.

when browsing to the file [http://IP/rest/persistence/items/Klima\_hum\_wz?serviceId=rrd4j](http://IP/rest/persistence/items/Klima_hum_wz?serviceId=rrd4j) I get a page with all the datapoint, see the extract here:

```csv
{"name":"Klima_hum_wz","datapoints":"360","data":[{"time":1570993680000,"state":"59.325"},
{"time":1570993920000,"state":"60.0"},{"time":1570994160000,"state":"59.95"},
{"time":1570994400000,"state":"59.8"},{"time":1570994640000,"state":"59.8"},
{"time":1570994880000,"state":"59.125"},{"time":1570995120000,"state":"58.9"},
{"time":1570995360000,"state":"58.925"},{"time":1570995600000,"state":"59.0"},
{"time":1570995840000,"state":"59.0"},{"time":1570996080000,"state":"58.925000000000004"},
{"time":1570996320000,"state":"58.9"},{"time":1570996560000,"state":"58.824999999999996"},
{"time":1570996800000,"state":"58.6"},{"time":1570997040000,"state":"58.6"},
{"time":1570997280000,"state":"58.75"},{"time":1570997520000,"state":"58.8"},

```

Why does the script does not take and transfer them? the script I use:

```csv
#!/bin/bash
# This script reads the values of an item from openhab via REST and imports the data to influxdb
# useage: get_item_states.sh <itemname>

itemname="$1"

if [-z $itemname]
then
  echo "Please define Item!"
  exit 0
fi

source /srv/openhab2-conf/services/rest2influx.cfg

# convert historical times to unix timestamps,
tenyearsago=`date +"%Y-%m-%dT%H:%M:%S%:z" --date="10 years ago"`
oneyearago=`date +"%Y-%m-%dT%H:%M:%S%:z" --date="-12 months 28 days ago"`
onemonthago=`date +"%Y-%m-%dT%H:%M:%S%:z" --date="29 days ago"`
oneweekago=`date +"%Y-%m-%dT%H:%M:%S%:z" --date="-6 days -23 hours 59 minutes ago"`
onedayago=`date +"%Y-%m-%dT%H:%M:%S%:z" --date="-23 hours 59 minutes ago"`
eighthoursago=`date +"%Y-%m-%dT%H:%M:%S%:z" --date="-7 hours 59 minutes ago"`

# print timestamps
echo ""
echo "### timestamps"
echo "item: $itemname"
echo "10y: $tenyearsago"
echo "1y: $oneyearago"
echo "1m: $onemonthago"
echo "1w: $oneweekago"
echo "1d: $onedayago"
echo "8h: $eighthoursago"

resturl="http://$openhabserver:$openhabport/rest/persistence/items/$itemname?serviceId=$serviceid"

# get values and write to different files
# curl -X GET --header "Accept: application/json" "$resturl&starttime=${tenyearsago}&endtime=${oneyearago}" > ${itemname}_10y.xml
curl -X GET --header "Accept: application/json" "$resturl&starttime=${tenyearsago}&endtime=${oneyearago}" > ${itemname}_10y.xml
curl -X GET --header "Accept: application/json" "$resturl&starttime=${oneyearago}&endtime=${onemonthago}" > ${itemname}_1y.xml
curl -X GET --header "Accept: application/json" "$resturl&starttime=${onemonthago}&endtime=${oneweekago}" > ${itemname}_1m.xml
curl -X GET --header "Accept: application/json" "$resturl&starttime=${oneweekago}&endtime=${onedayago}" > ${itemname}_1w.xml
curl -X GET --header "Accept: application/json" "$resturl&starttime=${onedayago}&endtime=${eighthoursago}" > ${itemname}_1d.xml
curl -X GET --header "Accept: application/json" "$resturl&starttime=${eighthoursago}" > ${itemname}_8h.xml

# combine files
cat ${itemname}_10y.xml ${itemname}_1y.xml ${itemname}_1m.xml ${itemname}_1w.xml ${itemname}_1d.xml ${itemname}_8h.xml > ${itemname}.xml

# convert data to line protocol file
cat ${itemname}.xml \
     | sed 's/}/\n/g' \
     | sed 's/data/\n/g' \
     | grep -e "time.*state"\
     | tr -d ',:[{"' \
     | sed 's/time/ /g;s/state/ /g' \
     | awk -v item="$itemname" '{print item " value=" $2 " " $1 "000000"}' \
     | sed 's/value=ON/value=1/g;s/value=OFF/value=0/g' \
> ${itemname}.txt

values=`wc -l ${itemname}.txt | cut -d " " -f 1`
echo ""
echo "### found values: $values"

# split file in smaller parts to make it easier for influxdb
split -l $importsize ${itemname}.txt "${itemname}-"

for i in ${itemname}-*
do
  curl -i -XPOST -u $influxuser:$influxpw "http://$influxserver:$influxport/write?db=$influxdatbase" --data-binary @$i
  echo "Sleep for $sleeptime seconds to let InfluxDB process the data..."
  sleep $sleeptime
done

echo ""
echo "### delete temporary files"
rm ${itemname}*

exit 0

```

---

<div class="post-metadata">

**Author:** ![controlc](https://community.openhab.org/letter_avatar_proxy/v4/letter/c/f1d935/32.png) [@controlc](https://community.openhab.org/u/controlc)\
**Post date:** [November 1, 2019, 3:42pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/829 "2019-11-01T15:42:15Z")

</div>

Hi @Woogi,

Well, now it´s clear: OSX is using BSD date and not GNU date and the syntax of both commands are different. You´ve two options: Install gnu coreutils via [brew](https://brew.sh/) (and replace “date” in the script with “gdate”) on your mac or adopt the script to BSD date syntax. As an example us this [website](https://unix.stackexchange.com/questions/361758/subtract-7-days-from-todays-date). Hope this will help.

Update: You have to change only the six variables like this:

> tenyearsago=`date -v -10y -R +“%Y-%m-%dT%H:%M:%S:%z”`  
> oneyearago=`date -v -12m -v -28d -R +“%Y-%m-%dT%H:%M:%S:%z”`  
> onemonthago=`date -v -29d -R +“%Y-%m-%dT%H:%M:%S:%z”`  
> oneweekago=`date -v -6d -v -23H -v -59M -R +“%Y-%m-%dT%H:%M:%S:%z”`  
> onedayago=`date -v -23H -v -59M -R +“%Y-%m-%dT%H:%M:%S:%z”`  
> eighthoursago=`date -v -7H -v -59M -R +“%Y-%m-%dT%H:%M:%S:%z”`

This should work.

---

<div class="post-metadata">

**Author:** ![Woogi](https://community.openhab.org/letter_avatar_proxy/v4/letter/w/dfb087/32.png) [@Woogi](https://community.openhab.org/u/Woogi)\
**Post date:** [November 1, 2019, 8:44pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/830 "2019-11-01T20:44:10Z")

</div>

Hi @controlc

I tried your hint, but I assume, this wasn’t the issue. further ideas?

```csv
date: invalid option -- 'v'
Try 'date --help' for more information.
date: invalid option -- 'v'
Try 'date --help' for more information.
date: invalid option -- 'v'
Try 'date --help' for more information.
date: invalid option -- 'v'
Try 'date --help' for more information.
date: invalid option -- 'v'
Try 'date --help' for more information.
date: invalid option -- 'v'
Try 'date --help' for more information.

### timestamps
item: Klima_hum_wz
10y:  
1y:   
1m:   
1w:   
1d:   
8h:   
  % Total % Received % Xferd Average Speed Time Time Time Current
                                 Dload Upload Total Spent Left Speed
100 229 100 229 0 0 14429 0 --:--:-- --:--:-- --:--:-- 15266
  % Total % Received % Xferd Average Speed Time Time Time Current
                                 Dload Upload Total Spent Left Speed
100 229 100 229 0 0 10986 0 --:--:-- --:--:-- --:--:-- 11450
  % Total % Received % Xferd Average Speed Time Time Time Current
                                 Dload Upload Total Spent Left Speed
100 229 100 229 0 0 15074 0 --:--:-- --:--:-- --:--:-- 16357
  % Total % Received % Xferd Average Speed Time Time Time Current
                                 Dload Upload Total Spent Left Speed
100 229 100 229 0 0 15272 0 --:--:-- --:--:-- --:--:-- 16357
  % Total % Received % Xferd Average Speed Time Time Time Current
                                 Dload Upload Total Spent Left Speed
100 229 100 229 0 0 17833 0 --:--:-- --:--:-- --:--:-- 19083
  % Total % Received % Xferd Average Speed Time Time Time Current
                                 Dload Upload Total Spent Left Speed
100 229 100 229 0 0 14906 0 --:--:-- --:--:-- --:--:-- 16357

### found values: 0
Warning: Couldn't read data from file "Klima_hum_wz-*", this makes an empty 
Warning: POST.
HTTP/1.1 204 No Content
Content-Type: application/json
Request-Id: 078dc04b-fce8-11e9-bede-b827eb33e913
X-Influxdb-Build: OSS
X-Influxdb-Version: 1.7.8
X-Request-Id: 078dc04b-fce8-11e9-bede-b827eb33e913
Date: Fri, 01 Nov 2019 20:41:50 GMT

Sleep for 5 seconds to let InfluxDB process the data...

### delete temporary files

```

---

<div class="post-metadata">

**Author:** ![controlc](https://community.openhab.org/letter_avatar_proxy/v4/letter/c/f1d935/32.png) [@controlc](https://community.openhab.org/u/controlc)\
**Post date:** [November 1, 2019, 8:55pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/831 "2019-11-01T20:55:14Z")

</div>

Hi @Woogi,

please try the following date line in your local terminal window:

```auto
date -v -10y -R +"%Y-%m-%dT%H:%M:%S:%z"

```

and lets have a look at `man date` to study the syntax. If all of it doesn´t work lets have a look at [brew](https://brew.sh/) or why you don´t execute the script on your Raspberry Pi?

---

<div class="post-metadata">

**Author:** ![Woogi](https://community.openhab.org/letter_avatar_proxy/v4/letter/w/dfb087/32.png) [@Woogi](https://community.openhab.org/u/Woogi)\
**Post date:** [November 1, 2019, 9:00pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/832 "2019-11-01T21:00:24Z")

</div>

hi @controlc

this is the result after typing the line into local terminal window:

```csv
2009-11-01T21:57:17:+0100

```

what is `man date` where can I find that?

I am connected to the raspberry by ssh so I thought I would execute it on the raspberry?!

---

<div class="post-metadata">

**Author:** ![rlkoshak](https://community.openhab.org/user_avatar/community.openhab.org/rlkoshak/32/75251_2.png) [@rlkoshak](https://community.openhab.org/u/rlkoshak)\
**Post date:** [November 1, 2019, 9:07pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/833 "2019-11-01T21:07:59Z")

</div>

> [@Woogi](#):
>
> what is `man date` where can I find that?

Type `man date` on the command line and it will bring up the documentation for the `date` command.

---

<div class="post-metadata">

**Author:** ![controlc](https://community.openhab.org/letter_avatar_proxy/v4/letter/c/f1d935/32.png) [@controlc](https://community.openhab.org/u/controlc)\
**Post date:** [November 2, 2019, 8:54am UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/834 "2019-11-02T08:54:44Z")

</div>

Hi @Woogi,

> [@Woogi](#):
>
> this is the result after typing the line into local terminal window:
> 
> ```auto
> 2009-11-01T21:57:17:+0100
> 
> ```

That means that my conversion of the `date` command works for you (and your mac).

> [@Woogi](#):
>
> I am connected to the raspberry by ssh so I thought I would execute it on the raspberry?!

I´m confused: Do you execute the script at a shell on the raspberry or at a shell on your mac?  
Normally the script should run on your local workstation aka mac - you have to edit the `config.cfg` to setup up the connection details of your raspberry. By executing the script it connects to your raspberry and read/write the informations from rrd4j to influxdb.

[Previous page](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761.md?page=40)

[Next page](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761.md?page=42)
