Skip to content

Grafana: select host for a dashboard

InfluxDB is running on a Raspberry Pi in my home network (with separate attached disk), and I installed a Grafana on top of it, to visualize crucial data.

In Grafana it is possible to define a variable for a dashboard and this variable can query the data source and use the returned list of values. Let's say the variable is $host, then the data query can use:

WHERE host =~ /^$host$/

and limit the current dashboard to the selected host. Also the variable will provide a select field at the top of the dashboard, which allows selecting the system one wants to see:

Now usually - according to the documentation - a "SHOW TAG VALUES" in the data source should be sufficient However as it is, this did not work for me, and the query came back empty:

> show tag values from system with key = host

Looks like I'm not the only one with this problem.

 

Luckily there is a way around with another query:

select distinct("host") from (select "host","load1" from system)

The result:

> select distinct("host") from (select "host","load1" from system)
name: system
time distinct
---- --------
0    host1
0    host2
0    host3
0    host4
0    host5
0    host6

Grafana ignores the "time" column and uses the second column for the host list. Voila.

  • Twitter
  • Bookmark Grafana: select host for a dashboard at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Grafana: select host for a dashboard
  • Bloglines Grafana: select host for a dashboard
  • Technorati Grafana: select host for a dashboard
  • Fark this: Grafana: select host for a dashboard
  • Bookmark Grafana: select host for a dashboard at YahooMyWeb
  • Bookmark Grafana: select host for a dashboard at Furl.net
  • Bookmark Grafana: select host for a dashboard at reddit.com
  • Bookmark Grafana: select host for a dashboard at blinklist.com
  • Bookmark Grafana: select host for a dashboard at Spurl.net
  • Bookmark Grafana: select host for a dashboard at Simpy.com
  • Bookmark Grafana: select host for a dashboard at blogmarks
  • Bookmark Grafana: select host for a dashboard with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Move InfluxDB data directory to a SDcard

For my openHAB system I installed InfluxDB (on a separate) Raspberry Pi. The Pi has a 32 GB SDcard, but that is not enough for storing all the data, and that Pi has additional work to do as well. For that reason I also attached a 1 TB disk to the Pi, and mounted it on /data. Now all I have to do is move the InfluxDB data directory to /data.

 

Continue reading "Move InfluxDB data directory to a SDcard"
  • Twitter
  • Bookmark Move InfluxDB data directory to a SDcard at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Move InfluxDB data directory to a SDcard
  • Bloglines Move InfluxDB data directory to a SDcard
  • Technorati Move InfluxDB data directory to a SDcard
  • Fark this: Move InfluxDB data directory to a SDcard
  • Bookmark Move InfluxDB data directory to a SDcard at YahooMyWeb
  • Bookmark Move InfluxDB data directory to a SDcard at Furl.net
  • Bookmark Move InfluxDB data directory to a SDcard at reddit.com
  • Bookmark Move InfluxDB data directory to a SDcard at blinklist.com
  • Bookmark Move InfluxDB data directory to a SDcard at Spurl.net
  • Bookmark Move InfluxDB data directory to a SDcard at Simpy.com
  • Bookmark Move InfluxDB data directory to a SDcard at blogmarks
  • Bookmark Move InfluxDB data directory to a SDcard with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

raspi-config automated

While I installed the Raspberry Pi with the Raspbee board on it, I had to modify the settings for the serial device. That's done using the raspi-config tool on Raspbian.

However since I'm into automation, I don't want to start "raspi-config" manually, but had to figure out how to do that in an automated way.

 

 

Continue reading "raspi-config automated"
  • Twitter
  • Bookmark raspi-config automated at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg raspi-config automated
  • Bloglines raspi-config automated
  • Technorati raspi-config automated
  • Fark this: raspi-config automated
  • Bookmark raspi-config automated at YahooMyWeb
  • Bookmark raspi-config automated at Furl.net
  • Bookmark raspi-config automated at reddit.com
  • Bookmark raspi-config automated at blinklist.com
  • Bookmark raspi-config automated at Spurl.net
  • Bookmark raspi-config automated at Simpy.com
  • Bookmark raspi-config automated at blogmarks
  • Bookmark raspi-config automated with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Install a Raspbee II on a Raspberry Pi

