Help with RPI Openhab full hang. (WAS Rule for longest ever uptime?)

Sharpy · July 16, 2018, 3:42pm

Hi everyone

I’m having a problem with my RPI

It seems too go unresponsive and fall off my network but I haven’t solved this is yet

so now is a good time too make a rule I have been wanting too add but don’t know how

I want too add a system uptime I already have a current system uptime but would like too add longest uptime (what is the record for the longest uptime)

I wanted too add a longest uptime this month and longest ever uptime

Help appreciated on this

Any hints on what the network problem might be welcome too

vzorglub · July 16, 2018, 4:08pm

Use persistence
And item.maximumSince(now.minusDays(30))

5iver · July 16, 2018, 4:12pm

Install a suitable persistence service, create an unlinked item that gets persisted, and write a rule that triggers when your system uptime changes. In the rule’s action, update the new item with…

newItem.sendCommand(systemUptimeItem.maximumSince(now.minusDays(30)))

Then do similar for longest. On a phone or I’d give more detail.

Sharpy · July 16, 2018, 4:15pm

Hi @5iver thanks for a response

I’m currently using RRD4J & MapDB

@vzorglub Hi again thanks for the reply does that give me the result for a month how do you do longest forever

5iver · July 16, 2018, 4:20pm

Neither of those store long term data, so not suitable.

vzorglub · July 16, 2018, 4:21pm

Install another one
I recommend influxdb

vzorglub · July 16, 2018, 4:22pm

now.minusDays(1000000)
Should do the trick

Sharpy · July 16, 2018, 4:24pm

With me now running on a pi I was hoping too get grapfina up and running for nicer charts but it looked extremely complex

Don’t you need too install influx dB too get that up and running isn’t it included with openhabian

sihui · July 16, 2018, 5:16pm

Step by Step guide:

Sharpy · July 16, 2018, 7:00pm

Hi @sihui

I have looked at that post a few times looks complicated can’t I just use the openhabian config?

sihui · July 16, 2018, 7:08pm

Not sure, have never used openHABian, just try it, looks promising.

Sharpy · July 16, 2018, 7:12pm

@sihui

It says that this will install influxdB and grafana but it can not like the two together at the moment please see a community post…

I’m assuming Openhabian is for beginners it makes getting oh running easy and has things like frontail smb shares ect already installed I’m sure you already know tho

Let me take my system offline and image my sd card i always do before messing with important stuff

I will run the command and see what happens will post back

Sharpy · July 16, 2018, 7:56pm

@sihui

I have Finished that now it said setup successful onscreen readings at bottom of this post

I’m not sure what too do next its directed me too the same post as you posted

having a scroll through too see if i can find answers

im not after setting grafana up atm although i can access a logon page for grafana from the OH Start Page

but getting influx working would be nice

I have tried too access the webfrontend by typing in 192.168.0.94:8086 into my browser it brings up a 404 error (Google says the web frontend has been removed since v1.3) ?

where should i type the commands from the post you linked too create the database / users after i have SSH into the RPI Here ?
Untitled

What was said onscreen during install i have since done the updates still stuck

2018-07-16_20:44:54_BST [openHABian] Checking for changes in origin... OK
2018-07-16_20:45:01_BST [openHABian] Setting up InfluxDB and Grafana...

$ apt -y install apt-transport-https
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-transport-https is already the newest version (1.4.8).
0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.

InfluxDB...
--2018-07-16 20:45:40--  https://repos.influxdata.com/influxdb.key
Resolving repos.influxdata.com (repos.influxdata.com)... 54.192.2.93, 54.192.2.117, 54.192.2.128, ...
Connecting to repos.influxdata.com (repos.influxdata.com)|54.192.2.93|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 3108 (3.0K) [application/pgp-keys]
Saving to: ‘STDOUT’

-                                         100%[=====================================================================================>]   3.04K  --.-KB/s    in 0s

2018-07-16 20:45:40 (40.3 MB/s) - written to stdout [3108/3108]

OK

