Xampp local installation guidance needed - Newbie questions

[minuteman1970]

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.

[michael_s]

Change the database username to

root

Leave the password blank, unless you set one up for mysql when you installed xampp.

[minuteman1970]

The DB user/password issue was the problem, I have replaced them with 'root' as the user (no password) and can get into the catalog side just fine.
I can get as far as the login screen on the Admin side, but get a 404 error or blank screen when I try to log in. I suspect it may be a pathing issue in my admin configure.php file. Here's the file:

 
define('HTTP_SERVER', 'http://localhost'); // eg, cPanel® - should not be empty for productive servers
define('HTTP_CATALOG_SERVER', 'http://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', 'root');
define('DB_SERVER_PASSWORD', '');
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.

[mfleeson]

Hi

You need to add trailing / to the entries

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

If you look at the catalog entries you'll see they are:
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/');

This is because these variables get used to build the file paths used by oscmax.

Change your entries to:

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


Cheers

Mark