MySQL Binary Log Error against AWS RDS MySQL data source

asked 2020-07-01 16:12:22 -0500

scfox gravatar image

I keep receiving this error: initialization error: java.lang.RuntimeException: Failed to get driver instance for jdbcUrl:...

when trying to run a simple pipeline with DataCollector against a simple MySQL RDS instance. DataCollector is deployed on an EC2 running Amazon Linux 2 with the AMI from the AWS Marketplace.

I followed the instructions here: https://streamsets.com/documentation/... and the troubleshooting steps here: https://streamsets.com/documentation/...

and tried 4 different JDBC libraries as discussed here: https://streamsets.com/documentation/...

I tried 3 most recent versions of Red Hat Linux (since closest in lineage to Amazon Linux) as well as Fedora, and even Ubuntu since the "About" says version built by Ubuntu, specifically: mysql-connector-java-8.0.20-1.el6.noarch.rpm mysql-connector-java-8.0.20-1.el7.noarch.rpm mysql-connector-java-8.0.20-1.el8.noarch.rpm mysql-connector-java-8.0.20-1.fc32.noarch.rpm mysql-connector-java_8.0.20-1ubuntu20.04_all.deb

All 5 gave same error.

I verified connectivity and user/password by installing mysql client on the same EC2 and was able to access RDS instance.

Version: StreamSets Data Collector 3.16.1

I installed each via the Package Manager in the GUI, and verified the files were put in the correct place by SSH'ing to the instance and checking the /opt/sdc-extras directory, and restarting the

Is this truly a driver issue or is it masking some other issue? Would like to use StreamSets to move our numerous mySQL instances data to Snowflake, but this is so far a show-stopper.

Thanks.

edit retag flag offensive close merge delete