All Apps and Add-ons

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

Motivator

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.
alt text

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

Kindly guide me how to fix this issue.

0 Karma
1 Solution

Motivator

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 

View solution in original post

0 Karma

Motivator

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 

View solution in original post

0 Karma

Motivator

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)

0 Karma

Motivator

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.

0 Karma

Motivator

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

0 Karma
Don’t Miss Global Splunk
User Groups Week!

Free LIVE events worldwide 2/8-2/12
Connect, learn, and collect rad prizes and swag!