PoppaBuzz Posted January 17 Posted January 17 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.
wolstech Posted January 17 Posted January 17 What are you using for the hostname when connecting externally?
Ookma-Kyi Posted January 17 Posted January 17 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.
PoppaBuzz Posted January 18 Author Posted January 18 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.
PoppaBuzz Posted January 18 Author Posted January 18 Exact same .env file, exact same .php file. 3 different domains.
wolstech Posted January 18 Posted January 18 What IPs are the failed connections coming from? They might be blocked in our firewall.
PoppaBuzz Posted January 19 Author Posted January 19 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.
wolstech Posted January 19 Posted January 19 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.
Krydos Posted January 19 Posted January 19 Instead of host=johnny.heliohost.org try host=64.62.151.106
PoppaBuzz Posted January 20 Author Posted January 20 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.
PoppaBuzz Posted January 20 Author Posted January 20 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.
Krydos Posted January 20 Posted January 20 What do you see when you run this command? curl http://portquiz.net:3306
Recommended Posts