ipbastola

JQ to filter JSON by value

Syntax: cat <filename> | jq -c '.[] | select( .<key> | contains("<value>"))'

Example: To get json record having _id equal 611

cat my.json | jq -c '.[] | select( ._id | contains(611))'

Remember: if JSON value has no double quotes (eg. for numeric) to do not supply in filter i.e. in contains(611)

ipbastola

Safest way to clean up boot partition - Ubuntu 14.04LTS-x64, Ubuntu 16.04LTS-x64

Reference

Case I: if /boot is not 100% full and apt is working

1. Check the current kernel version

$ uname -r 

ipbastola

CIFS Mount on Ubuntu 14.04

1. Install packages

$ sudo apt-get install cifs-utils

2. Create a Mount point Directory

$ sudo mkdir /mnt/CIFSMOUNT

ipbastola

How to find duplicates in Excel: identify, highlight count, filter, and more

Link: https://www.ablebits.com/office-addins-blog/2016/03/02/identify-duplicates-excel/

ipbastola

Free System Space from Massive Logs

1. Remove compressed log files from /var/log

$ sudo find /var/log -type f -name "*.gz" -delete

2. Truncate Log files

$ cd /var/log

ipbastola

Nginx 502 Fix

References

https://www.digitalocean.com/community/questions/getting-nginx-fpm-sock-error

http://stackoverflow.com/questions/23443398/nginx-error-connect-to-php5-fpm-sock-failed-13-permission-denied/23487409#23487409

http://geektnt.com/how-to-disable-xmlrpc-php.html