Author

Rich

Just another IT guy.

400 Million Records in MySQL

May 7, 2017

So I'm trying to figure out a way to make searching a VARCHAR in MySQL fast when there are 400 million rows. I tried the UNIQUE approach using…

SMBus Host Controller Not Enabled!

May 6, 2017

To fix the error message SMBus Host Controller not enabled! message, you can blacklist the module from loading. I use Debian 9; check with your distribution for specifics,…

Compile dynamic nginx modules

May 4, 2017

My notes for compiling modules in nginx.  As of nginx 1.9.11, you can dynamically load modules using load_module in nginx.conf.  To compile the module, if not available in…

CPU-miner Installed via Windows OS Vulnerability

April 27, 2017

I have triaged a handful of Windows servers this week that started out being ticketed as high CPU / performance issues. Upon investigation, I have found XMR cryptocurrency…

Fail2ban + fail2sql + Ban Hammer + PHP7

April 26, 2017

I recently revisited a project from some time ago that I found and modified the code to support PHP7 which dropped support for mysql extension in favor of mysqli.

From Linux Install to WordPress

April 25, 2017

A typical installation of Debian 8.x (Jessie) precedes this where I only select base system and ssh server options during operating system installation. After installation, this is a…

Powershell logparse regexp to csv

April 19, 2017

Input line: Thu 2017-03-30 00:00:07: user@domain.com (John Doe) checked mail from 127.0.0.1 using IMAP, 0 msgs collected, 21 remaining Powershell script: $rxp = "([a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?)|(d{1,3}.d{1,3}.d{1,3}.d{1,3})|(POP|IMAP)|(^[A-Z][a-z]+sd{4}-d{2}-d{2}sd{2}:d{2}:d{2})" gc ".*.log" | select-string…