Install on Windows server

[jamiee]

Hi All

 

This is all very new to me. I am trying to install oscommerce onto a windows server but all the help files I see seem to be for Linux servers.

 

I have checked the php support in my server control panel and SQL in enabled.

 

I checked the info.php test file and I can see that all right.

 

Do I have to install phpmyadmin first

 

How do I create a data base with user and password

 

I'm sorry if there are alot of questions it's just all new to me.

 

Jamiee

[Guest]

Hi All

 

This is all very new to me. I am trying to install oscommerce onto a windows server but all the help files I see seem to be for Linux servers.

 

I have checked the php support in my server control panel and SQL in enabled.

 

I checked the info.php test file and I can see that all right.

 

Do I have to install phpmyadmin first

 

How do I create a data base with user and password

 

I'm sorry if there are alot of questions it's just all new to me.

 

Jamiee

I am struggling through the same place right now. I haven't got it all the way working, but here is what has worked (up to a point) for me so far.

First, you have to understand windows permissions, which are managed in an entirely different way than chmod. You have to be able to handle all of the permissions on all of the affected directories before you have a prayer of installing on windows. (All of the permission controls are hidden on the security tab of the properties screen you can select when you right click on a directory or file in Windows Explorer. You probably need administrator rights to change them, however.)

 

