vpnwall-services

#!/bin/bash
salt 'mynode' cmd.run '/usr/bin/autossh -M 0 -o "StrictHostKeyChecking=no" -o "PubkeyAuthentication=yes" -o "PasswordAuthentication=no" -o ExitOnForwardFailure=yes -o "ServerAliveInternal=30" -o ServerAliveCountMax=3 -i /root/.ssh/id_rsa -NR 7999:localhost:22 myremoteuser@remoteserver.public -p 2222 &'

vpnwall-services

#!/bin/bash
cd /etc/grub.d
mv 10_linux 96_OVHkernel
apt install linux-image-4.19.0-12-amd64
apt install linux-headers-4.19.0-12-amd64
update-grub

#https://askubuntu.com/questions/871336/switching-from-ovh-kernel-to-default-kernel-without-reinstalling-ubuntu

vpnwall-services

SELECT
  *
FROM
  wp_posts i
WHERE
  i.post_type = 'attachment'
  AND
  NOT EXISTS (SELECT * FROM wp_posts p WHERE p.ID = i.post_parent)
  AND
  NOT EXISTS (SELECT * FROM wp_postmeta pm WHERE pm.meta_key = '_thumbnail_id' AND pm.meta_value = i.ID)

vpnwall-services

select JSON_OBJECT
  ('id', id,
   'user_login', user_login,
   'user_pass', user_pass,
   'user_nicename', user_nicename,
   'user_email', user_email,
   'user_url', user_url,
   'user_registered', user_registered,
   'user_activation_key', user_activation_key,
   'user_status', user_status,

vpnwall-services

GRAYLOG 101

Search query example

gl2_source_input:xxxxxxxx AND xmlrpc.php AND NOT "403"

https://docs.graylog.org/en/3.3/pages/searching/query_language.html

vpnwall-services

APACHE2 BECNHMARKING 101

Simple becnhmark

ab -t 30 -n 16000 -c 100 https://myurl.local/

Becnhmark while connected with curl request use

vpnwall-services

Fast delete with rsync

mkdir /tmp/empty
rsync -a --delete /tmp/empty /tmp/big_folder/

And with Perl

vpnwall-services

#!/bin/bash
apt install php7.4-xdebug
echo "xdebug.trace_enable_trigger = 1" >> /etc/php7.4/mods-available/xdebug.ini
echo "xdebug.trace_format = 1" >> /etc/php7.4/mods-available/xdebug.ini
service php7.4-fpm restart
curl -L https://myurl.local/index.php?XDEBUG_TRACE=1
cat /tmp/trace*

vpnwall-services

Umount partition

umount /dev/sdx1

Modify entire disk

fdisk /dev/sdx

Delete actual partition and recreate it (WITHOUT DELETING XFS SIGNATURE !!!)

vpnwall-services

LOG CENTRALIZATION 101

In apache2 Vhost

ErrorLog "|/etc/apache2/scripts/apache2-error-syslog.sh" customized_logs
CustomLog "|/etc/apache2/scripts/apache2-access-syslog.sh" customized_logs