topic Re: DBConnect - SQLconnection in Splunk Search

DBConnect - SQLconnection

gudavasr — Thu, 20 Jun 2013 23:02:38 GMT

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?

Re: DBConnect - SQLconnection

ziegfried — Thu, 20 Jun 2013 23:10:09 GMT

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.

Re: DBConnect - SQLconnection

gudavasr — Thu, 20 Jun 2013 23:16:26 GMT

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?

Re: DBConnect - SQLconnection

ziegfried — Thu, 20 Jun 2013 23:18:33 GMT

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.

Re: DBConnect - SQLconnection

gudavasr — Tue, 25 Jun 2013 20:07:14 GMT

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