You have to decide whether you are going to use apache webserver software or Windows IIS. If you get to choose, use apache. It will make your life much easier. If you have to use IIS as your server, you have to get it set up to run php extensions. (I'll leave that to microsoft to explain to you.)

 

Regardless of which webserver program you are going to use, you need to check what version of PHP is installed. PHP 4.4 works well if you install the register_globals contribution. PHP 5 is apparently a nightmare and I never got it to work.

 

If you are using IIS, you will need to set the smtp directive in php.ini and then reboot the machine to get the new php.ini to load. (If that sounds like greek to you, abandon all hope of using IIS.)

You will need to CREATE DATABASE in mysql to create the database name that osCommerce will reside in. Then you need to CREATE USER 'xxx'@'localhost' IDENTIFIED BY 'password' for the username and password the osCommerce will use to access mysql. You will also have to GRANT this user CREATE, UPDATE, SELECT, DROP and maybe DELETE privileges on your database files. After you create this user, you will need to SET_PASSWORD FOR 'xxx'@'localhost' = OLD_PASSWORD('password'); I know this sounds crazy, but it seems to get php and mysql using the same password.

 

You have to be able to access your website from the web somehow to use the install tool that comes with osC. If you are using apache, put the whole catalog directory tree under htdocs. (kind of where cgi-bin is). If you are using IIS, put the whole tree in C:\inetpub\wwwroot (please note windows screwy \'s). Then you can access the install script from http://www.mydomain.com/catalog/install/index.php. If you are using apache as your server, these forums will have all the help you need. If you are still stuck with IIS, you will have to make the following mod to catalog\install\includes\templates\pages\install_3.php:

// FIX FOR NON-APACHE SERVERS

// $script_filename = getenv('PATH_TRANSLATED');

$script_filename = $_SERVER["PATH_TRANSLATED"];

//

if (empty($script_filename)) {

// $script_filename = getenv('SCRIPT_FILENAME');

$script_filename = $_SERVER["PATH_TRANSLATED"];

 

When you run the install then, i will end with a parsing error when it trys to read your catalog\admin\includes\configure.php. If you open that up, the paths for all the DIR_FS_xxx are probably badly screwed up. It seems to work for me when I use:

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where the pages are located on the server

define('DIR_WS_ADMIN', '/catalog/admin/'); // absolute path required

define('DIR_FS_ADMIN', 'C:\inetpub\wwwroot\catalog\admin'); // absolute pate required

define('DIR_WS_CATALOG', '/catalog/'); // absolute path required

define('DIR_FS_CATALOG',DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG); // absolute path required

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

 

With the combination of window's \s and internet /s, getting this far was a major step forward. Make the same kind of changes to catalog\includes\configure.php (It doesn't have as many DIR_FSs and those are the ones that seem to get screwed up.)

 

With these changes, you should be able to get the configuration screen you recognize to come up at http://www.mydomain.com/catalog/admin/index.php You must choose smtp rather than the default of sendmail for e-mail options.

 

That is as far as I have gotten and I am about 90% of the way to complete functionality. Let me know how it goes for you and post back any tips I can use.

Ed Little

[Guest]

I am struggling through the same place right now. I haven't got it all the way working, but here is what has worked (up to a point) for me so far.

First, you have to understand windows permissions, which are managed in an entirely different way than chmod. You have to be able to handle all of the permissions on all of the affected directories before you have a prayer of installing on windows. (All of the permission controls are hidden on the security tab of the properties screen you can select when you right click on a directory or file in Windows Explorer. You probably need administrator rights to change them, however.)

 

You have to decide whether you are going to use apache webserver software or Windows IIS. If you get to choose, use apache. It will make your life much easier. If you have to use IIS as your server, you have to get it set up to run php extensions. (I'll leave that to microsoft to explain to you.)

 

Regardless of which webserver program you are going to use, you need to check what version of PHP is installed. PHP 4.4 works well if you install the register_globals contribution. PHP 5 is apparently a nightmare and I never got it to work.

 

If you are using IIS, you will need to set the smtp directive in php.ini and then reboot the machine to get the new php.ini to load. (If that sounds like greek to you, abandon all hope of using IIS.)

You will need to CREATE DATABASE in mysql to create the database name that osCommerce will reside in. Then you need to CREATE USER 'xxx'@'localhost' IDENTIFIED BY 'password' for the username and password the osCommerce will use to access mysql. You will also have to GRANT this user CREATE, UPDATE, SELECT, DROP and maybe DELETE privileges on your database files. After you create this user, you will need to SET_PASSWORD FOR 'xxx'@'localhost' = OLD_PASSWORD('password'); I know this sounds crazy, but it seems to get php and mysql using the same password.

 

You have to be able to access your website from the web somehow to use the install tool that comes with osC. If you are using apache, put the whole catalog directory tree under htdocs. (kind of where cgi-bin is). If you are using IIS, put the whole tree in C:\inetpub\wwwroot (please note windows screwy \'s). Then you can access the install script from http://www.mydomain.com/catalog/install/index.php. If you are using apache as your server, these forums will have all the help you need. If you are still stuck with IIS, you will have to make the following mod to catalog\install\includes\templates\pages\install_3.php:

// FIX FOR NON-APACHE SERVERS

// $script_filename = getenv('PATH_TRANSLATED');

$script_filename = $_SERVER["PATH_TRANSLATED"];

//

if (empty($script_filename)) {

// $script_filename = getenv('SCRIPT_FILENAME');

$script_filename = $_SERVER["PATH_TRANSLATED"];

 

When you run the install then, i will end with a parsing error when it trys to read your catalog\admin\includes\configure.php. If you open that up, the paths for all the DIR_FS_xxx are probably badly screwed up. It seems to work for me when I use:

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where the pages are located on the server

define('DIR_WS_ADMIN', '/catalog/admin/'); // absolute path required

define('DIR_FS_ADMIN', 'C:\inetpub\wwwroot\catalog\admin'); // absolute pate required

define('DIR_WS_CATALOG', '/catalog/'); // absolute path required

define('DIR_FS_CATALOG',DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG); // absolute path required

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

 

With the combination of window's \s and internet /s, getting this far was a major step forward. Make the same kind of changes to catalog\includes\configure.php (It doesn't have as many DIR_FSs and those are the ones that seem to get screwed up.)

 

With these changes, you should be able to get the configuration screen you recognize to come up at http://www.mydomain.com/catalog/admin/index.php You must choose smtp rather than the default of sendmail for e-mail options.

 

That is as far as I have gotten and I am about 90% of the way to complete functionality. Let me know how it goes for you and post back any tips I can use.

Ed Little

I have come across one more oddity of installing on Windows. After your install is working, you will get the pink warning across the top of your catalog indicating that your congifure.php is still open to writing. Locking down the appropriate windows permissions on this configure file does not make the warning go away. If, however, you mark the file as read only on the first tab of the files properties page, the warning will go away.

Ed Little

[zeeshop]

I have come across one more oddity of installing on Windows. After your install is working, you will get the pink warning across the top of your catalog indicating that your congifure.php is still open to writing. Locking down the appropriate windows permissions on this configure file does not make the warning go away. If, however, you mark the file as read only on the first tab of the files properties page, the warning will go away.

Ed Little

 

 

Hi ALl,

This is my first post here,

I have a same problem as ed little,.

I am using wampserver, it all open fine, but Admin area is not secure yet, how I can put ssl on wamp server, I am using my local pc as webserver, or is there any other server available which gives better interface and easy to use, For SMTP do I still have to use wamp server or IS work ok..

I am sorry but I am doing all these things together, prevciouslymy ecommerce site was working using aspnet.

 

thanks and regards.

zee

[jasonabc]

You are fighting a losing battle trying to get OSC running on IIS. Installing Apache. It comes with a Windows installer.

[cglubish]

You are fighting a losing battle trying to get OSC running on IIS. Installing Apache. It comes with a Windows installer.

 

 

pfft - typical