SQL-Ledger Version Detection

# 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.902009");
  script_tag(name:"cvss_base_vector", value:"AV:N/AC:L/Au:N/C:N/I:N/A:N");
  script_version("2026-05-07T06:32:13+0000");
  script_tag(name:"last_modification", value:"2026-05-07 06:32:13 +0000 (Thu, 07 May 2026)");
  script_tag(name:"creation_date", value:"2009-12-31 08:44:14 +0100 (Thu, 31 Dec 2009)");
  script_tag(name:"cvss_base", value:"0.0");
  script_name("SQL-Ledger Version Detection");
  script_category(ACT_GATHER_INFO);
  script_copyright("Copyright (C) 2009 Greenbone AG");
  script_family("Product detection");
  script_dependencies("find_service.nasl", "no404.nasl", "webmirror.nasl", "DDI_Directory_Scanner.nasl", "global_settings.nasl");
  script_require_ports("Services/www", 80);
  script_exclude_keys("Settings/disable_cgi_scanning");

  script_tag(name:"summary", value:"This script detects the installed SQL-Ledger version.");

  script_tag(name:"qod_type", value:"remote_banner");

  exit(0);
}

include("http_func.inc");
include("http_keepalive.inc");
include("port_service_func.inc");
include("list_array_func.inc");
include("cpe.inc");
include("host_details.inc");

port = http_get_port(default:80);

foreach dir( make_list_unique( "/sql-ledger", "/ledger", "/", http_cgi_dirs( port:port ) ) ) {

  install = dir;
  if( dir == "/" ) dir = "";

  rcvRes = http_get_cache( item: dir + "/login.pl", port:port );

  if( rcvRes =~ "^HTTP/1\.[01] 200" && ( "<title>SQL-Ledger" >< rcvRes || "images/sql-ledger.gif" >< rcvRes ) ) {

    version = "unknown";

    ver = eregmatch( pattern:">Version ([0-9.]+)", string:rcvRes );

    if( isnull( ver[1] ) ) {
      sndReq = http_get( item: dir + "/VERSION", port:port );
      rcvRes = http_keepalive_send_recv( port:port, data:sndReq );
      ver = eregmatch( pattern:"([0-9.]+)", string:rcvRes );
      if( ! isnull( ver[1] ) ) version = ver[1];
    } else {
      version = ver[1];
    }

    tmp_version = version + " under " + install;
    set_kb_item( name:"www/" + port + "/SQL-Ledger", value:tmp_version );
    set_kb_item( name:"sql-ledger/detected", value:TRUE );

    cpe = build_cpe( value:version, exp:"^([0-9.]+)", base:"cpe:/a:sql-ledger:sql-ledger:" );
    if( isnull( cpe ) )
      cpe = 'cpe:/a:sql-ledger:sql-ledger';

    register_product( cpe:cpe, location:install, port:port, service:"www" );

    log_message( data:build_detection_report( app:"SQL-Ledger",
                                              version:version,
                                              install:install,
                                              cpe:cpe,
                                              concluded:ver[0] ),
                                              port:port );
  }
}

exit( 0 );