Monday, January 9, 2012

SQLol - SQL Injection Testbed

Have you been wanting to learn more about SQL injection (SQLi) and practice identifying SQLi vectors in applications? A new SQLi testbed has been created by Trustwave that is easy to setup and provides a variety of SQLi vectors to practice on.

"SQLolis a configurable SQL injection testbed. It allows you to exploit SQL injection flaws, but furthermore allows a large amount of control over the manifestation of the flaw. The author thought about different data extraction techniques from SQL injection flaws and found that a vulnerability framework that includes SQLi verbose error extraction techniques was never found. To be precise, the author never came across a vulnerability framework that includes SQL injection in a DELETE query. So, with this aim in mind, SQLol was born, specifically for SQL injection flaws. It can be useful to those who know nothing about SQL injection, or those who know a bit of it. SQLol comes with a set of challenges which help you with performing some flavor of SQL injection and have pre-configured settings."

Options provided by SQLol:
  • Type of query (SELECT, DELETE, INSERT, UPDATE, and custom)
  • Location within query (String/Int in WHERE clause, column name, ORDER BY clause, etc.)
  • Type and level of sanitization (Single quotes [remove, escape, double], keyword blacklist [three levels of difficulty], etc.)
  • Level of query output (No rows, One row, All rows)
  • Verbosity of error messages (No errors, Generic errors, Verbose errors)
  • Visibility of query
  • Injection string entry point

Download SQLol

Monday, December 12, 2011

Free Online Education from Stanford University


Stanford Engineering professors are setting out to add a new level of interactivity to online education by offering the university's most popular computer science classes for free.

The class will consist of lecture videos, which are broken into small chunks, usually between eight and twelve minutes each. Some of these may contain integrated quiz questions. There will also be standalone quizzes that are not part of video lectures, and other assignments. There will be approximately two hours worth of video content per week.

You will not get university credit for participating in the courses. Expand your professional knowledge and earn some CISSP CPE credits instead!

Computer Security
http://www.security-class.org/
Dan Boneh, John Mitchell and Dawn Song
Class Starts February 2012

Learn how to design secure systems and write secure code. You will learn how to find vulnerabilities in code and how to design software systems that limit the impact of security vulnerabilities.

The course will cover topics such as:
  • Memory safety vulnerabilities
  • Techniques and tools for vulnerability detection
  • Sandboxing and isolation
  • Web security
  • Network security
  • Malware detection and defense
  • Mobile platform security
Other Online Free Courses
Computer Science - CS 101 - Class starts February 2012
Computer Science - Machine Learning - Class starts January 2012
Computer Science - Software as a Service - Class starts February 2012
Computer Science - Human-Computer Interaction - Class starts January 2012
Computer Science - Natural Language Processing - Class starts January 23, 2012
Computer Science - Game Theory - Class starts February 2012
Computer Science - Probabilistic Graphical Models - Class starts January 2012
Computer Science - Cryptography - Class starts January 2012
Computer Science - Design and Analysis of Algorithms I - Class starts January 23, 2012
Entrepreneurship - Lean Launchpad - Class starts February 2012
Entrepreneurship - Technology Entrepreneurship - Class starts January 2012
Medicine - Anatomy - Class starts January 2012
Civil Engineering - Making Green Buildings - Class starts January 2012
Electrical Engineering - Information Theory - Class starts March 2012
Complex Systems - Model Thinking - Class startsJanuary 23, 2012

Wednesday, November 23, 2011


The FBI is seeking information from individuals, corporate entities and Internet Services Providers who believe that they have been victimized by malicious software (“malware”) related to the defendants.

This malware modifies a computer’s Domain Name Service (DNS) settings, and thereby directs the computers to receive potentially improper results from rogue DNS servers hosted by the defendants.




Please use the following link http://www.fbi.gov/news/stories/2011/november/malware_110911 or navigate to the fbi.gov News section and select the 11.09.11 story entitled “International Cyber Ring That Infected Millions of Computers Dismantled” to learn about DNSChanger malware and how it can affect your computer, check your computer’s DNS settings, and register as a victim of the DNSChanger malware.

Thursday, November 10, 2011

Bad Password Campaign?

Google recently launched a major advertising campaign around its “Good to Know” guides for online safety and privacy. Google’s password advice has appeared on billboards and as a full-page ad in The Economist.

