Manabu Ohta

54 papers A 1B 7C 8Misc 4Journal 5Unranked 29
YearRankTypeTitle / Venue / Authors
2025 conf
IMCOM
Shunpei Nakayama, Teruhito Kanazawa, Fumito Uwano, Manabu Ohta
2025 conf
IMCOM
Rikuto Sakai, Teruhito Kanazawa, Fumito Uwano, Manabu Ohta
2025 conf
ADMA (4)
Lingyu Li, Fumito Uwano, Manabu Ohta
2024 conf
HCI (8)
Fumito Uwano, Ran'u Kobayashi, Manabu Ohta
2024 conf
ICAART (Revised Selected Paper, 2)
Fumito Uwano, Ryota Kubo, Manabu Ohta
2024 conf
ICAART (3)
Ryota Kubo, Fumito Uwano, Manabu Ohta
2023 conf
ICADL (2)
Manabu Ohta, Hiroyuki Aoyagi, Fumito Uwano, Teruhito Kanazawa, Atsuhiro Takasu
2022 C conf
ICPRAM
Hiroyuki Aoyagi, Teruhito Kanazawa, Atsuhiro Takasu, Fumito Uwano, Manabu Ohta
2021 B conf
DocEng
Manabu Ohta, Ryoya Yamada, Teruhito Kanazawa, Atsuhiro Takasu
2019 B conf
DocEng
Manabu Ohta, Ryoya Yamada, Teruhito Kanazawa, Atsuhiro Takasu
2018 C conf
MEDES
Shunsuke Tanabe, Manabu Ohta, Atsuhiro Takasu, Jun Adachi
2018 C conf
MEDES
Ryoya Yamada, Manabu Ohta, Atsuhiro Takasu
2018 C conf
MEDES
Hirotaka Niitsuma, Daiki Kubota, Manabu Ohta
2017 conf
ICDIM
Daiki Namikoshi, Manabu Ohta, Atsuhiro Takasu, Jun Adachi
2016 conf
ICDIM
Daiki Matsuoka, Manabu Ohta, Atsuhiro Takasu, Jun Adachi
2016 B conf
DocEng
Junki Tanijiri, Manabu Ohta, Atsuhiro Takasu, Jun Adachi
2014 conf
ICADL
Naomichi Kawakami, Manabu Ohta, Atsuhiro Takasu, Jun Adachi
2014 B conf
Document Analysis Systems
Manabu Ohta, Daiki Arauchi, Atsuhiro Takasu, Jun Adachi
2014 C conf
APWeb
Yuki Tanimoto, Hirotaka Niitsuma, Manabu Ohta
2014 C conf
ICPRAM
Atsuhiro Takasu, Manabu Ohta
2014 conf
ICPRAM (Selected Papers)
Atsuhiro Takasu, Manabu Ohta
2012 B conf
Document Analysis Systems
Manabu Ohta, Daiki Arauchi, Atsuhiro Takasu, Jun Adachi
2012 conf
ICADL
Manabu Ohta, Daiki Arauchi, Atsuhiro Takasu, Jun Adachi
2012 J jnl
Int. J. Web Appl.
Manabu Ohta, Toshihiro Hachiki, Atsuhiro Takasu
2010 conf
ICUIMC
Manabu Ohta, Ryoji Fujita
2010 conf
ICUIMC
Yuki Tanimoto, Manabu Ohta
2010 Misc conf
IRI
Manabu Ohta, Ryohei Inoue, Atsuhiro Takasu
2009 Misc conf
IRI
Manabu Ohta, Toshihiro Hachiki, Atsuhiro Takasu
2008 conf
ICDIM
Manabu Ohta, Takayuki Yakushi, Atsuhiro Takasu
2008 conf
JCDL
Manabu Ohta, Atsuhiro Takasu
2007 conf
ICDIM
Manabu Ohta, Shun Yamasaki, Takayuki Yakushi, Atsuhiro Takasu
2006 J jnl
Multim. Tools Appl.
Yasuo Yamane, Tadashi Hoshiai, Hiroshi Tsuda, Manabu Ohta, Kaoru Katayama, Hiroshi Ishikawa
2005 Misc conf
ADC
Shohei Yokoyama, Manabu Ohta, Kaoru Katayama, Hiroshi Ishikawa
2005 conf
ICDE Workshops
Erwan Loisant, José Martinez, Hiroshi Ishikawa, Manabu Ohta, Kaoru Katayama
2005 conf
KES (1)
Hiroshi Ishikawa, Shohei Yokoyama, Manabu Ohta, Kaoru Katayama
2005 J jnl
J. Digit. Inf. Manag.
Ernest Weke Maina, Manabu Ohta, Kaoru Katayama, Hiroshi Ishikawa
2004 B conf
KES
Hiroshi Ishikawa, Yasuo Shioya, Takeshi Omi, Manabu Ohta, Kaoru Katayama
2004 conf
CVDB
Yasuo Yamane, Tadashi Hoshiai, Hiroshi Tsuda, Kaoru Katayama, Manabu Ohta, Hiroshi Ishikawa
2004 conf
NTCIR
Manabu Ohta, Hirokazu Narita, Shigeyoshi Ohno
2004 conf
Databases and Applications
Manabu Ohta, Hirokazu Narita, Kaoru Katayama, Hiroshi Ishikawa
2003 B conf
KES
Hiroshi Ishikawa, Manabu Ohta, Shohei Yokoyama, Takuya Watanabe, Kaoru Katayama
2002 C conf
ISMIS
Hiroshi Ishikawa, Toshiyuki Nakajima, Tokuyo Mizuhara, Shohei Yokoyama, Junya Nakayama, Manabu Ohta, Kaoru Katayama
2002 conf
Web, Web-Services, and Database Systems
Hiroshi Ishikawa, Manabu Ohta, Shohei Yokoyama, Junya Nakayama, Kaoru Katayama
2002 J jnl
Intell. Syst. Account. Finance Manag.
Hiroshi Ishikawa, Manabu Ohta, Shohei Yokoyama, Junya Nakayama, Kaoru Katayama
2001 C conf
ISADS
Hiroshi Ishikawa, Manabu Ohta
2001 conf
WebDyn@ICDT
Hiroshi Ishikawa, Manabu Ohta
2001 conf
RIDE-DM
Hiroshi Ishikawa, Manabu Ohta, Koki Kato
2001 conf
IMSA
Hiroshi Ishikawa, Shohei Yokoyama, Seiji Isshiki, Manabu Ohta
2001 Misc conf
ADC
Hiroshi Ishikawa, Manabu Ohta
2001 conf
DEXA Workshop
Hiroshi Ishikawa, Shohei Yokoyama, Seiji Isshiki, Manabu Ohta
2000 conf
ECDL
Manabu Ohta, Atsuhiro Takasu, Jun Adachi
2000 J jnl
Int. J. Digit. Libr.
Manabu Ohta, Atsuhiro Takasu, Jun Adachi
1998 conf
ECDL
Manabu Ohta, Atsuhiro Takasu, Jun Adachi
1997 A conf
ICDAR
Manabu Ohta, Atsuhiro Takasu, Jun Adachi
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