![8vl3onvznkopxa6ny9995yrc4gw[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2021/10/8vl3onvznkopxa6ny9995yrc4gw1-175x150.jpg "Awk & sed Snippets for SysAdmins")
Articles in Data
Synology NAS Hacks
![rhd3hj6zvnqeth7qo8em0alduj0[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/10/rhd3hj6zvnqeth7qo8em0alduj01-150x150.jpg "Synology NAS Hacks")
I’ve been using various Synology NAS devices for many years now, and they’re great. Well, almost. There are a few rough spots that don’t thrill me. These consumer-grade devices are designed to be difficult to …
Finding Duplicate Photos
![9dwz62kvm0gtjya9kwb7pawtk9y[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/10/9dwz62kvm0gtjya9kwb7pawtk9y1-150x150.jpg "Finding Duplicate Photos")
Being a shutterbug and a digital hoarder can get expensive. A couple of days ago, my
TerraMaster D5-300 5-bay DAS crashed. Again. This time it was the power supply. I replaced it only to discover that …
Focus Stacking with Lightroom and Photoshop
![zxulfg358ydpeyelfjppawbkxhr[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2021/10/zxulfg358ydpeyelfjppawbkxhr1-150x150.jpg "Focus Stacking with Lightroom and Photoshop")
Not the usual topic for this blog and not the most comprehensive guide on the subject out there, but here I go anyway. Focus stacking combines multiple photos taken at different focal distances into an …
Generating Honeypot Data Structure
![on7avnij18ozm2jvppgdny2lhlv[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2021/10/on7avnij18ozm2jvppgdny2lhlv1-150x150.jpg "Generating Honeypot Data Structure")
I’ve been fiddling with my inotifywatch scripts to make a better “early-warning” system for ransomware detection and realized I needed a more realistic honeypot data structure. Ransomware is getting more clever and is no longer …
Inventorying NFS Mounts and Mount Options
![4ucne6vs8m7hqdl0el9ddqd1sql[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/10/4ucne6vs8m7hqdl0el9ddqd1sql1-150x150.jpg "Inventorying NFS Mounts and Mount Options")
As time goes by, NFS mounts multiply like rabbits. Added by many different people over the years, these entries present a dizzying variety of mount options – most are a copy-paste job that makes little …
Automatic File Backups in VIM
![bqlpzjqba7fn1jtghunz0z1vv5d[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/10/bqlpzjqba7fn1jtghunz0z1vv5d1-150x150.jpg "Automatic File Backups in VIM")
Having to undo stupid changes to config files is an unfortunate side effect of too few sysadmins supporting too many servers. The VIM editor has some built-in file backup options. However, I find these options …
Joining Text Files and Data Columns
![p65q1znipa66jngo3jjvbnmb7s7-scaled[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/p65q1znipa66jngo3jjvbnmb7s7-scaled1-150x150.jpg "Joining Text Files and Data Columns")
When working with application logs and other text files, it is often useful to view the contents of different source files side-by-side. Here we will take a quick look at various command-line methods for joining …
Decision Making Using Python TOPSIS
![96wed5sso8yxby9c0qj83cnkh6s[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/96wed5sso8yxby9c0qj83cnkh6s1-150x150.jpg "Decision Making Using Python TOPSIS")
In a nutshell, TOPSIS – the Technique for Order of Preference by Similarity to Ideal Solution – seeks out one of many options that is the closest to the ideal option while at the same …
Laziness vs Phishing
![43v0r4nyow1rbpxrr6gunkcbfcj[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/10/43v0r4nyow1rbpxrr6gunkcbfcj1-150x150.jpg "Laziness vs Phishing")
Here’s an interesting article detailing the methods scammers use to steal your one-time passwords for Coinbase.
A Wrapper Script for unrar
![53wmyx6na9379un1mmku8ibq6x6-2[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/53wmyx6na9379un1mmku8ibq6x6-21-150x150.jpg "A Wrapper Script for unrar")
Just a straightforward wrapper script for the unrar command that allows extracting specified filetypes from multipart archives while utilizing all available CPU cores.
Convert XLSX to a MySQL Table
![7auipjfjec4veay7sa4hrw32xzg[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/7auipjfjec4veay7sa4hrw32xzg1-150x150.jpg "Convert XLSX to a MySQL Table")
Some people find it hard to let go of Excel even when the situation is ripe for a database. And so dozens of different versions of the same spreadsheet edited by many people are floating …
Generating IP Whitelists
![sonlxanvz0en50ijq03cedkaz2e[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/sonlxanvz0en50ijq03cedkaz2e1-150x150.jpg "Generating IP Whitelists")
I have several scripts that scan various log files for signs of suspicious activity and block the offending IPs on my Web servers – pretty standard stuff. The trick, of course, is not to block …
Scraping a Web Page in Bash
![clfud46mxf2t5zph2l04zlpgl1d[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/clfud46mxf2t5zph2l04zlpgl1d1-150x150.jpg "Scraping a Web Page in Bash")
Just a scripting exercise because I need to do something important, but I am procrastinating. The idea is simple: grab some URL with text containing somewhat structured data and convert it into a spreadsheet. I …
Generating Random Text Files for Testing
![91ebozy1e3b138waujy28agrngy[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/91ebozy1e3b138waujy28agrngy1-150x150.jpg "Generating Random Text Files for Testing")
Sometimes you need dummy folder structures populated with random data for testing your various scripts and processes – backups, file transfers, encryption, compression, etc. Every time I need something like this, I end up writing …
Renaming Files with exiftool
![b8g72yca7casi5shj7otypjbi20[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/b8g72yca7casi5shj7otypjbi201-150x150.jpg "Renaming Files with exiftool")
Recently I exported a whole bunch of files from Lightroom to a NAS share and filenames like 2E570434-67B7E0489CA2-39354-000017CF24DD8ACD.jpg are not very informative. It would’ve been nice if the filename contained some useful information like date, …
Fixing Sudo
![c3i8vv2eqg40fc05p9whm8yjys0[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/c3i8vv2eqg40fc05p9whm8yjys01-150x150.jpg "Fixing Sudo")
A decade-old massive and easy-to-exploit security hole (CVE-2021-3156) has been found in sudo allowing for full root access by any unprivileged system user. This is one of those rare security bugs you can’t delay remediating.
Bulk Create Linux Users using Salt
![l5km2qq7sz7bbvg5pra24eygsdp-2[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2020/10/l5km2qq7sz7bbvg5pra24eygsdp-21-150x150.jpg "Bulk Create Linux Users using Salt")
Recently I ran into a situation where hundreds of VMs recently built via OpenShift/Ansible automation were missing an important local user account used for security audits. While our automation guys were working on tracking down …
Checking Linux Account Password
![IMG_5456-scaled[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2020/10/IMG_5456-scaled1-150x150.jpg "Checking Linux Account Password")
On occasion you may need to check if an account has a specific password. For example, when you build VMs, you may use some default passwords for some default accounts (i.e. root) that should be …
Updating Lynis
Lynis is an excellent security audit tool for Linux and various Unix derivatives. I have a small wrapper script that runs Lynis via a cron job, does a selective diff with the previous run’s output, …
Hiding Passwords
I’ve touched on this subject previously, but suddenly felt I should repeat myself. The big issue with using passwords from command line is shell history.
Backup Options for Raspberry Pi
Just about every Raspberry Pi I used suffered the same fate: the micro SD card died. It is generally accepted that the expected lifespan of an SD card is around ten years of normal use.
Backing Up WSL Images
Microsoft’s WSL is interesting. I’d go as far as to say that I like it. The mistake here would be to forget that your Linux image is running under Windows, with everything this entails. Making …
![wyryr1sn52gntzn65v4fpz5lc6v[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/wyryr1sn52gntzn65v4fpz5lc6v1-80x80.jpg "Plundering Facebook Photo Albums")
![clfud46mxf2t5zph2l04zlpgl1d[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/clfud46mxf2t5zph2l04zlpgl1d1-80x80.jpg "Scraping a Web Page in Bash")
![DSCF5361[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2020/10/DSCF53611-80x80.jpg "Processing Videos with ffmpeg and Lightroom")
![Cat-Devouring-A-Bird-Pablo-Picasso[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2020/10/Cat-Devouring-A-Bird-Pablo-Picasso1-80x80.jpg "Searching Twitter")
![91ebozy1e3b138waujy28agrngy[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/91ebozy1e3b138waujy28agrngy1-80x80.jpg "Generating Random Text Files for Testing")
![iwoau71okwxqh4jv3k4ook32qps[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/iwoau71okwxqh4jv3k4ook32qps1-80x80.jpg "Finding Cron Jobs")
![5gtysva4wkc8mzc1k3e66vaycxx[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/5gtysva4wkc8mzc1k3e66vaycxx1-80x80.jpg "Understanding Memory Utilization in Linux")
![sy2zeb1vp2h8itlxfbbylw0jrm0[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2019/12/sy2zeb1vp2h8itlxfbbylw0jrm01-80x80.jpg "Validating HTTPS Cache Peers for Squid")
![Photo-2019-10-07-14-39-03_0266[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2019/11/Photo-2019-10-07-14-39-03_02661-80x80.jpg "Verifying SNMP Connectivity on Multiple Hosts")
Latest Comments