Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

installation problem. HELP!


rev3lati0n

Recommended Posts

First post :) anyway....

 

i get to the database import or something on the installation. (its like the 3rd page into it) and i get this.

 

 

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:

 

/usr/local/psa/home/vhosts/install/oscommerce.sql

 

 

 

 

if i just hit continue anyway, i get this...

 

 

 

The following error has occurred:

 

SQL file does not exist: /usr/local/psa/home/vhosts/install/oscommerce.sql

 

 

 

 

 

help?????

 

thanks! :( :(

Link to comment
Share on other sites

  • Replies 52
  • Created
  • Last Reply
SQL file does not exist: /usr/local/psa/home/vhosts/install/oscommerce.sql

 

well you give the awnser yrslf, the routine tries to acces the oscommerce.sql file in order to create the database tables (I presume you created the blank db otherwise osc coulnd#T make up testconnection) and does not find it at the path stated.

 

place the oscommerce.sql file to the right place -->

/usr/local/psa/home/vhosts/install/

and you will have a lot of fun with this brilliant MP of SW

 

check Vgers installguide at

http://www.oscommerce.com/forums/index.php?showtopic=162231

 

hope that helps

dahui

Link to comment
Share on other sites

Far too many people have this problem. Try this for me.

 

In /catalog/install/templates/pages/install_3.php find:

 

$sql_file = $dir_fs_www_root . 'install/oscommerce.sql'; (it's line 44)

 

replace it with:

 

$sql_file = getenv('DOCUMENT_ROOT') . 'install/oscommerce.sql';

 

Or comment out the original line to be safe, then you'll have this:

 

// $sql_file = $dir_fs_www_root . 'install/oscommerce.sql';

$sql_file = getenv('DOCUMENT_ROOT') . 'install/oscommerce.sql';

 

Let me know what happens.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

Far too many people have this problem. Try this for me.

 

In /catalog/install/templates/pages/install_3.php find:

 

$sql_file = $dir_fs_www_root . 'install/oscommerce.sql'; (it's line 44)

 

replace it with:

 

$sql_file = getenv('DOCUMENT_ROOT') . 'install/oscommerce.sql';

 

Or comment out the original line to be safe, then you'll have this:

 

// $sql_file = $dir_fs_www_root . 'install/oscommerce.sql';

$sql_file = getenv('DOCUMENT_ROOT') . 'install/oscommerce.sql';

 

Let me know what happens.

 

the very nice way for all the ... let's say people who need it :thumbsup:

 

are you british alan (?) :lol:

 

btw, I do not want to offend, but before you start with osc, you might get into webservers and co a bit deeper rev3lati0n ;)

 

dahui

Link to comment
Share on other sites

tried that.... heres what happened when i retried installing it....

 

The following error has occurred:

 

SQL file does not exist: /usr/local/psa/home/vhosts/gatewayvineyard.com/httpdocsinstall/oscommerce.sql

 

 

 

 

 

:)

Link to comment
Share on other sites

We probably need to add a /

 

So make that:

 

// $sql_file = $dir_fs_www_root . 'install/oscommerce.sql';

$sql_file = getenv('DOCUMENT_ROOT') . '/install/oscommerce.sql';

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

SQL file does not exist: /usr/local/psa/home/vhosts/gatewayvineyard.com/httpdocs/install/oscommerce.sql

 

 

lol....

so you say lots of ppl have this problem? i have no clue what to do...

 

keep trying :) :)

 

thanks btw!

Link to comment
Share on other sites

OK, add the catalog in there too.

 

Like so:

 

// $sql_file = $dir_fs_www_root . 'install/oscommerce.sql';

$sql_file = getenv('DOCUMENT_ROOT') . '/catalog/install/oscommerce.sql';

 

I'm looking for a general solution but that should do.

 

(getenv('DOCUMENT_ROOT') points to root regardless of the directory you're in)

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

actually one more question... now that that worked.... hehe

 

/usr/local/psa/home/vhosts/

 

is this a valid place? i have no idea WHERE this is. because the next field i have to fill out the form and a question is

 

webserver root directory and /usr/local/psa/home/vhosts/ is the place....

errrrgh....

Link to comment
Share on other sites

The problem comes because lots of servers give no result for the Apache query

 

$dir_fs_www_root

 

We used a php query.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

actually one more question... now that that worked.... hehe

 

/usr/local/psa/home/vhosts/

 

is this a valid place? i have no idea WHERE this is. because the next field i have to fill out the form and a question is

 

webserver root directory and  /usr/local/psa/home/vhosts/ is the place....

errrrgh....

 

Your document root is: /usr/local/psa/home/vhosts/gatewayvineyard.com/httpdocs

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

ok everything got setup but now when i click administration tools it brings up a page that says it wont connect. :\ :\

 

am i doing something really wrong? dont usually have troubles like this. i installed phpBB on my website with no problem! :(

Link to comment
Share on other sites

No, this install routine is really old and needs revisions. I never use it, I just set the config files manually.

 

Post the catalog/admin/includes/configure.php file leaving out the database user name and password and we'll see what went wrong.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

<?php

/*

$Id: configure.php,v 1.14 2003/02/21 16:55:24 dgw_ Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2002 osCommerce

 

Released under the GNU General Public License

*/

 

// define our webserver variables

// FS = Filesystem (physical)

// WS = Webserver (virtual)

define('HTTP_SERVER', ''); // eg, http://localhost or - https://localhost should not be NULL for productive servers

define('HTTP_CATALOG_SERVER', '');

define('HTTPS_CATALOG_SERVER', '');

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

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where your pages are located on the server. if $DOCUMENT_ROOT doesnt suit you, replace with your local path. (eg, /usr/local/apache/htdocs)

define('DIR_WS_ADMIN', '/admin/');

define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN);

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

define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG);

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

define('DB_SERVER_USERNAME', 'mysql');

define('DB_SERVER_PASSWORD', '');

define('DB_DATABASE', 'osCommerce');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', '');

?>

 

 

 

 

 

 

this is wierd... my username and password and all thats wasnt in there..... i made the writeable???

Link to comment
Share on other sites

The catalog is not working either. Did you chmod both the configure.php files to 777?

 

Give me a minute or so and I'll look for other occurances of $dir_fs_www_root

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

catalog/includes/

 

catalog/admin/includes

 

these are both the same...

 

all my folders are set to 755 and the catalog/includes/configure.php is set to 777

and

catalog/admin/includes blah blah blah is also set to 777....

 

am i missing something?

Link to comment
Share on other sites

Here's admin, you'll have to add the database details, which you already know.

 

define('HTTP_SERVER', ''); // eg, http://localhost or - https://localhost should not be NULL for productive servers

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

define('HTTPS_CATALOG_SERVER', '');

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

define('DIR_FS_DOCUMENT_ROOT', '/usr/local/psa/home/vhosts/gatewayvineyard.com/httpdocs/catalog/');

define('DIR_WS_ADMIN', '/admin/');

define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN);

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

