reverse proxy setting wordpress, about certbot snap and acme.sh

Note for building 2+ tier web server

reverse proxy wordpress note: 
fastcgi_param HTTPS 1;
taken frrom:
Fixing a NGINX Wordpress HTTP 302 redirect loop - Austin's Nerdy Things (austinsnerdythings.com)
nyxi – Wordpress Nginx redirect loop

omit comments on files

 egrep -v '^[[:blank:]]*#|^[[:blank:]]*$' <file_name>

taken from:

https://stackoverflow.com/questions/17392869/how-to-print-a-file-excluding-comments-and-blank-lines-using-grep-sed

ONLY_FULL_GROUP_BY

2020/02/14 16:27:01 [error] 199#199: *1329 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to a member function fetch_row() on bool in /var/www/xxx/admin/modules/reporting/index.php:114

iki dikarenakan
ONLY_FULL_GROUP_BY di mysql

Dibiasakan Menulis

Dengan adanya keyboard baru, diharapkan saya bisa menjadi rajin menulis lagi. Ben gak edan

mancinglog.sh

berguna untuk mencari korelasi antara ip address / file di access.log
------------------------------------------------------------------------------------
start script
------------------------------------------------------------------------------------

#!/bin/bash
logpath=/var/log/nginx/access.log
ARRAY=()
getip=()
getfile=()

function getfiles {
        echo "getfiles param " ${getip[@]}
        pat=$(echo ${getip[@]}|tr " " "|")
        getfile+=($(grep -Ew $pat $logpath| cut -f 7 -d " " | sort | uniq))
        uniqf=($(printf "%s\n" "${getfile[@]}" | sort | uniq -c | sort -rnk1 | awk '{ print $2 }'))
        unset getfile
        getfile=("${uniqf[@]}")
        printf "%s\n" "${getfile[@]}" > files.txt
        echo "getfiles result " ${getfile[@]}
        getips
}



function getips {
        echo "getips param " ${getfile[@]}
        pat=$(echo ${getfile[@]}|tr " " "|")
        getip+=($(grep -Ew $pat $logpath| cut -f 1 -d " " | sort | uniq))
        uniqi=($(printf "%s\n" "${getip[@]}" | sort | uniq -c | sort -rnk1 | awk '{ print $2 }'))
        unset getip
        getip=("${uniqi[@]}")
        printf "%s\n" "${getip[@]}" > ips.txt
        echo "getips result "${getip[@]}
        getfiles
}

getfile=( `cat "files.txt"` )
getip=( `cat "ips.txt"` )
#getips $1
getfile+=($1)
getips

install solaris openstack on virtualbox

Jadi begini.. ternyata gak support

setelah lihat di web:
http://docs.oracle.com/cd/E36784_01/html/E37629/gnwoi.html#scrolltoc

Oracle Solaris Kernel Zones can run in guests on Oracle VM Server for SPARC. Each Oracle VM Server for SPARC domain has an independent limit for the number of kernel zones that you can run. The limit is 768 for SPARC T4 or SPARC T5 systems, and 512 for SPARC M5 or SPARC M6 systems.
Kernel zones cannot run in Oracle VM Server for x86 guests or on Oracle VM VirtualBox.

Gemblung right?

fix locale

fix locale on some python or another script that locale-sensitive

export LANGUAGE=en_US.UTF-8
export LANG=en_US.UTF-8
export LC_ALL=en_US.UTF-8
locale-gen en_US.UTF-8
sudo dpkg-reconfigure locales

 taken from:
http://askubuntu.com/questions/205378/unsupported-locale-setting-fault-by-command-not-found

sha512sum

