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!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

(view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...