Anton Grouchtchak Teraskull

Debian 13

Caution Upgrading from Debian 12 to Debian 13 on machines with mdadm has intermittently failed for me; symptom is that grub EFI is not up to date and system boots into BIOS. Root cause under investigation; it might not be related to mdadm.

To start, read the official release notes.

If your install fits into "vanilla Debian plus maybe a handful of 3rd-party repos", then this guide for a simple upgrade to Debian 13 "trixie" from Debian 12 "bookworm" can be helpful. 3rd-party repos are handled with a find command.

Note upgrade is only supported from Debian 12 to Debian 13. If you are on Debian 11, upgrade to Debian 12 first. Then once on Debian 12, you can upgrade to Debian 13.

MongoDB Cheat Sheet

Show All Databases

show dbs

Show Current Database

How to Crack Sublime Text 3.2.2 Build 3211 with Hex Editor (Windows | Without License) ↓

Download & Install Sublime Text 3.2.2 Build 3211
Visit https://hexed.it/
Open file select sublime_text.exe
Offset 0x8545: Original 84 -> 85
Offset 0x08FF19: Original 75 -> EB
Offset 0x1932C7: Original 75 -> 74 (remove UNREGISTERED in title bar, so no need to use a license)

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

MySQL Locations

Mac /usr/local/mysql/bin
Windows /Program Files/MySQL/MySQL version/bin
Xampp /xampp/mysql/bin

Add mysql to your PATH

First Things First

Enable PPA

 sudo apt update
 sudo apt install software-properties-common apt-transport-https curl

Install apt-fast [Yes! it's really fast]

CC0 Textures
3D Textures
CG Bookcase
Texture Haven
Free PBR
Poliigon free section (Non-commercial use)
30 Free PBR materials by Artem Lebedev
Free 5K textures by Miloš Belanec

FIRST THING FIRST

Update OS

sudo apt-get update && sudo apt-get upgrade

	blueprint:
	name: Zigbee2MQTT 2.x - Samsung SmartThings Button - event entity
	description: Automate your Samsung SmartThings button using Zigbee2MQTT.
	domain: automation
	input:
	samsung_smartthings_button:
	name: Samsung SmartThings Button
	description: The Samsung SmartThings button to use
	selector:
	entity:

	#include <stdio.h>
	#include <stdint.h>
	// Philips Sonicare NFC Head Password calculation by @atc1441 Video manual: https://www.youtube.com/watch?v=EPytrn8i8sc
	uint16_t CRC16(uint16_t crc, uint8_t *buffer, int len) // Default CRC16 Algo
	{
	while(len--)
	{
	crc ^= *buffer++ << 8;
	int bits = 0;
	do

	rem to disable private dns
	adb shell settings put global private_dns_mode off

	rem to enable private dns with hostname (example with dns.adguard.com)
	adb shell settings put global private_dns_mode hostname
	adb shell settings put global private_dns_specifier dns.adguard.com