This is a discussion on Xampp local installation guidance needed - Newbie questions within the osCMax v2 Installation issues forums, part of the osCMax v2.0 Forums category; I run a live OscMax shop, but would like to install it locally for isolated testing. I have installed the ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| 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. Last edited by minuteman1970; 08-05-2007 at 04:45 PM. |
|
#2
| ||||
| ||||
| Change the database username to root Leave the password blank, unless you set one up for mysql when you installed xampp.
__________________ Michael Sasek osCMax Developer
|
|
#3
| |||
| |||
| 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: Code:
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'
?>
|
|
#4
| ||||
| ||||
| 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 |
| The Following User Says Thank You to mfleeson For This Useful Post: | ||
minuteman1970 (08-11-2007) | ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| osCMax newbie questions | schieb | osCMax v2 Installation issues | 3 | 07-30-2007 10:29 AM |
| A few basic newbie questions | minuteman1970 | osCommerce 2.2 Modification Help | 5 | 02-11-2007 12:36 PM |
| osC MS2-MAX v1.7 with XAMPP 1.4.10a (lite) installation prob | Philibuster | osCMax v1.7 Installation | 6 | 10-04-2005 11:07 PM |
| a list of newbie questions,thanks.... | soundworker | osCMax v1.7 Discussion | 5 | 08-24-2005 05:34 AM |
| Win XP Pro Local Host Installation Issue | maxwelltl | osCommerce 2.2 Installation Help | 2 | 09-27-2003 04:17 PM |