Category: Sysadmin

Namecheap DDNS on Ubiquiti EdgeRouter

Namecheap provides a great domain service with an emphesis on security and privacy. I’ve recently decided to try their premium DNS service for a variety of reasons. It was nice to see a Dynamic DNS service. With my home network focused around the Ubiquiti product line and leveraging the EdgeRouter (ER-Lite) Dynamic DNS features. It’s […]

Run PtokaX Under systemd

Here is the example to run PtokaX Direct Connect Hub software as a daemon under systemd. Tested and used on Debian 9 Stretch. This also assumes you’re using a non-privileged user and your binary is at /usr/local/bin/PtokaX.

Quanta LB4M Quick Configuration Examples

The Quanta switches are not well documented nor is it very good. We will cover the basics of configuring the LB4M switch which includes management IP address, SSH, firmware and LACP port channeling. Configure a Management IP Address + Enable SSH: Upgrade LB4M Firmware: You can download the latest known Layer2 version of the firmware […]

Custom SSL Certificate Installation for UniFi Video

This article assumes that you have already have a certificate, a corresponding private key and the certificate authority certificate. This guide will not guide you on making a CA, certificates or singing a certificate. I would recommend using a OpenSSL wrapper tool such as EasyRSA for certificate management. The following steps assumes the following: You’re […]

Silicone Image Sil680 Controller in Windows 7 x64

The Adaptec ASH-1233 is a dual port IDE RAID controller card that features a Silicone Image Sil680 Sil0680 chipset. Drivers for it were never officially released for Windows 7 but this guide and drivers will help you enable your Sil680 chipset in Windows 7 (x64 or Itanium). The driver was released by Silicone Image but […]

Oracle Database Queries in PowerShell, Script Examples

Below are some code examples to help get your data out of an Oracle database into a PowerShell object quickly! The logic to manipulate data is the same regardless of vendor: load any required libraries, define the connection string, setup the connection object, use that connection object for subsequent queries and finally close the connection. […]

YaBB SE 1.5.5 MySQL Unknown Column Fix

For retro purposes, I wanted to make anĀ old instance of YaBB SE 1.5.4 a read-only version to look back with friends to get some kicks and laughs. I first upgraded from YaBB SE 1.5.4 to YaBB SE 1.5.5c. This was a small project try bring this up on a modern operating system, primarily around the […]