https://linen.dev logo
Join Slack
Powered by
do I need to open some ports on docker?
# announcements
k
do I need to open some ports on docker?
✅ 1
c
is your ms sql source running inside docker?
k
my sql server is locally installed (I'm running windows)
I installed it without docker
I followed the postgresql tutorial, but wanted to test replication from ms sql to postgresql
docker ps shows that 1433 port is not opened for airbyte containers
c
your MS SQL server is listening on 1433, it’s only when the source-mssql docker image that is launched when you schedule a sync that needs to connect to that port to retrieve data
DO you have access to the logs when checking the connection?
k
after I click set up source, it does testing, and in the end it prints out the logs, saying among many other things: 2021-01-27 095138 INFO (/tmp/workspace/4/0) DefaultAirbyteStreamFactory(lambda$create$0):73 - Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
like I said, management studio connects fine with those parameters
c
How do you run airbyte on windows?
k
via docker ,as per tutorial: git clone https://github.com/airbytehq/airbyte.git cd airbyte docker-compose up
c
are you providing an existing database name too when setting up the source in airbyte?
(not sure if this is causing this too, from what you describe, it seems all good)
k
yes, I do provide a db name, it is valid
got it, it didnt like localhost
changed to my IP
sorry for trouble
c
Great!
2 Views
Open in Slack
PreviousNext
Powered by