FATAL: database "bsim" does not exist

[kirovgrad]

Have been through a lot until I was able to run the docker image in Docker desktop for Windows. But nothing that couldn't be solved with GPT.
After I established the session in IDA and all binary data was sent to sighthouse_fronted, it returns fatal error related to java.lang.Exception
Here is the IDA log:

>>> SightHouseIDAPluginMod.run() is invoked with argument value: 0.
Logging in to the signature server...
Uploading current binary...
Importing current binary...
Importing sections binary...
Analyzing the binary file...
pending : Nonepending : Nonefinished : Analysis failed:
java.lang.Exception: FATAL: database "bsim" does not exist
	at SightHouseFrontendScript.searchBSimSignatures(SightHouseFrontendScript.java:730)
	at SightHouseFrontendScript.searchSignatures(SightHouseFrontendScript.java:855)
	at SightHouseFrontendScript.processProgram(SightHouseFrontendScript.java:899)
	at SightHouseFrontendScript.run(SightHouseFrontendScript.java:917)
	at ghidra.app.script.GhidraScript.executeNormal(GhidraScript.java:405)
	at ghidra.app.script.GhidraScript.doExecute(GhidraScript.java:260)
	at ghidra.app.script.GhidraScript.execute(GhidraScript.java:238)
	at ghidra.app.util.headless.HeadlessAnalyzer.runScript(HeadlessAnalyzer.java:588)
	at ghidra.app.util.headless.HeadlessAnalyzer.runScriptsList(HeadlessAnalyzer.java:926)
	at ghidra.app.util.headless.HeadlessAnalyzer.processWithImport(HeadlessAnalyzer.java:1781)
	at ghidra.app.util.headless.HeadlessAnalyzer.processLocal(HeadlessAnalyzer.java:457)
	at ghidra.app.util.headless.AnalyzeHeadless.launch(AnalyzeHeadless.java:198)
	at ghidra.GhidraLauncher.launch(GhidraLauncher.java:81)
	at ghidra.Ghidra.main(Ghidra.java:54)
Request for matches...
Got 0 potential signatures!

And here is logs from sighthouse_fronted in docker:

INFO:werkzeug:172.18.0.3 - - [18/Jun/2026 14:57:43] "GET /api/v1/programs/3/analyze HTTP/1.1" 200 -
INFO  -----------------------------------------------------
    ARM Constant Reference Analyzer            4.093 secs
    ARM Symbol                                 0.017 secs
    ASCII Strings                              0.622 secs
    Apply Data Archives                        0.931 secs
    Call Convention ID                         1.780 secs
    Call-Fixup Installer                       0.019 secs
    Create Address Tables                      0.030 secs
    Create Address Tables - One Time           2.694 secs
    Create Function                            0.020 secs
    Data Reference                             0.881 secs
    Demangler GNU                              0.906 secs
    Disassemble                                0.016 secs
    Disassemble Entry Points                   3.992 secs
    Embedded Media                             0.023 secs
    External Entry References                  0.000 secs
    Function Start Pre Search                  0.020 secs
    Function Start Search                      0.799 secs
    Function Start Search After Code           1.014 secs
    Function Start Search After Data           0.296 secs
    Function Start Search delayed - One Time   0.000 secs
    Non-Returning Functions - Discovered       0.120 secs
    Reference                                  1.223 secs
    Shared Return Calls                        0.197 secs
    Stack                                      1.730 secs
    Subroutine References                      0.304 secs
-----------------------------------------------------
     Total Time   21 secs
-----------------------------------------------------
 (AutoAnalysisManager) 
INFO  SightHouseFrontendScript.class> REPORT: Analysis succeeded for file: binary.bin (GhidraScript)  
INFO  SightHouseFrontendScript.class> Adding function to program (GhidraScript)  
INFO  SightHouseFrontendScript.class> Search for similar functions (GhidraScript)  
INFO  SightHouseFrontendScript.class> Start searching for BSIM among 590 functions (GhidraScript)  
INFO  SightHouseFrontendScript.class> java.lang.Exception: FATAL: database "bsim" does not exist
    at SightHouseFrontendScript.searchBSimSignatures(SightHouseFrontendScript.java:730)
    at SightHouseFrontendScript.searchSignatures(SightHouseFrontendScript.java:855)
    at SightHouseFrontendScript.processProgram(SightHouseFrontendScript.java:899)
    at SightHouseFrontendScript.run(SightHouseFrontendScript.java:917)
    at ghidra.app.script.GhidraScript.executeNormal(GhidraScript.java:405)
    at ghidra.app.script.GhidraScript.doExecute(GhidraScript.java:260)
    at ghidra.app.script.GhidraScript.execute(GhidraScript.java:238)
    at ghidra.app.util.headless.HeadlessAnalyzer.runScript(HeadlessAnalyzer.java:588)
    at ghidra.app.util.headless.HeadlessAnalyzer.runScriptsList(HeadlessAnalyzer.java:926)
    at ghidra.app.util.headless.HeadlessAnalyzer.processWithImport(HeadlessAnalyzer.java:1781)
    at ghidra.app.util.headless.HeadlessAnalyzer.processLocal(HeadlessAnalyzer.java:457)
    at ghidra.app.util.headless.AnalyzeHeadless.launch(AnalyzeHeadless.java:198)
    at ghidra.GhidraLauncher.launch(GhidraLauncher.java:81)
    at ghidra.Ghidra.main(Ghidra.java:54)
 (GhidraScript)  
