visualx Posted July 7, 2003 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? :)
Daemonj Posted July 7, 2003 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
visualx Posted July 8, 2003 Author 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 ?>
Guest Posted July 8, 2003 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
visualx Posted July 8, 2003 Author 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?
Recommended Posts
Archived
This topic is now archived and is closed to further replies.