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

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

<?php
/**
 * Plugin Name: WooCommerce Upsells Shortcode
 * Plugin URI: http://skyver.ge/51
 * Description: Adds a shortcode to output WooCommerce product upsells; removes them from the original location when used
 * Author: SkyVerge
 * Author URI: https://www.skyverge.com/
 * Version: 1.0.0
 *
 * Copyright: (c) 2016 SkyVerge, Inc. ([email protected])

thinkingcap

#/!/bin/bash
# Most of the tweaks here are wrapped up in gmailmig
#    https://code.google.com/p/gmailmig/
#
# Props to brave folks who figured this out before me
#    http://imapsync.lamiral.info/FAQ
#    http://www.thamtech.com/blog/2008/03/29/gmail-to-google-apps-email-migration
#    http://seagrief.co.uk/2010/12/moving-to-google-apps-with-imapsync/
#    http://blog.mcfang.com/tag/imapsync/
#

thinkingcap

# Optimized MySQL configuration by Fotis Evangelou - Updated Jan 2016
#
# The settings provided below are a starting point for a 4GB-8GB RAM server with 4 CPU cores.
# If you have less or more resources available you MUST adjust accordingly to save CPU, RAM and disk I/O usage.
# To fine tune these settings for your system, use MySQL DB diagnostics tools like:
# https://launchpad.net/mysql-tuning-primer
# or
# http://blog.mysqltuner.com/download/
# Note that if there is no comment beside a setting, then you don't need to adjust it.