Sety-up Problem

[LCC UK]

Hi

 

I am trying to install osCommerce for the first time after someone else did it for me on my other website. I am getting to the point below:

 

A test connection made to the database was successful.

Please continue the installation process to execute the database import procedure.

It is important this procedure is not interrupted, otherwise the database may end up corrupt.

The file to import must be located and named at:

/home/tellyplus/public_html/catalog/install/oscommerce.sql

 

When I click on continue, the following message appears:

 

SQL file does not exist: /home/tellyplus/public_html/catalog/install/oscommerce.sql

 

I have checked via my FTP access and I know where this missing file should go but can anyone tell me where to get it or can I download it etc. I know I need a database to start but is there a blank template or something like that?

 

Regards

 

Kerry

[email protected]

[♥Vger]

The oscommerce.sql file should be there in your 'install' directory. It looks as though it is not, and this is why you are getting this error. If you have a complete copy of osCommerce then just upload this one file via FTP into the install directory.

 

Vger

[LCC UK]

The oscommerce.sql file should be there in your 'install' directory.  It looks as though it is not, and this is why you are getting this error.  If you have a complete copy of osCommerce then just upload this one file via FTP into the install directory.

 

Vger

<{POST_SNAPBACK}>

 

Hi Vger

 

thanks for that it worked up to a point but I now have the following message in bright Red ink on my screen:

 

The configuration files do not exist, or permission levels are not set.

 

Please perform the following actions:

cd /home/tellyplus/public_html/catalog/includes/

touch configure.php

chmod 706 configure.php

cd /home/tellyplus/public_html/catalog/admin/includes/

touch configure.php

chmod 706 configure.php

 

This just as well be written in Cantonese! I have looked at the original file download from osCommerce and that which I uploaded and cannot find any files named touch configure.php or chmod 706 configure.php What the heck are they?

 

Kerry

[♥Vger]

There are two files named configure.php. One is in catalog/includes/ and the other is in catalog/admin/includes/

 

To be able to edit these files they need to be set (using the CHMOD command on Linux or Unix servers) to 644 (although this seems to be asking for them to be set to 706). After editing the catalog/includes/configure.php file it needs to be reset to CHMOD 400 (owner - read only). To do this FTP to your site, locate the file, right click and follow the options to alter the file permissions.

 

If you are on a Windows server this won't work, and you'll either have to use Telnet or SSH to alter the permissions, or get your hosting company to do it for you.

 

Vger

[LCC UK]

Hi Vger

 

thanks for the information. I seem to be progressing step by step but I have accessed the two configure files in the locations you said but I cannot see any values such as 644 or 706 and cannot see any reference to CHMOD anywhere in any folder. I have also searched my server using the Webmin interface and cannot find any reference to CHMOD there either.

 

I am very new to this so please have patience and all help is greatly appreciated.

 

Kerry

 

This is the contents of one of the configure.php files so if something is missing please let me know.

 

 

// Define the webserver and path parameters

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

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

define('HTTP_SERVER', ''); // 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', '');

define('HTTPS_COOKIE_DOMAIN', '');

define('HTTP_COOKIE_PATH', '');

define('HTTPS_COOKIE_PATH', '');

define('DIR_WS_HTTP_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', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']));

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

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

 

// define our database connection

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

define('DB_SERVER_USERNAME', '');

define('DB_SERVER_PASSWORD', '');

define('DB_DATABASE', 'osCommerce');

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

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