Failed to connect mysql

[jiuaige]

*My database I can connect the mysql with tools navcat But when i run this process i got the error

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.). Stack trace: [com.telefonica.iot.cygnus.backends.sql.SQLBackendImpl$SQLDriver.getConnection(SQLBackendImpl.java:861), com.telefonica.iot.cygnus.backends.sql.SQLBackendImpl.createDestination(SQLBackendImpl.java:143), com.telefonica.iot.cygnus.sinks.NGSIMySQLSink.persistAggregation(NGSIMySQLSink.java:431), com.telefonica.iot.cygnus.sinks.NGSIMySQLSink.persistBatch(NGSIMySQLSink.java:350), com.telefonica.iot.cygnus.sinks.NGSISink.processRollbackedBatches(NGSISink.java:403), com.telefonica.iot.cygnus.sinks.NGSISink.process(NGSISink.java:375), org.apache.flume.sink.DefaultSinkProcessor.process(DefaultSinkProcessor.java:67), org.apache.flume.SinkRunner$PollingRunner.run(SinkRunner.java:145), java.lang.Thread.run(Thread.java:748)] time=2021-11-26T09:09:00.239Z | lvl=INFO | corr=N/A | trans=N/A | srv=N/A | subsrv=N/A | comp=cygnus-ngsi | op=doRollbackAgain | msg=com.telefonica.iot.cygnus.sinks.NGSISink[498] : Finishing internal transaction (dd89f352-e634-4ed9-b9e4-383c0c2da4d4), this was retry #10

My configration is

cygnus-ngsi.sources = http-source-mysql cygnus-ngsi.sinks = mysql-sink cygnus-ngsi.channels = mysql-channel

Mysql http-source

cygnus-ngsi.sources.http-source-mysql.type = org.apache.flume.source.http.HTTPSource cygnus-ngsi.sources.http-source-mysql.channels = mysql-channel cygnus-ngsi.sources.http-source-mysql.port = 5050 cygnus-ngsi.sources.http-source-mysql.handler = com.telefonica.iot.cygnus.handlers.NGSIRestHandler cygnus-ngsi.sources.http-source-mysql.handler.notification_target = /notify cygnus-ngsi.sources.http-source-mysql.handler.default_service = default cygnus-ngsi.sources.http-source-mysql.handler.default_service_path = / cygnus-ngsi.sources.http-source-mysql.interceptors = ts nmi cygnus-ngsi.sources.http-source-mysql.interceptors.ts.type = timestamp cygnus-ngsi.sources.http-source-mysql.interceptors.gi.type = com.telefonica.iot.cygnus.interceptors.NGSIGroupingInterceptor$Builder cygnus-ngsi.sources.http-source-mysql.interceptors.gi.grouping_rules_conf_file = /opt/apache-flume/conf/grouping_rules.conf cygnus-ngsi.sources.http-source-mysql.interceptors.nmi.type = com.telefonica.iot.cygnus.interceptors.NGSINameMappingsInterceptor$Builder cygnus-ngsi.sources.http-source-mysql.interceptors.nmi.name_mappings_conf_file = /opt/apache-flume/conf/name_mappings.conf

Mysql sink

cygnus-ngsi.sinks.mysql-sink.type = com.telefonica.iot.cygnus.sinks.NGSIMySQLSink cygnus-ngsi.sinks.mysql-sink.channel = mysql-channel

cygnus-ngsi.sinks.mysql-sink.enable_encoding = false

cygnus-ngsi.sinks.mysql-sink.enable_grouping = false

cygnus-ngsi.sinks.mysql-sink.enable_name_mappings = false

cygnus-ngsi.sinks.mysql-sink.enable_lowercase = false

cygnus-ngsi.sinks.mysql-sink.data_model = dm-by-entity

cygnus-ngsi.sinks.mysql-sink.mysql_host = 10.1.100.37 "agent.conf" 448L, 26625C

cygnus-ngsi.sinks.mysql-sink.data_model = dm-by-entity

cygnus-ngsi.sinks.mysql-sink.mysql_host = 10.1.100.37 cygnus-ngsi.sinks.mysql-sink.mysql_port = 3306 cygnus-ngsi.sinks.mysql-sink.mysql_username = root cygnus-ngsi.sinks.mysql-sink.mysql_password = 123456

cygnus-ngsi.sinks.mysql-sink.attr_persistence = row

cygnus-ngsi.sinks.mysql-sink.attr_native_types = false

cygnus-ngsi.sinks.mysql-sink.batch_size = 1

cygnus-ngsi.sinks.mysql-sink.batch_timeout = 30

cygnus-ngsi.sinks.mysql-sink.batch_ttl = 10

cygnus-ngsi.sinks.mysql-sink.mysql_options =

[AlvaroVega]

@jiuaige Which version did you use? Could you provide us more logs in DEBUG level ?