[ https://issues.apache.org/jira/browse/KAFKA-5798?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Randall Hauch resolved KAFKA-5798. ---------------------------------- Resolution: Invalid Closing as invalid, since this involves connectors that are not part of Apache Kafka. > Couldnt connect to mysql using mysql.jdbc driver > ------------------------------------------------ > > Key: KAFKA-5798 > URL: https://issues.apache.org/jira/browse/KAFKA-5798 > Project: Kafka > Issue Type: Bug > Components: KafkaConnect > Affects Versions: 0.10.0.1 > Environment: Ubuntu > Reporter: Bubesh Shankar Govindarajan > > Am a beginner to both java and kafka, trying to connect kafka and mysql to > stream data from mysql database and consume it via kafka consumers. > I have downloaded the confluent 3.3.0 from the below link > https://www.confluent.io/download/ > I am using - *confluent-3.3.0* > *+Java version :+* > $ java -version > openjdk version "9-Ubuntu" > OpenJDK Runtime Environment (build 9-Ubuntu+0-9b161-1) > OpenJDK Server VM (build 9-Ubuntu+0-9b161-1, mixed mode) > Mysql JDBC driver: *com.mysql.jdbc_5.1.5.jar* > I have started the zookeeper and kafka server using the below commands > * zookeeper-server-start > /home/bubesh/Kafka/confluent-3.3.0/etc/kafka/zookeeper.properties > * kafka-server-start > /home/bubesh/Kafka/confluent-3.3.0/etc/kafka/server.properties > *+I have used the below command to invoke kafka-connect - to connect to mysql > via jdbc driver:+* > connect-standalone > /home/bubesh/Kafka/confluent-3.3.0/etc/schema-registry/connect-avro-standalone.properties > > /home/bubesh/Kafka/confluent-3.3.0/etc/kafka-connect-jdbc/source-quickstart-mysql.properties > *+My CLASSPATH variable has: +* > /home/bubesh/JDBCDriver/com.mysql.jdbc_5.1.5.jar::/home/bubesh/Kafka/confluent-3.3.0/share/java/kafka/*:/home/bubesh/Kafka/confluent-3.3.0/share/java/confluent-common/*:/home/bubesh/Kafka/confluent-3.3.0/share/java/kafka-serde-tools/*:/home/bubesh/Kafka/confluent-3.3.0/share/java/kafka-connect-elasticsearch/*:/home/bubesh/Kafka/confluent-3.3.0/share/java/kafka-connect-hdfs/*:/home/bubesh/Kafka/confluent-3.3.0/share/java/kafka-connect-jdbc/*:/home/bubesh/Kafka/confluent-3.3.0/share/java/kafka-connect-s3/*:/home/bubesh/Kafka/confluent-3.3.0/share/java/kafka-connect-storage-common/* > *+Error while running the command:+* > Error: Config file not found: > /usr/lib/jvm/java-9-openjdk-i386/conf/management/management.properties > *+connect-avro-standalone.properties:+* > bootstrap.servers=localhost:9092 > key.converter=io.confluent.connect.avro.AvroConverter > key.converter.schema.registry.url=http://localhost:8081 > value.converter=io.confluent.connect.avro.AvroConverter > value.converter.schema.registry.url=http://localhost:8081 > internal.key.converter=org.apache.kafka.connect.json.JsonConverter > internal.value.converter=org.apache.kafka.connect.json.JsonConverter > internal.key.converter.schemas.enable=false > internal.value.converter.schemas.enable=false > offset.storage.file.filename=/tmp/connect.offsets > I use a VMware with Ubuntu installed in it and my MySQL sever is installed in > my host machine. I have also connected to this > *+ipconfig of the host:+* > Connection-specific DNS Suffix . : home > Link-local IPv6 Address . . . . . : fe80::c81:5928:4ee6:5a2d%9 > IPv4 Address. . . . . . . . . . . : 192.168.1.10 > Subnet Mask . . . . . . . . . . . : 255.255.255.0 > Default Gateway . . . . . . . . . : 192.168.1.1 > *+source-quickstart-mysql.properties:+* > name=mysql-whitelist-timestamp-source > connector.class=io.confluent.connect.jdbc.JdbcSourceConnector > tasks.max=1 > connection.url=jdbc:mysql://192.168.1.10:3306/sandbox?user=bubesh&password=bubesh21 > query=SELECT * from temp1 > mode=incrementing > incrementing.column.name=c1 > topic.prefix=mysql-test-topic1 -- This message was sent by Atlassian JIRA (v6.4.14#64029)