Unable to connect to database server

[Guest]

Real newbie here - got osCommerce installed, and completed the Web Based Configuration Procedure.....

 

But when I click on Catalog or Administration Tool, I get an "unable to connect to database server" message - yet there were no errors during the config procedure...

 

I've searched the forums and tried the various ideas suggested - www.myurl.com/oscommerce/admin, and others....still nothing!

 

what am I doing wrong??

[Guest]

Here's what I'm typing in:

 

http://www.2galsscrappin.com/catalog/admin

 

I've deleted the catalog folder from my server, and uploaded it again, then redid the installation and configuration process......it gets right to the last screen on the Knowledge Base page for configuration, with the "Administration Tool" and "Catalog" buttons on it.....if I click either of these, or do a straight type in my address bar, I still get this message.....

 

Anybody?

[bobg7]

Please post your configure.php here so we can take a look for any errors.

 

Also, 'XXXX" out your database username and password, we don't need to see that part.

 

Bob G.

[etepalusip]

Did you create the database and database user/password, making sure the user has rights?

 

Make sure they're listed right in the configure.php files.

 

pete

 

http://RouseArtCo.com

[Guest]

Ok - here's my configure.php file: Now - I did find in my search that I should set the persistent connections to "false" and I believe I selected that option during my install - could this be the problem?

 

Thanks!!

 

<?php

/*

$Id: configure.php,v 1.14 2003/07/09 01:15:48 hpdl Exp $

 

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

define('HTTPS_COOKIE_DOMAIN', '');

define('HTTP_COOKIE_PATH', '');

define('HTTPS_COOKIE_PATH', '');

define('DIR_WS_HTTP_CATALOG', '');

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', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']));

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

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

 

// define our database connection

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

define('DB_SERVER_USERNAME', '');

define('DB_SERVER_PASSWORD', '');

define('DB_DATABASE', 'osCommerce');

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

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

?>

[etepalusip]

the important part is the:

 

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

define('DB_SERVER_USERNAME', '');

define('DB_SERVER_PASSWORD', '');

 

DB_SERVER is normally 'localhost'

the other two defines should match your db info from phpmyadmin

 

pete

 

http://www.RouseArtCo.com

[bobg7]

Is this the configure.php you have on the server? It looks like the one from the unzipped files.

 

If this is the one on your server, these lines need to be defined in both of the configure.php files:

 

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

  define('HTTPS_COOKIE_DOMAIN', 'www.2galsscrapping.com');

 

define('DIR_FS_CATALOG', '/home/www/2galsscrapping.com/catalog/');

(The absolute path to your website)

 

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

  define('DB_SERVER_USERNAME', 'xxxx_xxxx');

  define('DB_SERVER_PASSWORD', 'xxxxx');

  define('DB_DATABASE', 'xxxx_xxxx');

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

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

 

This is assuming you don't have SSL setup yet.

 

Bob G.

[Guest]

Thanks so much guys.....I'm at home right now, so I'll have to wait to head back to work to see if your suggestions work (my home PC stinks)....

 

I really appreciate it!!

[Guest]

Thank you thank you thank you!!

 

I found both config php files and edited them - now I'm at the OS Commerce Admin screen on my site.....

 

Appreciate the help!