Tuesday, December 6, 2016

Atlanta Panhellenic Opens Scholarship Competition Online

The Atlanta Alumnae Panhellenic Association has opened its annual scholarship competition to women in high school, college, or graduate programs.  For the first time, applications will be accepted online.

The following scholarships will be awarded at the Scholarship Luncheon on May 13, 2017:

Six (6) High School Senior Scholarships at $1,500 each

Three (3) Collegiate Member Scholarships at $2,000 each

One (1) Alumnae Scholarship at $2,000

Learn more and access the secured applications at http://www.atlantapanhellenic.org/scholarships/

That's the official announcement from AAPA, a 10-year client of SDOC.

Now here's the rest of the story....

For years the Scholarship Committee requested that the application forms in the competition be formatted as fillable PDFs - the kind you can download, fill in on your computer, print and then mail.  The members at the time thought it would be easier.  For them it probably was.  This year the Scholarship chair wanted AAPA to organize a procedure that mirrored other online applications.  The PDFs were put out to pasture and yours truly was tasked with creating a system of online applications.

There is no "plugin" or "extension" for scholarship applications for your CMS and you don't need one.  I created the system for AAPA using Contact Form 7 for WordPress.  (You can do the same thing with other content management systems - the original Dunwoody Chamber online application was made with the Webform plugin.)

The key is in the details.  First, make a very clear list of what information you need to collect from your visitors.  Then you decide how you want to collect that info - entering text into a box, selecting from a drop-down menu, uploading a file, etc.  Finally you divide up the info into forms for each group you want to reach and sequence them so that your visitor has a logical workflow that leads them from one step to the next.

Complex information collection doesn't require fancy add-ons.  But it does require close attention to detail and a visitor-centered POV.

On a final note, the Atlanta Panhellenic has called Dunwoody home for at least 15 years.   From the meeting room near the Library, they have been reaching out to Atlanta-area counties with information about modern NPC sorority life and educational opportunities.  AAPA has been providing scholarships to area young women since 1932 and the total granted to date is approximately $100,000.  The total planned to be presented this year is $17,000.  If you hang your hat in and around Atlanta, please visit and investigate this opportunity for scholarship funds.


Saturday, November 26, 2016

Everything's Great Until It's Not - Hacked Websites, What to Do About Them and How to Prevent a Hacking

Earlier this year, I was hired to repair a hacked website for a Los Angeles-based entertainment company.  Ever since then, I have been knocking the concept for this post around in my head.  With the City of Dunwoody's website hacking, the subject has come to the front burner and I decided it was time to get this one posted.

Security is Relative

There is no such thing as a 100%-hack-safe computer on the Internet.  Whenever I see RFPs requesting "100% uptime" in their website, I take that as a red flag that someone doesn't understand computer security.  Even NORAD and NASA were hacked by teenagers.    A developer or network admin can make hacking extremely difficult - so much so that a hacker decides the site isn't worth their time and moves on.  But if a hacker wants to get into a computer system, they will eventually find a way in.  Website owners and hosting admins have to be vigilant and plan for recovery from attacks before they happen.

All Hacks Are Not the Same

Hacked websites will appear and behave differently based on the intent of the hacker.  In Dunwoody's case, somebody wanted to make a point and make sure the entire planet knew who they were and what was on their mind.  My entertainment company hack was more insidious:  the site looked the same but the administrator could not log on.  The hacker had made numerous changes in the back end that not only allowed clandestine access rights but also made it difficult to track down and remove the rogue code.

You Got Hacked!  What Now?

The name of the game is to eliminate any code or other elements that were placed by hackers and make sure your actual website code is intact.  How much work is involved is going to depend on what the hacker did once they got access to your site or server account and in some cases, how much stuff you had stored there in the first place.

This may or may not be a DIY job, depending on how comfortable you are with the files and database that drive your website.  When in doubt, consult a professional.

If you have a simple website and your webhost provides a routine backup option (or "snapshot", as its called by some) you can simply restore an older version of the website to replace the hacked version.  This requires some planning ahead and I'll go into those plans further down.

