FrontAccounting Multiple SQL Injection Vulnerabilities

# SPDX-FileCopyrightText: 2009 Greenbone AG
# Some text descriptions might be excerpted from (a) referenced
# source(s), and are Copyright (C) by the respective right holder(s).
#
# SPDX-License-Identifier: GPL-2.0-only

if(description)
{
  script_oid("1.3.6.1.4.1.25623.1.0.900258");
  script_version("2025-03-05T05:38:52+0000");
  script_tag(name:"last_modification", value:"2025-03-05 05:38:52 +0000 (Wed, 05 Mar 2025)");
  script_tag(name:"creation_date", value:"2009-11-30 15:32:46 +0100 (Mon, 30 Nov 2009)");
  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_cve_id("CVE-2009-4037", "CVE-2009-4046");
  script_name("FrontAccounting Multiple SQL Injection Vulnerabilities");
  script_xref(name:"URL", value:"http://www.vupen.com/english/advisories/2009/3223");
  script_xref(name:"URL", value:"http://frontaccounting.net/wb3/pages/posts/release-2.2-rc104.php");

  script_tag(name:"qod_type", value:"remote_banner");
  script_category(ACT_GATHER_INFO);
  script_copyright("Copyright (C) 2009 Greenbone AG");
  script_family("Web application abuses");
  script_dependencies("secpod_frontaccounting_detect.nasl");
  script_require_ports("Services/www", 80);
  script_mandatory_keys("frontaccounting/detected");

  script_tag(name:"impact", value:"Successful exploitation will allow attackers to access and modify the backend
  database by conducting SQL injection attacks.");

  script_tag(name:"affected", value:"FrontAccounting versions prior to 2.2 RC.");

  script_tag(name:"insight", value:"Input passed via multiple unspecified parameters to various scripts is not
  properly sanitised before being used in SQL queries. This can be exploited
  to manipulate SQL queries by injecting arbitrary SQL code.");

  script_tag(name:"solution_type", value:"VendorFix");

  script_tag(name:"solution", value:"Upgrade to FrontAccounting version 2.2 RC.");

  script_tag(name:"summary", value:"FrontAccounting is prone to multiple SQL Injection vulnerabilities.");

  exit(0);
}

include("http_func.inc");
include("port_service_func.inc");
include("version_func.inc");

faPort = http_get_port(default:80);

faVer = get_kb_item("www/" + faPort + "/FrontAccounting");
if(!faVer)
  exit(0);

faVer = eregmatch(pattern:"^(.+) under (/.*)$", string:faVer);
if(faVer[1])
{
  if(version_in_range(version:faVer[1], test_version:"2.2.0", test_version2:"2.2.Beta")) {
    report = report_fixed_ver(installed_version:faVer[1], vulnerable_range:"2.2.0 - 2.2.Beta");
    security_message(port: faPort, data: report);
    exit(0);
  }
}

exit(99);