mika

#!/bin/zsh

HOST=homeassistant.lan
snapname=$(date +%Y-%m-%d_%T_homeassistant_autosnap)

slugname=$(ssh $HOST "source /etc/profile; ha backups new --name \"${snapname}\" "  | tail -n 1 ) || exit 1
[[ -z $slugname ]] && exit 2
echo $slugname | grep -q "slug: " || exit 3
slugname=$(echo $slugname | cut -c 7-)
snapfilename=backup/${slugname}.tar

mika

QNAP HDD Recovery Test (encrypted)

Removed HDD-2 from NAS (while running) and plugged into a Sharkoon USB-Bay and tried to recover data.

Tried to assemble all existing volumes:

  % sudo mdadm --assemble --scan
  mdadm: /dev/md/9 has been started with 1 drive (out of 24).
  mdadm: /dev/md/256 has been started with 1 drive (out of 2).

mika

HP Smart Storage Admin CLI (ssacli) installation and usage on Proxmox PVE (6.x)

Why use HP Smart Storage Admin CLI?

You can use ssacli (smart storage administrator command line interface) tool to manage any of supported HP Smart Array Controllers in your Proxmox host without need to reboot your server to access Smart Storage Administrator in BIOS. That means no host downtime when managing your storage.

CLI is not as convenient as GUI interface provided by BIOS or desktop utilities, but still allows you to fully manage your controller, physical disks and logical drives on the fly with no Proxmox host downtime.

ssacli replaces older hpssacli, but shares the same syntax and adds support for newer servers and controllers.

Installation

mika

Falsehoods programmers believe about time

This is a compiled list of falsehoods programmers tend to believe about working with time.

Don't re-invent a date time library yourself. If you think you understand everything about time, you're probably doing it wrong.

Falsehoods

• There are always 24 hours in a day.
• February is always 28 days long.
• Any 24-hour period will always begin and end in the same day (or week, or month).

mika

{
    "builders": [
        {
            "type": "openstack",
            "username": "xxx",
            "password": "yyy",
            "identity_endpoint": "https://auth.cloud.ovh.net/v3/",
            "region": "DE1",
            "tenant_id": "zzz",
            "image_name": "debian10-arnaud",

mika

Hyperlinks (a.k.a. HTML-like anchors) in terminal emulators

Most of the terminal emulators auto-detect when a URL appears onscreen and allow to conveniently open them (e.g. via Ctrl+click or Cmd+click, or the right click menu).

It was, however, not possible until now for arbitrary text to point to URLs, just as on webpages.

In spring 2017, GNOME Terminal and iTerm2 have changed this.

GNOME Terminal is based on the VTE widget, and almost all of this work went to VTE. As such, we expect other VTE-based terminal emulators to catch up and add support really soon. Other terminal emulators are also welcome and encouraged to join!

mika

# long running queries:
SELECT
  pid,
  now() - pg_stat_activity.query_start AS duration,
  query,
  state
FROM pg_stat_activity
WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes';

## active queries and killing them:

mika

#!/usr/bin/perl
#
# Brad's el-ghetto do-our-storage-stacks-lie?-script
#

sub usage {
    die <<'END';
Usage: diskchecker.pl -s <server[:port]> verify <file>
       diskchecker.pl -s <server[:port]> create <file> <size_in_MB>
       diskchecker.pl -l [port]

mika

#!/bin/sh

IFACE=$1
ACTION=$2

ntfy () {
	sudo -u cengiz \
		DISPLAY=:0 \
		DBUS_SESSION_BUS_ADDRESS=unix:path=/run/user/1000/bus \
		notify-send "$1" "$2"

mika

#!/bin/bash
set -x
puppet agent --disable "update Debian"
service keepalived stop
apt-get install udev acl
sed -i'' -e 's/jessie/stretch/g' /etc/apt/sources.list.d/*
export DEBIAN_FRONTEND=noninteractive
export DEBCONF_NONINTERACTIVE_SEEN=true
apt-get update
apt-get install apt dpkg deborphan # openjdk-8-jre-headless