But what if you didn't plan ahead and there are no backups to restore?  That's when you have to take the step-by-step approach.

The Most Complete Hack Job I've Ever Seen

My entertainment site hack client was an example of a very deliberate, stealthy, even surgical hack that left the public face of the site intact but prevented legit administrators from accessing the dashboard, allowed different admins access, and hid the hacked content inside of normal files.  Here's what I found.

  1. The hacked site was in WordPress.  Which had not been updated in years.  The site also used a commercial theme purchased from a developer.  Which also had updates available and also had not been updated in years.  The host was bare-bones GoDaddy.  Without a site backup option. Problem #1 was identified.  The owner provided access to the GoDaddy account and the files could be read through a browser.
  2. There were a ton of directories with obsolete code from earlier versions of the website.  Inside were recently-added PHP code files with benign names like "security.php" and "file.php".  But they weren't benign - they were part of the admin control hack.  The tip-off was the date when they were added:  when all of the files are 2,3,4 years old and you have a new file that was added last month, that's your culprit.   The delete key was my friend.
  3. Similar benign-sounding-but-not files were found in directories that housed javascript files that drive the interactive and animated elements of the website.  When you have a directory full of files that end in ".js" and there's a recently added file ending in ".php", that's a file that doesn't belong there.  Delete key again.
  4. Same process was repeated in the "uploads" file where images and the like are kept.  When you see a bunch of ".jpg" and ".gif" files and a new one out of nowhere ending in ".php", that's the file you delete.
  5. Database edits:  the hackers created an additional table in the WP database to override the admin commands.  They also added new users with administrator roles.  Delete the extra table and delete any and all users that were not currently authorized on the site.  This is where a professional database admin comes in handy and we leave the DIY Zone.
  6. The last piece of the puzzle was the worst.  The hackers had not only done ALL of the above, but they had inserted lines of code into actual WordPress files, either at the very beginning, or at the very end.  Now if you're a developer who is used to looking at the individual files that make up WordPress and reading the code, you can tell when something is added that doesn't belong there.  There is NO way a casual user would have caught this.  Even if they managed to spot and delete all of the above hacks, the result would have been the site crashing altogether.  I reviewed all of the files in the core content management system and removed code that wasn't kosher.
BINGO!  The administrators could log in.  Software got updated, including the outdated theme and my customer was updating the website again.  No further hacks.

The above cleanup process took about 12 hours and I charge my hourly rate for that kind of work.  Can that situation be avoided?  Oh hell yes.  And I highly prefer it to fixing a site that had been entered by somebody using a server in the Czech Republic.

Six Steps To Avoid the Highway to Hacker Hell