$ apt update
Get:1 http://raspbian.raspberrypi.org/raspbian stretch InRelease [15.0 kB]
Get:2 http://archive.raspberrypi.org/debian stretch InRelease [25.3 kB]
Ign:3 http://repos.azulsystems.com/debian stable InRelease
Hit:4 http://repos.azulsystems.com/debian stable Release
Ign:5 https://dl.bintray.com/openhab/apt-repo2 stable InRelease
Get:6 https://repos.influxdata.com/debian stretch InRelease [4,732 B]
Hit:7 https://dl.bintray.com/openhab/apt-repo2 stable Release
Hit:8 https://deb.nodesource.com/node_8.x stretch InRelease
Get:9 http://raspbian.raspberrypi.org/raspbian stretch/main armhf Packages [11.7 MB]
Get:10 http://archive.raspberrypi.org/debian stretch/ui armhf Packages [34.0 kB]
Get:12 http://raspbian.raspberrypi.org/raspbian stretch/contrib armhf Packages [56.9 kB]
Get:13 https://repos.influxdata.com/debian stretch/stable armhf Packages [925 B]
Fetched 11.8 MB in 10s (1,137 kB/s)
Reading package lists... Done
Building dependency tree
Reading state information... Done
18 packages can be upgraded. Run 'apt list --upgradable' to see them.

$ apt -y install influxdb
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
  influxdb
0 upgraded, 1 newly installed, 0 to remove and 18 not upgraded.
Need to get 21.3 MB of archives.
After this operation, 66.6 MB of additional disk space will be used.
Get:1 https://repos.influxdata.com/debian stretch/stable armhf influxdb armhf 1.6.0-1 [21.3 MB]
Fetched 21.3 MB in 3s (5,423 kB/s)
Selecting previously unselected package influxdb.
(Reading database ... 47418 files and directories currently installed.)
Preparing to unpack .../influxdb_1.6.0-1_armhf.deb ...
Unpacking influxdb (1.6.0-1) ...
Setting up influxdb (1.6.0-1) ...
Created symlink /etc/systemd/system/influxd.service → /lib/systemd/system/influxdb.service.
Created symlink /etc/systemd/system/multi-user.target.wants/influxdb.service → /lib/systemd/system/influxdb.service.
Processing triggers for man-db (2.7.6.1-2) ...
Updating FireMotD available updates count ...

$ systemctl daemon-reload

$ systemctl enable influxdb.service

$ systemctl start influxdb.service
OK
Grafana...

$ apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 
Executing: /tmp/apt-key-gpghome.RqmtlxTanG/gpg.1.sh --keyserver keyserver.ubuntu.com --recv-keys 
gpg: key : public key "Bintray (by JFrog) <bintray@bintray.com>" imported
gpg: Total number processed: 1
gpg:               imported: 1

$ apt update
Hit:1 http://archive.raspberrypi.org/debian stretch InRelease
Hit:2 http://raspbian.raspberrypi.org/raspbian stretch InRelease
Ign:3 http://repos.azulsystems.com/debian stable InRelease
Hit:4 http://repos.azulsystems.com/debian stable Release
Hit:5 https://repos.influxdata.com/debian stretch InRelease
Hit:6 https://deb.nodesource.com/node_8.x stretch InRelease
Ign:7 https://dl.bintray.com/fg2it/deb stretch InRelease
Ign:8 https://dl.bintray.com/openhab/apt-repo2 stable InRelease
Get:9 https://dl.bintray.com/fg2it/deb stretch Release [5,300 B]
Hit:10 https://dl.bintray.com/openhab/apt-repo2 stable Release
Get:11 https://dl.bintray.com/fg2it/deb stretch Release.gpg [821 B]
Get:14 https://dl.bintray.com/fg2it/deb stretch/main armhf Packages [1,784 B]
Fetched 7,905 B in 3s (2,163 B/s)
Reading package lists... Done
Building dependency tree
Reading state information... Done
18 packages can be upgraded. Run 'apt list --upgradable' to see them.

$ apt -y install grafana
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
  grafana