Their example of a “very strong password” is ‘2bon2btitq’, taken from the famous Hamlet quote “To be or not to be, that is the question”.

"Houston, we have a problem!!!!!"


According to the leaked 2009 RockYou password dataset, which contains 500,000 of the most common passwords, it was found that 4 people out of 32,603,387 picked ‘2bon2btitq’ and 5 out of 32,603,387 picked ‘2bon2b.’ An attacker, using the RockYou password dataset, would be able to successful crack or brute-force this example user password within 2-3 days.

Google’s advised password is not that strong!!!! Why is this?!?

Human passwords are the most common form of authentication for applications, systems and networks. Yet, we continue to face the challenge of easily guessed or cracked passwords due to users selecting easy passwords.

To overcome weak and easy passwords, we began to train our users to create mnemonic phrase-based passwords. But, we have forgotten there is still a human element in this approach. How common is the phrase, “To be or not to be, that is the question”? Humans will still resort to using common phrases, sayings, expressions, or favorite movie quotes for the creation of mnemonic phrased-based passwords. And attackers are taking these common lists and creating new password dictionaries for their attacks.

Don't get me wrong. Mnemonic phrased-based passwords have helped many people with improving the security and strength of their passwords. A recent study revealed there are still a huge number of people who pick from a very small list of common passwords.

In fact, 91% of all user passwords sampled all appear on the list of just the top 1,000 passwords. Even more interesting is that the list of the 10,000 most common passwords represents 99.8% of all user passwords!



For picking a strong password, it is recommend to use xkcd’s advice and tools like Diceware for generating something easy to memorize and nearly-guaranteed be unique. For mission critical systems and sensitive data, 2-factor authentication is the best solution for user authentication.

I recommend using 1Password and PasswordSafe for the management of multiple and complex passwords and as an alternative for users who write their passwords down and hide them under their keyboards! ;-)

FTC Takes on Super Cookies

On November 8, 2011, the Federal Trade Commission announced that an online advertiser, ScanScout, agreed to settle FTC charges that it deceptively used "Flash" cookies (also known as super cookies) to track consumers online.

As explained by Wired, unlike traditional browser cookies, Flash cookies are not controlled by privacy controls in a Web browser. That means that even if a user adjusts browser settings to clear the computer of tracking objects, Flash cookies most likely will remain.

FTC Allegations

According to the FTC, ScanScout is an advertising network that places video ads on websites for advertisers. ScanScout engages in behavioral advertising – it collects information about consumers’ online activities and then serves video ads targeted to their interests.

The FTC alleged that ScanScout deceptively claimed that consumers could opt out of receiving targeted ads by changing their computer’s Web browser settings to block cookies. Specifically, ScanScout's privacy policy stated that:

General user data, such as your computer’s Internet Protocol (IP) address, operating system and browser type, pages you visited, and the date and time of your visit, is automatically collected through the use of “cookies”. Cookies are small files that are stored on your computer by a website to give you a unique identification. Cookies also keep track of services you have used, record registration information regarding your login name and password, record your preferences and keep you logged into the Site. You can opt out of receiving a cookie by changing your browser settings to prevent the receipt of cookies. Since each web browser is different, we recommend that you please look through your browser “Help” file to learn the correct way to modify your cookies set-up. . . We may use automatically collected information and cookies information for a number of purposes, including but not limited to. . . provide custom, personalized content, and information; monitor the effectiveness of our marketing campaigns. . . (emphasis added)

According to the FTC, however, ScanScout actually used Flash cookies that users could not block by adjusting their Web browser settings. The FTC alleged that ScanScout's representations that consumers could prevent ScanScout from collecting data about their online activities by changing their browser settings were false or misleading and constituted deceptive acts or practices in or affecting commerce in violation of Section 5(a) of the Federal Trade Commission Act.

Tuesday, August 23, 2011

Rampant insider hacking at U.S. immigration agency

I have always tried to follow that old saying, "Learn from other people's mistakes, you don't have time to make all of them yourself". Over the past year, the security and business world has had a wealth of opportunity to learn from the many data breach incidents that have impacted multiple organizations. While most of the reports have been vague with attack vector information and root causes, there are lessons to be learned around prevention, effective detection and monitoring, and efficient incident response.

