Building an executive dashboard with Grafana

Grafana + InfluxDB + scripts = Awesome

I have many interests and some of them have metrics that are useful or fun to watch. For example, I have investment in Bitcoin so it’s nice to be able to keep an eye on it periodically.
I decided to create a graphical “at a glance” dashboard for myself. I chose Grafana as the user interface / front end and InfluxDB a the time-series backend database to store the metrics. I use various scripts and applets to populate the data into Influx and Grafana makes it easy to
render them into a user friendly dashboard.

Some of the metrics I monitor are Pihole stats, the price of bitcoin, how many IPs get banned from my webservers and my network throughput.

Here’s my dashboard:

Grafana Dashboard

Read more

Using Ansible to build a high availablity Sabnzbd usenet downloader

I’m limited to about 40MB/s on downloads on my VPC at Digital Ocean, but I run Sabnzbd for downloading large files from usenet. It doesn’t take long to download at all, but out of curiosity I wanted to see if I could parallelize this and download multiple files at the same. I use Sonarr for searching usenet for freely distributable training videos which then sends them to SABnzbd for downloading. Since Sonarr can send multiple files to sabnzbd which get queued up, I figured I can reduce the queue by downloading them at the same time.

Using Ansible and Terraform (devops automation tools), I can spin up VPC on demand, provision them, configure them as sabnzbd download nodes and then destroy the instances when complete.

The instances all run the same sabnzbd config and the instances use haproxy for round-robin distribution. I will probably change this to Consul, but I just wanted something quick so I used a basic haproxy config.

Read more

System info bash script

I put together a quick bash shell script to view system info at a glance. I know there are existing tools for this like inxi, but I wanted to put something together I can copypasta. This is specific to RHEL, Centos and Sci Linux but it can be easily adapted for other distros.

Read more

Inxi - a utility for viewing system information


inxi is a super handy system info utility. These days I typically work with ephemeral instances / microservers, so I just dispose of infrastructure that flakes out. Occassionally I’ll need to see what’s up with a box so I’ve put together some common invocations of inxi below for reference:

Common Invocations

Read more Panda

Comma is shipping the Panda interface again. I received mine last week. It’s a wifi enabled OBDII interface. The Panda is more than just a reader though. It decodes and enables writing to the Media canbus. It’s going to make for some fun projects. Using Cabana I should be able to create a Database file of the Kia Optima’s CANbus protocol.

Read more

Upgrading Honda Insight IMA Battery

Honda Insight MIMA battery 144v DC
A few months ago while driving my commuter car - a 2000 Honda Insight, I received the dreaded IMA light. For those that don’t drive this car, the IMA light indicates that the main hybrid vehicle battery is failing at capacity. In Georgia, this light means you will not pass State emissions which is a requirement. Additionally, you lose a tremendous amount of power, which is kind of the point of the electric motor.

Read more

DIY Homemade Bed

Yep. I made my bed. Well I make my bed every day, but over a weekend I built my master bed. It’s a very simple design.

Read more

Building a homebrew generator

A few years ago I built my own generator. I cobbled it together with some parts I had laying around the house. I found a free lawnmower on craigslist and I used the engine from it as a power source for the generator. I coupled the engine to an automobile alternator and a power inverter. The result is a cheap AC power generator. It only produces a few hundred watts of power, but it’s enough to power lights or emergency equipment in the event of power failure. I did this project for fun, not as a replacement for a real backup power generator. Here are some pictures:
The generator

The generator

Wood coupler panel

Belt and pulleys