Newbie Trying to Install osCommerce

[spindrift]

Question 1: http://wiki.oscommerce.com/helpDocuments

Are these available for download as a set, anywhere ?

I don't even seem to be able to save the pages.

 

Question 2:

Proceeding through the 'Install' on my local machine. It already has Apache and MySQL on it, which I started before going to the page:

http://127.0.0.1/catalog/install

 

Step2: Username - I used the one suggested in the help text - 'mysql_10'.

 

The help-text says:

Note: Create and Drop permissions are required at this point of the installation procedure.

 

Am unsure what these might be, or how to set them.

 

The test connection made to the database was successful, but the import of the database:

C:/apache/htdocs/catalog/install/oscommerce.sql

 

produced a large number of identical errors:

 

Warning: Supplied argument is not a valid MySQL-Link resource in C:apachehtdocscataloginstallincludesfunctionsdatabase.php on line 41

 

Line 41 appears to be:

function osc_db_query($query, $link = 'db_link') {

global $$link;

 

The last line said that the database import was successful.

 

Step 5 was a bit confusing, as it had pre-filled all the boxes and I couldn't see that any changes were required.

 

There didn't seem to be a 'Step 6' - I was taken straight to Step 7, which announced that 'The configuration was successful!'

 

However, when I tried to click on either of the 'Catalog' or 'Administration Tool' buttons, I got the same message:

 

Warning: MySQL Connection Failed: Access denied for user: 'mysql_10@localhost' (Using password: YES) in C:apachehtdocscatalogincludesfunctionsdatabase.php on line 19

Unable to connect to database server!

 

 

Item 4 in the install guide says:

View the file catalog/includes/configure.php and make necessary changes.

 

but gives no indication which changes are necessary !

 

My file contents are below the following line:

************************************************

<?php

/*

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

// Define the webserver and path parameters

// * DIR_FS_* = Filesystem directories (local/physical)

// * DIR_WS_* = Webserver directories (virtual/URL)

define('HTTP_SERVER', 'http://127.0.0.1'); // eg, http://localhost - should not be empty for productive servers

define('HTTPS_SERVER', ''); // eg, https://localhost - should not be empty for productive servers

define('ENABLE_SSL', false); // secure webserver for checkout procedure?

define('HTTP_COOKIE_DOMAIN', '127.0.0.1');

define('HTTPS_COOKIE_DOMAIN', '');

define('HTTP_COOKIE_PATH', '/catalog/');

define('HTTPS_COOKIE_PATH', '');

define('DIR_WS_HTTP_CATALOG', '/catalog/');

define('DIR_WS_HTTPS_CATALOG', '');

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

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

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_DOWNLOAD_PUBLIC', 'pub/');

define('DIR_FS_CATALOG', 'C:/apache/htdocs/catalog/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

// define our database connection

define('DB_SERVER', '127.0.0.1'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'mysql_10');

define('DB_SERVER_PASSWORD', '010203');

define('DB_DATABASE', 'osCommerce');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

[chfields]

Try changing this define('DB_SERVER', '127.0.0.1'); to define('DB_SERVER', 'localhost');

[Guest]

The help-text says:

Note: Create and Drop permissions are required at this point of the installation procedure.

 

Am unsure what these might be, or how to set them.

You would set them with the database directly, outside of osCommerce. If you have not configured a user to access the database yet, then OSC won't work. You can use a tool like phpMyAdmin to set up the user. Here is some reference material for the MySQL command line tools.

 

Good luck,

Matt

[spindrift]

Thanks for the answers they are MUCH appreciated - I have figured it out now, and will post as a new topic 'How to install on local host'.

 

Tim in Ireland.