Installing the databes?? HELP!

[Guest]

Okay so I uploaded all the files I believe I need to, set the user names and database name, password,and server thing to "localhost". Now I suppose I need to istall the database and tthe whole cart itself. Can anybody give me help on what to do now?? How to install the database?? Thanks - Jon

[VideoDude]

Jon, I'm assuming that you're working on a system that has MySQL installed and running. If so, I suggest that you download and install an Open Source app named phpMyAdmin and install it on your server. Once installed and working it'll give you a user-friendly interface to access MySQL. Use it to create a blank database (with the same name as you specified in your osCommerce setup). Then return to and continue with you osCommerce setup. osCommerce will find your newly created DB and will auto-magically set up all the necessary tables.

[VideoDude]

From Private Message:

Thanx for your help. But I already have phpmyadmin installed also. Where do I put the database file at thought?? is the DB file called mysql_catalog.sql ? Where do I put it? after that, where do I go to configure the site?

 

The database can be named anything that you want. Just remember that the name you define for the DB in phpMyAdmin must be the name of the database file you enter in the osCommerce setup program.

 

As far as configuring the site. Has anyone referred you to the following URL? http://guide.oscdox.com/ It's a very helpful reference. Remember to contribute a couple of $$$'s to the oscdox.com owners (helps keep the site running) 8)

[Guest]

Hey thanx a lot for that site, but I still need a lil more help. the site says to set my permissions to 755 and 777, 2 of the pages are not of my server's folders, nor in the installation files, /admin/includes/configure.php and /catalog/includes/configure.php. why arent these files anywhere to be found?? - jon

[drakonan]

I can't tell you why they're missing but if you want them...

 

configure.php in catalog/includes

<?php

/*

 osCommerce, Open Source E-Commerce Solutions

 http://www.oscommerce.com



 Copyright (c) 2002 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://www.yourdomain.com'); // eg, http://localhost - should not be NULL for productive servers

 define('HTTPS_SERVER', 'https://yourssl.com'); // eg, https://localhost - should not be NULL for productive servers

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

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

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

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

 define('DIR_WS_INCLUDES', 'includes/'); // If "URL fopen wrappers" are enabled in PHP (which they are in the default configuration), this can be a URL instead of a local pathname

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

 define('DIR_FS_DOCUMENT_ROOT', '/home/cookssaw/public_html');

 define('DIR_FS_CATALOG', '/home/cookssaw/public_html/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', 'localhost'); // eg, localhost - should not be NULL for productive servers

 define('DB_SERVER_USERNAME', 'yourusername');

 define('DB_SERVER_PASSWORD', 'yourpassword');

 define('DB_DATABASE', 'yourdatabase');

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

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

?>

 

and then in includes under admin:

 

<?php

/*

 osCommerce, Open Source E-Commerce Solutions

 http://www.oscommerce.com



 Copyright (c) 2002 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://www.yourdomain.com'); // eg, http://localhost or - https://localhost should not be NULL for productive servers

 define('HTTP_CATALOG_SERVER', 'http://www.yourdomain.com');

 define('HTTPS_CATALOG_SERVER', 'https://yourssl.com');

 define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module

 define('DIR_FS_DOCUMENT_ROOT', 'f:/apache/htdocs/'); // where the pages are located on the server

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

 define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . 'catalog/admin/'); // absolute pate required

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

 define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . '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/');



// define our database connection

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

 define('DB_SERVER_USERNAME', 'yourusername');

 define('DB_SERVER_PASSWORD', 'yourpass');

 define('DB_DATABASE', 'yourdatabase');

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

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

?>

[VideoDude]

I ran into similar problems when I set up my store. Have you carefully followed the instructions listed on "Quick Start Guide" found on http://guide.oscdox.com/ ? Also, Does the file http://yourserver.com/catalog/install/index.php exist on your server?

 

On your server, does your directory structure look like this...

 

/public_html

/catalog

/admin

/images

/includes

/download

/images

/includes

/install

 

???

[VideoDude]

oops, try this...

/public_html

            /catalog

                     /admin

                             /images

                             /includes

                    /download

                    /images

                    /includes

                    /install

[Guest]

no, all I have is a couple folders -

/catalog - within here I have put /admin, and existing already was only /images and /includes .there is no download or install directories.

[Guest]

Did I perhaps download an update version or somthing? where can I download the full version?? -jon

[VideoDude]

No, really... did you read the "Quick Start Guide"???? :?

 

The most recent snapshot of 2.2 can be found at http://www.oscommerce.com/downloads/snapshot