We have updated our Terms of Service, Code of Conduct, and Addendum.

Getting no results with DB Connect

noura ali
noura ali Posts: 4
edited September 22 in General Discussions

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.

Tagged:

Best Answers

  • Raanan Dagan
    Raanan Dagan Posts: 101 mod
    Answer ✓

    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

  • noura ali
    noura ali Posts: 4
    Answer ✓

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

Answers

  • Raanan Dagan
    Raanan Dagan Posts: 101 mod
    Answer ✓

    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

  • Ben Marcus
    Ben Marcus Posts: 27 mod

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

  • noura ali
    noura ali Posts: 4
    Answer ✓

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