using oscommerce - can't find database

Hi,

I'm using oscommerce on winXP at home; I have gotten apache & php to work together, but cannot figure out how to properly configure mysql to work w/ php & apache.

I try to load a .php page from the oscommerce package, and get the follow error message:

Unable to connect to database server!

I have loaded the tables into mysql - its running as a service in winXP.

PHP pages w/o mysql run OK on my computer.

Any ideas on where I could begin troubleshooting this? Is it an apache configuration issue? Or... ???

I appreciate any help that can be offered...

did you try to connect mysql on command promt?
mysql.exe should be in bin directory of the mysql installation.

It sounds like you don't have oscommerce setup properly. Check the configure.php, and application_top.php scripts to be sure all the database connection info is in there. It sounds like oscommerce can't find a database

Thank you for the response. I am able to connect to mysql via command prompt, and can view the contents of the tables included with oscommerce. So, I'm OK there.

I've been trying to correctly configure these files, but haven't found the right combination yet...

I am able to access the admin section, albeit w/ error messages...


Warning: open(/tmp\sess_19b47c8b9976f1175703e116f49ff83e, O_RDWR) failed: No such file or directory (2) in f:\apache\apache\htdocs\admin\includes\functions\sessions.php on line 4

Warning: Failed opening '//catalog/includes/data/rates.php' for inclusion (include_path='.;c:\php4\pear') in f:\apache\apache\htdocs\admin\includes\include_once.php on line 4

Warning: Failed opening 'includes/languages/english/' for inclusion (include_path='.;c:\php4\pear') in f:\apache\apache\htdocs\admin\includes\include_once.php on line 4


I'm still trying to figure out what these mean...

There is also a file in /includes/functions/ called database.php, which seems to control the actual connection to mysql; however, it seems that all of the variables called in that page are defined elsewhere.

It stands to reason that the mysql configuration(s) would occur in the configure.php and application_top.php files, though I haven't been able to discover the means by which I communicate with php where it can find the mysql tables.

Anyhow... more input is appreciated... and I greatly appreciate the fact that you obviously have prior experience using this software that you're able to draw upon in your responses... much thanks again....

OK. Now I'm confused.

I'm actually not able to locate the configure.php file - I did find a 'readme' file in /includes/local, which says:


This directory contains local configuration information.

It also must contain a file named configure.php that can be used to override
the defaults set in application_top.php

Also it *MUST* end with the following lines:

// This is needed to tell application_top.php that we were read in and OK
define('CONFIGURE_STATUS_COMPLETED', 1);

Remember to execute PHP commands the file needs to start with <? and end with ?>



So, is there a configure.php file? Is this something I'm meant to create?

Which version of OSC are you using?

Older versions (pre 2.2), don't use the configure.php, they just use the application_top.php file for configs. Be sure to look through the entire script.

You may have a problem with the paths to your sessions. Note the change in backslashes and forward slashes. And it looks like your paths to the other things are incorrect as well. Your include path looks kind of bizarre.

Is it pointing to the location on your drive of the files? Keep messing around with the paths.

I'll check into the version # & get back to ya - thx again for the replies!