A while ago I got a recommendation to look into a Raspbee (from dresden elektronik) as Zigbee gateway. That looked like fun, therefore I ordered one of the devices. The first step is the installation of the Pi itself and then the software for the Raspbee. 

For various reasons I decided to use a dedicated Pi for this, and don't install this on the openHAB Pi already running here:

  • The Raspbee needs software from a closed repository
  • During installation and configuration I don't have to reboot my openHAB system all the time
  • The headless install runs a webserver, this conflicts with the redirect I have on port 80 on the openHAB system
  • I still have a couple Raspberry Pi B+ here, which I don't need for other projects

 

Continue reading "Install a Raspbee II on a Raspberry Pi"
  • Twitter
  • Bookmark Install a Raspbee II on a Raspberry Pi at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Install a Raspbee II on a Raspberry Pi
  • Bloglines Install a Raspbee II on a Raspberry Pi
  • Technorati Install a Raspbee II on a Raspberry Pi
  • Fark this: Install a Raspbee II on a Raspberry Pi
  • Bookmark Install a Raspbee II on a Raspberry Pi at YahooMyWeb
  • Bookmark Install a Raspbee II on a Raspberry Pi at Furl.net
  • Bookmark Install a Raspbee II on a Raspberry Pi at reddit.com
  • Bookmark Install a Raspbee II on a Raspberry Pi at blinklist.com
  • Bookmark Install a Raspbee II on a Raspberry Pi at Spurl.net
  • Bookmark Install a Raspbee II on a Raspberry Pi at Simpy.com
  • Bookmark Install a Raspbee II on a Raspberry Pi at blogmarks
  • Bookmark Install a Raspbee II on a Raspberry Pi with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Raspberry Pi watchdog for openHAB

The openHAB display in the kitchen is still the problem child. Occasionally it just stops, other times it does not refresh the HABpanel, even though it has a connection to the openHAB server. Then there is the problem with the network card in the Pi. And - ok, that's a server-side problem - occasionally the weather stops updating. All in all that's a lot of trouble for a display which is just supposed to run standalone.

In the latest iteration I looked into activating the integrated hardware watchdog in the Raspberry Pi. Checking the temperature it never goes above ~55°C celcius, even though the display is in an almost closed frame and can't exchange much heat with the environment. But nevertheless occasionally the Pi just halts, and stops operating.

 

Continue reading "Raspberry Pi watchdog for openHAB"
  • Twitter
  • Bookmark Raspberry Pi watchdog for openHAB at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Raspberry Pi watchdog for openHAB
  • Bloglines Raspberry Pi watchdog for openHAB
  • Technorati Raspberry Pi watchdog for openHAB
  • Fark this: Raspberry Pi watchdog for openHAB
  • Bookmark Raspberry Pi watchdog for openHAB at YahooMyWeb
  • Bookmark Raspberry Pi watchdog for openHAB at Furl.net
  • Bookmark Raspberry Pi watchdog for openHAB at reddit.com
  • Bookmark Raspberry Pi watchdog for openHAB at blinklist.com
  • Bookmark Raspberry Pi watchdog for openHAB at Spurl.net
  • Bookmark Raspberry Pi watchdog for openHAB at Simpy.com
  • Bookmark Raspberry Pi watchdog for openHAB at blogmarks
  • Bookmark Raspberry Pi watchdog for openHAB with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Restic upgrade on Debian Buster

A while ago I switched backups from "Duplicity" to "Restic". About time: I was using Duplicity for many years (I think I started using it around 2010, long before "Restic" became available) and it served me well. But recently I ran into more and more issues, especially with archives getting larger and larger. There is an 11 years old open bug in the Duplicity bugtracker, which describes a showstopper for backing up larger archives. And it doesn't look like this will be solved anytime soon. Therefore it was time for something new.

