Getting no results with DB Connect

noura ali

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.

Raanan Dagan

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

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

Raanan Dagan

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

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

noura ali

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