Technology Insights

LiteSpeed Web Server Virtual Host Showing Restart Required in Web Admin Console

Recently I configured a virtual host in Litespeed outside of the normal Virtual Host Template I use. Typically I use the EasyRailsWithSuEXEC but this time I needed to use the PHP_SuEXEC template. It was easy as most configurations are with the LiteSpeed however when I performed a graceful restart I noticed that the virtual host I had just configured was showing “Restart Required” instead of “Running” as shown in the image below.

Litespeed Virtual Host Restart Required

Technology Insights

Import Outlook Contacts Into Gmail and Export Gmail Contacts to CSV

Google’s Gmail has a handy little interface to import and export contacts in CSV format which will allow for easy synchronization between Outlook’s contacts and Gmail’s contacts without having to install some third party software. Most people will typically be making the switch to use more Outlook thus needing to import contacts into Gmail from Outlook so below the first set of instructions explains how to do so. The second set of instructions will explain how to export from Google in Outlook CSV format and then import back into Outlook. Both import functions provide a merge so duplicates can be kept to a minimum or really even zero duplicates.

First lets look at how to export Outlook contacts to a CSV file and then import that CSV file into Gmail.

Technology Insights

Change the Table Prefix of WordPress Blog MySQL Database from wp_

The directions below will provide simple instructions on changing the prefix to your WordPress blog’s MySQL database from wp_ to whatever you choose. Its a good idea to change this prefix to prevent zero-day SQL injection attacks from being performed against your WordPress installation since your database tables will be known to everyone if you use the default prefix. So follow the below directions to make the change that should only cause minimal downtime if the steps are followed properly.

  1. MySQL Database Backup:Use the CLI or backup your database from phpMyAdmin. If using phpMyAdmin use the export feature to export a SQL version of your database and download it to the PC you are working on. Your backup should be something similar to mydb_DATE.sql.

Technology Insights

Install a Ruby Gem From Your Local Linux Server

Installing a gem locally is extremelly easy if you follow the steps below. I was recently in a situation where I had to upgrade a gem quickly to resolve a bug but the latest version of the gem located on http://gems.rubyforge.org was older than what was necessary. You need to locate the .gem file for the gem that needs to be installed and get a copy on the local server. In my case I happened to have a gem server that had ben installed but the web access was down at the moment so I SCP’d (secure copy) it to the local server and placed it in /usr/local/src.

Once you have the gem moved onto the local server issue the below command to install.