Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database Connection Error


mattwa

Recommended Posts

Posted

Same problem I've seen a few people reporting, but no solutions that have worked for me. I can access the store and everything works fine. When I go to admin, I get

 

Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10061) in D:\Inetpub\wwwroot\charmofmadura.com\html\catalog\admin\includes\functions\database.php on line 19

Unable to connect to database server!

 

I tried using the DB connection info from the store config, even though they looked identical (turns out they were :rolleyes: ) but no dice. Interesting thing is the error says can't connect to localhost but I specified the IP address in both config files. In fact, TextPad tells me that the word localhost doesn't appear in any files on the site except in comments. And yes, this is a Windows server, I have no choice in the matter with this site, but the failure to write the config info does not seem to be the problem here.

 

The only thing I can think is that somehow the $server variable isn't getting set properly (that's what's on line 19 of database.php) but that looks like it gets set to DB_SERVER, which is properly defined with an IP address in both config files.

Any ideas?

 

Thanks

Matt

Posted

The only thing I can think of is that you have uploaded admin/includes/local/configure.php If it exists delete this file.

Posted
The only thing I can think of is that you have uploaded admin/includes/local/configure.php If it exists delete this file.

 

 

That's not it. The only other thing I can think of (accepting that I don't know OScommerce very well yet) is something with the .htaccess file, which I can't get to, but then the store should be affected as well, right?

 

This is driving me nuts. Please, if anybody has an idea :)

 

Matt

Posted
That's not it. The only other thing I can think of (accepting that I don't know OScommerce very well yet) is something with the .htaccess file, which I can't get to, but then the store should be affected as well, right?

 

This is driving me nuts. Please, if anybody has an idea :)

 

Matt

 

 

Got it. I was working with html/admin/configure.php. The problem was html/catalog/admin/includes/configure.php - the DB info wasn't written, of course.

 

Thanks to everyone who scratched their head over this one :)

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...