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
Connecting to MySQL database via VPN
Moderators: TinCanTech, TinCanTech, TinCanTech, TinCanTech, TinCanTech, TinCanTech
-
- OpenVpn Newbie
- Posts: 3
- Joined: Wed Nov 01, 2017 4:34 pm
-
- OpenVPN Protagonist
- Posts: 11137
- Joined: Fri Jun 03, 2016 1:17 pm
Re: Connecting to MySQL database via VPN
Can you ping the MySQL server from a VPN client ?