Charlie Peters

It’s been two months since I lost my friend and colleague.  It was just as we began to enter the busiest time of the year for the company where we both work, so busy in fact, I never really had (and very much didn’t want) the opportunity to process what was taking place. And as the days went on, I often found myself getting up from my desk, I wanted to go talk to Charlie about one thing or another.  Charlie and I had a connection…  he hired me 20 plus years ago and along the way had been everything from a boss, to a mentor, to a friend.  We were wired a lot alike, both of us having spent our entire lives with technical things, he was the only guy I’ve ever been able to talk to without having to think about, or translate what I was saying on the fly – something I miss more than any words could ever express.  He’d immediately get it and would often “one up me” in the conversation.  He loved to just make stuff work and it’s what attracted me to this company so many years ago.  Charlie was never full of it, as down to earth as they come and as easy to talk with as anyone could ever imagine.  He was a gift, and my life has been forever bettered because of him and forever altered at the loss of his presence… Miss you Charlie… We all do…

Struggling to stay young

For all us old goobers who we’re lucky enough to find our girl when we were young and stupid, who are now all caught up in the insanity of life, but still young enough to remember all those years ago.

Say goodbye to the halls and the classes
Say hello to a job and the taxes
The weekends with old friends spilling into 9 to 5 routine
Tell me how you feel over and done with Like your life is a map with no compass to guide,
At the bar drinkin’ way too much
We sing along to “Forever Young”.

So here we go again
Wishin’ we could start again

Wendy run away with me
I know I sound crazy
Don’t you see what you do to me?
I wanna be your lost boy
Your last chance, a better reality

Wendy we can get away
I promise if you’re with me, say the word and we’ll find a way
I can be your lost boy, your last chance
Your “everything better” plan
Oh, somewhere in Neverland

We’ll start a life of the plain and the simple
Of great times with far better people
And weekends with our friends
Laughing about the wine that stains their teeth
We’ll talk about how your parents separated and
How you don’t wanna make the same mistakes as them
I’ll say it’s all about stickin’ it out
And trying to feel forever young

So here we go again
Wishin’ we could start again

Wendy run away with me
I know I sound crazy
Don’t you see what you do to me?
I want to be your lost boy
Your last chance, a better reality

Wendy we can get away
I promise if you’re with me, say the word and we’ll find a way
I can be your lost boy, your last chance
Your “everything better” plan
Oh, somewhere in Neverland

So here we go again
Wishin’ we could start again

Wendy run away with me
I know I sound crazy
Don’t you see what you do to me?
I want to be your lost boy
Your last chance, a better reality

Wendy we can get away
I promise if you’re with me, say the word and we’ll find a way
I can be your lost boy, your last chance
Your “everything better” plan
Oh, somewhere in Neverland…

Somewhere in Neverland – All Time Low – circa 2012

My wordpress got hacked

Last week while doing some Google searching, I notice my SEO meta data on this site had been hacked. Oh joy… A little poking around quickly confirmed the issue/problem. Oh joy, again… Time for a little cleanup. Thought I’d share the process in case any of you find yourselves in this predicament.

The process:

  1. Make a backup, just in case things go horribly wrong. For me, since I knew what I wanted to preserve, I just grabbed a copy of my database and uploads folder.  If you’re not familiar with WordPress, you might just want to grab everything.
  2. Quick assessment/documentation of the site – plugins, theme, site configurations – anything you’ll need to put back.
  3. Decision time: to clean it up or blow away and start fresh.  For me, I decided it’d be easier to blow everything away and start fresh – I only have about 500-ish posts and only about a 100 or so uploads.  And this site has been through various themes, conversions, etc., so the database, along with the hack had grown way beyond anything I wanted to try and clean up.  Miss something and all that effort could go down the drain, so it’s was just easier to start fresh.  Your mileage may vary.
  4. Next I disabled any plugins I wasn’t interest in keeping – an attempt to make the export process as clean and simple as possible.
  5. Export “all content” using the export feature of WordPress.  You want to be sure you’re exporting from the most current version of wordpress.  More precisely, you want to make sure whatever version you export from will be the same version you’ll reimport into.
  6. Now that you have your content (the XML file WordPress just exported for you) and other important files you snagged from the backup process, you’re ready to blow away your existing WordPress install. For me: I simply created a new database, along with a new database users and password for safety.  I then blew away all the WordPress files except for my /wp-content/uploads folder.  Now, you need to systematically go through your uploads folder and verify everything in there belongs and is clean – don’t just assume – verify or all this work could be for nothing.
  7. Now go download new/clean copy of WordPress – don’t use your existing files since they could have been compromised.  Again, it’s important that your versions remain consistent, so be sure to use the same version you exported with earlier. Upload your new files and configure WordPress to use your new database.  The configuration/install process is triggered by simply accessing your website URL after you’ve finished uploading WordPress.  Be sue you use a new admin password, you old one is compromised – it’s also a good idea to steer clear of the “admin” username period.
  8. Now that WordPress is functional, but empty, go download plugins and themes you may need.  Again, these should be fresh downloads, being sure you keep the versions consistent.
  9. Ready for import.  Simply click on tools import – WordPress. You’ll have to download and install the WordPress import plugin, but if you made it this far, you’ll make it through that.  Once the plugin in installed, you simply import the content.  You’ll have the option to reattribute post to existing or other users.  You can also decide wether or not you wan to download/import files.

A couple of things about about the import process.  At the time I’m writing this it’s WordPress is 3.7.1 and the importer is 0.6.1, things do change.  The first time I ran the importer I didn’t check the “download and import file attachment” option.  Remember, I left my “cleaned” wp-content/uploads directory in place.  This preserved all my image links and such, but didn’t populate the media library – it was empty.  Not exactly what I wanted, so I dropped all the table in the database and went through the WordPress configuration and import process again, this time checking the “download and import file attachment” option.  That populated the media library, but create a couple new problems:

  1. It duplicated, and in couple of cases tripled all of my files.  I assume this was because the import process was acquiring/downloading and writing the files to the same directory and simply append the file names with a 1, 2 or 3.  Oh well – no biggie.
  2. But on some posts it also didn’t edit the img link correctly to reflect the new file name it just created during the import process.
  3. Most, if not all, relationships between the media library files and the posts they were used in were broken – not attached.

Not to worry, all isn’t lost. I simply examined all the post that had image links. Using the Search Regex plugin I searched all posts for  img tags.  That’ll help you identify the posts, then basically you just have to examine and repair any posts where the image link got fouled up.  During this process I also relinked these posts to the media library file so those relationships would exist. Finally I went back through my uploads folder and deleted all the duplicate files the importer plugin had created.

All-in-all, it sounds a lot worse that what it was.  If the importer plugin had worked correctly, this would have been a piece of cake, even so, it just took a little extra effort to clean up from the import process.  My almost 50MB database had been reduced to just over 1MB, the site nice and speedy again and my Google searches where no longer polluted with a bunched of hacked up meat data after a few days.

This time I’ll do a better job of keeping my WordPress, plugins and themes updated.