Hey all. Ive tried everything and i just cant get this to work.
I cant start influx ssh, i get failed to connect to host.
ensure the service is running.
[19:03:50] openhabian@openHABianPi:/lib/systemd/system$ sudo systemctl start influxdb
[19:04:19] openhabian@openHABianPi:/lib/systemd/system$ influx
Failed to connect to http://localhost:8086
Please check your connection settings and ensure 'influxd' is running.
[19:04:45] openhabian@openHABianPi:/lib/systemd/system$ sudo systemctl start influxd
[19:04:53] openhabian@openHABianPi:/lib/systemd/system$ influx
Failed to connect to http://localhost:8086
Please check your connection settings and ensure 'influxd' is running.
[19:04:56] openhabian@openHABianPi:/lib/systemd/system$ influx d
Failed to connect to http://localhost:8086
Please check your connection settings and ensure 'influxd' is running.
I have installed using the openhabian-config. Grafana is installed. I just cant get this to work
I cant even figure out where to start.
after purging influx db and trying to reinstall i get this
Fetched 46.6 MB in 7s (6,376 kB/s)
Selecting previously unselected package influxdb.
(Reading database ... 48677 files and directories currently installed.)
Preparing to unpack .../influxdb_1.7.7-1_armhf.deb ...
Unpacking influxdb (1.7.7-1) ...
dpkg: error processing archive /var/cache/apt/archives/influxdb_1.7.7-1_armhf.deb (--unpack):
trying to overwrite '/usr/bin/influx', which is also in package influxdb-client 1.0.2+dfsg1-1
dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)
Errors were encountered while processing:
/var/cache/apt/archives/influxdb_1.7.7-1_armhf.deb
Updating FireMotD available updates count ... 2019-07-03 19:12:04,142: FireMotD: Error: Template folder doesn't exist. Upgrading from an older version? Please run make again or run the install function "FireMotD -I -v".
E: Sub-process /usr/bin/dpkg returned an error code (1)
$ systemctl daemon-reload
$ systemctl enable influxdb.service
Failed to enable unit: File influxdb.service: No such file or directory
$ systemctl restart influxdb.service
Failed to restart influxdb.service: Unit influxdb.service not found.
I have a small problem with the grafana graphs in openhab.
I use the webview to display them on in my basic UI but there is a small icon at the top showing that something can not be displayed.
See picture - any idea?
The instructions for installing Grafana on Debian via apt are located here. There are several commands listed that you must run before you can use the apt install.
If you upgrade to Debian buster and your " ā¦as āImageā Element" images no longer work, while you see msg=āPhantomjs exited with non zero exit codeā in your grafana.log, setting OPENSSL_CONF=/etc/ssl
in /etc/default/grafana-server may work around this issue for you.
This comes from https://github.com/grafana/grafana/issues/17588
Maybe it will help someone to find the workaround quicker than I didā¦
Thanks for the tutorial,I was able to set it up on my Raspberry Pi using MySQL instead of InfluxDB.
However I want to ask a few questions:
What is the performance for you on RPi? For me it takes 10-30 secs to load a 1 day graph. I would be happy if this would be almost instant. Viewing on the Grafana Dashboard it loads instantly, only the direct rendered image takes a lot of time to load
That is probably the best you can expect from an RPi. And if you add many more charts, you will probably start crashing OH itself. The library that renders the images is not RPi friendly. But even on a very powerful machine, it takes me about 10 seconds to generate 5 charts. It appears instantly in Grafana because it isnāt generating a JPG, itās actually drawing it on screen.
I would guess you have no data stored before 11:50(ish) in your database.
That would be better, Iām still moving to a more powerful machine.
Yes it looks like. However not, I have data to months back now, I even checked it in MySQL. Also doesnāt change nothing if I āzoomā the time axis. For example if Only the last 6 hours would be shown (from 16:00 at the picture above) I will still get this white screen at the beginning. Also I found out just now that timestamps are not correct for all charts. Some charts shows midnight almost midnight now, some only 22:00 (which is the current time nowā¦).
I moved Grafana to my Windows server insted of using the Rpiā¦ Rendering 2-3 charts on the Rpi crashed java (and openhab). After moving Grafana to my (actually a rather old dual core E6350) it takes aprox 5-6 seconds to render 3 charts.
I know that InfluxDB+Grafana is a powerful combination but is there a lightfull way for graphing on an rpi? For me it is a common function to have in a home automation system.
Its a good way to try/test it. IĀ“m very pleased with how Grafana runs on my windows server. Very fast and simple setup, and hardly take any resources. IĀ“ll never ever again have it run on a Rpi or simular againā¦
When moving over on the right part, a scroll line appear!
Without move-over there is NO hint that there are more lines!
Itās even harder in the Android app, where the scroll bar never appears.
I did not yet find a full solution for this issue, but only some workarounds.
Most of them depend on the height of the graph.
In grafana web interface you can increase height by pulling the handle down.
When using the embedded image method, you can work with &height=700 or the like.
When using the webview library by wborn, you can play with the height parameter in html/panel-300px.css.
The higher the panel is, the more space you have in the legendā¦
If someone has a better solution for this (meaning that the legend is always shown completely), Iāll very interested in this.
Update:
I just found the root cause and in consequence another workaround:
The root cause can be found in /usr/share/grafana/public/sass/components/_panel_graph.scss. There you find the following (reduced to relevant lines):
This implies, that the legend can only take 35% of the output. If you change this from 65/35 to 10/90, the legend will usually be displayed completely.
One little problem: the above sccs file seems to be there for information only but it has to be compiled first.
For this you can either install the source distribution and compile it yourself, or you go the ugly way, that I took for testing and this is to patch /usr/share/grafana/public/build/grafana.light.9d62d98149547e1107ad.css (or how the file you are using is named, maybe the dark one).
This isnāt very well readable, but with a good editor like emacs you will be able to find and replace the two numbers above.
Now a restart of grafana-server may be necessary.
To see an effect with the wborn webview, you need to set render=true (which breaks the horizontal scrolling in my Android app for the legend )
I guess something went wrong with the upgradeā¦ and grafana is not restarting properly, and does not get to the point of listening on port 3000? Any opinion on what I should do to get back to normal?