Ian Kegel

32 papers A* 2B 1C 1Misc 1Journal 10Unranked 17
YearRankTypeTitle / Venue / Authors
2023 conf
ICIAP Workshops (1)
Michael Milliken, Andriy Kharechko, Ian Kegel, Brahim Allan, Shuai Zhang, Sally I. McClean
2023 J jnl
Algorithms
Zhi Chen, Shuai Zhang, Sally I. McClean, Fionnuala Hart, Michael Milliken, Brahim Allan, Ian Kegel
2022 J jnl
IEEE Access
Rafael de Andrade Moral, Zhi Chen, Shuai Zhang, Sally I. McClean, Gabriel R. Palma, Brahim Allan, Ian Kegel
2022 conf
ICCSPA
Vijaya Nirmala Mitnala, Martin J. Reed, Ian Kegel, John W. Bicknell
2022 J jnl
Multim. Syst.
Brahim Allan, Ian Kegel, Sri Harish Kalidass, Andriy Kharechko, Michael Milliken, Sally I. McClean, Bryan W. Scotney, Shuai Zhang
2021 conf
SmartWorld/SCALCOM/UIC/ATC/IOP/SCI
Zhi Chen, Shuai Zhang, Sally I. McClean, Brahim Allan, Ian Kegel
2019 J jnl
IEEE Trans. Cloud Comput.
Richard G. Clegg, Raul Landa, David Griffin, Miguel Rio, Peter Hughes, Ian Kegel, Tim Stevens, Peter R. Pietzuch, Doug Williams
2019 conf
CHI Extended Abstracts
Thomas Röggla, Jie Li, Stefan Fjellsten, Jack Jansen, Ian Kegel, Luke Pilgrim, Martin Trimby, Doug Williams, Pablo César
2019 conf
SmartWorld/SCALCOM/UIC/ATC/CBDCom/IOP/SCI
Zhi Chen, Shuai Zhang, Sally I. McClean, Gaye Lightbody, Michael Milliken, Ian Kegel, Aygul Garifullina
2018 conf
IPTComm
Yousif Humeida, Fabian Muller, Nicola Bull, Ian Kegel, Manfred Lutzky, Stefan Döhla, Martin Dietz
2018 B conf
HAI
Sha Li, Marian Florin Ursu, Doug Williams, Ian Kegel
2017 conf
TVX (Adjunct)
Ian Kegel, James Walker, Mark Lomas, Jack Jansen, John Wyver
2015 J jnl
IEEE Multim.
Doug Williams, Ian Kegel, Pablo César, Jack Jansen, Marian Florin Ursu, Erik Geelhoed
2014 conf
MoVid@MMSys
Simon N. B. Gunkel, Jack Jansen, Ian Kegel, Dick C. A. Bulterman, Pablo César
2012 A* conf
ACM Multimedia
Ian Kegel, Pablo César, Jack Jansen, Dick C. A. Bulterman, Tim Stevens, Joke Kort, Nikolaus Färber
2012 C conf
ICIDS
Michael Frantzis, Vilmos Zsombori, Marian Florin Ursu, Rodrigo Laiola Guimarães, Ian Kegel, Roland Craigie
2012 Misc conf
ICIN
Tim Stevens, Ian Kegel, Doug Williams, Pedro Torres, Pablo César, Phil Stenton, Rene Kaiser, Marian Florin Ursu, Manolis Falelakis, Nikolaus Färber
2011 conf
HT
Vilmos Zsombori, Michael Frantzis, Rodrigo Laiola Guimarães, Marian Florin Ursu, Pablo César, Ian Kegel, Roland Craigie, Dick C. A. Bulterman
2011 A* conf
ACM Multimedia
Rodrigo Laiola Guimarães, Pablo César, Dick C. A. Bulterman, Vilmos Zsombori, Ian Kegel
2011 J jnl
IEEE Trans. Multim.
Jack Jansen, Pablo César, Dick C. A. Bulterman, Tim Stevens, Ian Kegel, J. Issing
2011 J jnl
Telematics Informatics
Doug Williams, Marian Florin Ursu, Joshan Meenowa, Pablo César, Ian Kegel, Karl Bergström
2009 conf
EuroITV
Doug Williams, Marian Florin Ursu, Pablo César, Karl Bergström, Ian Kegel, Joshan Meenowa
2009 J jnl
Comput. Entertain.
Marian Florin Ursu, Vilmos Zsombori, John Wyver, Lucie Conrad, Ian Kegel, Doug Williams
2008 J jnl
ACM Trans. Multim. Comput. Commun. Appl.
Marian Florin Ursu, Maureen Thomas, Ian Kegel, Doug Williams, Mika Luma Tuomola, Inger Lindstedt, Terence Wright, Andra Leurdijk, Vilmos Zsombori, Julia Sussner, Ulf Myrestam, Nina Hall
2008 conf
EuroITV
Vilmos Zsombori, Marian Florin Ursu, John Wyver, Ian Kegel, Doug Williams
2008 J jnl
Multim. Syst.
Marian Florin Ursu, Ian Kegel, Doug Williams, Maureen Thomas, Harald Mayer, Vilmos Zsombori, Mika Luma Tuomola, Henrik Larsson, John Wyver
2007 conf
AAAI Fall Symposium: Intelligent Narrative Technologies
Marian Florin Ursu, Jonathan J. Cook, Vilmos Zsombori, Ian Kegel
2007 conf
AIIDE
Marian Florin Ursu, Jonathan J. Cook, Vilmos Zsombori, Ian Kegel, Tim Stevens, Harald Mayer, Michael Hausenblas
2007 conf
EuroITV
Marian Florin Ursu, Jonathan J. Cook, Vilmos Zsombori, Robert Zimmer, Ian Kegel, Doug Williams, Maureen Thomas, John Wyver, Harald Mayer
2007 conf
International Conference on Virtual Storytelling
Doug Williams, Ian Kegel, Marian Florin Ursu, Nico Pals, Andra Leurdijk
2007 conf
AIIDE
Marian Florin Ursu, Jonathan J. Cook, Vilmos Zsombori, Ian Kegel, Doug Williams, Michael Hausenblas, Mika Luma Tuomola
2004 conf
EWIMT
Doug Williams, Ian Kegel
redb/extractors/pe_extractors/pe_extra_findings.py
← Index redb/extractors/pe_extractors/pe_extra_findings.py python
from hashlib import md5, sha1, sha256
import inspect
import pefile
from magika import Magika
import json
from datetime import datetime, timezone
from typing import List, Optional, Any
from asn1crypto import cms, pem, x509, core
from dataclasses import asdict