FOR THE LOVE OF GOD, UPDATE YOUR SOFTWARE!!



  1. This is no longer a joke, gang.  If you are one of the many millions on Planet Earth using some kind of content management system (CMS) whether open-source or commercially available, apply all of your updates when you are aware of them.  The purpose of these updates is to close those little loopholes where hackers get through.  That's the core software.  Plus the little add-ons - "plugins", "modules", "extensions", whatever they're called.  And your themes.  Or "templates", whatever they're called too.  Most of these can be done automatically through the administrator's dashboard.  Or even from a VAN DOWN BY THE RIVER!!!

    Contact the CMS' manufacturer's website (or tech support if you're using a proprietary software like Sitefinity).  Don't put it off.  If you can't work it into your schedule, hire a pro to review it regularly.  That's cheaper than recovery.

  2. BACKUP, BACKUP, BACKUP  If your webhost has an automatic backup function, turn it on and use it.  If they don't, back up your files manually and find a new webhost that offers this service.  Backups refer to both the files where your data is displayed, and the database where the data is stored.  Most competent web hosts have help files and/or tech support that will walk you through this.  When in doubt - hire a professional and have it done for you regularly.  Monthly, at the very least for the typical non-government small business.

  3. Remove any obsolete files or directories from your web host.  If you're not using old plugins or other code, delete it from your server.  Save it to a local drive for posterity if you want but it's just a trouble magnet on the Internet.  Follow your CMS' instructions for uninstalling and removing components for your website.  Old directories with code no longer in use need to go.  If you're not sure how to do this ... wait for it....  hire a professional.

    WordPress users:  even if you uninstall and delete a plugin properly, the data from that plugin may still be left behind in the database.  That can still be a vulnerability, albeit a rare one.  There are plugins available that can clean out "orphan" data from a database but a database admin can manually go through and remove anything no longer in use.

  4. Remove any users who are no longer working on the site.  I believe this may have been part of what led to the major hacking I cleaned up.  There were a number of users still listed on the site who edited content and plugins from time to time, but were no longer involved.  They were still there, same passwords in place.  A disgruntled former employee can do a lot of damage.  But even if there are no bad feelings, what if that former employee gets hacked and someone gets a hold of their login credentials?  The result is the same.  Just delete the user and their access.  If they return, give them a new login.

  5. Rotate your passwords.  I know, passwords are a PITA to remember and use.  Changing them on a regular basis can prevent hacking and other fraud.  Don't forget to make it something that a hacker won't be able to find using a standard algorithm of searching for common words.  Many CMS and hosting providers require a minimum security level, including a mix of numbers, upper and lower case letters, and punctuation.  Anyone who still uses "password" or "123456" needs to be slapped.  As well as kept away from computers!

  6. Reevaluate your hosting provider periodically.  Not all hosts are created equally.  The uber-cheapo hosts are great for hosting vacation pictures by Aunt Suzie from Syracuse.  E-commerce needs something more secure, and that will require an investment.  Do some research as your web presence expands to make sure your website's foundation is secure and has the power to run your applications without hanging or crashing.  Government agencies and municipalities - don't skimp on this, no matter what the citizenry says.  When I consult for any government office or agency, I have a very short list of providers I will work with.

    Amazon web hosting is the gold standard for high-volume performance and security.  To give you an idea of what they are capable of, Amazon hosts WhiteHouse.gov, Georgia.gov and a number of federal agencies, including the CDC here in Atlanta.  In the private sector, they host NetFlix.  But hosting like that costs big bucks - there is no price menu at Amazon, all contracts are negotiated especially the high visibility ones.  Most enterprises do not need this level (or cost) of power and security but the point is, this isn't a place to go cheap.

It's all about paying regular attention to the bones of your website.  Either set aside the time or hire someone who will.  The following does not have to be you, if you apply some regular due diligence.




Wednesday, November 23, 2016

Happy Thanksgiving 2016

As usual, the sun doesn't set on an entrepreneur so between baking pie, roasting turkey and making sure the kids get out and run off some energy, I'll be upgrading software for my e-commerce clients in advance of Cyber Monday.

I hope all reading this can find some peace this week, through Christmas, Hanukkah, and the New Year.

Usually I post a brief excerpt from Nathaniel Philbrick's Mayflower regarding how building a community takes hard work and compromise.  Not going to cut it this year.  Here's the link if you'd like to review.

After the kids are settled in for the night Pat and I will split a bottle of pinot noir and a viewing of Places in the Heart.

Not a typical Thanksgiving movie.  Or any holiday movie for that matter.

Places represents Sally Field's 2nd Oscar win.  The movie is set in Great Depression-era Waxahachie, Texas (yes, that's a real town, just outside of DFW).  Won't spoil the plot if you'd like to see it but my takeaway is that family and community can grow anywhere - whether you want it to or not - in places you can't imagine.  Forces outside that family can modify it, but not destroy it if you don't let them.  (Warning:  given the date and setting there is some blatant racial violence in a few scenes.  Parents, judge carefully and be ready for an intense conversation if you allow your children to watch.)

Also a movie I recommend for Sisterhood nights in Phi Mu or any sorority chapter gathering.

We'll be home for turkey day, so it's OK to stop by and pass judgement on my cooking.  :-)