Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Installation problem


Guest

Recommended Posts

:unsure:

Hi,

 

I have been reading through this forum to find the answer but to no avil.

 

this is the error message I get.

 

A test connection made to the database was NOT successful.

 

The error message returned is:

 

Access denied for user: '[email protected]' (Using password: YES)

 

and my config files are assigned as follows.

 

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

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

define('HTTP_SERVER', 'http://www.jaucity.com/eShop/'); // 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', 'http://www.jaucity.com');

define('HTTPS_COOKIE_DOMAIN', '');

define('HTTP_COOKIE_PATH', 'eShop');

define('HTTPS_COOKIE_PATH', '');

define('DIR_WS_HTTP_CATALOG', 'eShop');

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', '/home/jaucity/public_html/eShop/');

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 empty for productive servers

define('DB_SERVER_USERNAME', 'jaucity_sales');

define('DB_SERVER_PASSWORD', '********');

define('DB_DATABASE', 'jaucity_Shop');

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

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

 

I confirmed that database is created and the user is added as user for the database. I am very new at this. Trying to learn and put up a test site...

Any help would be greatly appreciated.

 

Zack.

Link to comment
Share on other sites

define('HTTP_SERVER', 'http://www.jaucity.com/eShop/');

would be

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

define('HTTP_COOKIE_PATH', 'eShop');

would be

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

define('DIR_WS_HTTP_CATALOG', 'eShop');

would be

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

then the database may be

 

define('DB_SERVER', 'jaucity.com');

or localhost

define('DB_DATABASE', 'jaucity_Shopdb');

 

It is the database that it cannot connect to so the database info is the first part to get right

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

Hey steve,

 

made the changes as you have provided, but I am still getting the same error.

 

My database was created with myphpadmin with database name jaucity_Shop.

 

just curious why this was defined.

define('DB_DATABASE', 'jaucity_Shopdb');

 

Anything else I could try?

 

Zack

Link to comment
Share on other sites

I also use phpMyAdmin and if say the user name was jaucity the database was called jaucitydb and the domain name is used instead of localhost

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

I see, like I said I'm new at this... got anything else that I might try to resolve this? Been browsing this forum for two days. Try lot of thing other ppl said which worked for them... I must be missing something. Just can't figure out what.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...