Norm Coleman’s staffers have still not responded to my queries about their disputed claim that the former senator’s Web site crashed due to a traffic spike, but one thing’s for certain: While the site is up and running again, it appears to be severely under-secured. One IT professional tells me that the campaign has stored a database of campaign donors (complete with names, email addresses, phone numbers and donation amounts) in a publicly accessible, unprotected directory, and MN Publius commenter Adria Richards posts a screen grab of the 205 mb database available for download from Coleman’s site. (The FEC makes donor information available to the public, but not with this level of detail.)
It’s hard to say whether the scrutiny brought on by today’s questioning about a possibly faked site crash (dubbed “Crashgate” by some on Twitter) somehow exposed the data or whether Team Coleman has stored the database in such a fashion throughout the entire campaign. I’m also told that the database included the usernames of registered site users, along with their unencrypted passwords, a potentially serious security concern for users who, like many of us, have a master password for various online accounts.
“It’s security by obscurity,” a web developer told me on condition of anonymity. “Hoping nobody finds where the data is.”
Update: Adria Richards, a technology consultant, offers a comprehensive post about these and other technical issues with Coleman’s site security.
Update: As of 11:40 this evening, the database appears to be password protected.












18 Comments »
Comment posted January 28, 2009 @ 11:03 pm
Sometimes I wish they hadn’t even tried with Crashgate in the first place. It’s like the web community is going to have its own “secure ballot” drama.
Comment posted January 28, 2009 @ 11:19 pm
There is no excuse for these horrible web management practices. If you somehow cause your database, or a copy of it to end up in public web directories, you deserve what you have coming to you, especially after declaring that your site was down under false pretenses. That’s only going to cause people to investigate, and they can’t help what they find posted to public directories when they do.
I can’t imagine his web “guru” will have a job much longer after this. Also, how long until Norm Coleman comes out and says, “I WAS HACKED”. Most people will be likely to believe that, and yet not understand the reasons why this wasn’t a hack.
Comment posted January 28, 2009 @ 11:57 pm
Thanks for picking up my post Paul! I wish I’d seen your Twitter earlier today.
It’s a fairly common (and insecure) practice to store backups of database files in publicly accessible directories or in this case, not clean up directories after a site is moved or updated.
In the past, I’ve actually sent letters out to companies in the Twin Cities notifying them of basic security problems like this. The letters include screenshots, articles on why it’s a security issue and what steps they can take to fix it. None replied to my letters or returned my phone calls.
Many probably have heard of the problem with sequential numbering of user ID’s that caused major security and privacy issues for some well known Fortune 500 companies.
Here is a great article that summarizes how all the issues on Norm Coleman’s site could have been addressed before “Crashgate”
http://uis.georgetown.edu/web/hosting/securityexamples.html
Comment posted January 29, 2009 @ 2:37 pm
I’m really starting to think this wasn’t a deliberate effort to deceive, but a technical error combined with other people not understanding the situation and assuming rather than checking that the cause must have been people seeking information the Coleman campaign had been touting, and thinking the traffic involved was enough to crash a site. The technical people had a screw up, but I’m thinking Coleman’s touts had the bigger screw up. They put out their announcement having no idea if it was true.
Which I suppose is still a lie of a sort. It reminds me of that book on bull—-, where the author defined bull— as different from a lie because the liar knows the truth so it can be covered up, while the bull—er doesn’t know or care about the truth, but says what sounds good.
Comment posted January 29, 2009 @ 2:49 pm
Geezeus, cut Normy some slack. He has canned his staff and they are sucking wind over there.
Probably they fired the uneeded overhead, like the technicians.
But of course they kept the middle management (the guy that clicks the on-off switch on the
server admin screen.) And the budget for blo-and-go.
Comment posted January 29, 2009 @ 5:16 pm
Eric, I would agree with you, except for the TTL entries; someone could easily have put out a DNS entry of 1.1.1.1 by mistake. However, explicitly setting it up to be renewed every 10 minutes makes things seem a bit more deliberate, especially since that’s not the kind of default value you’d see in a DNS setup tool. In fact, the kind of default you’d see in a DNS setup tool wouldn’t be 1.1.1.1, either – it’d be 0.0.0.0, which is explicitly set aside for unassigned addresses. If that had happened, browsers would have put up an error message distinctly different from “Site not found” – testing that on my Firefox browser results in sending the request to the local host (i.e. my own computer)
The only reason someone would even think of 1.1.1.1 is that it would display an error message on most people’s browsers that is superficially similar to that of a crashed site, and is likely not assigned to anything.
Comment posted February 2, 2009 @ 9:12 pm
As incompetent as Norm’s office has been, it’s easy to believe that a half-dozen visitors to his site would be enough to crash the system. I’d be amazed if it wasn’t crashed more often than running. Still, this has the reek of a Karl Rove stunt. If anyone is a devout follower of Rove-tactics, it’s Norm.
Comment posted February 19, 2009 @ 5:24 pm
The database also contains unencrypted credit card numbers, expiration dates and card verification numbers. I don’t know why this hasn’t hit the mainstream media yet. According to Minnesota law, the Coleman campaign should be required to release information of their loss of data to public news sources in addition to notifying the people whose data they lost directly. Since news of this database leak made it well around the internet, anyone could be using these credit card numbers now.
Someone needs to go very public with this information and soon. Peoples’ data is at stake here, and it’s just completely fucking stupid that nothing has happened yet.
Pingback posted March 11, 2009 @ 10:39 am
[...] with a little more digging, it looks like Coleman’s IT group was just sloppy Posted by Gabriel | Filed in Corruption, Leftist [...]
Pingback posted March 11, 2009 @ 11:00 am
[...] indicate that people were at accessing the directory that contained this database. How do I know? There’s screenshots that [...]
Pingback posted March 11, 2009 @ 11:14 am
[...] brought down his campaign website? Anyway, his dumb, unimpressive fake crash stunt left a database full of info on supporters/donors unprotected and free for anyone to download, including information such as unencrypted credit card [...]
Pingback posted March 11, 2009 @ 4:05 pm
[...] indicate that people were at accessing the directory that contained this database. How do I know? There’s screenshots that [...]
Comment posted March 12, 2009 @ 2:56 am
Smooth move, VISI.
Pingback posted March 12, 2009 @ 9:42 am
[...] campaign, which violated basic on-line security procedures. The unprotected Coleman database was discovered in January, and the campaign was notified by the Minnesota Independent, which has done outstanding reporting [...]
Pingback posted March 12, 2009 @ 3:57 pm
[...] that evening, the Independent reported Richards’ findings that an unsecured donor database was stored on the Coleman site. A few hours after that, the page containing that database was [...]
Comment posted March 16, 2009 @ 1:22 pm
Why are they storing unencrypted credit card numbers?? Their webmaster or DBA has failed Security 101. Even if the database is leaked, the worst that should happen is that *encrypted* CC numbers are leaked, which don’t give away anything unless you know the encryption key (which should not be in that database).
Pingback posted March 17, 2009 @ 4:35 am
[...] that evening, the Independent reported Richards’ findings that an unsecured donor database was stored on the Coleman site. A few hours after that, the page containing that database was [...]
Comment posted March 25, 2009 @ 12:16 pm
The question of whether the site was hacked or if any card data was published on the web is no longer the main point. This information discloses that the Coleman campaign retained the verification code numbers that are usually on the back of the card. The mere fact that they retained these code numbers is itself a violation of Minnesota law AND the agreement contracts with the credit card organizations. Forget about the possible hacking, forget about who might have done or not done it. The fact remains that the retention of these code numbers alone puts the Coleman campaign in violation of the law.
“No person or entity conducting business in Minnesota… shall retain the card security code data, the PIN verification code data, or the full contents of any track of magnetic stripe data,” says state statute 325E.64. “A person or entity is in violation of this section if its service provider retains such data subsequent to the authorization of the transaction.”
RSS feed for comments on this post. TrackBack URL
Leave a comment