0 upgraded, 1 newly installed, 0 to remove and 18 not upgraded.
Need to get 48.5 MB of archives.
After this operation, 131 MB of additional disk space will be used.
Get:1 https://dl.bintray.com/fg2it/deb stretch/main armhf grafana armhf 5.1.4 [48.5 MB]
Fetched 48.5 MB in 1min 15s (645 kB/s)
Selecting previously unselected package grafana.
(Reading database ... 47444 files and directories currently installed.)
Preparing to unpack .../grafana_5.1.4_armhf.deb ...
Unpacking grafana (5.1.4) ...
Processing triggers for systemd (232-25+deb9u2) ...
Setting up grafana (5.1.4) ...
Adding system user `grafana' (UID 111) ...
Adding new user `grafana' (UID 111) with group `grafana' ...
Not creating home directory `/usr/share/grafana'.
### NOT starting on installation, please execute the following statements to configure grafana to start automatically using systemd
 sudo /bin/systemctl daemon-reload
 sudo /bin/systemctl enable grafana-server
### You can start grafana-server by executing
 sudo /bin/systemctl start grafana-server
Processing triggers for systemd (232-25+deb9u2) ...
Updating FireMotD available updates count ...

$ systemctl daemon-reload

$ systemctl enable grafana-server.service
Synchronizing state of grafana-server.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install enable grafana-server
Created symlink /etc/systemd/system/multi-user.target.wants/grafana-server.service → /usr/lib/systemd/system/grafana-server.service.

$ systemctl start grafana-server.service
OK
Connecting (TODO)...
Adding openHAB dashboard tile...
2018-07-16_20:48:23_BST [openHABian] Adding an openHAB dashboard tile for 'grafana'... OK
2018-07-16_20:48:36_BST [openHABian] Checking for default openHABian username:password combination... OK
2018-07-16_20:48:36_BST [openHABian] We hope you got what you came for! See you again soon ;)

rlkoshak · July 16, 2018, 9:23pm

since you are in the InfluxDB shell I think you just type in the commands there.

Sharpy · July 16, 2018, 9:29pm

Hi Rich

I have typed the commands there i wasen’t sure i was in the right place im still new too this

i Still cant access the web frontend for influx
grafana seems too be working not joined with influx but working

i have edited the text config files too

I new this would be tricky I can’t work out what I need too do now or next im getting tired too so that never helps

Any hints appreciated

I am picking some of the linux stuff up and am. Enjoying it at the same time it’s just slightly different than I’m used too with windows

rlkoshak · July 16, 2018, 9:37pm

It may be gone. It was deprecated shortly after that tutorial was written but still hanging around and usable. I guess they finally just dropped it entirely.

Reading through the Influxdb+grafana tutorial it doesn’t mention anything about the web based interface for InfluxDB. What tutorial are you following?

Sharpy · July 16, 2018, 9:39pm

@rlkoshak

I’m following the one posted above

But I didn’t install influx or grafana myself I used the openhabian-config add component and followed the guide it linked me too again it was the same one posted above

What is the monitering host? I’m not sure about this

WHAT I DID

I used the openhabian-config to install the influx and grafana packages

It told me too follow the guide posted above I did
The parts influxdb install and setup

2)Entered the commands in the influx cli (created users and dB)

3)I then changed the influx.config

restarted influx

I didn’t inject data

4)I tried too connect too OH installed influx persistence edited influx.cfg

5)Created a persist file

Rebooted rpi

rlkoshak · July 16, 2018, 10:00pm

It’s the machine where you installed InfluxDB.

You have yet to indicate what, if anything, the problem is. Are you seeing errors? If so what are they? Is persistence not working? If not then how are you checking?

Sharpy · July 16, 2018, 10:07pm

Ok so I don’t have too really worry about that it’s installed on the same rpi

Yes the problems just getting it working so I can start using the rules posted above

I’m just struggling with what too actually do maby it’s just not working as expected getting mapdb and rrd4j running was easy I have just been checking the persistence folder for files created by influx but I don’t know how too check the simple stuff like if the actual influx dB is running as it told me it’s accessible on localhost:8086 and then I couldent access it there

vzorglub · July 16, 2018, 10:10pm

Did you install the influxdb persistence service in OH?
Do you get any influxdb related error messages when you start OH?