Mysql: script taking dump of all dbs
1608, 2017
1408, 2017
T-SQL: create a lock
You can create a temporary lock in T-SQL for -for example- testing:
0908, 2017
FFmpeg: decrease size of mp4 file
With ffmpeg you can also decrease the size (aka: quality) of a mp4 file on linux command line.You can use the following example, which will generate a +/- 5Mb file :
0908, 2017
Jpegoptim: How to Optimize and Compress JPEG in Linux Commandline
You can optimize Jpeg images on 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: To optimize the jpeg file:
0708, 2017
Denyhosts: Add IP to whitelist
Create a file ‘allowed-hosts’ in the ‘work_dir’ (can be found in the denyhosts.conf file), which is /var/lib/denyhosts on Ubuntu, containing the ip.See the example below:
0708, 2017
Fail2ban: unblock an ip
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 address is in. To do so, type the following: fail2ban-client status unban the IP: fail2ban-client set ssh unbanip 192.168.1.1
0708, 2017
Fail2ban: whitelist an ip
First, edit the config file : vi /etc/fail2ban/jail.conf Then, check the line : ignoreip = Add now add all ip you want. Each IP or range IP must be placed here with a space. Ex: 192.168.0.1 192.168.5.0/32 Save. And restart Fail2Ban: service fail2ban restart
0408, 2017
HAProxy: redirect http traffic to https
Within HAProxy it is possible to redirect all http traffic to https.It is sufficient to add the following rule within the frontend section:
0408, 2017
HAProxy: redirect http traffic to https
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 https if !{ ssl_fc }
0408, 2017
HAProxy: configure transparent proxy
If you configure HAProxy by default, the backends will receive the IP address of the HAProxy as incoming IP address. Some applications (or people) don’t want that. It is possible to configure haproxy as transparent proxy, so that the IP of the client is being used. First of all you need to ensure that you have a Linux kernel with