本人小白 ,尝试canal连接数据库 参照文档各种配置后 canal启动成功 但是数据库连接显示异常 这是怎么回事?跪求大佬告知
mysql中canal账号权限已加
canal1.1.1
mysql5.7
下面是cannal启动example日志
2020-10-13 17:19:14.482 [Thread-6] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - stop CannalInstance for null-example
2020-10-13 17:19:15.179 [Thread-6] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - stop successful....
2020-10-13 17:19:19.104 [main] INFO c.a.o.c.i.spring.support.PropertyPlaceholderConfigurer - Loading properties file from class path resource [canal.properties]
2020-10-13 17:19:19.111 [main] INFO c.a.o.c.i.spring.support.PropertyPlaceholderConfigurer - Loading properties file from class path resource [example/instance.properties]
2020-10-13 17:19:19.629 [main] INFO c.a.o.c.i.spring.support.PropertyPlaceholderConfigurer - Loading properties file from class path resource [canal.properties]
2020-10-13 17:19:19.630 [main] INFO c.a.o.c.i.spring.support.PropertyPlaceholderConfigurer - Loading properties file from class path resource [example/instance.properties]
2020-10-13 17:19:20.562 [main] INFO c.a.otter.canal.instance.spring.CanalInstanceWithSpring - start CannalInstance for 1-example
2020-10-13 17:19:20.571 [main] WARN c.a.o.canal.parse.inbound.mysql.dbsync.LogEventConvert - --> init table filter : ^.*\..*$
2020-10-13 17:19:20.571 [main] WARN c.a.o.canal.parse.inbound.mysql.dbsync.LogEventConvert - --> init table black filter : ^mysql\.slave_.*$
2020-10-13 17:19:20.795 [destination = example , address = /172.18.0.4:3306 , EventParser] WARN c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - ---> begin to find start position, it will be long time for reset or first position
2020-10-13 17:19:20.834 [main] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - start successful....
2020-10-13 17:19:20.837 [destination = example , address = /172.18.0.4:3306 , EventParser] WARN c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - prepare to find start position just show master status
2020-10-13 17:19:21.867 [destination = example , address = /172.18.0.4:3306 , EventParser] WARN c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - ---> find start position successfully, EntryPosition[included=false,journalName=mysql-bin.000004,position=4,serverId=123,gtid=<null>,timestamp=1602578716000] cost : 1040ms , the next step is binlog dump
以下cannal启动mysql数据库报错日志
2020-10-13T09:19:21.885041563Z 2020-10-13T09:19:21.882052Z 40 [Note] Aborted connection 40 to db: 'unconnected' user: 'canal' host: '172.18.0.2' (Got an error reading communication packets)
2020-10-13T09:19:21.954091411Z 2020-10-13T09:19:21.952107Z 41 [Note] Start binlog_dump to master_thread_id(41) slave_server(1), pos(mysql-bin.000004, 4)