Skip to main content
Solved

Getting no results with DB Connect

  • March 11, 2025
  • 3 replies
  • 2 views
N

Hello,Given

  1. Successful DB connection config (attached)
  2. DB collector config (attached)

I get no results when i run the collector (attached)What is wrong or what is missing? Appreciate your support.

443_1d5fa1c74d414912b48483a86a458656.png443_386138bb6f1a4dce9078ff5f6eb45616.png443_d3283cae9b664a38b4c7ec01fc46054d.png

Best answer by noura ali

the issue lied in the syntax itself, so instead of
select * from RUNS ;
it should have been
select * from "RUNS" ;

    3 replies

    Raanan Dagan
    • Raanan Dagan
    • Employee
    • March 11, 2025

    Please try this:
    `select * from RUNS;`

    Instead of
    'select * from RUNS;'

    Can you verify this SQL query also return results independent of Cribl?

    If all of the above checks .. and you still do not get results .. try:

    • Last time I saw this issue the customer upgraded the Leader to a version that supports Postgres, but not the Workers
    • Make sure you commit and deploy
    B
    • Ben Marcus
    • Employee
    • March 11, 2025

    also check for any errors in the logs in cribl and/or auth errors in the postgres db logs.

    N
    • noura ali
    • Author
    • New Participant
    • Answer
    • March 11, 2025

    the issue lied in the syntax itself, so instead of
    select * from RUNS ;
    it should have been
    select * from "RUNS" ;

    Terms & ConditionsAccessibility statement