from redb.extractors.enum import Tag
from redb.extractors.pe_extractor import PEExtractor
from redb.models.dataclasses import PEExtraFinding, PECertificate


class PEExtraFindings(PEExtractor):

    def __init__(
        self,
        filepath,
        log,
        exporters=None,
        index_prefix=None,
        elastic_index=None,
        known_benign=False,
        known_malicious=False,
        pe=None,
    ):
        super().__init__(
            filepath,
            log,
            exporters,
            index_prefix,
            elastic_index,
            known_benign,
            known_malicious,
            pe,
        )
        self.elastic_index = self.index_prefix + "-pe_extrafindings"
        self.log.debug(inspect.currentframe().f_code.co_name)
        self.has_binary_overlay = False
        self.has_binary_resource = False
        self.findings = []

    def tag(self):
        return Tag.PE_EMBEDDED_EXTRAS.value

    """
    The section below triggers in case of a binary which is not signed.
    It trigger the scan for Certificates inside the binary, for example
    inside a resource or an overlay.
    """

    def _scan_for_certificates(self):
        """
        Comprehensive scan for certificate data in PE file.
        Returns list of tuples (location_description, certificate_data)
        """
        self.log.debug(inspect.currentframe().f_code.co_name)

        # 1. Scan resources for embedded PE files
        self._scan_resources_for_certificates()

        # 3. Scan overlay
        overlay_data = self.pe.get_overlay()
        if overlay_data:
            self._scan_overlay_for_certificates(overlay_data)


    def _extract_certificate_info(self, cert_data):
        self.log.debug(inspect.currentframe().f_code.co_name)

        certificate = x509.Certificate.load(cert_data)
        certificate_serial_number = format(certificate.serial_number, "x").upper()
        grouped_serial_number = ":".join(
            [
                certificate_serial_number[i : i + 2]
                for i in range(0, len(certificate_serial_number), 2)
            ]
        )
        return PECertificate(
            certificate_serial_number=grouped_serial_number,
            certificate_issuer=certificate.issuer.human_friendly,
            certificate_subject=certificate.subject.human_friendly,
            certificate_valid_from=certificate["tbs_certificate"]["validity"][
                "not_before"
            ].native.strftime("%Y-%m-%d %H:%M:%S"),
            certificate_valid_to=certificate["tbs_certificate"]["validity"][
                "not_after"
            ].native.strftime("%Y-%m-%d %H:%M:%S"),
            certificate_thumbprint=sha1(cert_data).hexdigest().upper(),
            certificate_algorithm=None,
        )

    def _extract_standard_certificates(self, pe):
        self.log.debug(inspect.currentframe().f_code.co_name)
        address = pe.OPTIONAL_HEADER.DATA_DIRECTORY[
            pefile.DIRECTORY_ENTRY["IMAGE_DIRECTORY_ENTRY_SECURITY"]
        ].VirtualAddress
        size = pe.OPTIONAL_HEADER.DATA_DIRECTORY[
            pefile.DIRECTORY_ENTRY["IMAGE_DIRECTORY_ENTRY_SECURITY"]
        ].Size

        addr_8 = address + 8
        signature_data = bytes(
            pe.write()[addr_8 : addr_8 + size]  # noqa E203
        )  # Ensure this is a bytes object
        if pem.detect(signature_data):
            signature_data = pem.unarmor(signature_data)

        content_info = cms.ContentInfo.load(signature_data)
        signed_data = content_info["content"]
        certificates = signed_data["certificates"]

        certificates_list = []
        for cert in certificates:
            cert_info = self._extract_certificate_info(cert.chosen.dump())
            certificates_list.append(cert_info)

        return certificates_list

    def _is_signed(self, pedata):
        address = pedata.OPTIONAL_HEADER.DATA_DIRECTORY[
            pefile.DIRECTORY_ENTRY["IMAGE_DIRECTORY_ENTRY_SECURITY"]
        ].VirtualAddress
        if address == 0:
            return False
        return True

    def _scan_resources_for_certificates(self):
        """Scan resources for embedded PE files and their certificates"""
        self.log.debug(inspect.currentframe().f_code.co_name)

        try:
            if hasattr(self.pe, "DIRECTORY_ENTRY_RESOURCE"):
                for entry in self.pe.DIRECTORY_ENTRY_RESOURCE.entries:
                    for resource in self._get_resource_data(entry):
                        # Check if resource data might be a PE file
                        resource_magika = Magika().identify_bytes(resource).output.label
                        if resource.startswith(b"MZ") or resource_magika == "pebin":
                            try:
                                embedded_pe = pefile.PE(data=resource)
                                if self._is_signed(embedded_pe):
                                    cert_data = self._extract_standard_certificates(
                                        embedded_pe
                                    )
                                    if cert_data:
                                        # certificates.append(
                                        #     (f"Resource_{entry.id}", cert_data)
                                        # )
                                        self.findings.append(
                                            PEExtraFinding(
                                                context=f"Resource ({sha256(resource).hexdigest()}) is a PE file. Found Code Signing Certificates information inside.",
                                                finding=cert_data,
                                            )
                                        )
                            except Exception as e:
                                self.log.warning(
                                    f"Resource {sha256(resource).hexdigest()} is not a valid PE: {e}"
                                )

                        # Direct certificate pattern matching in resource
                        cert_data = self._find_certificate_patterns(resource)
                        if cert_data:
                            # certificates.append((f"Resource_{entry.id}", cert_data))
                            self.findings.append(
                                PEExtraFinding(
                                    context=f"Resource ({sha256(resource).hexdigest()}) is a PE file.\
                                    Found Code Signing Certificates information inside.",
                                    finding=cert_data,
                                )
                            )

        except Exception as e:
            self.log.error(f"Failed to scan resources: {e}")


    def _scan_overlay_for_certificates(self, overlay_data) -> List[bytes]:
        """Scan PE overlay for certificate data"""
        self.log.debug(inspect.currentframe().f_code.co_name)
        try:
            # Check if overlay is a PE file
            overlay_magika = Magika().identify_bytes(overlay_data).output.ct_label
            if overlay_data.startswith(b"MZ") or overlay_magika == "pebin":
                try:
                    overlay_pe = pefile.PE(data=overlay_data)
                    if self._is_signed(overlay_pe):
                        cert_data = self._extract_standard_certificates(overlay_data)
                        if cert_data:
                            self.findings.append(
                                PEExtraFinding(
                                    context=f"Overlay data ({sha256(overlay_data).hexdigest()}) is a PE file.\
                                    Found Code Signing Certificates information inside.",
                                    finding=cert_data,
                                )
                            )
                except Exception as e:
                    self.log.warning(f"Error looking for certificates in Overlay: {e}")
                    pass

            # Direct certificate pattern matching in overlay
            cert_data = self._find_certificate_patterns(overlay_data)
            if cert_data:
                self.findings.append(
                    PEExtraFinding(
                        context=f"Overlay data ({sha256(overlay_data).hexdigest()}) is a PE file.\
                        Found Code Signing Certificates information inside.",
                        finding=cert_data,
                    )
                )
        except Exception as e:
            self.log.error(f"Failed to scan overlay: {e}")


    def _get_resource_data(self, entry) -> List[bytes]:
        """Recursively get resource data"""
        resources = []
        try:
            if hasattr(entry, "directory"):
                for subentry in entry.directory.entries:
                    resources.extend(self._get_resource_data(subentry))
            else:
                data = self.pe.get_data(
                    entry.data.struct.OffsetToData, entry.data.struct.Size
                )
                resources.append(data)
        except Exception as e:
            self.log.error(f"Failed to get resource data: {e}")
        return resources

    def _find_certificate_patterns(self, data: bytes) -> Optional[bytes]:
        """Find certificate patterns in binary data"""
        # PKCS#7 SignedData OID pattern
        PKCS7_PATTERN = b"\x06\x09\x2A\x86\x48\x86\xF7\x0D\x01\x07\x02"

        try:
            idx = data.find(PKCS7_PATTERN)
            if idx != -1:
                # Search backwards for ASN.1 sequence marker
                for i in range(idx, max(0, idx - 50), -1):
                    if data[i] == 0x30:  # ASN.1 SEQUENCE
                        try:
                            # Try to parse as X.509 certificate
                            cert = x509.load_der_x509_certificate(
                                data[i:], default_backend()
                            )
                            return data[i:]
                        except Exception:
                            continue
        except Exception as e:
            self.log.error(f"Failed to find certificate patterns: {e}")
        return None

    def prepare_export_data(self, exporter_type: str) -> Any:
        self.log.debug(inspect.currentframe().f_code.co_name)
        if exporter_type == "ElasticsearchExporter":
            return self.findings
        elif exporter_type == "ClickHouseExporter":
            current_time = datetime.now(timezone.utc)
            
            data = [
                [
                    self.sha256,
                    self.md5,
                    self.sha1,
                    finding.context,
                    [asdict(cert) for cert in finding.finding] if finding.finding else None,
                    current_time
                ]
                for finding in self.findings
            ]
            
            column_names = [
                'sha256', 'md5', 'sha1', 'context', 'finding', 'analysis_date'
            ]
            
            if not data:
                return None

            column_type_names = [
                'FixedString(64)', 'FixedString(32)', 'FixedString(40)',
                'String', 'Array(JSON)', 'DateTime64(3, \'UTC\')'
            ]

            return (data, column_names, column_type_names)

    def get_clickhouse_table(self) -> str:
        return "redb_extra_findings"

    def extract(self):
        try:
            self.log.debug(inspect.currentframe().f_code.co_name)
            self._scan_for_certificates()
            if len(self.findings) > 0:
                return self.findings
            return None
        except Exception as e:
            self.log.error(f"Error extracting PE Extras: {e}")
            return None