hashcode86

-- First method
SELECT * FROM t1
LEFT JOIN t2 ON t1.id = t2.id
UNION
SELECT * FROM t1
RIGHT JOIN t2 ON t1.id = t2.id

-- Second Method
-- The query above works for special cases where a FULL OUTER JOIN operation would not produce any duplicate rows. 
-- The query above depends on the UNION set operator to remove duplicate rows introduced by the query pattern. 

hashcode86

Tinc setup instructions for Ubuntu and Windows. Based on 1 2.

Start here.

1. sudo apt-get install -y build-essential libncurses5-dev libreadline6-dev libzlcore-dev zlib1g-dev liblzo2-dev libssl-dev
2. Download and install tinc
   2.1. Download the latest tinc 1.1 source package ( current: wget https://www.tinc-vpn.org/packages/tinc-1.1pre16.tar.gz -O tinc.tar.gz)
   • tar -xf tinc.tar.gz --one-top-level --strip-components=1
   • cd tinc
   • ./configure

hashcode86

List of Open-Source or Free P2P VPNs

P2P VPNs allow you to connect two or more hosts together and do some stuff like play games or test out services just like you were on one real physical local network (LAN). Even when you are on different continents.

List

• https://www.freelan.org/
• https://haguichi.net/ (Hamachi free GUI client)
• https://www.tinc-vpn.org/download/
• https://edgevpn.io/about/
• https://github.com/ntop/n2n

hashcode86

Enable Processor Boost Mode Control in Windows

Disable Turbo Boost to Reduce Power Consumption and Heat

Why Do We Need It?

The thing is if your laptop cpu is getting really hot and you are trying to undervolt it then chances are 99% that there are no method to do so. I have also tried to do undervolt my Ryzen 7 5800H but no luck. Because the bios doesn't allow that much control over the cpu. I don't know the specific reasons for the manufactures to restrict such a great thing. But with this you can disable the Turbo Boost. While this might sounds stupid but trust me you won't see a massive difference in performance after turned it off.

When You should Do It?

hashcode86

Installing FreeSWITCH 1.10.X on Ubuntu 18.04 | 20.04 | 22.04 LTS

Introduction

FreeSWITCH is a software defined telecom stack that runs on any commodity hardware. FreeSWITCH can handle voice, video and text communication and support all popullar VoIP protocols. FreeSWITCH is flexible and modular, and can be used in any way you can imagine

This guide demonstrates how to get it install FreeSWITCH and get it up and running on a Ubuntu 20.04 LTS machine

Prerequisites

To follow along with this guide, you need one Ubuntu 20.04 LTS server which has prerequisite packages installed and configured. In order to install required packages issue following command

hashcode86

All Kazoo 4.2.x sup-commands

https://github.com/telephoneorg/kazoo-builder/releases/download/v4.2/sup_commands.txt

sup hotornot_maintenance get_rate_version 
sup hotornot_maintenance local_summary 
sup hotornot_maintenance rates_between Pre Post
sup hotornot_maintenance rates_for_did DID
sup hotornot_maintenance rates_for_did DID AccountId
sup hotornot_maintenance rates_for_did DID Direction RouteOptions

hashcode86

Create rabbitmq operator

RABBITMQ_OPERATOR=https://gist.githubusercontent.com/hashcode86/4d6c4c32bd59b0843f22eaec8a019f6d/raw/4d3142af45d88ed3ccc9060ae843917f57df44ea/cluster-operator.yaml

curl ${RABBITMQ_OPERATOR} | kubectl apply -f -
echo 'wait 10s after creating cluster-operator...'; sleep 10;

Create rabbitmq 3 nodes cluster

hashcode86

Windows Preparation

1. Ensure hypervisor functionality is enabled in BIOS.

   • I know it sounds stupid, but if you already have it enabled, disable it, restart the machine, and enable it again.
   • Otherwise you will hit microsoft/WSL#5363

2. Launch a PowerShell prompt in Administrator mode [Win+X > Windows PowerShell (Admin)]

dism.exe /online /enable-feature /featurename:Microsoft-Windows-Subsystem-Linux /all /norestart