logstach启动成功,但是同步mysql数据出错
今天同步索引库时一直连不上mysql,找了半天问题,最后定位是引用的mysql的jar包版本有问题
Unable to connect to database. Tried 1 times {:error_message=>"Java::ComMysqlJdbcExceptionsJdbc4::CommunicationsException: Communications link failure\n\nThe last packet successfully received from the server was 67 milliseconds ago. The last packet sent successfully to the server was 62 milliseconds ago."}
我的mysql是5.7版本,原先一直使用mysql-connector-java-5.0.40.jar这个版本的包,然后怎么也连不上,网上找了很久,后来自己思考可能是jar包版本不匹配,改成8.0.13,成功连接数据库
jdbc_driver_library => "C:/Users/chencheng/.m2/repository/mysql/mysql-connector-java/8.0.13/mysql-connector-java-8.0.13.jar"
连接过程还遇到一个小问题
Unable to connect to database. Tried 1 times {:error_message=>"TypeError: could not coerce Fixnum to class java.lang.String"}
数据的用户名或者密码没有用引号""括起
jdbc_user => "root"
jdbc_password => "123456"