Connecting to MySQL database via VPN

This forum is for general conversation and user-user networking.

Moderators: TinCanTech, TinCanTech, TinCanTech, TinCanTech, TinCanTech, TinCanTech

Post Reply
duncane
OpenVpn Newbie
Posts: 3
Joined: Wed Nov 01, 2017 4:34 pm

Connecting to MySQL database via VPN

Post by duncane » Sat Nov 18, 2017 5:50 pm

I am able to connect to my vpn server and can map network drives etc. The server is on the network 10.195.194.0. I want to now connect via the vpn to a MySQL server sitting on that network and using the default port 3306 but I get a time out when trying to connect using MySQL workbench to test the connection. The MySQL setup is configured to allow remote connections (ie not just localhost) and is working. I am guessing this maybe a firewall issue rather than an OpenVPN issue but any help would be appreciated.

Much thanks

Duncan

Client:
client
dev tun
proto udp
remote 1.1.1.1 1194
resolv-retry infinite
nobind
persist-key
persist-tun
ca "C:\\Program Files\\OpenVPN\\config\\ca.crt"
cert "C:\\Program Files\\OpenVPN\\config\\DuncanHome.crt"
key "C:\\Program Files\\OpenVPN\\config\\DuncanHome.key"
remote-cert-tls server
tls-auth "C:\\Program Files\\OpenVPN\\config\\ta.key" 1
cipher AES-256-CBC
verb 3

Server

port 1194
proto udp
dev tun
ca "C:\\Program Files\\OpenVPN\\config\\ca.crt"
cert "C:\\Program Files\\OpenVPN\\config\\pdcserver.crt"
key "C:\\Program Files\\OpenVPN\\config\\pdcserver.key" # This file should be kept secret
dh "C:\\Program Files\\OpenVPN\\config\\dh4096.pem"
topology subnet
push "route 10.195.194.0 255.255.255.0"
push "dhcp-option DNS 10.195.194.5"
client-to-client
keepalive 10 120
tls-auth "C:\\Program Files\\OpenVPN\\config\\ta.key" 0 # This file is secret
cipher AES-256-CBC
persist-key
persist-tun
status openvpn-status.log
verb 3
explicit-exit-notify 1

TinCanTech
OpenVPN Protagonist
Posts: 11137
Joined: Fri Jun 03, 2016 1:17 pm

Re: Connecting to MySQL database via VPN

Post by TinCanTech » Sat Nov 18, 2017 7:33 pm

Can you ping the MySQL server from a VPN client ?

Post Reply