LinkBack URL
About LinkBacks
Xampp local installation guidance needed - Newbie questions I run a live OscMax shop, but would like to install it locally for isolated testing. I have installed the latest version of Xampp, and am able to activate its services and get into PHPMyadmin. I have copied my Osc catalog to \xampp\htdocs\store\catalog\. I also used PHPmyadmin to 'create' a new DB with the same name as my original, then did a sql import of my saved copy. I have also edited the two configure.php files, changing the paths.
However, when I try to access the catalog or admin pages, I am getting this error:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ORIGINAL USER NAME'@'localhost' (using password: YES) in C:\Program Files\xampp\htdocs\store\catalog\admin\includes\fu nctions\database.php on line 19
Unable to connect to database server!
I also get a similar error when I remove the DB Server username & password from either configure.php files. I feel as though I am almost there, but am missing something rather minor. Perhaps a pathing typo in the configure.php files?
Here is the code from the catalog\includes\configure.php file:
define('HTTP_SERVER', 'http://localhost'); // eg, cPanel® - should not be empty for productive servers
define('HTTPS_SERVER', 'https://localhost'); // eg, https://localhost - should not be empty for productive servers
define('ENABLE_SSL', true); // secure webserver for checkout procedure?
define('HTTP_COOKIE_DOMAIN', 'http://localhost');
define('HTTPS_COOKIE_DOMAIN', 'https://localhost');
define('HTTP_COOKIE_PATH', '/store/catalog/');
define('HTTPS_COOKIE_PATH', '/store/catalog/');
define('DIR_WS_HTTP_CATALOG', '/store/catalog/');
define('DIR_WS_HTTPS_CATALOG', '/store/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', 'C:/Program Files/xampp/htdocs/store/catalog/');
define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'C:/Program Files/xampp/htdocs/store/catalog/download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'C:/Program Files/xampp/htdocs/store/catalog/pub/');
// define our database connection
define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers
define('DB_SERVER_USERNAME', 'ORIGINAL USERNAME');
define('DB_SERVER_PASSWORD', 'ORIGINAL PW');
define('DB_DATABASE', 'specopst_p_os1');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>
Here is the code from the catalog\admin\includes\configure.php file:
define('HTTP_SERVER', 'https://localhost'); // eg, cPanel® - should not be empty for productive servers
define('HTTP_CATALOG_SERVER', 'https://localhost');
define('HTTPS_CATALOG_SERVER', 'https://localhost');
define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module
define('DIR_FS_DOCUMENT_ROOT', 'C:/Program Files/xampp/htdocs/store/catalog/'); // where the pages are located on the server
define('DIR_WS_ADMIN', '/store/catalog/admin'); // absolute path required
define('DIR_FS_ADMIN', 'C:/Program Files/xampp/htdocs/store/catalog/admin'); // absolute pate required
define('DIR_WS_CATALOG', '/store/catalog/'); // absolute path required
define('DIR_FS_CATALOG', 'C:/Program Files/xampp/htdocs/store/catalog/'); // absolute path required
define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');
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', DIR_WS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'C:/Program Files/xampp/htdocs/store/catalog/includes/languages/');
define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'C:/Program Files/xampp/htdocs/store/catalog/images/');
define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'C:/Program Files/xampp/htdocs/store/catalog/includes/modules/');
define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'C:/Program Files/xampp/htdocs/store/catalog/backups/');
define('DIR_FCKEDITOR', DIR_FS_CATALOG . 'C:/Program Files/xampp/htdocs/store/catalog/FCKeditor/');
define('DIR_WS_FCKEDITOR', DIR_WS_CATALOG . 'FCKeditor/');
// define our database connection
define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers
define('DB_SERVER_USERNAME', 'ORIGINAL USERNAME');
define('DB_SERVER_PASSWORD', 'ORIGINAL PW');
define('DB_DATABASE', 'specopst_p_os1');
define('USE_PCONNECT', 'false'); // use persisstent connections?
define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>
Thanks in advance.
Bookmarks