bretton

If you run a Mikrotik Dude instance on CHR, have a lot of devices and years of activity, problems start to arise with errors like:

server status: db failure: disk image is malformed. stop
server status: db failure: database disk image is malformed. stop

The problem might temporarily be resolved by running

#!/bin/bash

bretton

Self-hosted AI toolsets

TabbyML is a self-hosted AI coding assistant, offering an open-source and on-premises alternative to GitHub Copilot.

jan.ai is a self-hosted tool to run different LLMs. github releases

Apple's mlx is an array framework for machine learning on Apple silicon

AUTOMATIC1111's Stable Diffusion web UI is a browser interface for Stable Diffusion.

bretton

This comes from this forum post and adapted with info from this gist

A sample HAproxy configuration using SNI. Using SNI has the advantage that you don't have to mess with the certificates on the HAproxy server itself. Useful with many servers and / or many fast-expiring certificates (letsencrypt).

global
        maxconn         5000
        ulimit-n        16384
        log             127.0.0.1 local0
        uid             99

bretton

Virtual machines on Apple M2 chips, with Ventura

Version

This is version 0.1

Requirements

I want to run VMs with custom networking over a bridge.

bretton

disk usage alternatives to du

• NCurses Disk Usage - ncdu
• Disk Usage/Free Utility - duf
• Duc
• du+rust = dust
• dutree (also rust)
• pydf

bretton

Create a month-by-month income statement in GnuCash

This works for Gnucash 4.12 on a Mac.

Reports > Multicolumn > Custom Multicolumn Report

Click the Options icon.

Set 12 columns.

bretton

Optimal Virtualbox on FreeBSD, running FreeBSD images

For best results:

• Use only a single core per VM (cpus setting). This is critical, more causes problems.
• Set the sysctl.conf settings below

Configure sysctl.conf and reboot

Add to /etc/sysctl.conf and reboot

bretton

Best method to convert CSV to JSON in bash one-liner

wget http://host/file.csv

# csv to json in python, requires a header row
cat file.csv | python -c 'import csv, json, sys; print(json.dumps([dict(r) for r in csv.DictReader(sys.stdin)]))' > file.json

cat file.json |jq

bretton

#!/bin/bash -e
# JAVA_HOME can be passed as argument if not set
if [ ! -d $JAVA_HOME ]; then
	JAVA_HOME=${1}
fi

KEYSTORE=$JAVA_HOME/jre/lib/security/cacerts
if [ ! -f "$KEYSTORE" ]; then
	echo "Keystore not found in '$KEYSTORE'"
	exit 1

bretton

Self-Determination and Routing Capacity

This has been observed in the wild. I'm not the originator, just documenting what I've seen.

Fund a node

You need a bitcoin and lightning network node.

You need to fund it with Bitcoin.

Open genesis channel