Setup Unifi Controller on Debian10 /Buster

Link to original persons blog post The requirements of the Unifi Controller do not allow a direct installation. But with a few manual steps a successful setup is possible! Basic requirements apt install wget gnupg2 ca-certificates apt-transport-https dirmngr gnupg...

SmartOS Tricks

Start smartOS VM from iso that is in /zones/UUID/root/ vmadm start UUID order=cdn,once=d cdrom=/FILE.iso,ide Set static vnc port Do vmadm list to get UUID vmadm update UUID_HERE vnc_port=PORT_#_HERE I love RealVNC. It works well and they have stand-alone executable...

Empora Total power usage email report

For this to work you will need to dump a CSV export at least twice a month and then upload the CSVs from the ZIP to nextcloud. This could honestly be from anywhere nextcloud is just easy for me. Here’s links to the files. I try my best to paste them in the blog,...

Calculate Emporia Energy usage in Bash

How to calculate data use for specfici month using bash for Emporia Energy device cat FILE.csv | egrep “MonthInNumForm/?[0-9]?[0-9]/2019″ | awk -F”,” ‘{print;x+=$2}END{print “Total ” x}’

WP Search-Replace

This is how to use wp-cli to change the domain If using CentOS sudo -u nginx wp search-replace ‘old.domain.com’ ‘newdomain.com’ If using Plesk sudo -u user /opt/plesk/php/7.1/bin/php /usr/local/bin/wp search-replace ‘old.domain.com’...

Windows Service CMD control

These aren’t really tricks, but super useful if you want to change things without interrupting the end user. Find service name since the display name may be different sc query | find “DISPLAY_NAME” sc config “SERVICE_NAME” start=disabled sc stop...

Search and replace WordPress Database

I NO LONGER RECOMEND USING THIS WAY. I RECOMEND USING WP-CLI SEARCH-REPALCE. HOW TO USE CAN BE FOUND HERE. Below is the search and replace for WP which I find really helpful when changing to a new domain. I DO NOT TAKE ANY RESPONSIBILITY FOR USING THIS. MAKE SURE TO...

Static IP KVM Guest

Copied from Here If you don’t want to do any configuration inside the guest, then the only option is a DHCP server that hands out static IP addresses. If you use bridge mode, that will probably be some external DHCP server. Consult its manual to find out how to...

MySQL/MariaDB Not Securing

mysql_secure_installation doesn’t seem to work on the newest Debain After some googling I think I found what works for me. Delete anon user DELETE FROM mysql.user WHERE User=”; delete non local root user DELETE FROM mysql.user WHERE User=’root’...

Mail Server

I finally set up my own mail server using a couple guides. Just putting this here for my memory. Thank you to the great people who write amazing blogs. How to set up the server When put behind cloudflare you need to add the bellow to /etc/nginx/nginx.conf in the http...

Screenly

This is something I’ve really been wanting to play with. I will one day. https://www.screenly.io/ose/