A tiny typo in an automated email to thousands of customers turns out to be a big problem for legal

Unexpected consequences of the SQL Slammer worm

Who, Me? Do you check your emails before sending them? Re-read a dozen times but still that typo sneaks through? Welcome to a Who, Me? in which a reader learns that one mistyped letter can result in a visit from the legal department.

Our tale, from a reader Regomised as "Ali", takes place nearly 20 years ago, when he was in his first (and almost last) job in IT. His career, in a manner familiar to many, began on the helpdesk. And his company? An outfit that lurked behind the scenes for many of the personal websites that came bundled with the major ISPs of the era.

"We hosted about 1/3 of all existing websites at the time," he told us, "so if you had a little vanity site … we were probably the host."

Unfortunately for Ali, this was also the era of the SQL Slammer worm. One night the helpdesk lines lit up as customers found themselves unable to reach their sites. For those who don't remember the event, Slammer exploited a flaw in Microsoft's SQL Server (patched, but not applied everywhere) to cause denial of service on some hosts and generally slow down traffic on the internet.

Ali's helpdesk tickets up until this point had mainly consisted of users not knowing how to use the service: "Like how do I get my email, why can't I edit my site, what do you mean I need to own a computer to work on a website – I just bought a modem!"

"You know," he said, "all the usual BS that makes up about 90 per cent of all calls to the helpdesk."

Being a creative fellow, he put together macros that could go through the helpdesk queue and fire off the appropriate response. A little like the bots of today that annoy users so. Unlike those bots, Ali also built in some human interaction so he could check what was being sent before it actually went out. "Having it set to semi-auto like that made sure that any mistakes didn't get out of hand," he explained.

However, with the sheer volume of cases being generated by the SQL Slammer worm, Ali decided to go full-auto ("with my supervisor's blessing," he added, "which is probably what saved my ass from getting fired").

It was a simple enough task. The answer would be the same message. There was a security flaw with MSSQL that was responsible for screwing with everyone's day. It went out to around four thousand users.

Except there was a typo. Just a single letter, but pretty much the worst one that he could have got wrong. Rather than 'MSSQL', Ali managed to point the finger of blame at a well-known open-source relational database management system. It also transpired that his message managed to hit one of the bigwigs behind the project who, understandably, was not best pleased at their software being blamed for the cockup by a web host the size of Ali's.

The next evening, when Ali started his helpdesk shift, he was called into a meeting with all the company cheeses, from big to grand. The legal team, looking less than polished and more than flustered, were also present.

"That meeting went on for about seven years," recalled Ali with a shudder, "but oddly enough, it was only about an hour later that they let me go back to my desk and send out a 'correction' to all recipients of the first message."

No more was ever spoken about the event. "So I assume we didn't get sued into oblivion."

We've all sent that email with a critical typo, or referenced an attachment we forgot to include. But have your fat fingers ever resulted in thousands of raised eyebrows? Confess all with an email to Who, Me? ®

Similar topics

Broader topics