java.lang.Exception: FATAL: database "bsim" does not exist
    at SightHouseFrontendScript.searchBSimSignatures(SightHouseFrontendScript.java:730)
    at SightHouseFrontendScript.searchSignatures(SightHouseFrontendScript.java:855)
    at SightHouseFrontendScript.processProgram(SightHouseFrontendScript.java:899)
    at SightHouseFrontendScript.run(SightHouseFrontendScript.java:917)
    at ghidra.app.script.GhidraScript.executeNormal(GhidraScript.java:405)
    at ghidra.app.script.GhidraScript.doExecute(GhidraScript.java:260)
    at ghidra.app.script.GhidraScript.execute(GhidraScript.java:238)
    at ghidra.app.util.headless.HeadlessAnalyzer.runScript(HeadlessAnalyzer.java:588)
    at ghidra.app.util.headless.HeadlessAnalyzer.runScriptsList(HeadlessAnalyzer.java:926)
    at ghidra.app.util.headless.HeadlessAnalyzer.processWithImport(HeadlessAnalyzer.java:1781)
    at ghidra.app.util.headless.HeadlessAnalyzer.processLocal(HeadlessAnalyzer.java:457)
    at ghidra.app.util.headless.AnalyzeHeadless.launch(AnalyzeHeadless.java:198)
    at ghidra.GhidraLauncher.launch(GhidraLauncher.java:81)
    at ghidra.Ghidra.main(Ghidra.java:54)
INFO:werkzeug:127.0.0.1 - - [18/Jun/2026 14:57:45] "PUT /api/v1/programs/3/analyze HTTP/1.1" 200 -
[2026-06-18 14:57:45,025: INFO/ForkPoolWorker-1] frontendanalyzer.do_work[de30e5ad-1b79-4d86-ba94-fc6292812b1a]: Update status Response Code :: 200
[2026-06-18 14:57:45,025: INFO/ForkPoolWorker-1] frontendanalyzer.do_work[de30e5ad-1b79-4d86-ba94-fc6292812b1a]: Status update successfully.
[2026-06-18 14:57:45,032: INFO/ForkPoolWorker-1] Task frontendanalyzer.do_work[de30e5ad-1b79-4d86-ba94-fc6292812b1a] succeeded in 31.417511649999142s: 'Failure'
INFO:werkzeug:127.0.0.1 - - [18/Jun/2026 14:57:47] "GET /api/v1/ping HTTP/1.1" 200 -
INFO:werkzeug:172.18.0.3 - - [18/Jun/2026 14:58:13] "GET /api/v1/programs/3/analyze HTTP/1.1" 200 -

Information about binary:

Processor       : ARM
ARM architecture: ARMv7
Target assembler: Generic assembler for ARM
Byte sex        : Little endian

This binary statically linked with bunch of functions from MbedTLS library, so probably it should find something. I've tried it on several ARM binaries from ONT device in which I believe should be open-sourced function, but the result are always the same. Maybe you could help me?

[Fenrisfulsur]

Hi,

Nice to see people using our tool :D

This error likely indicates that you do not have an existing database. In order for the frontend to work, you need to provide a database with signatures which we do not provide "out of the box". But you can create one yourself using the pipeline.

It seems you are interested in the MbedTLS library. I would recommend starting from there. Unfortunately, the MbedTLS library needs to be built using CMake, which we do not support right now. That's something we can try to tackle in the near future. In the meantime, you can use PlatformIO scrapers/compilers. There are plenty of projects that include cryptography libraries such as MbedTLS, and since you are likely working on embedded firmware, there are plenty of other signatures that you can extract from there.

There is an example of how to run the pipeline here. It features PlatformIO, Linux kernel, glibc/uclibc and OpenSSL. If you just want the PlatformIO projects, you can remove the other targets inside pipeline.yml like this:

# pipeline.yml
name: Full Pipeline
description: Full pipeline running all developed modules
workers:

  # --- PlatformIO ---
  - name: scrap_platformio
    package: PlatformIo Scrapper
    target: preprocess_platformio

  - name: preprocess_platformio
    package: PlatformIo Preprocessor
    target: compile_platformio

  - name: compile_platformio
    package: PlatformIo Compiler
    target: analyzer

  # --- Analyzer ---
  - name: analyzer
    package: Ghidra Analyzer
    args:
      bsim:
        urls:
          - postgresql://user@bsim_postgres:5432/bsim
        min_instructions: 10
        max_instructions: 0

You can also tweak the docker-compose.yml to remove unnecessary workers (they shouldn't eat any CPU as they won't have anything to do).

Be aware that running the pipeline can take a LONG time as projects need to be downloaded, compiled and analyzed.

I hope this is a bit clearer now. If you have any other problems, please let me know. In the meantime, we will work on the CMake compiler as it looks to be a nice addition to the worker collection.