There seems to be a problem connecting to our database

[Debbledee]

[FONT="Arial Black"]I have had alot of issues with my website, now when i try to go to the store i get the error.
Sorry!
There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you.

Now i have read the forums and there may be a problem with my configure files. So i have pasted both files here. Can somebody please tell me if they see any issues with either one.[/FONT]

[FONT="Arial Black"]admin/includes/configure.php[/FONT]

// Define the webserver and path parameters
// Main webserver: eg, http://localhost - should not be empty for productive servers
// HTTP_SERVER is your Main webserver: eg, http://www.yourdomain.com
// HTTPS_SERVER is your Secure webserver: eg, https://www.yourdomain.com
// HTTP_CATALOG_SERVER is your Main webserver: eg, http://www.yourdomain.com
// HTTPS_CATALOG_SERVER is your Secure webserver: eg, https://www.yourdomain.com
/*
* URLs for your site will be built via:
* HTTP_SERVER plus DIR_WS_ADMIN or
* HTTPS_SERVER plus DIR_WS_HTTPS_ADMIN or
* HTTP_SERVER plus DIR_WS_CATALOG or
* HTTPS_SERVER plus DIR_WS_HTTPS_CATALOG
* ...depending on your system configuration settings
*/
define('HTTP_SERVER', 'http://leather2flesh.com.au');
define('HTTPS_SERVER', 'https://leather2flesh.com.au');
define('HTTP_CATALOG_SERVER', 'http://leather2flesh.com.au');
define('HTTPS_CATALOG_SERVER', 'https://leather2flesh.com.au');

// Use secure webserver for catalog module and/or admin areas?
define('ENABLE_SSL_CATALOG', 'false');
define('ENABLE_SSL_ADMIN', 'false');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
// these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
define('DIR_WS_ADMIN', '/store/admin/');
define('DIR_WS_CATALOG', '/store/');
define('DIR_WS_HTTPS_ADMIN', '/store/admin/');
define('DIR_WS_HTTPS_CATALOG', '/store/');

define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_CATALOG_IMAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'images/');
define('DIR_WS_CATALOG_TEMPLATE', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/templates/');
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', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/languages/');

// * DIR_FS_* = Filesystem directories (local/physical)
//the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
define('DIR_FS_ADMIN', '/home/mistress/public_html/store/admin/');
define('DIR_FS_CATALOG', '/home/mistress/public_html/store/');

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_CATALOG_TEMPLATES', DIR_FS_CATALOG . 'includes/templates/');
define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');
define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'mistress_zc1');
define('DB_SERVER_PASSWORD', 'nRW71{2E19w{\[');
define('DB_DATABASE', 'mistress_zc1');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from: none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'database');
define('DIR_FS_SQL_CACHE', '/home/mistress/public_html/store/cache');


[FONT="Arial Black"]includes/configure.php[/FONT]


// Define the webserver and path parameters
// HTTP_SERVER is your Main webserver: eg, http://www.yourdomain.com
// HTTPS_SERVER is your Secure webserver: eg, https://www.yourdomain.com
define('HTTP_SERVER', 'http://leather2flesh.com.au');
define('HTTPS_SERVER', 'https://leather2flesh.com.au');

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

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
// these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
define('DIR_WS_CATALOG', '/store/');
define('DIR_WS_HTTPS_CATALOG', '/store/');

define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_INCLUDES', 'includes/');
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', DIR_WS_CATALOG . 'pub/');
define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/');

define('DIR_WS_PHPBB', '/');

// * DIR_FS_* = Filesystem directories (local/physical)
//the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
define('DIR_FS_CATALOG', '/home/mistress/public_html/store/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/');
define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS);
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'mistress_zc1');
define('DB_SERVER_PASSWORD', 'nRW71{2E19w{\[');
define('DB_DATABASE', 'mistress_zc1');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from: none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'database');
define('DIR_FS_SQL_CACHE', '/home/mistress/public_html/store/cache');

[FONT="Arial Black"]Also when i try to log into my store admin i get the following error. Can someone please help me and save me. [/FONT]

0 DB_ERROR_NOT_CONNECTED
in:
[db_cache table]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[jaskarn]

are you sure your password is correct.
It is probably because you have not added yourself as a user to your database. Go to cPanel, then MySQL Database, and there should be a section which says "Add Users" where you can select your user name from a drop down list and then your databse from a dropdown list. Once you have assigned your username to your databse it should work. If it still does not work then try using a simpler password. Im not sure but the brackets and slashs could be confusing it. tell me if you succed.

[Website Rob]

Not sure if this is a new problem or if you've had it since day one.

First, I would change your db password:
define('DB_SERVER_PASSWORD', 'nRW71{2E19w{\[');

Get rid of the special characters for now.

If you still get the error msg. "There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem.", then contact your Hoster. Problem could be on their end.

[agentj]

Hi, Did you problem get resolved? I'm having the same problem, I cannot even access my www.domain.com/admin panel! Did you get yours fixed and if so, how?

[Paula]

I am getting this same message:

Sorry!
There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you.


Help!!

[crisand]

Help!!
My site has been up and running for months and has been fine, and then this morning the site is down with the message there seems to be a problem connecting to our database, and when I do to my admin I get the answer '0 DB_ERROR_NOT_CONNECTED
in:
[db_cache table]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Help, help, what can I do to fix this!

[Jahfree]

I MAY HAVE A FIX: I have the some ERROR in accessing my Storefront DB.

I recently changed my passwords on my server (Admin, and all others) -- THEN i noticed this error.

SO, I went into the includes/configure.php and changed the admin password to the new one.

NOTE: After you edit the file, you will have to do a CHMOD 444 Configure.php to reset the file to READ ONLY.

It may very well be that your HOSTING admin changed username and/or password to the SQL program they use - CALL EM UP!

Otherwise, perhaps the admin changed one of the other variables below:
(THIS CODE IS AT THE BOTTOM OF THE CONFIGURE.PHP FILE)

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'mistress_zc1');
define('DB_SERVER_PASSWORD', '*****');
define('DB_DATABASE', 'mistress_zc1');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

Please let me know if this worked for you.

[Jahfree]

In addition to the main storefront/includes/configure.php file., dont forget to modify the username & password in the Admin/includes/configure.php file. This give you access to your Admin Page.

Then you will have reset the file access permissions using CHMOD 444 configure.php.

I hope this helps!

Please let me know.

[berryb]

Wow. I'll be excited to try this. Unfortunately our client has gone AWAL. We have our deposit and the site is done, but he's not paying up. We've stopped work until this is resolved.

I'll make sure to post my findings when we restart. Thanks for the reply!

[BobTheBuilder]

I ran into this same problem. It turned out to be caused by the fact that I had a PHPbb forum database linked to my zen-cart. When I changed the admin password for MySql databases I changed them in include/configure.php and admin/include/configure.php but somehow neglected to also change the password in ~/phpbb2/config.php