![8vl3onvznkopxa6ny9995yrc4gw[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2021/10/8vl3onvznkopxa6ny9995yrc4gw1-175x150.jpg "Awk & sed Snippets for SysAdmins")
Articles in Applications
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 …
WordPress: Post-processing of the image failed
![ytioq398kc1wnvvz95uixhcn5ii[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/ytioq398kc1wnvvz95uixhcn5ii1-150x150.jpg "WordPress: Post-processing of the image failed")
This particular WordPress issue appeared with version 5.3 and is refusing to go away. However, the problem here is not with WordPress but with the Apache ModSecurity. The particular ModSecurity rule in question is 200003 …
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 …
Processing Videos with ffmpeg and Lightroom
![DSCF5361[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2020/10/DSCF53611-150x150.jpg "Processing Videos with ffmpeg and Lightroom")
On occasion I wondered how to apply advanced photo filters to my lackluster GoPro and drone videos. You know, not the basic exposure/contrast/saturation or the cheesy special effects you find in video editors, but something …
Searching Twitter
![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-150x150.jpg "Searching Twitter")
Here are just a few hopefully useful tips for searching Twitter to get more relevant results and buy cheap twitter followers.
Bash Scripts and MySQL
![1fxshw1sngujguztkvexhxu0no9-2[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2020/10/1fxshw1sngujguztkvexhxu0no9-21-150x150.jpg "Bash Scripts and MySQL")
I frequently use MySQL to store data collected or processed by various shell scripts. The database comes in handy when massaging data with good old awk and sed gets too cumbersome.
Validating HTTPS Cache Peers for Squid
![sy2zeb1vp2h8itlxfbbylw0jrm0[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2019/12/sy2zeb1vp2h8itlxfbbylw0jrm01-150x150.jpg "Validating HTTPS Cache Peers for Squid")
I have a squid proxy server that uses a long list of authenticated cache peers in a round-robin configuration. The process looks something like this:
Updating PHP 5.6w to 7.1u on CentOS 6.10
![wvtchvkz4f4ua8we5yngswc1mkd[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2019/11/wvtchvkz4f4ua8we5yngswc1mkd1-150x150.jpg "Updating PHP 5.6w to 7.1u on CentOS 6.10")
This is mostly just a note to self. As I mentioned previously (probably more than once), I very much dislike systemd and will stick with CentOS 6 for as long as possible. Having said that, …
Windows 10 Upgrades
![img_0002[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2019/11/img_00021-150x150.jpg "Windows 10 Upgrades")
I did the only sensible thing and disabled automatic updates on my two Windows 10 laptops. Microsoft’s belated foray into the world of CI/CD for releasing Windows patches suffers from limited automated testing.
Notes on ownCloud configuration
The ownCloud file sharing application has been around for some time now, but somehow evaded my attention. My limited imagination makes me say “think of it us Dropbox hosted on the server in your basement”.
Removing Chef Server Installation
Just a quick note on how to completely remove (more or less) Chef server installation from a CentOS/RHEL box.
AWS CLI Cheat Sheet
The installation and configuration process for AWS CLI is fairly simple. The package itself is installed with pip (yum -y install python-pip):
Late Night Rant: Agile Apps
While we’re still in the middle of a pandemic, rules about going out have loosened up. But experts agree that the best way to protect yourself is to limit your interactions with other people. If …
The Mystery of a Hemisphere
To make this long (and embarrassing) story short: a friend’s kid had a homework assignment in geometry to calculate the surface area of a conjoined cone, a cylinder, and a hemisphere.
Useful MySQL One-Liners
I am by no means an expert SQL programmer. Having said that, I’ve been using MySQL for a very long time. This is a collection of simple but useful SQL queries and MySQL configuration options. …
SystemD: Back To The Future
A creature in its death throes, Sun Microsystems gave birth to Solaris SMF – the product of a disturbing union between Unix System V and the Microsoft Windows Registry. Shortly thereafter the proud father died, …
Get a List of all ESX Hosts in a Datacenter
Another simple one-liner to get a list of hostnames of all ESX servers in the vCenter. This can be useful for a number of things, specifically as input for other PowerCLI scripts.
Use PowerCLI to Change NIC Type
This is a quick PowerCLI script that reads from a list of VM names and for each VM with network adapter type “E1000” changes it to “Vmxnet3”. Nothing fancy, no reboot is needed. MAC should …
Sample Salt Proxy Configuration for vCenter/ESX
The Salt proxy agent is a relatively new feature of Salt allowing to control networked devices where salt-minion cannot be installed directly. The official Salt documentation on the subject is outdated and full of syntax errors. It’s actually …
Configure and Run esxcli on Red Hat
The esxcli utility is used to interface with the vSphere and ESX hosts. It is a useful tool for getting to some basic VMWare functionality from Unix shell. It is also a pre-requisite for some of …
Samba Flexible Character Mapping
This is probably old news to most of you, but I just found out: Samba v 3.5+ has a new option for flexible mapping of filename characters. Unix filenames allow certain characters that Windows filename …
Managing VMs with PowerCLI
Below is a collection of useful Power-CLI one-liners (or thereabouts) that can speed up your script-writing efforts. As everything Windows, things change often and for no obvious reason, so expect to see type is deprecated and …
![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