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

HP Color LaserJet: Unable to connect to the network

We have a HP Color LaserJet in the office, one of these which can do both printing and scanning. The newer versions include a very nice feature "Scan to network folder" - so I did setup options to scan different PDF sizes to all of our laptops. Very convenient!

Until it stopped working a while ago.

The printer refuses scans to a network folder with the error message: "Scan Error" "Unable to connect to the network. Check the network, and then try again."

 

Continue reading "HP Color LaserJet: Unable to connect to the network"
  • Twitter
  • Bookmark HP Color LaserJet: Unable to connect to the network at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg HP Color LaserJet: Unable to connect to the network
  • Bloglines HP Color LaserJet: Unable to connect to the network
  • Technorati HP Color LaserJet: Unable to connect to the network
  • Fark this: HP Color LaserJet: Unable to connect to the network
  • Bookmark HP Color LaserJet: Unable to connect to the network at YahooMyWeb
  • Bookmark HP Color LaserJet: Unable to connect to the network at Furl.net
  • Bookmark HP Color LaserJet: Unable to connect to the network at reddit.com
  • Bookmark HP Color LaserJet: Unable to connect to the network at blinklist.com
  • Bookmark HP Color LaserJet: Unable to connect to the network at Spurl.net
  • Bookmark HP Color LaserJet: Unable to connect to the network at Simpy.com
  • Bookmark HP Color LaserJet: Unable to connect to the network at blogmarks
  • Bookmark HP Color LaserJet: Unable to connect to the network with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca