Mysql refusing remote connection over vpn

kwdamp

Well-Known Member
Dec 7, 2017
56
5
8
usa
cPanel Access Level
Root Administrator
I've been using the remote access hosts feature on cpanel for awhile to remote into one of our mysql databases on a dedicated server we own. I have a few hours a week I'm on a VPN (expressVPN if it matters) and for some reason even after I enter the IP address and/or IP address range it won't allow me to connect.

Wondering if this is possibly a port specification issue or something to do with the type of request the vpn server is making? This is not my area of expertise but it seems like it shouldn't really matter where the request is coming from so long as the IP is in the connection list.

Is there something I'm missing?
 
Last edited by a moderator:

kwdamp

Well-Known Member
Dec 7, 2017
56
5
8
usa
cPanel Access Level
Root Administrator
I'm running what I think is the pretty standard setup w/ WHM and Centos. We have CSF running, but even if I allow a temporary "full access" period to the connection IP it won't connect. I'm starting to think it's the type of request or port issue but I have no idea how to track that down.

Is there a place to view the mysql connection log in WHM/Cpanel? Or does that have to be done through the CLI? Wondering if it will tell me why the connection was refused.
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
12,499
1,971
363
cPanel Access Level
Root Administrator
I would guess this is a limitation of that particular VPN. It's possible that connection is only setup for certain traffic.

There isn't a good way to view that data in WHM or cPanel, and even directly in the MySQL log I'm not sure if it would provide much information. I'd recommend checking the main MySQL error log and the cPanel error log (/usr/local/cpanel/logs/error_log) to see if either of those give you any more helpful details.
 
  • Like
Reactions: kwdamp