Page 1 of 1

mysql refuses connection via VPN

PostPosted: 25. May 2018 10:40
by ekb
Hello,
When I try to connect to XAMPP mysql database on default port 3306 via VPN, the server (10.35.48.19) refuses connection. The result from Wireshark is :
Code: Select all
No.     Time           Source                Destination           Protocol Length Info
      1 0.000000       192.168.63.251        10.35.48.19           TCP      66     61401 → 3306 [SYN] Seq=0 Win=8192 Len=0 MSS=1460 WS=256 SACK_PERM=1
      2 0.287101       10.35.48.19           192.168.63.251        TCP      66     3306 → 61401 [SYN, ACK] Seq=0 Ack=1 Win=14600 Len=0 MSS=1460 SACK_PERM=1 WS=128
      3 0.287209       192.168.63.251        10.35.48.19           TCP      54     61401 → 3306 [ACK] Seq=1 Ack=1 Win=65536 Len=0
      4 0.579776       10.35.48.19           192.168.63.251        TCP      60     3306 → 61401 [RST] Seq=1 Win=0 Len=0

If I don't use VPN, everything is OK. The result from Wireshark is :
Code: Select all
No.     Time           Source                Destination           Protocol Length Info
      1 0.000000       10.35.49.101          10.35.48.19           TCP      66     18472 → 3306 [SYN] Seq=0 Win=8192 Len=0 MSS=1460 WS=256 SACK_PERM=1
      2 0.000364       10.35.48.19           10.35.49.101          TCP      66     3306 → 18472 [SYN, ACK] Seq=0 Ack=1 Win=14600 Len=0 MSS=1460 SACK_PERM=1 WS=128
      3 0.000416       10.35.49.101          10.35.48.19           TCP      54     18472 → 3306 [ACK] Seq=1 Ack=1 Win=65536 Len=0
      4 0.000916       10.35.48.19           10.35.49.101          MySQL    147    Server Greeting proto=10 version=5.5.5-10.1.16-MariaDB
      5 0.051171       10.35.49.101          10.35.48.19           TCP      54     18472 → 3306 [ACK] Seq=1 Ack=94 Win=65536 Len=0
...........

Just for info, via VPN I can connect for example to http://10.35.48.19/phpmyadmin/

I would be very grateful if someone help me with solving this problem. Thank you in advance !

Re: mysql refuses connection via VPN

PostPosted: 25. May 2018 11:16
by Altrea
There is no MySQL setting i know which would prevent accessing MySQL via VPN.
If i would guess thats a VPN, network or operating system configuration issue.