MySQL error Problems connecting to...

User 2592034 Photo


Registered User
3 posts

I had WFB working fine when deployed to my public web server, then I decided to install a local copy of MySQL and replicate my environment on my dev machine. (fresh install of MySQL) All seems fine on the MySQL front. I have created users and a DB, can connect to them with ODBC. Also tried using straight PHP to connect to the new DB and create a table. Works fine.

Here's the weird part - I can't figure out why WFB is not able to access the DB. The user credentials are the same. I've even tried root. The form comes up fine, but submitting it errors each time. The browser error essentially says "No such host is known". The fb_error.log.php file in the storage folder shows:
Thu, 06 Nov 2014 13:14:36 +0000: Problems connecting to MySQL: [2002] SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: No such host is known.

It's not making much sense to me. The host name I'm using is "localhost". I've also tried "127.0.0.1" with the same results. I have MySQL set up to use a standard TCP connection on 3306. The only difference that I can think of between my public server and my dev environment is that my webserver is running on port 83 on my dev box. I wouldn't think that would affect the MySQL connection though.

Stumped... Thanks for any advice.
Attachments:
User 103173 Photo


VP of Software Development
0 posts

One thing I noticed is your local server is Windows. Does this server meet the minimum requirements?

http://www.coffeecup.com/help/articles/ … m-builder/
Learn the essentials with these quick tips for Responsive Site Designer, Responsive Email Designer, Foundation Framer, and the new Bootstrap Builder. You'll be making awesome, code-free responsive websites and newsletters like a boss.
User 2592034 Photo


Registered User
3 posts

Hi Scott,

Thanks for the advice. I checked and my installation phpinfo() and it meets all of the requirements. Still stumped.

Scott Swedorski wrote:
One thing I noticed is your local server is Windows. Does this server meet the minimum requirements?

http://www.coffeecup.com/help/articles/ … m-builder/

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.