# Logstash-7.8.1 - Couldn't connect MySQL jdbc on plugin logstash-integration-jdbc (5.0.5)

**URL:** <https://discuss.elastic.co/t/logstash-7-8-1-couldnt-connect-mysql-jdbc-on-plugin-logstash-integration-jdbc-5-0-5/252767>\
**Category:** Logstash\
**Created:** [October 21, 2020, 4:34am UTC](https://discuss.elastic.co/t/logstash-7-8-1-couldnt-connect-mysql-jdbc-on-plugin-logstash-integration-jdbc-5-0-5/252767 "2020-10-21T04:34:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![matthewdeepblue](https://avatars.discourse-cdn.com/v4/letter/m/e5b9ba/32.png) [@matthewdeepblue](https://discuss.elastic.co/u/matthewdeepblue)\
**Post date:** [October 21, 2020, 4:34am UTC](https://discuss.elastic.co/t/logstash-7-8-1-couldnt-connect-mysql-jdbc-on-plugin-logstash-integration-jdbc-5-0-5/252767/1 "2020-10-21T04:34:44Z")

</div>

Hi guys.

I got error message below when I tried to connect MySQL RDS through logstash plugin.

please post here if you guys have any idea.

Thanks.

```auto
[2020-10-21T04:27:23,538][ERROR][logstash.inputs.jdbc] Unable to connect to database. Trying again {:error_message=>"Java::ComMysqlCjJdbcExceptions::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."}

input {
  jdbc {
    jdbc_driver_library => "/usr/share/java/mysql-connector-java.jar"
    jdbc_driver_class => "com.mysql.cj.jdbc.Driver"
    jdbc_connection_string => "jdbc:mysql://rdshostnameurl:3306/IXDB"
# jdbc_connection_string => "jdbc:mysql://ipaddress:3306/IXDB"
    jdbc_user => "mysqluser"
    jdbc_password => "mysqlpassword"
    jdbc_pool_timeout => 60
    connection_retry_attempts => 5
    statement_filepath => "/etc/logstash/templates/statistics_mysql.sql"
    schedule => "* * * * *"
  }
}
output {
  stdout{}
}

```

---

<div class="post-metadata">

**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\
**Post date:** [October 21, 2020, 6:46am UTC](https://discuss.elastic.co/t/logstash-7-8-1-couldnt-connect-mysql-jdbc-on-plugin-logstash-integration-jdbc-5-0-5/252767/2 "2020-10-21T06:46:42Z")

</div>

try this  
jdbc\_driver\_library =\> "mysql-connector-java-5.1.36-bin.jar"

---

<div class="post-metadata">

**Author:** ![matthewdeepblue](https://avatars.discourse-cdn.com/v4/letter/m/e5b9ba/32.png) [@matthewdeepblue](https://discuss.elastic.co/u/matthewdeepblue)\
**Post date:** [October 21, 2020, 7:57am UTC](https://discuss.elastic.co/t/logstash-7-8-1-couldnt-connect-mysql-jdbc-on-plugin-logstash-integration-jdbc-5-0-5/252767/3 "2020-10-21T07:57:13Z")

</div>

Thanks mate, I tried, even upgraded the plugin to 5.0.6, it didn't work.

mysql connection worked on command line.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 18, 2020, 7:57am UTC](https://discuss.elastic.co/t/logstash-7-8-1-couldnt-connect-mysql-jdbc-on-plugin-logstash-integration-jdbc-5-0-5/252767/4 "2020-11-18T07:57:13Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.