Splunk Search

DBConnect - SQLconnection

gudavasr
Path Finder

Hi,
when I try to connect to sql server with dbconnect, i get this exception:
In handler 'dbx-databases': Unknown error while validating database connection

Can someone help how to fix this?

Tags (1)
0 Karma

gudavasr
Path Finder

The issue is:
in dbx/local/java.conf

i gave /usr/bin/ as java path.

Somewhere the process is adding bin i.e. the commandline is /usr/bin/bin/java instead of /usr/bin/java.

i changed java.conf to /usr/ and it started working.

the issue is found in jbridge.log

Thank You

ziegfried
Influencer

Without the java bridge running it won't work. Go to settings -> Configure DB Connect and make sure the java installation path is correct. If that doesn't help take a look into jbridge.log to find out why it's not starting.

0 Karma

gudavasr
Path Finder

no, java bridge is not running. I don't see dbx.log in my deployment.
I am looking at this doc: http://docs.splunk.com/Documentation/DBX/latest/

is there any other doc that I can follow?

0 Karma

ziegfried
Influencer

is the java bridge running? Are there any error messages in dbx.log? You can look for errors using the built-in saved search "Recent DB Connect errors" in the Searches dropdown in the app.

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...