Technology Insights

Convert Amazon Web Services Private RSA Key For Use With SecureCRT

When I first was working with an Amazon Web Services instance at EC2 I was getting frustrated trying to use SecureCRT to connect to the AWS instance. When you configure an instance you are required to configure an Amazon EC2 key pair which will allow you to connect to your instances via SSH.  The problem is once you receive the key pair via download it will not work with SecureCRT so you need to convert it to a public key to work. I did a lot of searching and didn’t find much but the below worked for me.

Details
Technology Insights

Download Torrent Files Using Opera Web Browser

If you are not very familiar with torrents then it is very easy to download them using Opera web browser. The .torrent files are configuration files that list a group of smaller files that need to be downloaded to create the larger file you are trying to obtain. The great thing about using Opera for torrents is the fact that you don’t have to be very familiar with the configuration of a more complex file you can simply click on the .torrent file and Opera will do the rest after you tell it the directory to download the torrent to.

Details
Technology Insights

WordPress Default Redirect to WWW Not Working, Example from domain.com to www.domain.com

I recently noticed that the redirect from question-defense.com to www.question-defense.com was no longer working. Recently I updated WordPress and many of the plugins I have installed. The issue with this was some of the pages served from question-defense.com versus www.question-defense.com were serving different cached pages. After some investigating I thought the issue was related to caching however when caching appeared to b e turned off the issue still existed.

Details
Technology Errors

DivX Player .MKV Files: Audio Format Not Supported, Use KMPlayer Play .MKV Files Without Issues

I downloaded a video file the other day that had a .MKV file ending and was having a lot of trouble playing this file in the typical video players I had installed. Typically when all else fails I can use DivX Player and install an additional audio or video codec to play pretty much any video file with sound. This file was causing me a little bit more of a problem so I had to do some reading so below I explain some information I found, some things I tried, and the overall final step I took to play this .mkv video file.

Details
Technology Errors

PostgreSQL Table Issue: Mduplicate key value violates unique constraint

It is possible for data within a PostgreSQL database table to get out of sync. When this happens it is possible for an attempt to be made to write data to a row in a table that already exists. This is being kept track of internally within Postgres by an ID of some sort and you can reset what the next ID that will be written to a row will be. Typically this will resolve your issue.

I received the below error in a Ruby on Rails application that was attempting to write data to PostgreSQL and at some point the data got out of wack.

Details