# Logstash JDBC connection not sending request to Database custom port

**URL:** <https://discuss.elastic.co/t/logstash-jdbc-connection-not-sending-request-to-database-custom-port/336664>\
**Category:** Logstash\
**Created:** [June 22, 2023, 10:11am UTC](https://discuss.elastic.co/t/logstash-jdbc-connection-not-sending-request-to-database-custom-port/336664 "2023-06-22T10:11:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rijinmp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rijinmp/32/24634_2.png) [@rijinmp](https://discuss.elastic.co/u/rijinmp)\
**Post date:** [June 22, 2023, 10:11am UTC](https://discuss.elastic.co/t/logstash-jdbc-connection-not-sending-request-to-database-custom-port/336664/1 "2023-06-22T10:11:05Z")

</div>

**When I I am trying to retrieve data from a MSSQL database , Logstash JDBC input not connecting to the required custom port 59237. Logstash only trying to connect port 3306.**

Mentioned the required port 59237 in Connection string. But Logstash still sending request to port 3306 ( Same Port mentioned in logstash documentaion )

DB and Logstash in Same Timezone

Firewall log checked and confirmed that my logstash is trying to connect 3306.  
My connection String is  
` **jdbc_connection_string => "jdbc:mysql://DB_Ip:59237/SQLPROD"** `

Conf:

> input {  
> jdbc {  
> jdbc\_driver\_library =\> "/home/ubuntu/logstash-8.5.3/lib/jar/mysql-connector-java-5.1.36-bin.jar"  
> jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"  
> jdbc\_connection\_string =\> "jdbc:mysql://DB\_Ip:59237/SQLPROD"  
> jdbc\_user =\> "username"  
> jdbc\_password =\> "password"  
> schedule =\> "\* \* \* \* \*"  
> statement =\> "select \* from vlog"  
> jdbc\_validate\_connection =\> "true"  
> }  
> }

Error message

```auto
[2023-06-22T11:34:00,108][ERROR][logstash.inputs.jdbc][main][20e72f1a873bfa286818f8df6e6a163bfa90d2a7439484838b895d09e47b1e05] Unable to connect to database. Tried 1 times {:message=>"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.", :exception=>Sequel::DatabaseConnectionError, :cause=>#<Java::ComMysqlJdbcExceptionsJdbc4::CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.>, :backtrace=>["jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)", "jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(jdk/internal/reflect/NativeConstructorAccessorImpl.java:77)", "jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(jdk/internal/reflect/DelegatingConstructorAccessorImpl.java:45)", "java.lang.reflect.Constructor.newInstanceWithCaller(java/lang/reflect/Constructor.java:499)", "java.lang.reflect.Constructor.newInstance(java/lang/reflect/Constructor.java:480)",

```

---

<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:** [July 20, 2023, 10:11am UTC](https://discuss.elastic.co/t/logstash-jdbc-connection-not-sending-request-to-database-custom-port/336664/2 "2023-07-20T10:11:15Z")

</div>

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