All Apps and Add-ons

Splunk DB Connect: How to resolve MySQL connection error "Failed to initialize pool: Communications link failure"?

sshres5
Communicator

Trying to setup a connection through Splunk DB Connect to MySQL dB. However receiving following error:

com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Has anyone seen this error before? We just added mysql jar on the lib to have DB connection with mysql.
mysql-connector-java-5.1.40-bin.jar on our UNIX box

0 Karma
1 Solution

sshres5
Communicator

So yes, Firewall turned out to be the culprit. Once the firewall rule was implemented, DB connect was able to connect the DB without any issues.

View solution in original post

0 Karma

sshres5
Communicator

So yes, Firewall turned out to be the culprit. Once the firewall rule was implemented, DB connect was able to connect the DB without any issues.

View solution in original post

0 Karma

kannu
Communicator

@sshres5 @aaraneta

I have disabled the firewall on my splunk server where i have installed db connect app on my centos 7
using

sudo systemctl disable firewalld

[root@dserver sys]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
Active: inactive (dead)

But still i am facing the same issue

0 Karma

sshres5
Communicator

So, it might not be your host firewall that is causing the issue. It will be the connectivity between your DB connect host and where you are trying to query.
run following
nc -vz port

0 Karma

sshres5
Communicator

Looks like it is a Firewall issue. Will let y'all know if that was the reason for this.

0 Karma

aaraneta_splunk
Splunk Employee
Splunk Employee

Hi @sshres5 - Just checking in. Did it end up being a firewall issue or no? Either way, if you found the solution, be sure to post the answer below and "Accept" it so that others will know your post is resolved. Thanks!

0 Karma
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.