Ralf Teusner

49 papers B 4C 9Journal 14Unranked 21
YearRankTypeTitle / Venue / Authors
2023 conf
AMCIS
Lukas Böhme, Tobias Wuttke, Benedict Bender, Ralf Teusner, Sebastian Baltes, Christoph Matthies, Michael Perscheid
2023 J jnl
CoRR
Lukas Böhme, Tobias Wuttke, Ralf Teusner, Michael Perscheid, Sebastian Baltes, Christoph Matthies, Benedict Bender
2022 conf
HICSS
Christoph Matthies, Ralf Teusner, Michael Perscheid
2022 J jnl
Datenbank-Spektrum
Michael Perscheid, Hasso Plattner, Daniel Ritter, Rainer Schlosser, Ralf Teusner
2022 J jnl
SIGMOD Rec.
Michael Perscheid, Hasso Plattner, Daniel Ritter, Rainer Schlosser, Ralf Teusner
2021 conf
XP Workshops
Franziska Dobrigkeit, Christoph Matthies, Philipp Pajak, Ralf Teusner
2021 B conf
L@S
Sebastian Serth, Ralf Teusner, Christoph Meinel
2021 J jnl
CoRR
Franziska Dobrigkeit, Christoph Matthies, Ralf Teusner, Michael Perscheid
2021
Ralf Teusner
2021 B conf
L@S
Hendrik Steinbeck, Ralf Teusner, Christoph Meinel
2020 conf
SE
Christoph Matthies, Johannes Huegle, Tobias Dürschmid, Ralf Teusner
2020 conf
DeLFI
Sebastian Serth, Ralf Teusner, Christoph Meinel
2020 conf
ICSE (Workshops)
Frederike Ramin, Christoph Matthies, Ralf Teusner
2020 J jnl
CoRR
Frederike Ramin, Christoph Matthies, Ralf Teusner
2019 J jnl
CoRR
Christoph Matthies, Johannes Huegle, Tobias Dürschmid, Ralf Teusner
2019 conf
ICSE (SEET)
Christoph Matthies, Johannes Huegle, Tobias Dürschmid, Ralf Teusner
2019 conf
TALE
Christiane Hagedorn, Thomas Staubitz, Ralf Teusner, Christoph Meinel
2019 C conf
FIE
Sebastian Serth, Ralf Teusner, Jan Renz, Matthias Uflacker
2019 C conf
EDUCON
Thomas Staubitz, Ralf Teusner, Christoph Meinel
2018 J jnl
CoRR
Ralf Teusner, Thomas Hille, Christiane Hagedorn
2018 C conf
FIE
Christoph Matthies, Ralf Teusner, Guenter Hesse
2018 J jnl
CoRR
Christoph Matthies, Ralf Teusner, Guenter Hesse
2018 J jnl
CoRR
Ralf Teusner, Thomas Hille, Thomas Staubitz
2018 B conf
L@S
Ralf Teusner, Thomas Hille, Thomas Staubitz
2018 conf
LWMOOCS
Ralf Teusner, Thomas Hille
2018 J jnl
CoRR
Ralf Teusner, Christoph Matthies, Philipp Giese
2018 J jnl
CoRR
Ralf Teusner, Kai-Adrian Rollmann, Jan Renz
2018 C conf
FIE
Ralf Teusner, Christoph Matthies, Thomas Staubitz
2018 J jnl
CoRR
Ralf Teusner, Christoph Matthies, Thomas Staubitz
2017 C conf
FIE
Ralf Teusner, Thomas Hille, Christiane Hagedorn
2017 J jnl
Int. J. Eng. Pedagog.
Thomas Staubitz, Ralf Teusner, Christoph Meinel, Nishanth Prakash
2017 C conf
QRS
Ralf Teusner, Christoph Matthies, Philipp Giese
2017 B conf
L@S
Ralf Teusner, Kai-Adrian Rollmann, Jan Renz
2017 conf
TALE
Thomas Staubitz, Ralf Teusner, Christoph Meinel
2017 conf
TALE
Ralf Teusner, Nicholas Wittstruck, Thomas Staubitz
2017 conf
ABP
Thomas Staubitz, Ralf Teusner, Christoph Meinel
2016 conf
DeLFI
Thomas Staubitz, Ralf Teusner, Jan Renz, Christoph Meinel
2016 conf
ICL (1)
Catrina Tamara Grella, Thomas Staubitz, Ralf Teusner, Christoph Meinel
2016 conf
TALE
Thomas Staubitz, Ralf Teusner, Christoph Meinel, Nishanth Prakash
2016 C conf
EDUCON
Thomas Staubitz, Hauke Klement, Ralf Teusner, Jan Renz, Christoph Meinel
2016 conf
Urb-IoT
Keven Richly, Ralf Teusner
2015 conf
UrbanGIS@SIGSPATIAL
Keven Richly, Ralf Teusner, Alexander Immer, Fabian Windheuser, Lennard Wolf
2015 conf
ASE Workshops
Thomas Kowark, Ralf Teusner, Keven Richly, Hasso Plattner
2015 C conf
FIE
Martin von Löwis, Thomas Staubitz, Ralf Teusner, Jan Renz, Christoph Meinel, Susanne Tannert
2015 conf
TALE
Thomas Staubitz, Hauke Klement, Jan Renz, Ralf Teusner, Christoph Meinel
2014 conf
WBDB
Ralf Teusner, Michael Perscheid, Malte Appeltauer, Jonas Enderlein, Thomas Klingbeil, Michael Kusber
2013 J jnl
Electron. Commun. Eur. Assoc. Softw. Sci. Technol.
Ralf Teusner, Gregor Gabrysiak, Stefan Richter, Stefan Kleff
2013 C conf
EDUCON
Franka Grünewald, Elnaz Mazandarani, Christoph Meinel, Ralf Teusner, Michael Totschnig, Christian Willems
2013 conf
DeLFI
Franka Grünewald, Elnaz Mazandarani, Christoph Meinel, Ralf Teusner, Michael Totschnig, Christian Willems
redb/extractors/apk_extractors/apk_inconsistency_tests.py
← Index redb/extractors/apk_extractors/apk_inconsistency_tests.py python
import inspect
import re
from datetime import datetime, timezone
from typing import Any

