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);

thinkingcap

Looking to create a Software RAID 1 setup for your 2-disk server on Ubuntu Server 20.04?

Let's start with the basics: the official guide by Ubuntu (https://ubuntu.com/server/docs/install/storage) is outdated/wrong. And as of March 2021 it's possible that there's a bug as well with how the bios_grub partitions are created when using multiple disks.

Now on to the solution:

• Select "Custom storage layout" when you reach the storage configuration step of the installer.
• If the disks have existing partitions, click on each disk under AVAILABLE DEVICES and then select REFORMAT. This will (temporarily) wipe out the partitions.

thinkingcap

{
    /**
    * Better Defaults
    **/
    "editor.copyWithSyntaxHighlighting": false,
    "diffEditor.ignoreTrimWhitespace": false,
    "editor.emptySelectionClipboard": false,
    "workbench.editor.enablePreview": false,
    "window.newWindowDimensions": "inherit",
    "editor.multiCursorModifier": "ctrlCmd",

thinkingcap

Import-Module $env:SyncroModule -WarningAction SilentlyContinue

# TODO:
# Cleanup commands after upgrade:
# C:\Windows10Upgrade\Windows10UpgraderApp.exe /ForceUninstall
# Del C:\Windows\UpdateAssistant\*.* /F /Q

#================================================================================
# Configuration
#================================================================================