Doing a server migration and in the process decided to make sure all the routing was secure.
I discovered I get an internal error in the generated site if the MySQL port (3306 TCP) isn’t forwarded on the router.
I assumed this wouldn’t be necessary since the database is stored on the same server as the site.
Did I configure something wrong or is this normal?
All connections are from the PHP scripts on the web server only. Are you sure your web server and your MySQL server are on the same server? If so, check your connection info, try use 127.0.0.1 or “localhost” instead of real IP or host name.
Ah thank you this was the case I uploaded the wrong version.
Is there a way to work in PHPMaker with the remote IP for database sync but always generate the site with localhost?
You may use Database_Connecting server event.