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.

Technology Insights

Remove the Website Field For Comment Posting on WordPress Using Mandingo Theme

In an attempt to promote as much community as possible I would suggest removing the Website field for when people post comments to your WordPress blog. In this scenario below the Mandingo Theme is being used however it is just as easy to remove the Website field from the default field as well. If people still want to post their web site when making a comment they can do so in the body of the comment.

If you are using the Mandingo Theme then you will need to modify two files but if using the default WordPress Theme you should only need to modify one file. The lines to remove should be the same or very similar no matter what Theme you are using.

In Mandingo follow the below directions to remove the Website field from the comments form when people are not logged in.