scrollocks

Homelab Server Setup Guide

This guide aims to document how I've gone about setting-up my homelab server. It mostly serves as a guide for myself so when it all inevitably burns to the ground I have an idea what to do to get it working again. Perhaps one day I can create an Ansible playbook for it.

The server hardware is a plain-old mITX PC with the following specs:

Component	Hardware

scrollocks

FROM golang:alpine as build
ENV GO111MODULE=on
WORKDIR /app
ADD ./ /app
RUN apk update --no-cache
RUN apk add git
RUN go build -o golang-test  .

FROM alpine:latest as final
WORKDIR /app

scrollocks

BEGIN{
    # Get input and output mappings from the command line variables (-v)
    output_num_cols = split(output_cols, output_layout);

    if ( input_cols )
    # If input_cols wasn't given, assume the first row is a header and use that instead.
    {
        input_num_cols = split(input_cols, input_layout);
    }

scrollocks

CREATE TABLE so.data_all (
    capacity_bytes Nullable(Int64),
    date Date,
    failure Nullable(Int64),
    model Nullable(String),
    serial_number Nullable(String),
    smart_10_normalized Nullable(Int64),
    smart_10_raw Nullable(Int64),
    smart_11_normalized Nullable(Int64),
    smart_11_raw Nullable(Int64),