Splunk Search

Issues adding FileMaker driver to DB Connect

On_fire
Engager

I have Splunk version 5.0.2, build 149561 and DB Connect 1.0.8 running on an Ubuntu server 12.10.

I am trying to use DB Connect to connect to my FileMaker Server Advanced 12 and index some data, however it keeps throwing obscure errors. Any help to get this working would greatly appreciated already. Below are the errors that I get and what I have done so far.


When I try to to Fetch Database Names I get:


ERROR com.splunk.config.SplunkConfigurationException: Error instantiating typeClass com.filemaker.jdbc.Driver for database type filemaker: com.splunk.config.SplunkConfigurationException: Unable to create instance of class com.filemaker.jdbc.Driver




When I try to save the connection I get:


Encountered the following error while trying to save: In handler 'dbx-databases': Unknown error while validating database connection




I also get the following in the Splunk log:


ERROR AdminManager - Unknown error while validating database connection




Here is what I have done so far: (As per the DB Connect documentation)

I downloaded the driver (xDBC update for FileMaker Pro and FileMaker Server - version 12.3.103a) from:
http://www.filemaker.com/support/downloads/

And extracted the exe file and copied the jar from the JDBC folder to:

/opt/splunk/etc/apps/dbx/bin/lib

I changed the owner and permissions of fmjdbc.jar to match the other files in the folder.

I then copied:

/opt/splunk/etc/apps/dbx/default/database_types.conf

to

/opt/splunk/etc/apps/dbx/local/database_types.conf

and added a section to the top for FileMaker (Complete file):

http://pastebin.com/FBKfKegj

0 Karma
1 Solution

ziegfried
Influencer

The database_types.conf stanza you added uses the typeClass parameter. You should always use jdbcDriverClass instead as typeClass is only applicable to those database types that are defined by default. Here's an example how your stanza should look like for Filemaker:

[filemaker]
displayName = Filemaker
jdbcDriverClass = com.filemaker.jdbc.Driver
defaultPort = 2399
connectionUrlFormat = jdbc:filemaker://{0}/{2}

(This is not tested, but it might work)

View solution in original post

ziegfried
Influencer

The database_types.conf stanza you added uses the typeClass parameter. You should always use jdbcDriverClass instead as typeClass is only applicable to those database types that are defined by default. Here's an example how your stanza should look like for Filemaker:

[filemaker]
displayName = Filemaker
jdbcDriverClass = com.filemaker.jdbc.Driver
defaultPort = 2399
connectionUrlFormat = jdbc:filemaker://{0}/{2}

(This is not tested, but it might work)

On_fire
Engager

Thanks! This was exactly it.

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...