JDBC Input plugin : Port number is invalid

Elastic Stack Logstash
1

I have a configuration for connecting to a SQL Server on my local machine. While trying to connect from docker container, I get below error:

Error: Java::ComMicrosoftSqlserverJdbc::SQLServerException: The port number 101.10.175.11:49172 is not valid.
Exception: Sequel::DatabaseConnectionError

I have created inbound/outbound rules in my Windows Firewall Settings to accept connections for/from this port.
Can anyone help me understand what's going wrong?

2

A combination of an IP and port is indeed not a valid port number. What does your configuration look like?

3

jdbc_connection_string => "jdbc:sqlserver://tcp:101.10.175.11:49172;databasename=testdb;"

I tried giving machine name as well instead of ip address, but it gave same error.

4

What happens if you remove the "tcp:"?

5

It worked.
Actually initially my sql server was not connecting from any other machine in network. So I open all ports to access and was able to connect by adding a "tcp:" in front of hostname. But somehow I suppose that's not required in the configuration file.

6

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