Hi, we are facing a problem with JDBC INPUT plugin connection to DB.
When Logstash service start, the following error is logged:
[2017-03-09T16:44:15,061][ERROR][logstash.pipeline ] Error registering plugin {:plugin=>"<LogStash::Inputs::Jdbc jdbc_connection_string=>"jdbc:mysql://172.26.254.114:3306/notificaciones?zeroDateTimeBehavior=convertToNull", jdbc_user=>"dispositivos", jdbc_password=>, jdbc_driver_library=>"/usr/share/java/mysql-connector-java.jar", jdbc_driver_class=>"com.mysql.jdbc.Driver", jdbc_validate_connection=>true, jdbc_validation_timeout=>120, jdbc_pool_timeout=>60, jdbc_paging_enabled=>true, jdbc_page_size=>50000, schedule=>"*/5 * * * *", statement=>"SELECT * from webservice where webservice_lastlogin > :sql_last_value", last_run_metadata_path=>"/var/lib/logstash/.logstash_jdbc_last_run", type=>"mysql-notificaciones", id=>"f10d0c3e9b16f8f90766179ac190d8acdd115182-2", enable_metric=>true, codec=><LogStash::Codecs::Plain id=>"plain_ea591014-0ea6-4b76-8431-fc8fa758675f", enable_metric=>true, charset=>"UTF-8">, sql_log_level=>"info", connection_retry_attempts=>1, connection_retry_attempts_wait_time=>0.5, use_column_value=>false, tracking_column_type=>"numeric", clean_run=>false, record_last_run=>true, lowercase_column_names=>true>", :error=>"Java::ComMysqlJdbcExceptionsJdbc4::CommunicationsException: Communications link failure\n\nThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server."}
MySQL connection from command line is working fine, using same parameters, like:
mysql -u dispositivos -p -h 172.26.254.114 -p 3306 notificaciones
So I thinking that there is a problem with the JDB Driver or something rleated.
I tried it jdbc-mysql-connector 5.1.40 and 5.1.41
Any help is appreciated.
Thanks