Discuss using oscommerce - can't find database in the MySQL Help forum on Dev Shed. using oscommerce - can't find database MySQL Help forum discussing administration, SQL syntax, and other MySQL-related topics. MySQL is an open-source relational database management system (RDBMS).
The ASP Free website provides in-depth information on the latest developer tools available from Microsoft. Our cadre of writers, highly experienced industry experts, reveals the best ways to use established technologies as well as new and emerging technologies. Our coverage of Microsoft's development and administration technologies is among the most respected in the IT industry today.
ASP Free and Iron Speed Designer are giving away $5,500+ in FREE licenses. Iron Speed's RAD CASE toolset can save up to 80% of your coding time. One free license per week, one perpetual license per month! Download and Activate to enter!
Intel® Graphics Performance Analyzers is a powerful tool suite for analyzing and optimizing your games, media, and graphics-intensive applications. Used by some of the best developers on the planet, Intel GPA lets you maximize your app’s performance.
Posts: 7,130
Time spent in forums: 6 Days 17 h 43 m 36 sec
Reputation Power: 1889
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... ???
Posts: 1,062
Time spent in forums: 1 Day 10 h 1 m 34 sec
Reputation Power: 13
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
__________________
The Dude
I'm the Dude. So that's what you call me.
That, or Duder, His Dudeness, Or El Duderino.
If, you know, you're not into the whole brevity thing
Posts: 7,130
Time spent in forums: 6 Days 17 h 43 m 36 sec
Reputation Power: 1889
Quote:
Originally posted by sylow did you try to connect mysql on command promt?
mysql.exe should be in bin directory of the mysql installation.
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.
Posts: 7,130
Time spent in forums: 6 Days 17 h 43 m 36 sec
Reputation Power: 1889
Quote:
Originally posted by thedude 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
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....
Posts: 1,062
Time spent in forums: 1 Day 10 h 1 m 34 sec
Reputation Power: 13
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.
Posts: 7,130
Time spent in forums: 6 Days 17 h 43 m 36 sec
Reputation Power: 1889
Quote:
Originally posted by thedude 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!
__________________ DrGroove, Devshed Moderator | New to Devshed? Read the User Guide | Follow DrGroove on Twitter. Or don't. FWIW, I think Twitter is kinda lame.
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
