thinkingcap

docker buildx bake \
 --load \
 --set static-builder-gnu.args.PHP_VERSION=8.3 static-builder-gnu \
 --set '*.platform=linux/amd64'
 
 docker cp $(docker create --name static-builder-gnu dunglas/frankenphp:static-builder-gnu):/go/src/app/dist/frankenphp-linux-$(uname -m) frankenphp ; docker rm static-builder-gnu

thinkingcap

nano /etc/lsws-rc/extra.d/mywebappname.rewrite.block-bot.conf

# Block unwanted bots by User-Agent
RewriteCond %{HTTP_USER_AGENT} "(scrapy|acunetix|BLEXBot|domaincrawler\.com|LinkpadBot|MJ12bot/v|majestic12\.co\.uk|AhrefsBot|TwengaBot|SemrushBot|Amazonbot|nikto|winhttp|Xenu\s+Link\s+Sleuth|Baiduspider|HTTrack|clshttp|harvest|extract|grab|miner|python-requests|ClaudeBot)" [NC]
RewriteRule .* - [F,L]

thinkingcap

if ($http_user_agent ~* "(?:acunetix|gptbot|BLEXBot|domaincrawler\.com|LinkpadBot|MJ12bot/v|majestic12\.co\.uk|bingbot|AhrefsBot|TwengaBot|SemrushBot|Amazonbot|nikto|winhttp|Xenu\s+Link\s+Sleuth|Baiduspider|HTTrack|clshttp|harvest|extract|grab|miner|python-requests|meta-externalagent)") {
	return 403;
}

thinkingcap

OpenVPN Server and certificate management on MikroTik

Contents

• Setup OpenVPN server and generate certificates
• Add a new user
• Setup OpenVPN client
• Decrypt private key to avoid password asking (optional)
• Delete a user and revoke his certificate
• Revert OpenVPN server configuration on MikroTik

thinkingcap

#!/bin/bash

# Set a container name of your choice
CONTAINER=fed-insync

# Create the toolbox container AND initial update
distrobox-create --name $CONTAINER --image fedora:latest
distrobox enter $CONTAINER -- sudo dnf update -y

# Insync Repo

thinkingcap

<button wire:click="save" wire:loading.attr="data-loading" class="relative">
    <div class="[[data-loading]>&]:opacity-0">Save changes</div>

    <div class="[[data-loading]>&]:opacity-100 opacity-0 absolute inset-0 flex items-center justify-center">
        <!-- loading spinner... -->
    </div>
</button>

thinkingcap

47.128.41.56
47.128.22.227
47.128.52.255
47.128.25.247
195.191.219.130
47.128.44.2
47.128.29.213
47.128.56.5
195.191.219.132
47.128.119.100

thinkingcap

sudo apt install php8.3 php8.3-bcmath php8.3-bz2 php8.3-cli php8.3-common php8.3-curl php8.3-dev php8.3-gd php8.3-igbinary php8.3-imagick php8.3-intl php8.3-mbstring php8.3-msgpack php8.3-mysql php8.3-opcache php8.3-pgsql php8.3-readline php8.3-redis php8.3-ssh2 php8.3-tidy php8.3-xml php8.3-xmlrpc php8.3-zip php8.3-sqlite3

thinkingcap

# Define the paths to the MSI files
$virtioWinMSI = "D:\virtio-win-gt-x64.msi"
$guestAgentMSI = "D:\guest-agent\qemu-ga-x86_64.msi"

# Install Virtio-Win MSI
Start-Process msiexec.exe -ArgumentList "/i `"$virtioWinMSI`" /qn" -Wait


# Add the Root CA for the drivers to the TrustedPublisher and the Root CA store

thinkingcap

DELETE from wp_users where wp_users.ID not in (
	SELECT meta_value FROM wp_postmeta WHERE meta_key = '_customer_user'
) AND wp_users.ID not in (
	select distinct(post_author) from wp_posts
);

delete from wp_usermeta where wp_usermeta.user_id not in (select ID from wp_users);