to generate recursively:
find . -type f -exec sha512sum {} \; > sha512sum-${PWD##*/}

to check:
sha512sum -c sha512sum-${PWD##*/} | grep -i fail

ps.: "${PWD##*/}" is only the directory name, like: "pwd | rev | cut -d / -f1 | rev"

from:
http://www.shell-fu.org/lister.php?id=850

Remedial for hacked incident

 sudo grep '/alias.php\|/Association.php\|/blog.php\|/buffer.php\|/cache.php\|/class.wpcom-json-api-get-media-endpoint.php\|/db.php\|/dirs.php\|/file.php\|/footer.php\|/functions.php\|/global.php\|/idna_convert.class.php\|/info.php\|/menu.php\|/options.php\|/patError.php\|/PlainHTTPFetcher.php\|/shortcodes.php\|/twentyten.php\|/twentythirteen.php\|/utf.php\|/vs3xmo1.php\|/vs3xmo1.php' /var/log/xxx/xx-xx.com_access_log | cut -f 1 -d " " | sort |


find /home/ -type f -iname "*.php" -print0 | xargs -0 grep -i "qV="

https://gist.github.com/facelordgists/5761101

http://houseoflaudanum.com/navigate/snippets/removing-spam-from-postfix-queues/

This command does several things.

1. Read in the mailqueue
2. Look for sender address that end with `example.com`
3. Ignore senders with valid addresses (`david` and `john`)
4. Deletes all those messages from the queue

$ mailq | tail +2 | grep -v '^ *(' | awk 'BEGIN { RS = "" } { if ($7 ~ "example.com$" && $7 !~ "^david|^john" && $9 == "" ) print $1 } ' | tr -d '*!' | sudo postsuper -d -

http://www.cyberciti.biz/faq/searching-multiple-words-string-using-grep/

http://www.cyberciti.biz/tips/howto-postfix-flush-mail-queue.html

To remove all mail from the queue, enter:
# postsuper -d ALL

To remove all mails in the deferred queue, enter:
# postsuper -d ALL deferred

enable ssh on mac os x

SSH access by users is controlled by the local copy of Directory Services. (Controlled using dscl)

First off run dscl . list /Groups | grep 'access_ssh'. If the returned value says com.apple.access_ssh-disabled then all users have SSH access. If not, then we need to give the user access.

To add the user you need to run:

sudo dscl . append /Groups/com.apple.access_ssh user USERNAME

(replace USERNAME with the short username of the user) as well as:

sudo dscl . append /Groups/com.apple.access_ssh groupmembers `dscl . read /Users/USERNAME GeneratedUID | cut -d " " -f 2`

(replace USERNAME with short username as well)

taken from:

http://superuser.com/questions/166179/how-to-enable-remote-access-for-another-account-on-mac-remotely-via-ssh

InnoDB: Completed initialization of buffer pool InnoDB: Error: checksum mismatch in data file ./ibdata1

untuk menangani:

131104 11:17:16 InnoDB: Completed initialization of buffer pool InnoDB: Error: checksum mismatch in data file ./ibdata1 131104 11:17:16 InnoDB: Could not open or create data files

maka dilakukan

mysqld_safe  --innodb_force_recovery 4

diambil dari 

http://lifeandshell.com/mysql-innodb-error-checksum-mismatch/

Finding out largest tables on MySQL Server

mysql> SELECT CONCAT(table_schema, '.', table_name),

    ->        CONCAT(ROUND(table_rows / 1000000, 2), 'M')                                    rows,

    ->        CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G')                    DATA,

    ->        CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G')                   idx,

    ->        CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size,

    ->        ROUND(index_length / data_length, 2)                                           idxfrac

    -> FROM   information_schema.TABLES

    -> ORDER  BY data_length + index_length DESC

    -> LIMIT  10;

taken from: http://www.mysqlperformanceblog.com/2008/02/04/finding-out-largest-tables-on-mysql-server/

rapalan mysql akbar :D

mysqlcheck --all-databases -r #repair
mysqlcheck --all-databases -a #analyze
mysqlcheck --all-databases -o #optimize

autologin wp

/** Loads the WordPress Environment and Template */

require('./wp-blog-header.php');

$creds = array();

$creds['user_login'] = 'admin';

$creds['user_password'] = 'passwordente';

$creds['remember'] = true;

$user = wp_signon( $creds, false );

header('Location: http://domainente.com/wp-admin');

list fungsi excel

=RANDBETWEEN(DATE(bottomdate),DATE(topdate)

http://www.techrepublic.com/blog/microsoft-office/generate-random-dates-within-a-specific-date-range/

=INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1)

http://www.ozgrid.com/Excel/excel-random-pick.htm

fake name generator

http://dailydoseofexcel.com/archives/2006/07/13/random-name-generator/

rupa-rupa

UPDATE wp_posts SET post_content = replace(tablefield, "datjong24th.com", "24thphoto.com");

du -sk * | sort -n | while read size fname; do for unit in k M G T P E Z Y; do if [ $size -lt 1024 ]; then echo -e "${size}${unit}\t${fname}"; break; fi; size=$((size/1024)); done; done

du -sk .[!.]* * | sort -n | while read size fname; do for unit in k M G T P E Z Y; do if [ $size -lt 1024 ]; then echo -e "${size}${unit}\t${fname}"; break; fi; size=$((size/1024)); done; done

 find /home/ -type f -iname "*.php" -print0 | xargs -0 sha512sum | grep -f /home/bidikdata/analisa-vrs/sidik.data

find -type f -mtime -30 | more

find /home/ -type f -newermt 2013-05-20 ! -newermt 2013-05-25 -iname "*.php" | more

quota at amazon

http://askubuntu.com/questions/109585/quota-format-not-supported-in-kernel

macport startup install

###########################################################
# A startup item has been generated that will aid in
# starting logwatch with launchd. It is disabled
# by default. Execute the following command to start it,
# and to cause it to launch at startup:
#
# sudo launchctl load -w /Library/LaunchDaemons/org.macports.logwatch.plist
###########################################################

Simple Search Engine

http://pctechtips.org/a-simple-php-search-engine-tutorial/
http://onlamp.com/pub/a/php/2002/10/24/simplesearchengine.html?page=3

xss and sql injection prevention

//filtering input for xss and sql injection
$input = strip_tags( $input );
$input = mysql_real_escape_string( $input );
$input = trim( $input );