Nginx reverse proxy with Stream block is not connecting to server

Question

I am trying to create a load balancer for SQL servers using Nginx (On my windows machine). To start with , I am testing, with my local system with port 12345 to another SQL Server.

To do that, I am creating a streat block on main node, and then forwarding in the server, after listening on port 12345.

events {
    worker_connections  1024;
}

stream{
    server {
        listen     10.20.10.9:12345;
        #TCP traffic will be forwarded to the "stream_backend" upstream group
        proxy_pass SQLSERVERONLAN:1433 ;
        proxy_bind 10.20.10.9:12345;
    } 
}

http {..../No Code for bravity}

I start Nginx and there are no error logs.

I checked all ports by netstat -a and it's listening on port 12345.

But when I am using Management studio, not able to connect to the remote server after passing in the credentials.

@TarunLalwani, Getting error, "A network-related or instance-specific error occurred while establishing a connection to SQL Server." — Simsons, Jun 19 '19 at 05:15
@TarunLalwani, Unfortunately there are no error logs on nginx folder.When I do a netstat , I can see that, I am listening on port 12345 — Simsons, Jun 19 '19 at 23:58
@TarunLalwani, Tried now. It was not there at the beginning . Removing proxy bind is not making any changes. — Simsons, Jun 20 '19 at 03:46
`SQLSERVERONLAN` is it a good hostname? Did you grant permissions for proxy server in your SQL Server? You can always use `wireshark` to sniff communication between proxy and sql server. — pawelbylina, Jun 25 '19 at 10:44
Can you check the logs at mysql server? also check if this post helps https://stackoverflow.com/questions/8348506/grant-remote-access-of-mysql-database-from-any-ip-address — Krishnom, Jun 25 '19 at 16:41

score -1 · Answer 1 · edited Mar 12 '20 at 12:11

-1

I think the setting is good. Try to login as "your_login_id@SQLSERVERONLAN". Reference.

edited Mar 12 '20 at 12:11

Valerii Boldakov

1,751
9
19

answered Mar 12 '20 at 09:06

jung

1

Nginx reverse proxy with Stream block is not connecting to server

1 Answers1