Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Unable to connect to database server!


Gowans007

Recommended Posts

Posted

In one folder I have a osCommerce site that I've had no problems.

 

In a adjacent folder I have setup another, install went fine but when I go to it I get "Unable to connect to database server!" ????

 

Checked the configure.php files in /catalog/includes and /catalog/admin/includes and they are correct. The only difference between the two is the other uses https: and SSL as True. (this one doesn't).

 

Any ideas guys, I don't have much hair left to tear out.

Posted

Gowans,

 

Check the database name, log in name and password for the second site.

 

 

 

 

Chris

Posted

Cheers Chris but it's all fine, all entered in the setup, just checked the tables in mySQL and they are all there.

 

Why wont you work damn you Grrr!

Posted

Any more ideas guys????

 

Here's my two configure.php files. (x replaces sensitive data)

 

<?php
 define('HTTP_SERVER', 'http://www.x.co.uk');
 define('HTTP_CATALOG_SERVER', 'http://www.x.co.uk');
 define('HTTPS_CATALOG_SERVER', 'http://www.x.co.uk');
 define('ENABLE_SSL_CATALOG', 'false');
 define('DIR_FS_DOCUMENT_ROOT', '/home/x/public_html/x/catalog/');
 define('DIR_WS_ADMIN', '/catalog/admin/');
 define('DIR_FS_ADMIN', '/home/x/public_html/x/catalog/admin/');
 define('DIR_WS_CATALOG', '/catalog/');
 define('DIR_FS_CATALOG', '/home/x/public_html/x/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('DB_SERVER', 'localhost');
 define('DB_SERVER_USERNAME', 'x');
 define('DB_SERVER_PASSWORD', 'x');
 define('DB_DATABASE', 'x');
 define('USE_PCONNECT', 'false');
 define('STORE_SESSIONS', 'mysql');
?>

 

 

<?php
 define('HTTP_SERVER', 'http://www.x.co.uk');
 define('HTTPS_SERVER', 'http://www.x.co.uk');
 define('ENABLE_SSL', false);
 define('HTTP_COOKIE_DOMAIN', 'www.x.co.uk');
 define('HTTPS_COOKIE_DOMAIN', 'www.x.co.uk');
 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', '/home/x/public_html/x/catalog/');
 define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
 define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 define('DB_SERVER', 'x');
 define('DB_SERVER_USERNAME', 'x');
 define('DB_SERVER_PASSWORD', 'x');
 define('DB_DATABASE', 'x');
 define('USE_PCONNECT', 'false');
 define('STORE_SESSIONS', 'mysql');
?>

Posted

Heres a really odd thing.

 

I made a new test folder in my domain root then installed an example there under a different domain name and it works fine.

Its not where I want it tho.

 

Any ideas?

Posted

Try to use another db for second site (if you need info from first, after installing osCommerce, restore new db from the first db).

Archived

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

×
×
  • Create New...