Here is a recent example:

As reported by Homeland Security Newswire, "A yearlong investigation by the DHS Inspector General has revealed multiple instances of insider hacking at U.S. Citizenship and Immigration Services (USCIS); the inspector general found that employees had accessed management-level email and other confidential files."

"According to the report, employees and supervisors abused logon privileges, gained unauthorized access, and even allegedly altered audit logs to delete any record of their activities. The inspector general’s investigation focused on seventeen individuals in particular, all of who were information technology specialists.

Investigators also found “hackware” on several computer drives – software that allows users to intercept sensitive information passing through the agency’s network."

"The inspector general warned that USCIS could be putting itself at greater risk from insider threats as a result of the poorly planned $2.4 billion project to automate immigration paperwork. USCIS Transformation is designed to be an online system for the agency’s immigration records that will improve fraud detection, but the inspector general said the program is missing controls to prevent internal hacking."

What can be learned from this incident as reported? First thing, as security professionals, we need to fully understand the main purpose and mission of the business that we work for and protect it. In this case, the "U.S. Citizenship and Immigration Services (USCIS) is the government agency that oversees lawful immigration to the United States."

The USCIS Mission Statement is:

"USCIS will secure America’s promise as a nation of immigrants by providing accurate and useful information to our customers, granting immigration and citizenship benefits, promoting an awareness and understanding of citizenship, and ensuring the integrity of our immigration system."

Hold on! Does this mission statement map to any of the 3 core tenants of security: Confidentiality, Integrity, Availability? Can you ascertain the main reason USCIS is in business? Absolutely, yet USCIS failed to meet the objectives of it's own mission statement!

Immigration and it's policies have continued to be one of the top two political topics in the US. Identity theft continues to be the prime motive for the majority of data breaches. So, why did a $2.4 billion project to automate immigration paperwork fail to address internal fraud when it has been proven that over half of all IT fraud and incidents are the result of "regular workers, privileged employees usually are the ones to target the company's most sensitive data."

I am going to take a guess that immigration records would be considered "sensitive data" for USCIS. This leads to our second lesson learned: do you have a data classification process in your organization? Do you know what systems process, store, and/or transmit each type of data within your organization? Do you know who has access to each type of data, where is the data being accessed from, when is the data being access, and what is being done to your data?

Collecting logs pertaining to network, system, application and database activities and actions is imperative to the success of your security program. According to the recent Verizon Data Breach report, 90 percent of the time, companies had logs available from the time of the incident, but only managed to discover breaches in five percent of cases. Technology exists to collect, correlate, and mine logs for anomalies which may indicate an internal or external breach. These types of technologies should be coupled to your data classification and system inventory. Any system, application, and database processing, storing, and/or transmitting your sensitive data should have auditing and logging enabled and sending it's logs to a centralized Security Information and Event Manager (SIEM) or log server.

The last lesson to be learned: access control management and auditing. Periodic audits, or the more positive saying "assurance activities", should be performed against all users, systems, and processes that pertain to your organization's sensitive data.

While we may not know or understand the overall root causes of the security failures with the new USCIS immigration system, security professionals around the world, in any organization, can use this incident report and build business cases for implementing new or enhanced policies, processes and activities within their organizations. Many organizations are "resource challenged" and prioritizing where we spend our limited resources is important. Data classification can help focus and prioritize where we spend our staff time and our budgets, and assist in building a strong strategy in protecting our organizations most sensitive assets.

Friday, August 12, 2011

Malware DNS Scraper v0.3.1 Error

Went to use the Malware DNS Scraper perl script from Mayhemic Lab and received the following error:

Malware DNS Scraper v0.3.1 - DNS Cache Scraper by Mayhemic Labs (mayhemiclabs.com)

Downloading the Mayhemic Labs malicious hosts list...
Error at https://secure.mayhemiclabs.com/malhosts/malhosts.txt
500 Can't connect to secure.mayhemiclabs.com:443 (certificate verify failed)
Aborting at malwarednsscrape-0.3.1.pl line 81.


To fix this issue, add the following line to malwarednsscrape-0.3.1.pl after the "use" module statements:

$ENV{'PERL_LWP_SSL_VERIFY_HOSTNAME'} = 0;