Carolina Fuentes

32 papers A* 3A 1B 3Journal 12Unranked 13
YearRankTypeTitle / Venue / Authors
2026 A* conf
CHI
Sunbul M. Ahmad, Muneeb Imtiaz Ahmad, Carolina Fuentes, Nervo Verdezoto, Katarzyna Stawarz
2025 J jnl
SoftwareX
Bernardo Fernández-Zambrano, Carolina Fuentes, Pedro O. Rossel, Valeria Herskovic
2025 J jnl
Frontiers Robotics AI
Aisha Gul, Liam D. Turner, Carolina Fuentes
2025 J jnl
Comput. Support. Cooperative Work.
Sarah Dsane-Nsor, Aakash Gautam, Carolina Fuentes, Gideon Kwesi Toffah, Nervo Verdezoto, Yaseen Joolay, Melissa Densmore
2025 B conf
RO-MAN
Marc Roig Vilamala, Jack Furby, Julian de Gortari Briseno, Mani Srivastava, Alun D. Preece, Carolina Fuentes
2025 J jnl
Int. J. Soc. Robotics
Sunbul M. Ahmad, Muneeb Imtiaz Ahmad, Carolina Fuentes, Nervo Verdezoto, Katarzyna Stawarz
2024 B conf
RO-MAN
Aisha Gul, Liam D. Turner, Carolina Fuentes
2024 conf
CSCW Companion
Carla F. Griggio, Mayra Donaji Barrera Machuca, Marisol Wong-Villacres, Laura S. Gaytán-Lugo, Karla Badillo-Urquiola, Adriana Alvarado Garcia, Monica Perusquía-Hernández, Marianela Ciolfi Felice, Franceli L. Cibrian, Michaelanne Thomas, Carolina Fuentes, Pedro Reynolds-Cuéllar
2024 conf
CSCW Companion
Carolina Fuentes, Iyubanit Rodríguez, Gabriela Cajamarca, Laura Cabrera Quiros, Andrés Lucero, Valeria Herskovic, Kenton O'Hara
2024 conf
ICSR + AI (3)
Aisha Gul, Liam D. Turner, Carolina Fuentes
2023 J jnl
J. Ambient Intell. Humaniz. Comput.
Iyubanit Rodriguez, Pedro O. Rossel, Marcelo Fernández, Carolina Fuentes, Alberto León, Valeria Herskovic
2023 A* conf
CHI
Pedro Reynolds-Cuéllar, Marisol Wong-Villacres, Karla A. Badillo-Urquiola, Mayra Donaji Barrera Machuca, Franceli L. Cibrian, Marianela Ciolfi Felice, Carolina Fuentes, Laura Sanely Gaytán-Lugo, Vivian Genaro Motti, Monica Perusquía-Hernández, Oscar A. Lemus
2023 conf
CUI
Carolina Fuentes, Martin Porcheron, Joel E. Fischer
2023 A conf
Conference on Designing Interactive Systems
Gabriela Cajamarca, Valeria Herskovic, Stephannie Dondighual, Carolina Fuentes, Nervo Verdezoto
2022 J jnl
PeerJ Comput. Sci.
Fabián Fernández-Vera, Denisse C. Urrutia, Pedro O. Rossel, Valeria Herskovic, Carolina Fuentes
2019 conf
CHI Extended Abstracts
Carolina Fuentes, Martin Porcheron, Joel E. Fischer, Enrico Costanza, Nervo Verdezoto, Valeria Herskovic, Oren Zuckerman, Leila Takayama
2019 J jnl
CoRR
Carolina Fuentes, Martin Porcheron, Joel E. Fischer, Nervo Verdezoto, Oren Zuckerman, Enrico Costanza, Valeria Herskovic, Leila Takayama
2019 A* conf
CHI
Carolina Fuentes, Martin Porcheron, Joel E. Fischer, Enrico Costanza, Obaid Malik, Sarvapali D. Ramchurn
2018 J jnl
Comput. Support. Cooperative Work.
Lewis Hyland, Andy Crabtree, Joel E. Fischer, James A. Colley, Carolina Fuentes
2017 J jnl
J. Ambient Intell. Humaniz. Comput.
Carolina Fuentes, Valeria Herskovic, Iyubanit Rodriguez, Carmen Gerea, Maíra Marques, Pedro O. Rossel
2017 conf
HICSS
Iyubanit Rodriguez, Carolina Fuentes, Valeria Herskovic, José A. Pino
2017 J jnl
Mob. Inf. Syst.
Iyubanit Rodriguez, Gabriela Cajamarca, Valeria Herskovic, Carolina Fuentes, Mauricio Campos
2017 conf
UCAmI
Marcelo Fernández, Iyubanit Rodriguez, Pedro O. Rossel, Carolina Fuentes, Valeria Herskovic
2016 conf
UbiComp Adjunct
Iyubanit Rodriguez, Valeria Herskovic, Carolina Fuentes, Mauricio Campos
2016 B conf
TEI
Carolina Fuentes, Iyubanit Rodriguez, Valeria Herskovic
2016 conf
UCAmI (1)
Iyubanit Rodriguez, Carolina Fuentes, Valeria Herskovic, Mauricio Campos
2015 conf
AmIHEALTH
Carolina Fuentes, Iyubanit Rodriguez, Valeria Herskovic
2015 conf
UCAmI
Carolina Fuentes, Carmen Gerea, Valeria Herskovic, Maíra Marques, Iyubanit Rodriguez, Pedro O. Rossel
2014 J jnl
Int. J. Hum. Comput. Interact.
Carolina Fuentes, Carlos Hernández, Lizbeth Escobedo, Valeria Herskovic, Monica Tentori
2013 J jnl
J. Univers. Comput. Sci.
Valeria Herskovic, Carolina Fuentes, Richard Ibarra, Javier Bustos-Jiménez
2013 conf
UCAmI
Carolina Fuentes, Valeria Herskovic, Jurgen Heysen, Monica Tentori
2013 conf
ChileCHI
Carolina Sandoval, Camila Montero, Carolina Fuentes, Mariana Jordán
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