Scratchpad – PostgreSQL with PostGIS

Here are some reference notes I made a while back when using a PostgreSQL database with PostGIS extensions on an Ubuntu machine. Hope it is useful for you too! 1) Installing PostgreSQL $ sudo apt-get install postgresql $ sudo apt-get install postgresql-contrib 2) Installing PostGIS Extension Use psql --version to check which PostgreSQL version is installed, … Continue reading Scratchpad – PostgreSQL with PostGIS

Realtek 8192EU (RTL8192EU) Driver Not Compatible with CentOS 7.6 Kernel

tl;dr: On a vanilla CentOS 7.6 installation, it is not possible to install the Realtek 8192EU driver due to kernel incompatibilities. I bought an AmazonBasics branded Wi-Fi 11N USB Adapter and was keen to set it up with a vanilla minimal install CentOS 7.6. It uses the RTL8192EU chipset and while the official Realtek drivers are … Continue reading Realtek 8192EU (RTL8192EU) Driver Not Compatible with CentOS 7.6 Kernel

Updating BIOS of HP ProDesk 600 G1 SFF

Within the chassis of my HP ProDesk 600 G1 SFF lies a HP motherboard with part number 795972-001, and "Merlin Rev.A" stamped just below the barcode. To enter the BIOS, press F10 during boot process and you will be presented with the Hewlett-Packard Setup Utility, whose UI wraps around the actual BIOS from American Megatrends, … Continue reading Updating BIOS of HP ProDesk 600 G1 SFF

Enabling Host-Only Adapter for VirtualBox 6.0.X and 6.1.X on Windows and Mac OS X

Are you looking for VirtualBox 5.1.X or 5.2.X?  This post explains how to set up a Host-Only Adapter for VirtualBox 6.0.X and 6.1.X on Windows and Mac OS X. Creating a Host-Only Network in VirtualBox Windows Start VirtualBox 6.0.X and in the toolbar click on "File" > "Host Network Manager..." Under the Network tab, click … Continue reading Enabling Host-Only Adapter for VirtualBox 6.0.X and 6.1.X on Windows and Mac OS X

Setting Up inetd Super-Server (in theory)

As part of the LPIC-1 Exam 102 objectives, inetd and xinetd are covered under the host security section. As I have not used inetd/xinetd previously, it took a while for me to understand the concepts and how it should be configured. This is especially so for inetd, which has been "succeeded" by xinetd. In this post, … Continue reading Setting Up inetd Super-Server (in theory)

Using One SSH Key Pair Across Multiple Network Zones

Reminder: All views expressed on this blog are my own, and are not representative of any organization I was/am affiliated with.  Overview Secure Shell (SSH) is an encrypted protocol that is commonly used for communication between hosts on an unencrypted network. Connecting to another host on the network comprises of connecting to its SSH server, … Continue reading Using One SSH Key Pair Across Multiple Network Zones

Updating BIOS of Lenovo Yoga 700-11ISK (11″ Screen Size)

Another straightforward BIOS update - simply download the driver from the official Lenovo site, double click, and you're done! Official Site for Lenovo Yoga 700 11ISK: https://pcsupport.lenovo.com/us/en/products/laptops-and-netbooks/yoga-series/yoga-700-11isk/downloads. The latest version I downloaded was v1.10, released on 30 Oct 2016. The BIOS update will reset all configurations to default, and you may encounter the following error after rebooting: … Continue reading Updating BIOS of Lenovo Yoga 700-11ISK (11″ Screen Size)

Creating a Development CI Pipeline for Appian

A while back I did several posts on Appian, specifically one regarding setting it up on Docker. The objective was two fold - the first was to solve an important development CI pipeline challenge, and second was to evaluate if the software was deploy-able on a PaaS (ans: yes it is, but not via the … Continue reading Creating a Development CI Pipeline for Appian

Installing Appian 17.4 on CentOS 7

Appian 17.4 was released on 17th November 2017, and is the final quarterly release in 2017. More information of the release can be found here: https://www.youtube.com/watch?v=k1868iUYIco) This post will describe the installation steps I took to get Appian 17.4 running on a clean installation of CentOS 7. I previously did a guide for Appian 17.2 - … Continue reading Installing Appian 17.4 on CentOS 7