Other stories you might like

  • Lonestar plans to put datacenters in the Moon's lava tubes
    How? Founder tells The Register 'Robots… lots of robots'

    Imagine a future where racks of computer servers hum quietly in darkness below the surface of the Moon.

    Here is where some of the most important data is stored, to be left untouched for as long as can be. The idea sounds like something from science-fiction, but one startup that recently emerged from stealth is trying to turn it into a reality. Lonestar Data Holdings has a unique mission unlike any other cloud provider: to build datacenters on the Moon backing up the world's data.

    "It's inconceivable to me that we are keeping our most precious assets, our knowledge and our data, on Earth, where we're setting off bombs and burning things," Christopher Stott, founder and CEO of Lonestar, told The Register. "We need to put our assets in place off our planet, where we can keep it safe."

    Continue reading
  • Conti: Russian-backed rulers of Costa Rican hacktocracy?
    Also, Chinese IT admin jailed for deleting database, and the NSA promises no more backdoors

    In brief The notorious Russian-aligned Conti ransomware gang has upped the ante in its attack against Costa Rica, threatening to overthrow the government if it doesn't pay a $20 million ransom. 

    Costa Rican president Rodrigo Chaves said that the country is effectively at war with the gang, who in April infiltrated the government's computer systems, gaining a foothold in 27 agencies at various government levels. The US State Department has offered a $15 million reward leading to the capture of Conti's leaders, who it said have made more than $150 million from 1,000+ victims.

    Conti claimed this week that it has insiders in the Costa Rican government, the AP reported, warning that "We are determined to overthrow the government by means of a cyber attack, we have already shown you all the strength and power, you have introduced an emergency." 

    Continue reading
  • China-linked Twisted Panda caught spying on Russian defense R&D
    Because Beijing isn't above covert ops to accomplish its five-year goals

    Chinese cyberspies targeted two Russian defense institutes and possibly another research facility in Belarus, according to Check Point Research.

    The new campaign, dubbed Twisted Panda, is part of a larger, state-sponsored espionage operation that has been ongoing for several months, if not nearly a year, according to the security shop.

    In a technical analysis, the researchers detail the various malicious stages and payloads of the campaign that used sanctions-related phishing emails to attack Russian entities, which are part of the state-owned defense conglomerate Rostec Corporation.

    Continue reading
  • FTC signals crackdown on ed-tech harvesting kid's data
    Trade watchdog, and President, reminds that COPPA can ban ya

    The US Federal Trade Commission on Thursday said it intends to take action against educational technology companies that unlawfully collect data from children using online educational services.

    In a policy statement, the agency said, "Children should not have to needlessly hand over their data and forfeit their privacy in order to do their schoolwork or participate in remote learning, especially given the wide and increasing adoption of ed tech tools."

    The agency says it will scrutinize educational service providers to ensure that they are meeting their legal obligations under COPPA, the Children's Online Privacy Protection Act.

    Continue reading
  • Mysterious firm seeks to buy majority stake in Arm China
    Chinese joint venture's ousted CEO tries to hang on - who will get control?

    The saga surrounding Arm's joint venture in China just took another intriguing turn: a mysterious firm named Lotcap Group claims it has signed a letter of intent to buy a 51 percent stake in Arm China from existing investors in the country.

    In a Chinese-language press release posted Wednesday, Lotcap said it has formed a subsidiary, Lotcap Fund, to buy a majority stake in the joint venture. However, reporting by one newspaper suggested that the investment firm still needs the approval of one significant investor to gain 51 percent control of Arm China.

    The development comes a couple of weeks after Arm China said that its former CEO, Allen Wu, was refusing once again to step down from his position, despite the company's board voting in late April to replace Wu with two co-chief executives. SoftBank Group, which owns 49 percent of the Chinese venture, has been trying to unentangle Arm China from Wu as the Japanese tech investment giant plans for an initial public offering of the British parent company.

    Continue reading
  • SmartNICs power the cloud, are enterprise datacenters next?
    High pricing, lack of software make smartNICs a tough sell, despite offload potential

    SmartNICs have the potential to accelerate enterprise workloads, but don't expect to see them bring hyperscale-class efficiency to most datacenters anytime soon, ZK Research's Zeus Kerravala told The Register.

    SmartNICs are widely deployed in cloud and hyperscale datacenters as a means to offload input/output (I/O) intensive network, security, and storage operations from the CPU, freeing it up to run revenue generating tenant workloads. Some more advanced chips even offload the hypervisor to further separate the infrastructure management layer from the rest of the server.

    Despite relative success in the cloud and a flurry of innovation from the still-limited vendor SmartNIC ecosystem, including Mellanox (Nvidia), Intel, Marvell, and Xilinx (AMD), Kerravala argues that the use cases for enterprise datacenters are unlikely to resemble those of the major hyperscalers, at least in the near term.

    Continue reading

Biting the hand that feeds IT © 1998–2022