from redb.extractors.enum import Tag
from redb.extractors.apk_extractor import APKExtractor
from redb.models.dataclasses import APKInconsistencyTests

# Emulator detection indicator strings
EMULATOR_INDICATORS = {
    "generic", "sdk", "google_sdk", "Emulator",
    "goldfish", "ranchu", "Andy", "Genymotion",
    "BlueStacks", "nox", "ttVM_Hdragon",
}

# Root detection indicator strings
ROOT_INDICATORS = {
    "/system/app/Superuser.apk",
    "/system/xbin/su",
    "/system/bin/su",
    "com.noshufou.android.su",
    "com.thirdparty.superuser",
    "eu.chainfire.supersu",
    "com.koushikdutta.superuser",
    "com.topjohnwu.magisk",
}

# Standard DEX filename pattern
STANDARD_DEX_PATTERN = re.compile(r"^classes\d*\.dex$")


class APKInconsistencyTestsExtractor(APKExtractor):

    def __init__(
        self, filepath, log, exporters=None, index_prefix=None,
        known_benign=False, known_malicious=False,
        apk=None,
    ):
        super().__init__(
            filepath, log, exporters, index_prefix,
            known_benign, known_malicious, apk,
        )
        self.test_results = None
        self.log.debug(inspect.currentframe().f_code.co_name)

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

    def _test_zip_bomb(self):
        """Check if any ZIP entry has compression ratio > 100:1."""
        try:
            zf = self._get_zip_file()
            if not zf:
                return None
            with zf:
                for info in zf.infolist():
                    if info.compress_size > 0:
                        ratio = info.file_size / info.compress_size
                        if ratio > 100:
                            return True
            return False
        except Exception as e:
            self.log.warning(f"Error in zip bomb test: {e}")
            return None

    def _test_zip_duplicate_entries(self):
        """Check for duplicate filenames in ZIP directory."""
        try:
            zf = self._get_zip_file()
            if not zf:
                return None
            with zf:
                names = [info.filename for info in zf.infolist()]
                return len(names) != len(set(names))
        except Exception as e:
            self.log.warning(f"Error in duplicate entries test: {e}")
            return None

    def _test_zip_path_traversal(self):
        """Check for path traversal (../) in ZIP entry names."""
        try:
            for f in self._list_files():
                if ".." in f or f.startswith("/"):
                    return True
            return False
        except Exception as e:
            self.log.warning(f"Error in path traversal test: {e}")
            return None

    def _test_zip_suspicious_timestamps(self):
        """Check for timestamps at epoch (1980) or in the future."""
        try:
            zf = self._get_zip_file()
            if not zf:
                return None
            now = datetime.now()
            with zf:
                for info in zf.infolist():
                    try:
                        dt = datetime(*info.date_time)
                        if dt.year <= 1980 or dt > now:
                            return True
                    except (ValueError, TypeError):
                        continue
            return False
        except Exception as e:
            self.log.warning(f"Error in suspicious timestamps test: {e}")
            return None

    def _test_hidden_dex_files(self):
        """Check for DEX files not matching classes*.dex pattern."""
        try:
            for f in self._list_files():
                if f.endswith(".dex"):
                    basename = f.split("/")[-1]
                    if not STANDARD_DEX_PATTERN.match(basename):
                        return True
            return False
        except Exception as e:
            self.log.warning(f"Error in hidden DEX files test: {e}")
            return None

    def _test_manifest_component_mismatch(self):
        """Check for declared components that don't exist in DEX."""
        try:
            if not self._is_valid_apk():
                return None

            # Get all class names from DEX
            dex_classes = set()
            try:
                from androguard.core.dex import DEX
                for dex_data in (self.apk.get_all_dex() or []):
                    try:
                        d = DEX(dex_data)
                        for cls in d.get_classes():
                            name = cls.get_name()
                            if name:
                                # Convert "Lcom/example/Foo;" to "com.example.Foo"
                                dex_classes.add(
                                    name[1:-1].replace("/", ".") if name.startswith("L") else name
                                )
                    except Exception:
                        continue
            except Exception:
                return None

            if not dex_classes:
                return None

            # Check manifest components against DEX classes
            components = []
            try:
                components.extend(self.apk.get_activities() or [])
                components.extend(self.apk.get_services() or [])
                components.extend(self.apk.get_receivers() or [])
                components.extend(self.apk.get_providers() or [])
            except Exception:
                return None

            for comp in components:
                if comp and comp not in dex_classes:
                    # Component might use a shorthand; check with package prefix
                    package = self.apk.get_package() or ""
                    full_name = package + comp if comp.startswith(".") else comp
                    if full_name not in dex_classes:
                        return True

            return False
        except Exception as e:
            self.log.warning(f"Error in manifest component mismatch test: {e}")
            return None

    def _test_debuggable_release(self):
        """Check android:debuggable=true combined with a release signature."""
        try:
            if not self._is_valid_apk():
                return None

            is_debuggable = self.apk.get_attribute_value(
                "application", "debuggable"
            ) == "true"

            if not is_debuggable:
                return False

            # Check if it has a signing certificate (release builds have certs)
            try:
                certs = self.apk.get_certificates()
                if certs and len(certs) > 0:
                    return True
            except Exception:
                pass

            return False
        except Exception as e:
            self.log.warning(f"Error in debuggable release test: {e}")
            return None

    def _get_dex_strings(self):
        """Get all string constants from DEX files."""
        all_strings = set()
        try:
            from androguard.core.dex import DEX
            for dex_data in (self.apk.get_all_dex() or []):
                try:
                    d = DEX(dex_data)
                    for s in d.get_strings():
                        if s:
                            all_strings.add(s)
                except Exception:
                    continue
        except Exception:
            pass
        return all_strings

    def _test_emulator_detection_strings(self):
        """Check for emulator detection patterns in DEX strings."""
        try:
            if not self._is_valid_apk():
                return None

            dex_strings = self._get_dex_strings()
            for indicator in EMULATOR_INDICATORS:
                for s in dex_strings:
                    if indicator in s:
                        return True
            return False
        except Exception as e:
            self.log.warning(f"Error in emulator detection test: {e}")
            return None

    def _test_debugger_detection(self):
        """Check for debugger detection API calls in DEX."""
        try:
            if not self._is_valid_apk():
                return None

            dex_strings = self._get_dex_strings()
            debugger_patterns = {
                "isDebuggerConnected",
                "waitingForDebugger",
                "Debug.isDebuggerConnected",
            }
            for pattern in debugger_patterns:
                for s in dex_strings:
                    if pattern in s:
                        return True
            return False
        except Exception as e:
            self.log.warning(f"Error in debugger detection test: {e}")
            return None

    def _test_root_detection(self):
        """Check for root detection patterns in DEX."""
        try:
            if not self._is_valid_apk():
                return None

            dex_strings = self._get_dex_strings()
            for indicator in ROOT_INDICATORS:
                for s in dex_strings:
                    if indicator in s:
                        return True
            return False
        except Exception as e:
            self.log.warning(f"Error in root detection test: {e}")
            return None

    def extract(self):
        if not self._is_valid_apk():
            self.log.error(f"Invalid APK for {self.hash.sha256}")
            return None

        self.test_results = APKInconsistencyTests(
            test_zip_bomb=self._test_zip_bomb(),
            test_zip_duplicate_entries=self._test_zip_duplicate_entries(),
            test_zip_path_traversal=self._test_zip_path_traversal(),
            test_zip_suspicious_timestamps=self._test_zip_suspicious_timestamps(),
            test_hidden_dex_files=self._test_hidden_dex_files(),
            test_manifest_component_mismatch=self._test_manifest_component_mismatch(),
            test_debuggable_release=self._test_debuggable_release(),
            test_emulator_detection_strings=self._test_emulator_detection_strings(),
            test_debugger_detection=self._test_debugger_detection(),
            test_root_detection=self._test_root_detection(),
        )
        return self.test_results

    def _bool_to_nullable(self, val):
        """Convert bool/None to ClickHouse Nullable(UInt8)."""
        if val is None:
            return None
        return int(val)

    def prepare_export_data(self, exporter_type: str) -> Any:
        if exporter_type == "ClickHouseExporter":
            if not self.test_results:
                return None

            current_time = datetime.now(timezone.utc)
            t = self.test_results

            data = [[
                self.sha256,
                self._bool_to_nullable(t.test_zip_bomb),
                self._bool_to_nullable(t.test_zip_duplicate_entries),
                self._bool_to_nullable(t.test_zip_path_traversal),
                self._bool_to_nullable(t.test_zip_suspicious_timestamps),
                self._bool_to_nullable(t.test_hidden_dex_files),
                self._bool_to_nullable(t.test_manifest_component_mismatch),
                self._bool_to_nullable(t.test_debuggable_release),
                self._bool_to_nullable(t.test_emulator_detection_strings),
                self._bool_to_nullable(t.test_debugger_detection),
                self._bool_to_nullable(t.test_root_detection),
                current_time,
            ]]

            column_names = [
                'sha256',
                'test_zip_bomb', 'test_zip_duplicate_entries',
                'test_zip_path_traversal', 'test_zip_suspicious_timestamps',
                'test_hidden_dex_files', 'test_manifest_component_mismatch',
                'test_debuggable_release', 'test_emulator_detection_strings',
                'test_debugger_detection', 'test_root_detection',
                'analysis_date',
            ]

            column_type_names = [
                'FixedString(64)',
                'Nullable(UInt8)', 'Nullable(UInt8)',
                'Nullable(UInt8)', 'Nullable(UInt8)',
                'Nullable(UInt8)', 'Nullable(UInt8)',
                'Nullable(UInt8)', 'Nullable(UInt8)',
                'Nullable(UInt8)', 'Nullable(UInt8)',
                "DateTime64(3, 'UTC')",
            ]

            return (data, column_names, column_type_names)

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