Database path problems

[1886]

Hi all,

I need some guidance…Only been using ZC for a few weeks. I downloaded, installed, and had ZC running without any trouble. Then ran into customizing trouble, so I backed up the 70 or so products in my database, deleted ZC fro the server and reloaded from scratch. I was able to restore the database without any trouble. After a few days I deleted ZC again and this time reloaded to the root on my server. And you can guess…ZC path to my database has changed, so no website shows. I do see the database products in my Admin.

I looked at my config.php files, but don’t see anything that appears wrong?? Can someone lend a hand?

My domain is www.midwestdefense.com

Thanks in advance,





Config.php below:



<?php
/**
* @package Configuration Settings circa 1.3.8
* @copyright Copyright 2003-2007 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
*/


/*************** NOTE: This file is similar, but DIFFERENT from the "admin" version of configure.php. ***********/
/*************** The 2 files should be kept separate and not used to overwrite each other. ***********/

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

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

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

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

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', '');
define('DB_SERVER', 'localhost:/tmp/mysql5.sock');
define('DB_SERVER_USERNAME', 'securitystop');
define('DB_SERVER_PASSWORD', '042294');
define('DB_DATABASE', 'securitystop_catalog');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'db');
// for STORE_SESSIONS, 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', 'none');
define('DIR_FS_SQL_CACHE', '/home/securitystop/www/www/cache');

// EOF

[tony_sar]

define('DB_SERVER', 'localhost:/tmp/mysql5.sock');

// EOF

what happens if you change that to just 'localhost' ?? removing the extra path info ??

[kobra]

Change your DB user name and password immediately and NEVER post them openly

[1886]

Tony_Sar, I changed the localhost path, like you suggested, nothing changed..and now the admin gives a database error. thanks

Oh, and sorry bout the password, guess I'm stupid, good thing the sites not live, so no harm could be done!

[kobra]

/home/securitystop/www/www/

Not positive but the doubling up of the "www" in your virtual path looks suspicious??

[1886]

kobra,

Thanks for the help, the double "www" is correct, that just how my host has it set up.

The original path was: home/username/www/www/zencart/

which I later changed to : home/username/www/www/

maybe its in my SQL database files?

Its only about 70 products, so I may scrap it and start from scratch.

Thanks

[angst]

I just had the same problem today. The cause was due to changing my database password while I was in my database fiddling around looking for something to break.
You know (probably) that you have not likely changed any values in your configure.php file, so look for places that the configure.php references that may have changed (database password in my case). In your case you could have done like me and changed the name or password values on your database and not realized or thought much about it at the time.