silverwind

Fix logrotate error regarding mysql on Ubuntu

Sometimes if you are mailed of cronjobs, will may got an error like this:

/etc/cron.daily/logrotate:
error: error running shared postrotate script for '/var/log/mysql.log /var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log /var/log/mysql/error.log '
run-parts: /etc/cron.daily/logrotate exited with return code 1

Well, don't panic! Also don't ignore it! :)

Cloudflare DDNS bash client with systemd

This is a bash script to act as a Cloudflare DDNS client, useful replacement for ddclient.

Look out!

A newer version is available!

This gist will no longer update, instead please go to https://github.com/lifehome/systemd-cfddns for more updated versions.

How to use?

Put the cfupdater files to /usr/local/bin

If you are using IPv4 for A record, append -v4 to cfupdater in the following systemd service unit.

When you need to set value to "UV_THREADPOOL_SIZE"?

Libuv has a default thread pool size of 4, and uses a queue to manage access to the thread pool - the upshot is that if you have 5 long-running DB queries all going at the same time, one of them (and any other asynchronous action that relies on the thread pool) will be waiting for those queries to finish before they even get started.
Note, however, that tuning UV_THREADPOOL_SIZE may make more sense for a standalone application like a CLI written in Node.js. If you are standing up a bunch of Node.js processes using the cluster module then I would be surprised if tuning UV_THREADPOOL_SIZE was particularly beneficial for you. But if your application resembles the web tooling benchmarks then tuning UV_THREADPOOL_SIZE may help with performance.

`<script> async, defer, async defer, module, nomodule, src, inline` - the cheat sheet

This document is a comparison of various ways the <script> tags in HTML are processed depending on the attributes set.

If you ever wondered when to use inline <script async type="module"> and when <script nomodule defer src="...">, you're in the good place!

Note that this article is about <script>s inserted in the HTML; the behavior of <script>s inserted at runtime is slightly different - see Deep dive into the murky waters of script loading by Jake Archibald (2013)

title	author	date	source	notoc
LDAP Search Filter Cheatsheet	Jon LaBelle	January 4, 2021	https://jonlabelle.com/snippets/view/markdown/ldap-search-filter-cheatsheet	true

LDAP Search Filter Cheatsheet

	// The Monaco Editor can be easily created, given an
	// empty container and an options literal.
	// Two members of the literal are "value" and "language".
	// The editor takes the full size of its container.

	// Important Bit #1: Typescript must see the 'file' it is editing as having
	// a .tsx extension
	const modelUri = monaco.Uri.file("foo.tsx")

	// Important Bit #2

	# Disable / Enable Dashboard
	# Settings / Mission control / Dashboard (selector) - Off
	# or
	# completely disable:
	defaults write com.apple.dashboard mcx-disabled -boolean YES; killall Dock
	# enable again:
	#defaults write com.apple.dashboard mcx-disabled -boolean NO; killall Dock

	defaults write NSGlobalDomain NSAutomaticWindowAnimationsEnabled -bool false
	defaults write NSGlobalDomain NSWindowResizeTime -float 0.001

	-- Thank @sbengo to figure out foreign_keys constraints is defaults to false in sqlite
	-- Enable to delete logs by cascading delete
	PRAGMA foreign_keys = ON;

	WITH n_build_ids_per_repo as (
	SELECT build_id
	FROM (
	SELECT
	build_id,
	build_repo_id,

	#!/bin/bash

	## HOW TO RUN
	#
	# 1. Enter Recovery mode w. CMD+R
	# 2. cd /Volumes/Macintosh\ HD
	# 3. sh /Volumes/Macintosh\ HD/Users/disable.sh

	## LOCATIONS
	#

	#!/usr/bin/python3

	from functools import partial

	def colors16():
	for bold in [0, 1]:
	for i in range(30, 38):
	for j in range(40, 48):
	print(f'\x1b[{bold};{i};{j}m {bold};{i};{j} \|\x1b[0m', end='')
	print()