# Logstash 6.7 - Cannot connect mysql

**URL:** <https://discuss.elastic.co/t/logstash-6-7-cannot-connect-mysql/175541>\
**Category:** Logstash\
**Created:** [April 5, 2019, 8:27am UTC](https://discuss.elastic.co/t/logstash-6-7-cannot-connect-mysql/175541 "2019-04-05T08:27:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nopparat](https://avatars.discourse-cdn.com/v4/letter/n/a5b964/32.png) [@nopparat](https://discuss.elastic.co/u/nopparat)\
**Post date:** [April 5, 2019, 8:27am UTC](https://discuss.elastic.co/t/logstash-6-7-cannot-connect-mysql/175541/1 "2019-04-05T08:27:16Z")

</div>

Hi all,

Could you please check the code.

Environment :  
OS : Windows 10  
Web Server : Apache  
Mysql : 5.05  
JDBC : 5.1.24  
Elasticsearch : 6.7(zip)  
Kibana : 6.7(zip)  
Logstash : 6.7(zip)

elas.conf :  
input {  
jdbc {  
jdbc\_driver\_library =\> "/Users/nopparat.mue/Desktop/Elasticsearch/logstash-6.7.0/lib/mysql-connector-java-5.1.24-bin.jar"  
jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"  
jdbc\_connection\_string =\> "jdbc:mysql://localhost:81/elas"  
jdbc\_user =\> "root"  
jdbc\_password =\> "ssc555"  
statement =\> "SELECT \* FROM elas.log"  
}  
}  
output {  
stdout { codec =\> json\_lines }  
elasticsearch {  
hosts =\> ["localhost:9200"]  
index =\> "love"  
}  
}

Error Message :  
[2019-04-05T15:12:44,141][ERROR][logstash.inputs.jdbc] Unable to connect to  
database. Tried 1 times {:error\_message=\>"Java::ComMysqlJdbcExceptionsJdbc4::Co  
mmunicationsException: Communications link failure\n\nThe last packet sent succe  
ssfully to the server was 0 milliseconds ago. The driver has not received any pa  
ckets from the server."}  
[2019-04-05T15:12:44,181][ERROR][logstash.pipeline] A plugin had an unre  
coverable error. Will restart this plugin.  
Pipeline\_id:main  
Plugin: \<LogStash::Inputs::Jdbc jdbc\_user=\>"root", jdbc\_password=\>,  
statement=\>"SELECT \* FROM elas.log", jdbc\_driver\_library=\>"/Users/nopparat.mue/D  
esktop/Elasticsearch/logstash-6.7.0/lib/mysql-connector-java-5.1.24-bin.jar", jd  
bc\_connection\_string=\>"jdbc:mysql://localhost:81/elas", id=\>"0345ef29d67de0d5556  
800503982c55930c87b8eb2621f778279de763d11a4ba", jdbc\_driver\_class=\>"com.mysql.jd  
bc.Driver", enable\_metric=\>true, codec=\>\<LogStash::Codecs::Plain id=\>"plain\_3402  
d592-ad72-4cca-8dda-87c678d1de3e", enable\_metric=\>true, charset=\>"UTF-8"\>, jdbc\_  
paging\_enabled=\>false, jdbc\_page\_size=\>100000, jdbc\_validate\_connection=\>false,  
jdbc\_validation\_timeout=\>3600, jdbc\_pool\_timeout=\>5, sql\_log\_level=\>"info", conn  
ection\_retry\_attempts=\>1, connection\_retry\_attempts\_wait\_time=\>0.5, parameters=\>  
{"sql\_last\_value"=\>1970-01-01 00:00:00 UTC}, last\_run\_metadata\_path=\>"C:\Users  
\nopparat.mue/.logstash\_jdbc\_last\_run", use\_column\_value=\>false, tracking\_column  
\_type=\>"numeric", clean\_run=\>false, record\_last\_run=\>true, lowercase\_column\_name  
s=\>true\>  
Error: Java::ComMysqlJdbcExceptionsJdbc4::CommunicationsException: Communicati  
ons link failure  
The last packet sent successfully to the server was 0 milliseconds ago. The driv  
er has not received any packets from the server.  
Exception: Sequel::DatabaseConnectionError  
Stack: java.lang.reflect.Constructor.newInstance(java/lang/reflect/Constructor  
)  
com.mysql.jdbc.Util.handleNewInstance(com/mysql/jdbc/Util.java:411)  
com.mysql.jdbc.SQLError.createCommunicationsException(com/mysql/jdbc/SQLError.ja  
va:1121)

---

<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:** [May 3, 2019, 8:27am UTC](https://discuss.elastic.co/t/logstash-6-7-cannot-connect-mysql/175541/2 "2019-05-03T08:27:22Z")

</div>

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