visualx Posted July 7, 2003 Share Posted July 7, 2003 I've just installed osCommerce on a Win2000 Pro machine. The Admin and Catalog pages are accessible through Apache. IIS is installed but Ive stopped the service. MySQL is started as a service. I am able to create and manage databases with Mysqladmin. However the Catalog and Admin tools are unable to connect to the MySQL server or any databases. Any ideas? :) Link to comment Share on other sites More sharing options...
Daemonj Posted July 7, 2003 Share Posted July 7, 2003 In your configure.php files, what is the entry for define('DB_SERVER'? It should be define('DB_SERVER', 'localhost'); "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein Link to comment Share on other sites More sharing options...
visualx Posted July 8, 2003 Author Share Posted July 8, 2003 Change was needed but still nbo server connection. configuration.php looks like this. What's next? <?php /* $Id: configuration.php,v 1.1 2001/02/23 04:54:34 pkellum Exp $ * * Configuration */ define('DB_SERVER', 'localhost'); define('DB_SERVER_USERNAME', 'mysql'); define('DB_SERVER_PASSWORD', ''); define('DB_DATABASE', 'catalog'); define('USE_GZIP', 0); // Change to 1 if your server supports GZip ?> Link to comment Share on other sites More sharing options...
Guest Posted July 8, 2003 Share Posted July 8, 2003 Check that the user mysql@localhost exists and has an empty password. You will need a DB admin tool for this. MySQL comes with command line programs mysql and mysqladmin. phpMyAdmin is a web based tool that many here use. Good luck, Matt Link to comment Share on other sites More sharing options...
visualx Posted July 8, 2003 Author Share Posted July 8, 2003 Added user as suggested but unfortunately no effect. The phpadmin tools are connecting to the database but just not the commerce application. I don't have a OBDC connection for mySQL but I don't hink that's the problem either if the phpadmin page connects. I'm quite stumped. Any other ideas? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.