Splunk DB connect 3.14: How to resolve MY SQL Communications link failure?

[Hemnaath]

Hi All,

I am trying to setup a connection through Splunk DB Connect to MySQL dB. When I trying to create the connection and trying to save the created Connection, I am getting this error.

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.

Steps:
1) Created database and table using the phpMyAdmin.
2) Uploaded Splunk DB connect app 3:14 version in Splunk (Single instance)
3) Installed Java Run time Environment version 8 and database driver mysql-connector-java-8.0.18
4) Created Identity with user name and password.
5) While creating the connection and provided the below details and when I am try to save I am getting the above error.

Details:
a)Connection Name : mysql_test
b)Identity: mysql_identity
c)Connection Type: MYSQL
d)Time Zone: Asia/Kolkata +05:30
e)JDBC URL settings : local
f)Port : 3306
g)Default Database : splunk_db_connect_demo

Reset of the other option is set as default value and permission Set Global and while trying to save the detail, I am getting the above, attached screen shot for reference.

Ports used:
MYSQL:3306
Apache:10080 & 10443
Management Port: 8089
Splunk Web port:8000

Kindly guide me how to fix this issue.

[Hemnaath · Accepted solution]

Hi Team, I have fixed the issue by correcting the time zone issue by following the below link.

Problem :  Unable to communicate with MYSQL database from Splunk DB-Connect 

Error:  The server time zone value 'unknown' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

Solution:  jdbc:mysql://localhost/splunk_db_connect_demo?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

Link : https://stackoverflow.com/questions/26515700/mysql-jdbc-driver-5-1-33-time-zone-issue 

[Hemnaath]

Hi All,
I have tried to re-install the complete setup from the beginning by installing Xampp and creating MYSQL database via phpmyadmin and finally reinstalled the splunk db connect app but still I am facing an issue in creating the connection, could please guide how to fix this issue.

Details:

Database name : splunk_db_connect_demo
    username: root
    password:splunk123
    MYSQL:3306
    Apache:10080 & 10443
    Management Port: 8089
    Splunk Web port:8000
    identity name:mysql_identity
    password:same password
Permission to the app is set as global.

While trying to save the connection, I am getting below error. kindly guide me how to fix this issue.

Access denied for user 'root'@'localhost' (using password: YES)

[Hemnaath]

When I tried to use the password field = blankspace, and trying to save connection, I am getting the below error details.

The server time zone value 'unknown' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

Kindly guide where I need to correct this.

[Hemnaath]

Hi Team, Can anyone guide me on this issue, I am unable to identify where the issue is.