Drupal is a free and open-source content-management framework.The standard release of Drupal, known as Drupal core, contains basic features common to content management systems.

A SQL injection vulnerability exists in Drupal core (CVE-2014-3704)

The expandArguments function in the database abstraction API in Drupal core 7.x before 7.32 does not properly construct prepared statements, which allows remote attackers to conduct SQL injection attacks via an array containing crafted keys. The API does not properly sanitize the key values. So a remote user can add user account by constructing a Post request with a malicious sql-query. Below example shows a Post request having an SQL statement.

This request successfully adds an user named ‘sqlinjection’.

Following are the before and after screenshots:

After

This vulnerability has been patched.

Dell Sonicwall Threats Research team has implemented following signature to prevent this attack

• IPS 1394: INSERT INTO Statement 3 (Possible SQL Injection)
• IPS 4168: UPDATE SET Statement 3 (Possible SQL Injection)
• IPS 1831: INSERT INTO Statement 1 (Possible SQL Injection)