Posts

SSH Auto Login Using Putty

I once had a person tell me that the most successful individuals in IT are lazy.  Years after hearing that, the notion has stuck with me and translates into much of how I attach problems.

If you’re like me, you use putty to connect to servers via SSH frequently. Now, I know that you can use key based authentication using puttygen, but in the scenario that you don’t want to go that route, you can use the method below to create windows shortcuts to automatically log into a host using putty.

Continue reading “SSH Auto Login Using Putty”

Change the Author of Multiple WordPress Posts

Disclaimer: This idea requires access to the shell on your webserver.

This is the SQL query you’ll use:

UPDATE wp_posts 
SET post_author='[NEW ID]' 
WHERE post_author='[EXISTING ID]';

I had posts that were assigned to Admin (which by default is user ID 1), and I wanted to assign them all to my user (which in this case is user ID 2).

My query looked like this:

UPDATE wp_posts 
SET post_author='2' 
WHERE post_author='1';

That will go through the posts database and update the author for all of them.

Continue reading “Change the Author of Multiple WordPress Posts”

Back Again

Sometimes I wonder how the content for this blog still exists…  I started this blog more than 3 years ago using Drupal, and since then I’ve converted the SQL to be used with wordpress, and had numerous problems that could have caused me to lose everything.  Somehow I still have it, and I’m happy that I do.

I have to say that this version of wordpress is so much better than the version I was using before (which was 2.1)

Continue reading “Back Again”

SSH Local Port Forwarding Made Easy

I’ve been using this for a while now, and have found it a great little trick for accessing services that are blocked due to a firewall.

It’s pretty simple, you just have a few parts to the command string.  The first command argument tells ssh to forward a local port (LP) to a remote machine Remote) on a remote port (RP).  The second part is something you’re probably familiar with, the destination that you’re connecting to (Destination).

Continue reading “SSH Local Port Forwarding Made Easy”

Problems with AllPeers in Firefox

I found out recently, like a lot of people, that the AllPeers Firefox extension went Open Source. So naturally, I realized the hype it created and installed it.

Unfortunately, I never tested it, because none of my friends wanted to install it, so there it sat right there in my Firefox installation, dormant. It wasn’t until today that I had problems with it.

I restarted my computer today, and tried to start up Firefox, and it did nothing… So I started up the console, and started Firefox. It started starting up fine, with loading of AllPeers, then had a segmentation fault error…

Continue reading “Problems with AllPeers in Firefox”

Howto: Convert NRG Files to ISO Files

I recently got a couple fo CD images from a friend in the NRG format, and wanted to burn them to a couple of CD-R’s. Here’s the process I used to do this:

sudo apt-get install nrg2iso
nrg2iso original_image.nrg new_image.iso

Then just use k3b, gnomebaker, or your favorite CD Burning software to burn the ISO.

Jon

HowTo: Use Find on Linux to Execute Commands Recursively

I just used the best music player on the planet to organize my music really nicely. It organized them by filetype, first letter of artist, artist, and album. The problem was, it left some dangling folders that I wanted to delete so my library looked clean on the filesystem. So I decided to use a little bit of linux command line fun to get the folders removed.

Continue reading “HowTo: Use Find on Linux to Execute Commands Recursively”

Using AOL Instant Messenger with PHP

I’ve been looking for a while for a way to integrate PHP and AOL Instant Messenger (AIM). Up until now I haven’t found a way to do it besides the stuff Here. Fortunately, I got a little distracted in my studies and found what looks like a Dynamite OO Library Here.

Look in the future for some examples of how to use this.

Jon