Iptables: redirect port to other IP – port
You can use the following shell commands in order to redirect a port to another port.
SCHELSTRAETE.ORG
I.T. minded
Read MoreIptables: redirect port to other IP – port
Linux: simulate memory usage
Using the “stress” application, you can simulate high memory usage of your system.You may use the following command line:
Mysql: script taking dump of all dbs
T-SQL: create a lock
You can create a temporary lock in T-SQL for -for example- testing:
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 :
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:
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:
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: whitelist an ip
First, edit the config file : vi 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
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:
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 }
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…
Linux: Haproxy , set selinux to allow remote backends
With the code below, you can set selinux to allow remote backends.
Avamar: Query postgresql db
admin@xxx:~/>: psql -p 5555 -U viewuser mcdb mcdb=> Example query: SELECT * FROM “public”.”v_clients”; SELECT v_clients.cid, v_clients.client_name, v_clients.client_addr,v_clients.os_type FROM “public”.”v_clients”; select client_name,status_code,domain FROM v_activities_2 WHERE (status_code=30901 or status_code=30915) and recorded_date_time > current_timestamp – interval ’24 hours’
SQL-Server: The query processor ran out of internal resources and could not produce a query plan
from : The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received…
Ispconfig: Enable Letsencrypt certificate for admin console
You can use Letsencrypt certificates for the Ispconfig admin console too.In order to achieve this, you can use the following commands:
Linux: increase inodes on EXT4 file system
If you have a file system with a lot of small files, it it possible that you are running out of inodes. Unfortunately it is not possible to increase the number of inodes on the fly. In order achieve this, you will need to create a new file system, using…