Installing osCommerce on Windows
dreamhost uses these versions: (as of last week)
MySQL 4.1.14-Debian3
php 4.3.10
phpMyAdmin 2.6.4-p13
osCommerce Store v.2.2m2
This procedure installs a different major release of MySQL than is
used on dreamhost: dreamhost uses MySQL 4.1.14, and this procedure
installs MySQL 5.0.5. This will require me to make the changes mentioned
at the end of the osCommerce file update-20051113.txt.
But I have not made these changes yet. Maybe by the next milestone of osCommerce,
these changes will have been made.
This procedure installs PHP 5 rather than PHP 4. I did that because of a
password issue between the PHP MySQL interface and the database This required me to
change the (PHP5) setting register_long_arrays, as mentioned below.
--------------------------------
download and install apache_2.0.55-win32-x86-no_ssl.msi
(from http://httpd.apache.org/download.cgi)
c:\Program Files\Apache Group\Apache2\conf\httpd.conf
ServerAdmin rharris@pobox.com
#ServerName basket.HOME:80
ServerName 208.177.250.14:80
DocumentRoot "C:/Web"
<Directory "C:/Web">
#UserDir "My Documents/My Website"
DirectoryIndex index.html index.html.var index.php
ScriptAlias /php/ "C:/Program Files/PHP/"
AddType application/x-httpd-php .php
Action application/x-httpd-php "/php/php-cgi.exe"
After editing httpd.conf, restart the server, by left clicking on the red feather
in the notification area in the lower right of the screen
------------------------------
Download and install mysql-essential-5.0.16-win32.msi
(From http://dev.mysql.com/downloads/mysql/5.0.html and called Windows Essentials)
skip the sign-up
run the MySQL Server Instance Config Wizard
choose all the defaults,
where it says Installation Path, type: \WebData\
choose a password, I used: 88password
------------------------------
Download and install php-5.1.1-installer.exe
to c:\Program Files\PHP
Download and extract php-5.1.1-Win32.zip
into c:\Program Files\PHP (it is OK to overwrite any files that are the same)
install PHP to c:\Program Files\PHP
php.ini from php.ini-recommended
register_globals = On
register_long_arrays = On
uncomment the lines:
extension=php_mbstring.dll
extension=php_mysql.dll
extension_dir = "c:/Program Files/PHP/ext/"
------------------------------
Make the file c:\Web\index.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My Web</title>
</head>
<body>
<h1>My Web</h1>
<a href="catalog/">myStore</a>
<br>
<a href="catalog/admin">myStore admin</a>
<br>
</body>
</html>
------------------------------
Download and extract oscommerce-2.2ms2-051113.zip
(From http://www.oscommerce.com/solutions/downloads)
into a directory such as c:\WebOsCommerce, then
copy the directory "catalog" into c:\Web\
open a web browser on http://localhost
click on myStore
click on Install
click on Continue
Database Server should be localhost or 127.0.0.1
(must be localhost or the equicalent number, unless
the "allow remote root access" was checked, during the MySQL database configuration)
Username should be root
Password should be the password you chose when running the MySQL Server Instance Config Wizard
Database Name should be myStore or some name like that
Session Storage should be Database
click on Continue
------------------------------
after the other <a> in index.html, add the lines:
<a href="phpMyAdmin-2.6.4-pl4\">myStore database admin</a>
Download and extract phpMyAdmin-2.6.4-pl4.zip
(From http://www.phpmyadmin.net/home_page/index.php)
to C:\Web\
edit c:\Web\phpMyAdmin-2.6.4-pl4\config.inc.php
$cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin-2.6.4-pl4/';
$cfg['Servers'][$i]['password'] = '88password';// MySQL password (only needed
// with 'config' auth_type)