PoppaBuzz Posted Saturday at 12:25 AM Posted Saturday at 12:25 AM I'm not sure if it's just me, but I'm having trouble with remote database connections to my MariaDB. I have set my Access control to "Allow remote connections from any host." I am able to connect to my database from my HelioHost pages, but not from my externally hosted pages. I can provide any necessary details upon request, just don't want to post anything too private that people could misuse. Quote
wolstech Posted Saturday at 04:05 AM Posted Saturday at 04:05 AM What are you using for the hostname when connecting externally? Quote
PoppaBuzz Posted Saturday at 07:21 PM Author Posted Saturday at 07:21 PM DB_HOST = "johnny.heliohost.org" DB_PORT="3306" Quote
Ookma-Kyi Posted Saturday at 09:59 PM Posted Saturday at 09:59 PM 2 hours ago, PoppaBuzz said: DB_HOST = "johnny.heliohost.org" DB_PORT="3306" Are you able to log in via PHPMysql? Trying to diagnose the issue by eliminating potential issues. Quote
PoppaBuzz Posted Sunday at 12:02 AM Author Posted Sunday at 12:02 AM 2 hours ago, Ookma-Kyi said: Are you able to log in via PHPMysql? Trying to diagnose the issue by eliminating potential issues. Yes I am. Quote
PoppaBuzz Posted Sunday at 12:29 PM Author Posted Sunday at 12:29 PM Exact same .env file, exact same .php file. 3 different domains. Quote
wolstech Posted Sunday at 08:03 PM Posted Sunday at 08:03 PM What IPs are the failed connections coming from? They might be blocked in our firewall. Quote
PoppaBuzz Posted Monday at 03:34 AM Author Posted Monday at 03:34 AM This is the one I really care about: 104.21.50.86. This is the one I created just for testing purposes: 185.176.43.110. Quote
wolstech Posted Monday at 02:19 PM Posted Monday at 02:19 PM Weird. Not blocked. I'm not sure why this doesn't work considering you said you already enabled remote access. Let's have Krydos take a look. Quote
PoppaBuzz Posted Monday at 05:04 PM Author Posted Monday at 05:04 PM Here are screenshots of the settings. Quote
Krydos Posted Monday at 08:54 PM Posted Monday at 08:54 PM Instead of host=johnny.heliohost.org try host=64.62.151.106 Quote
PoppaBuzz Posted Tuesday at 12:41 AM Author Posted Tuesday at 12:41 AM 3 hours ago, Krydos said: Instead of host=johnny.heliohost.org try host=64.62.151.106 It works on the HelioHosted file, but still fails on the other ones. Quote
PoppaBuzz Posted Tuesday at 02:48 AM Author Posted Tuesday at 02:48 AM 25 minutes ago, Krydos said: What is the error message? Error Details: Error: Connection timed out I also set the time to timeout to longer and it still times out. Quote
Krydos Posted Tuesday at 02:53 AM Posted Tuesday at 02:53 AM What do you see when you run this command? curl http://portquiz.net:3306 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.