Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Unable to connect to database server


horror_guy

Recommended Posts

Hello,

 

I think im getting this error because there is no mention of my database, username or password on this form.

 

Where do I fill this information in and what should it look like when it is finished?

 

Also do I need to modify any other php pages?

 

A configure.php file was mentioned on another post under the /catalog directory but I cannot find it, I only see the configure.php file under the /admin directory.

 

Thanks for the help all!!

 

Mark

Link to comment
Share on other sites

The configure.php files are located catalog/includes/configure.php and admin/includes/configure.php

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

Thanks for the quick replies guys :)

 

I checked out the two configure files and everything seems okay to me, all of my passwords and database names and servers are the exact same as the ones I inputted during the install when I was told that the connection was okay.

 

Not sure why I can't connect.

 

Mark

Link to comment
Share on other sites

I contacted my hosting company and the tech that I spoke to created a test script that functioned properly on my site.

 

<?php

$link = mysql_connect('sql.megasqlservers.com', 'dbm.horrormonsters.com', '******');

if (!$link) {

die('Could not connect: ' . mysql_error());

}

echo 'Connected successfully';

mysql_select_db('db1_horrormonsters_com');

mysql_close($link);

?>

 

it looks like this, these are the same names I have inputted into my config files but still cannot connect.

 

any help would be greatly appreciated.

 

Thanks!

 

 

Mark

Link to comment
Share on other sites

Here is the catalog config file:

 

<?php

/*

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 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://horrormonsters.com'); // eg, http://localhost - should not be empty for productive servers

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

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

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

define('HTTPS_COOKIE_DOMAIN', 'horrormonsters.com');

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', '/services/webpages/h/o/horrormonsters.com/public/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', 'sql.megasqlservers.com '); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'dbm.horrormonsters.com');

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

define('DB_DATABASE', 'db1_horrormonsters_com');

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

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

?>

 

Thank you very much for your patience and assistance :)

 

 

 

Mark

Link to comment
Share on other sites

That's an exact copy and paste?

 

Look at this line:

 

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

 

See the space after sql.megasqlservers.com (between the last character and the ') ?

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

BTW:

 

You better turn ssl off.

 

ie: set this:

 

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

 

to: define('ENABLE_SSL', false)

 

because you do not have a secure connection available at this address.

 

https://horrormonsters.com

 

Your next thread would be "Why can't I log 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

Archived

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

×
×
  • Create New...