Guillaume Quittet gquittet

Cake QOS fix on TUF AX3000 v2

Create a script in /jffs/scripts called qos-start

with this content

#!/bin/sh
sed -i 's/tc filter add dev .*/tc filter add dev $DLIF parent ffff: protocol all prio 10 u32 match u32 0 0 flowid 1:1 action mirred egress redirect dev $MIF/g' /tmp/qos

Sum size of binlog for a specific day

ls -lha binlog* | grep "Oct 20" | awk '{print $5}' | numfmt --from=iec | awk '{ sum += $1; } END { print sum; }' | numfmt --to=iec

Convert it to readable text file

mysqlbinlog -vv --base64-output=decode-rows binlog.190611 &gt; binlog.190611.txt

IntelliJ insert current date live template

Go to Settings -> Editor -> Live Tempalates
Click on "+" icon
Name the abbreviation date
Add description: Insert current date using RFC 8601
Write following template text: $date$
Edit variable and write date and the following expression: date("yyyy-MM-dd'T'HH:mm:ss.SSSZ")

VPS

Locale

Edit /etc/locale.conf to change LANG to en_US.UTF-8

LANG=en_US.UTF-8

NGinx Proxy Manager

Forward request IP: proxy_set_header X-Forwarded-For $remote_addr;

Disable lid suspend

Create a file sudo vim /etc/systemd/logind.conf.d/00-laptop.conf

Append this content in it

[Login]
HandleLidSwitch=ignore
HandleLidSwitchExternalPower=ignore
HandleLidSwitchDocked=ignore

	{
	"summary": "{{environment}} deployment {{status}} on {{project.name}}",
	"themeColor": "412888",
	"title": "The {{environment}} deployment is {{status}} on {{project.name}}",
	"sections": [
	{
	"activityTitle": "{{user.name}}",
	"activitySubtitle": "{{deployment.finished_at}}",
	"activityImage": "{{user.avatar_url}}",
	"text": "The {{environment}} deployment is {{status}}."

	#!/usr/bin/env sh

	install_missing_dep() {
	if ! command -v "$1" > /dev/null 2>&1; then
	echo "Installing $1..."
	apk add "$1"
	fi
	}

	DEPS="curl jq"

	printf "
	\e[1mDocker Network Usage\e[0m
	\e[3mRunning containers (I/O):\e[0m $(docker stats --format "table {{.NetIO}}" --no-stream \| tail -n +2 \| sed "s/kB/KB/g" \| sed "s/B//g" \| cut -d '/' -f1 \| numfmt --from=iec \| awk '{ sum += $1; } END { print sum; }' \| numfmt --to=iec) / $(docker stats --format "table {{.NetIO}}" --no-stream \| tail -n +2 \| sed "s/kB/KB/g" \| sed "s/B//g" \| cut -d '/' -f2 \| numfmt --from=iec \| awk '{ sum += $1; } END { print sum; }' \| numfmt --to=iec)
	\e[3mAll containers (I/O):\e[0m $(docker stats --all --format "table {{.NetIO}}" --no-stream \| tail -n +2 \| sed "s/kB/KB/g" \| sed "s/B//g" \| cut -d '/' -f1 \| numfmt --from=iec \| awk '{ sum += $1; } END { print sum; }' \| numfmt --to=iec) / $(docker stats --all --format "table {{.NetIO}}" --no-stream \| tail -n +2 \| sed "s/kB/KB/g" \| sed "s/B//g" \| cut -d '/' -f2 \| numfmt --from=iec \| awk '{ sum += $1; } END { print sum; }' \| numfmt --to=iec)
	"

	/*
	This has been generated by the overpass-turbo wizard.
	The original search was:
	“aminity=*”
	*/
	[out:json];
	// gather results
	(
	// query part for: “aminity=*”
	node["amenity"="recycling"]["recycling_type"="centre"]["ownership"!="private"](around:10000,lat,lon);