Created 12-15-2018 06:26 AM
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
Created 01-02-2019 11:04 PM
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.