Hi All,
I used PHP fusion for my first ever website back in 2007 and decided to circle back and see if the project was still alive. I'm glad to see that PHP fusion is thriving! Anyways...
I'm running into an issue with my installation when attempting to connect to my MySQL database. Unfortunately with my current web host (1and1) the databases are hosted on different servers which complicates things, I don't connect to "localhost" but rather a different server address that they provide me.
Tested the SQL server connection with other tools, and another PHP CMS and am able to install/use those things without issue with the exact same credentials, server address, port, database name, users, etc, you name it!
MySQL 5.7 & PHP 7.3
My running theory is that it does not like the server address because it has a dash in it. The address I enter is as follows (exact address changed for privacy):
servernameherexyz.hosting-data.io
Now the interesting thing is when I hit the "Save and Proceed" button, it refreshes the page, gives me the "Cannot connect to database." generic error, and it actually re-writes the server address with an underscore in the database hostname field like so:
servernameherexyz.hosting_data.io
I'm beginning to think this is a glitch with the PHP Fusion installer rather than my server/host as other PHP applications have been working flawlessly up until this point. Has anyone else run into this?
Thanks in advance!