Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Starting HDF streamline suing mysql ERROR:Failed to initialize pool: Communication link failure: Bad handshake Caused by: java.sql.SQLException: Communication link failure: Bad handshake

Highlighted

Starting HDF streamline suing mysql ERROR:Failed to initialize pool: Communication link failure: Bad handshake Caused by: java.sql.SQLException: Communication link failure: Bad handshake

New Contributor

Executing the below command to start streamline gives error.

./streamline-server-start.sh /etc/streamline/conf/streamline.yaml

Streamline.yaml

# Jar storage configuration
fileStorageConfiguration:
  className: com.hortonworks.registries.common.util.LocalFileSystemStorage
  properties:
    directory: /hdf/streamline/jars
dashboardConfiguration:
  url: "http://<streamline_host>:9088"
storageProviderConfiguration:
  properties:
    db.properties:
      dataSource.password: "mysql_streamline_password"
      dataSource.url: "jdbc:mysql://<mysql_host>:3306/streamline"
      dataSource.user: "streamline"
      dataSourceClassName: "com.mysql.jdbc.jdbc2.optional.MysqlDataSource"
      #dataSourceClassName: "com.mysql.jdbc.Driver"
    db.type: mysql
    queryTimeoutInSecs: 30
  providerClass: "com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager"

Error

Exception in thread "main" com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Communication link failure: Bad handshake
	at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:544)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:536)
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
	at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)
	at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)
	at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)
	at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)
	at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)
	at com.hortonworks.streamline.webservice.StreamlineApplication.getStorageManager(StreamlineApplication.java:194)
	at com.hortonworks.streamline.webservice.StreamlineApplication.getDao(StreamlineApplication.java:183)
	at com.hortonworks.streamline.webservice.StreamlineApplication.registerResources(StreamlineApplication.java:215)
	at com.hortonworks.streamline.webservice.StreamlineApplication.run(StreamlineApplication.java:101)
	at com.hortonworks.streamline.webservice.StreamlineApplication.run(StreamlineApplication.java:75)
	at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)
	at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)
	at io.dropwizard.cli.Cli.run(Cli.java:75)
	at io.dropwizard.Application.run(Application.java:79)
	at com.hortonworks.streamline.webservice.StreamlineApplication.main(StreamlineApplication.java:79)
Caused by: java.sql.SQLException: Communication link failure: Bad handshake
	at com.mysql.jdbc.MysqlIO.init(Unknown Source)
	at com.mysql.jdbc.Connection.connectionInit(Unknown Source)
	at com.mysql.jdbc.jdbc2.Connection.connectionInit(Unknown Source)
	at com.mysql.jdbc.Driver.connect(Unknown Source)
	at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(Unknown Source)
	at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(Unknown Source)
	at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(Unknown Source)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:356)
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:199)
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:444)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:515)
	... 17 more


1 REPLY 1

Re: Starting HDF streamline suing mysql ERROR:Failed to initialize pool: Communication link failure: Bad handshake Caused by: java.sql.SQLException: Communication link failure: Bad handshake

New Contributor

After trying an extensive set of things, what worked was adding the path to the mysql-connector jar to the CLASSPATH in the .env file for streamline.

Don't have an account?
Coming from Hortonworks? Activate your account here