Hi,
I'm trying to set up my first MySQL database connection using the DB Connect app. I'm stuck at trying to create my database connection. I enter all my info (port, user, password, etc) and click Save. After a while Splunk comes back with this error:
Encountered the following error while trying to save: Splunkd daemon is not responding: ('Error connecting to /servicesNS/admin/dbx/dbx/databases: The read operation timed out',)
I know all my connection info is correct. This is a local DB (localhost server) and I can get in with the same password / user from the MySQL command line client. I've confirmed that the DB is running and Splunk shows that the Java Bridge server is running.
Any suggestions for what else I should check? There seemed to be a lot of posts on this topic but I haven't been able to fix the problem as of yet and I'm pretty new to Splunk.
Thanks,
Victorio
We got the same error while creating a cluster in Hadoopconnect - In backend -- CLI -- we changed the code in core-site.xml file and restarted splunk, after that it worked fine.
I get this trying to connect to MSSQL 2014. From my dbx.log I can see it trying to connection, but this is the last entry.
2015-05-08 10:46:25.023 dbx4931:DEBUG:MicrosoftSqlServer - Connecting to database=MicrosoftSqlServer using JDBC url=jdbc:jtds:sqlserver://sql1:1433/master;useCursors=true;ssl=request;appName=Splunk;progName=Splunk
Facing the same error message.
Env details: Win2008R2/SP1, Splunk 6.2.3, DB_Connect v1, SQL Server 2008R2 Express, Java v8 u45, Java Bridge is 'running'. Path in DBX auto-detected.
Attempting connection to locally installed McAfee ePO Server.
Splunk running as local admin user, SQL Server service configured for Windows Authentication running on port 1433.
I'd recommend that you open a support case so we can get a diag file and troubleshoot further.
I'm trying to setup MS SQL with the same error on Windows 7 - I copied the Jar files to the instructed dbx directory - can't we get any assistance on DB Connect?
Encountered the following error while trying to save: Splunkd daemon is not responding: ('Error connecting to /servicesNS/admin/dbx/dbx/databases: The read operation timed out',)
Curious as well, I seem to getting the same issue. Any posts that show an answer?
that error message seems to say that you're not able to contact the Splunk server, which means you're failing before you get to Java Bridge or MySQL. I'd make sure you're running as admin.
Also getting this error when trying to setup a connection from a Splunk 6.2 HWF to a MSSQL 2012 database server.
Java bridge is running, increased splunkdConnectionTimeout in web.conf to 90.
Logged into Splunk as admin/changeme and using DB Connect 1.
With DB Connect 2 I couldn't get the default cert to generate on this system.
I did not get it resolved.
Victorio, did you get this resolved? I am getting this same error message while creating my first DB connection. I did search for solutions to no avail.