define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG);

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

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

Here's catalog

 

// Define the webserver and path parameters

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

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

define('HTTP_SERVER', 'http://gatewayvineyard.com');

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

define('HTTP_COOKIE_DOMAIN', 'gatewayvineyard.com');

define('HTTPS_COOKIE_DOMAIN', '');

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

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

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

define('DIR_WS_HTTPS_CATALOG', '/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', '/usr/local/psa/home/vhosts/gatewayvineyard.com/httpdocs/catalog/');

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

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

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

WOW!! alan. you are the man. seriously.

 

that totally worked. i actually got the oscommerce screen lol. i think i can work my way around from here... if i have any other questions ill start a new thread because ITS INSTALLED NOW :) but seriously though... did i do something wrong. yes or no?

 

anyway... THANKS!!!!! B) B) B) B)

Link to comment
Share on other sites

The config files are actually very easy to set. Scary for newbies though.

 

I've been combing through the install scripts to see if there are any other easy fixes.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

ok lol... i think im about to give up on this... ive been working on trying to get this setup for weeks :\ ok its all installed but there are TONS of major problems. something had got to be screwed up. on the administration page. i cant click on anything without it taking me to the a file not found page. yeah... i dont even know anymore :(

Link to comment
Share on other sites

Change this line:

 

define('DIR_FS_DOCUMENT_ROOT', '/usr/local/psa/home/vhosts/gatewayvineyard.com/httpdocs/catalog/');

 

to:

 

define('DIR_FS_DOCUMENT_ROOT', '/usr/local/psa/home/vhosts/gatewayvineyard.com/httpdocs/');

 

I goofed. :blush:

 

You'll get it. This is the easy part, wait till you want to do something complicated.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...