#!/bin/sh set -o pipefail PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin #--------------------------------------------------- # (1) set up all the mysqldump variables…

You can create a temporary lock in T-SQL for — for example — testing: BEGIN TRAN SELECT 1 FROM TABLE WITH (TABLOCKX) WAITFOR DELAY '00:02:00' ROLLBACK TRAN GO

With ffmpeg you can also decrease the size (aka quality) of an mp4 file on the Linux command line. You can use the following example, which will generate a +/- 5MB file: ffmpeg -i original.mp4 -fs 5M…

You can optimize JPEG images on the Linux command line (= reduce the size to load images faster). In order to achieve that, you can make use of the 'jpegoptim' application. On Ubuntu/Debian systems:…

Create a file 'allowed-hosts' in the 'work_dir' (which can be found in the denyhosts.conf file), located at /var/lib/denyhosts on Ubuntu, containing the IP addresses. See the example below: cat <>…

Find IP Address to Unblock Log in to your server via SSH and type in the following command: iptables -L -n Look for the IP address you want to unblock / unban. Now we must find the jail name this IP…

First, edit the config file: vi /etc/fail2ban/jail.conf Then, check the line: ignoreip = Now add all the IPs you want. Each IP or IP range must be placed here separated by a space. Ex: 192.168.0.1…

Within HAProxy it is possible to redirect all HTTP traffic to HTTPS. It is sufficient to add the following rule within the frontend section: frontend incoming80 bind 10.1.1.13:80 redirect scheme…

Within HAProxy it is possible to redirect all HTTP traffic to HTTPS. It is sufficient to add the following rule within the frontend section: frontend incoming80 bind 10.1.1.13:80 redirect scheme…

If you configure HAProxy by default, the backends will receive the IP address of the HAProxy as the incoming IP address. Some applications (or people) don't want that. It is possible to configure…