Unable to connect to database server

[horror_guy]

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

[OceanRanch]

Try

 

catalog/includes/configure.php

 

and

 

admin/includes/configure.php

 

HTH

Tom

[241]

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

[horror_guy]

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

[horror_guy]

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

[AlanR]

Post the config file.

[horror_guy]

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

[AlanR]

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 ') ?

[AlanR]

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?"