Since I'm rolling out my backups with Ansible, it was relatively easy to create a set of scripts for Restic which use almost the same infrastructure as the old Duplicity backups. That works as expected on all our laptops. But the Raspberry Pi, which does the fileserver backups, seem to had a problem. Backups took way longer than before, jumped from 30-60 minutes (depending on the amount of changes) to constantly around 10 hours.

After some investigation (means: --verbose --verbose --verbose debugging), it turns out that Restic identifies most of the files as new, even though they did not change at all. Some background information: the Raspberry mounts the QNAP fileserver using the SMB3 protocol. The "mount -t cifs" uses the "serverino" option, but apparently that is not enough to provide a stable inode number. And if the inode for a file changes, Restic assumes it is a new file.

On the bright side, because the content of the files do not change, the deduplication still works, and no additional content is added to the backup. The size of the backup does not increase. Still, Restic fetches all the data from the server, and that takes a long time.

 

Continue reading "Restic upgrade on Debian Buster"
  • Twitter
  • Bookmark Restic upgrade on Debian Buster at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Restic upgrade on Debian Buster
  • Bloglines Restic upgrade on Debian Buster
  • Technorati Restic upgrade on Debian Buster
  • Fark this: Restic upgrade on Debian Buster
  • Bookmark Restic upgrade on Debian Buster at YahooMyWeb
  • Bookmark Restic upgrade on Debian Buster at Furl.net
  • Bookmark Restic upgrade on Debian Buster at reddit.com
  • Bookmark Restic upgrade on Debian Buster at blinklist.com
  • Bookmark Restic upgrade on Debian Buster at Spurl.net
  • Bookmark Restic upgrade on Debian Buster at Simpy.com
  • Bookmark Restic upgrade on Debian Buster at blogmarks
  • Bookmark Restic upgrade on Debian Buster with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Disable screensaver for Raspberry Pi

The 7" Raspberry display in the kitchen is nice, but unfortunately by default the installation comes with a screensaver enabled. After a while, the display goes dark. No one wants to stare at a blank display, and touch the screen in order to see crucial information.

 

Continue reading "Disable screensaver for Raspberry Pi"
  • Twitter
  • Bookmark Disable screensaver for Raspberry Pi at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Disable screensaver for Raspberry Pi
  • Bloglines Disable screensaver for Raspberry Pi
  • Technorati Disable screensaver for Raspberry Pi
  • Fark this: Disable screensaver for Raspberry Pi
  • Bookmark Disable screensaver for Raspberry Pi at YahooMyWeb
  • Bookmark Disable screensaver for Raspberry Pi at Furl.net
  • Bookmark Disable screensaver for Raspberry Pi at reddit.com
  • Bookmark Disable screensaver for Raspberry Pi at blinklist.com
  • Bookmark Disable screensaver for Raspberry Pi at Spurl.net
  • Bookmark Disable screensaver for Raspberry Pi at Simpy.com
  • Bookmark Disable screensaver for Raspberry Pi at blogmarks
  • Bookmark Disable screensaver for Raspberry Pi with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Remove Trashcan Icon from Raspberry Pi Desktop

Our home automation got a nice 7" Raspberry display in the kitchen, showing the most relevant information (like temperature, weather, washing machine, dryer ect) on a dedicated screen. Quite handy, especially the temperature, and the one-click stop to the weather forecast.

While installing the Pi and setting everything up, I stumbled over the Icons which LXDE by default shows on the desktop. Not necessary, I want them removed. All I want on the desktop is the browser icon which directly goes to the HABpanel.

The reason is simple: if the Pi starts up, but the browser for unknown reasons doesn't come up, I don't want anyone to be confused by additional icons on the desktop. After all, usually the LXDE desktop is not seen by default.
 

