Installing Unifi Controller on Raspbian/Ubuntu

Configuring the Pi for SSH and Network is fairly easy. We bought some new Unifi gear, and I wanted to set up a Raspberry Pi to run the controller software.I use Linux on my desktop, so copying the image is pretty simple. Normally I just download the image, right…

Adopting Unifi Security Gateway

If you buy a Unifi Security gateway, out of the box the lan port is 192.168.1.1/24, which didn't work in my case as I wanted to configure the network interface on a different subnet.It's fairly easy to do from the command line:configure edit interfaces…

Install unrar on Fedora 29 or Centos 6-7

It's super easy to install unrar in Centos 6, 7, and Fedora I've included some of the primary operating systems below, for more options please see here Fedora 29: dnf install https://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-29.noarch.rpm dnf install https://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-29.noarch.…

Install 7zip on Fedora or Centos 7

sudo dnf install p7zip…

How to hide sleeps from mysql processlist

I run some larger mysql databases with thousands of sleeping connections usually, and sometimes I just want to show what processes are doing.SELECT user, time, state, info FROM information_schema.processlist WHERE command != 'Sleep' AND time >= 2 ORDER BY time DESC, id \G Should select user, time, state,…