All Apps and Add-ons

Splunk DB Connect 2: Why am I getting MS SQL Connection error "Cannot create PoolableConnectionFactory (isValid() return false)"

crt89
Communicator

Good day Splunkers,

Been stuck on this for a day. Can't get to the connectivity to work. Please see attached image for my error. (karma to low for the image)

Here's the error message when validating the connection with the db.

Validating the connection with URL
[jdbc:sqlserver://<IP here>:<port>;databaseName=faultline;selectMethod=cursor] failed: java.sql.SQLException:,Cannot create PoolableConnectionFactory (isValid() return false)

Here's my setup
- I got my Heavy Forwarder to connect to the remote MS SQL db.
- Installed Splunk DB Connect 2 app on my HF.
- Got the ports open 1433 on my HF.
- JDBC driver properly installed which is 4.0 that has support for MS SQL 2005.
- Created authentication with proper credentials.

I can't seem to figure out what I missed. What I am curious about is, do I need to also open port 1433 on the remote DB server?

Hope to hear form the community.

Thanks

fdi01
Motivator
  • DB Connect 2.0.x also requires Java 8 and Microsoft JDBC driver.
  • don't use .jar file of windows on Linux, ...
    Download the MySQL Connector/J driver, version 5.1.24 or later (mysql-connector-java-*-bin.jar).
    don't use JDBC driver version 4.0 instead version 5.1.24 or later on db2.

  • Copy the mysql-connector-java-version-bin.jar file to the
    $SPLUNK_HOME/etc/apps/splunk_app_db_connect/bin/lib directory.

DBX V2 Troubleshooting

rajbir1
Explorer

I am experiencing the exact same issue with the same setup. Below is the error:

03/03/2016 14:52:55 [ERROR] [rh_connections.py] exception java.sql.SQLException: Validating connection with URL [jdbc:sqlserver://hostname:1433;databaseName=dbName;selectMethod=cursor;integratedSecurity=true;encrypt=true;trustServerCertificate=true] failed: java.sql.SQLException:java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:e7380d53-c6cc-4b6e-bb53-ca38a6c7117d) 

2016-03-03 15:08:35 ERROR ServiceResponder:437 - Service Responder Responds Error: 
java.sql.SQLException: Validating connection with URL [jdbc:sqlserver://hostname1433;databaseName=dbName;selectMethod=cursor;integratedSecurity=true] failed: java.sql.SQLException:java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:c689377f-9412-4a53-8451-296e50bdd288)
    at com.splunk.dbx2.Connector.isValid(Connector.java:359)
    at com.splunk.dbx2.DefaultDBX2JDBC.getConnectionStatus(DefaultDBX2JDBC.java:130)
    at com.splunk.dbx2.DBX2Proxy.getConnectionStatus(DBX2Proxy.java:64)
    at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:497)
    at com.splunk.dbx2.ServiceResponder.respond(ServiceResponder.java:422)
    at org.apache.avro.ipc.Responder.respond(Responder.java:151)
    at org.apache.avro.ipc.Responder.respond(Responder.java:99)
    at org.apache.avro.ipc.ResponderServlet.doPost(ResponderServlet.java:48)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
    at org.eclipse.jetty.server.Server.handle(Server.java:497)
    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
    at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
    at java.lang.Thread.run(Thread.java:745)
0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...