Continue reading "Remove Trashcan Icon from Raspberry Pi Desktop"
  • Twitter
  • Bookmark Remove Trashcan Icon from Raspberry Pi Desktop at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Remove Trashcan Icon from Raspberry Pi Desktop
  • Bloglines Remove Trashcan Icon from Raspberry Pi Desktop
  • Technorati Remove Trashcan Icon from Raspberry Pi Desktop
  • Fark this: Remove Trashcan Icon from Raspberry Pi Desktop
  • Bookmark Remove Trashcan Icon from Raspberry Pi Desktop at YahooMyWeb
  • Bookmark Remove Trashcan Icon from Raspberry Pi Desktop at Furl.net
  • Bookmark Remove Trashcan Icon from Raspberry Pi Desktop at reddit.com
  • Bookmark Remove Trashcan Icon from Raspberry Pi Desktop at blinklist.com
  • Bookmark Remove Trashcan Icon from Raspberry Pi Desktop at Spurl.net
  • Bookmark Remove Trashcan Icon from Raspberry Pi Desktop at Simpy.com
  • Bookmark Remove Trashcan Icon from Raspberry Pi Desktop at blogmarks
  • Bookmark Remove Trashcan Icon from Raspberry Pi Desktop with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Raspberry Pi: take a screenshot from a display with no keyboard and mouse

The Raspberry Pi in the kitchen runs relatively stable, but recently the browser (which is showing the openHAB HABpanel) popped up a warning in the upper right corner. That's annoying, because this area in HABpanel shows the outside temperature.

Before investigating what's going on, I had to figure out a way to get a screenshot of the display - without running into the kitchen with my mobile phone. And without attaching a keyboard all the time (to press the "Print" button).

 

Continue reading "Raspberry Pi: take a screenshot from a display with no keyboard and mouse"
  • Twitter
  • Bookmark Raspberry Pi: take a screenshot from a display with no keyboard and mouse at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Raspberry Pi: take a screenshot from a display with no keyboard and mouse
  • Bloglines Raspberry Pi: take a screenshot from a display with no keyboard and mouse
  • Technorati Raspberry Pi: take a screenshot from a display with no keyboard and mouse
  • Fark this: Raspberry Pi: take a screenshot from a display with no keyboard and mouse
  • Bookmark Raspberry Pi: take a screenshot from a display with no keyboard and mouse at YahooMyWeb
  • Bookmark Raspberry Pi: take a screenshot from a display with no keyboard and mouse at Furl.net
  • Bookmark Raspberry Pi: take a screenshot from a display with no keyboard and mouse at reddit.com
  • Bookmark Raspberry Pi: take a screenshot from a display with no keyboard and mouse at blinklist.com
  • Bookmark Raspberry Pi: take a screenshot from a display with no keyboard and mouse at Spurl.net
  • Bookmark Raspberry Pi: take a screenshot from a display with no keyboard and mouse at Simpy.com
  • Bookmark Raspberry Pi: take a screenshot from a display with no keyboard and mouse at blogmarks
  • Bookmark Raspberry Pi: take a screenshot from a display with no keyboard and mouse with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Hide the mouse cursor on a Raspberry Pi

The openHAB HABpanel we have in the kitchen runs on a Raspberry Pi and uses a touchscreen display. The browser starts in fullscreen mode, and shows a specific HABpanel screen for this display. That's all nice, but by default the mouse cursor is in the way. Let's get rid of it.

 

Continue reading "Hide the mouse cursor on a Raspberry Pi"
  • Twitter
  • Bookmark Hide the mouse cursor on a Raspberry Pi at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Hide the mouse cursor on a Raspberry Pi
  • Bloglines Hide the mouse cursor on a Raspberry Pi
  • Technorati Hide the mouse cursor on a Raspberry Pi
  • Fark this: Hide the mouse cursor on a Raspberry Pi
  • Bookmark Hide the mouse cursor on a Raspberry Pi at YahooMyWeb
  • Bookmark Hide the mouse cursor on a Raspberry Pi at Furl.net
  • Bookmark Hide the mouse cursor on a Raspberry Pi at reddit.com
  • Bookmark Hide the mouse cursor on a Raspberry Pi at blinklist.com
  • Bookmark Hide the mouse cursor on a Raspberry Pi at Spurl.net
  • Bookmark Hide the mouse cursor on a Raspberry Pi at Simpy.com
  • Bookmark Hide the mouse cursor on a Raspberry Pi at blogmarks
  • Bookmark Hide the mouse cursor on a Raspberry Pi with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca