Practical experiences from every day IT – Page 7 – Programming languages, operating systems, appliances and many more

List number of requests from specific IPs from Nginx access-Logs

7. December 2015

less access.log | awk '{print $1}' | sort | uniq -c | sort -n | tail

Deny in iptables based on AS-number

7. December 2015

iptables -N AS_DENY; iptables -I INPUT -j AS_DENY; whois -T route -i origin AS57169 | grep '^route:' | awk '{print $2}' | aggregate -q | xargs -n1 -I% iptables -A AS_DENY -s % -j DROP

Search for entrys containing a specific string

7. December 2015

SELECT * FROM `Liste` WHERE Webseite LIKE '%http:// http://%%'
//the string in this case is "http:// http://"

Compress every folder in the current directory with strongest compression possible

7. December 2015

for D in *; do [ -d "${D}" ] && tar -cf - $D | xz -9 -c - > $D.tar.xz; done