Entries Categorized as 'How-To’s'
Author:
erics, October 24th, 2019
All credit to Matt Wilcox for this excellent article, for which this post is based – thank you, Matt! https://mattwilcox.net/web-development/unexpected-ddos-blocking-china-with-ipset-and-iptables/ All commands run as root!
|
|
yum install -y ipset vi blockchina (see below for contents) chmod 755 blockchina ./blockchina |
Do this once only:
|
|
iptables -A INPUT -p tcp -m set --match-set china src -j DROP; service iptables save |
Then add blockchina to the root cron
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
#!/bin/sh # # blockchina # DIR=/etc # Create the ipset list ipset -N china hash:net # remove any old list that might exist from previous runs of this script rm $DIR/cn.zone # Pull the latest IP set for China wget -P $DIR http://www.ipdeny.com/ipblocks/data/countries/cn.zone # Add each IP address from the downloaded list into the ipset 'china' for i in $(cat $DIR/cn.zone ); do ipset -A china $i; done # Update iptables service iptables restart |
Categories: How-To's, Technology Tags: Amazon, Amazon Linux, AWS, Block, China, DDOS, dos, Firewall, ipset, IPTables, Linux, root, traffic
| 
No comments
Author:
erics, October 9th, 2019
Use Case: Export Apple Reminders from MacOS application to cleaned plain text, i.e. remove unwanted spaces, blank lines and square brackets PROCEDURE Click on a single item in the MacOS Reminders app list Select All (either Command-a or use Edit->Select All) Copy (either Command-c or use Edit->Copy) Open Terminal Run cleanme Paste the copied reminders […]
Categories: How-To's, Technology Tags: apple, array, input, List, MacOS, Multi, Multi-line, Multiline, Multiple, perl, Plain, Plaintext, Read, Reminders, STDIN, Terminal, text()
| No comments
Author:
erics, October 3rd, 2019
To sync various cloud resources, use the excellent cli tool rclone from https://rclone.org/docs/ For this use case, the need was to sync from Box to an AWS S3 bucket. Install rclone:
|
|
curl https://rclone.org/install.sh | sudo bash |
Configure both S3 and Box – for remote name labels I just used “S3” and “Box”:
Validate Access and Functionality:
|
|
rclone lsd Box: rclone lsd S3: |
Perform […]
Categories: How-To's, Technology Tags: Amazon, AWS, AWS S3, Box, Clone, rclone, rsync, S3, Sync
| No comments
Author:
erics, September 12th, 2019
Needed to build a feature for a Bookstore tool to have an optional sequence number for the Custom Post Type “books” that would allow items with a seq number to float to the top of the list and be sorted by seq #. The rest of the books would show underneath, sorted alphabetically.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
$querytop = get_posts(array( 'post_type' => 'books', 'numberposts' => -1, 'orderby' => 'meta_value', 'meta_key' => 'book_seq', 'order' => 'ASC', 'meta_query' => array( // meta query takes an array of arrays, watch out for this! array( 'key' => 'book_seq', 'value' => array('', 'NULL'), 'compare' => 'NOT IN' ) ) )); $querybottom = get_posts(array( 'post_type' => 'books', 'numberposts' => -1, 'orderby' => 'post_title', 'order' => 'ASC', 'meta_query' => array( // meta query takes an array of arrays, watch out for this! array( 'key' => 'book_seq', 'compare' => 'NOT EXISTS' ) ) )); $query = array_merge($querytop, $querybottom); |
Categories: How-To's, Technology Tags: bottom, Compare, cpt, Exists, Filter, Float, get_posts, howto, key, meta_key, meta_value, NOT EXISTS, NOT IN, Order, OrderBy, post_type, Query, Seq, Sequence, sort, tips, top, Value, WordPress
| No comments
Author:
erics, August 22nd, 2019
As root:
|
|
PACKAGES=`yum list installed | grep php | awk -F. '{print $1}' | tr "\n\r" " "` echo $PACKAGES yum remove -y $PACKAGES |
~or~
|
|
yum remove php56 php56-cli php56-common php56-devel php56-gd php56-jsonc php56-jsonc-devel php56-mbstring php56-mcrypt php56-mysqlnd php56-pdo php56-pecl-imagick php56-process php56-xml |
THEN:
|
|
yum install php72 php72-bcmath php72-cli php72-common php72-devel php72-gd php72-imap php72-json php72-mysqlnd php72-pdo php72-pecl-apcu php72-pecl-imagick php72-pecl-imagick-devel php72-pecl-memcache php72-php-bcmath php72-php-common php72-php-json php72-process php72-runtime php72-xml php72-mbstring php72-pecl-mcrypt |
Be sure to restart your web server!!
Categories: How-To's, Technology Tags: Amazon, AWS, Install, Linux, php, php7, upgrade, Yum, yum install, yum list, yum remove, yum search
| No comments
Author:
erics, August 4th, 2019
To prevent vim from added net comments, edit the .vimrc file in your home directory, and add:
|
|
autocmd FileType * setlocal formatoptions-=c formatoptions-=r formatoptions-=o |
Categories: How-To's, Technology Tags: Auto-Comment, Comment, Disable, disable auto-comment, howto, line, new, new line, new line comment, tips, vim
| No comments
Author:
erics, August 4th, 2019
I wanted to call a sub-routine based on a variable in Perl, like this:
|
|
our $role = 'master'; &$role; |
but it failed because of use strict:
|
|
Can't use string ("master") as a subroutine ref while "strict refs" in use at /opt/continuent/tungsten/tools/tungsten_find_orphaned line 213. |
To enable using a variable as a reference, simply specify that to Perl:
|
|
use strict no strict "refs"; |
Categories: How-To's, Technology Tags: de-reference, dereference, howto, no strict, perl, Reference, Strict, Subroutine, tips, Variable
| No comments
Author:
erics, August 1st, 2019
Every time I use awk, my respect for it grows! Like grep, find and rsync, it is one of the powerhouse command-line tools in my arsenal. Recently, I needed to list all MySQL binary log files from a starting file forwards in sequence. AWK to the rescue! For example, I knew the starting file was […]
Categories: How-To's, Technology Tags: AWK, binary log file, howto, Index, Log, log file, Match, mysql, tips
| No comments
Author:
erics, July 31st, 2019
While using Confluence, I wanted to learn how to add a simple task checkbox in free-flow text and lists without creating a “real” task. The answer is very easy – just type the square bracket pair [] and the checkbox will appear!
Categories: How-To's, Technology Tags: CheckBox, Confluence, howto, Simple, Task, tips
| No comments
Author:
erics, July 28th, 2019
When I upgraded to Mojave, my laptops were no longer able to connect to my desktop. Deeply frustrating. Long story short, combo of factors: – Mojave filesystems on disk now default to APFS containers – APFS filesystems can ONLY be shared out via SMB! – Hostname resolution in Mojave also seems broken So, the fix […]
Categories: How-To's, Technology Tags: AFS, APFS, Default, File sharing, Finder, howto, MacOS, Mojave, Sharing, SMB, tips
| No comments
