Hello:

I was hoping someone could help me figure out why I'm having trouble connecting to my mySQL db.

I'm installing ZenCart for a friend's online business. I have successfully connected and modified ZenCart (and mySQL) to my own website without absolutely no problems.

Now, I just downloaded the new version of ZenCart and am installing a clean copy on her server. I verified with her hosting company that they met the requirements for ZenCart and they said they did.

Now I'm trying to install ZenCart and I get the big red X next to MySQL support in the Set up System Inspection page:

Register Globals = OFF

MySQL Support = OFF Click here for more info

MySQL Version = Unknown Click here for more info

If I continue to the database setup page, and fill out the information I got from her hosting company, I get an error and it won't let me continue:
"Warning: Problems Found
* Database not supported more info..."

Her hosting company forwarded me the below db info:
Database

host: local-xdb (this host is only visible from the web server)
version: mysql Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386)

Any thoughts would be greatly appreciated.
Thank you,

Hello,

the errors you are receiving seem to be in conflict with the information you have received from your host.

They may indeed have a funky setup which prevents zen cart from reading the DB info - however, I am not certain you would see this error:

MySQL Support = OFF Click here for more info

We have a similar setup (where the db server is only accessible from the web servers and zen cart spits out a warning that it cant read the db server info - not the error you are seeing.

Irregardless, ask your host for an IP address of their DB server and try using that in the host info area.

Hopefully this will resolve your problems - however, I suspect there is something more at play here.

This part of the installer hasn't changed between versions, as far as I can tell.

The error "Database not supported" suggests that the "mysql_connect()" function cannot be located in your server's PHP library of client functions. Since this function is used to talk to the database when it needs to establish a connection before sending queries, it's rather critical.

Technically, what's failing is this command:```php
if (function_exists('mysql_connect')) {....proceed.... }

You need to talk to your host about why the mysql functions aren't available to your hosting account.