Guest Posted December 31, 2007 Share Posted December 31, 2007 I have just installed the Shop but cannot now access the admin section of the OSC program. I get the following message: <quote> Warning: mysql_connect() [function.mysql-connect]: Access denied for user '***'@'localhost' (using password: YES) in ****/catalog/admin/includes/functions/database.php on line 19 Unable to connect to database server! <quote> Can anyone help please? I have been so careful in installing the Store that I am puzzled at what has happened. There has been no change to this particular file, database.php, since original installation. Thanks for any help that you can give. There surely must be a simple explanation. I have looked at the postings but can't find anything useful. Martin Quote Link to comment Share on other sites More sharing options...
Mav666 Posted December 31, 2007 Share Posted December 31, 2007 Presuming you have not changed the db password, have you checked the /admin/includes/configure.php? If the store is working and the admin section is not, that would be the first place I'd check. Quote Even at a Mensa convention someone is the dumbest person in the room. Link to comment Share on other sites More sharing options...
Guest Posted December 31, 2007 Share Posted December 31, 2007 Presuming you have not changed the db password, have you checked the /admin/includes/configure.php? If the store is working and the admin section is not, that would be the first place I'd check. Thanks Mav666 All I have done is to add the additional definition as required in the Super Download Shop installation viz: // BOF Super Download Shop v1.0 mod define('DIR_FS_CATALOG_DOWNLOAD', DIR_FS_CATALOG . 'download/'); // EOF Super Download Shop v1.0 mod Everything else is the same. Martin Quote Link to comment Share on other sites More sharing options...
Mav666 Posted January 1, 2008 Share Posted January 1, 2008 Don't mean to beat a dead horse, but have you tried to write a quick script that connects to the database, does a query and disconnects and uses the parameters you have in the configure.php? If the store works and the admin section does not, and you compared the two configure.php files and they are essentially the same, there has to be a logical flaw somewhere. At the time the script craps out, the only parameters you pass along is server, username and password - so there is not a lot to go wrong yet. I guess what you could do is post the section under the // define our database connection portion in the admin configure and make sure you take the actual info out. You could have inadvertently changed the name of one of the constants ... just my 2 cents Quote Even at a Mensa convention someone is the dumbest person in the room. Link to comment Share on other sites More sharing options...
satish Posted January 1, 2008 Share Posted January 1, 2008 well appears that You have modified the db parameters in the config file. Do chek. Satish Quote Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
Guest Posted January 1, 2008 Share Posted January 1, 2008 Thanks for all the advice. Having backed up the relevant files before I installed the Contribution, I have just tried restoring the original config file back to catalog/admin/includes/ BUT I get the same result as before. This is the relevant //define our database connection section and it is precisely the same in both the backed up original config file and the amended one: <quote> // define our database connection define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', '****_osc1'); define('DB_SERVER_PASSWORD', '****'); define('DB_DATABASE', '****_osc1'); define('DB_TABLE_PREFIX', 'osc1_'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql' </quote> I feel a bit stuck on this one! Martin Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 1, 2008 Share Posted January 1, 2008 define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' // BOF Super Download Shop v1.0 mod define('DIR_FS_CATALOG_DOWNLOAD', DIR_FS_CATALOG . 'download/'); // EOF Super Download Shop v1.0 mod ?> You do have ?> as the last line in the file, don't you? Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Guest Posted January 1, 2008 Share Posted January 1, 2008 define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'// BOF Super Download Shop v1.0 mod define('DIR_FS_CATALOG_DOWNLOAD', DIR_FS_CATALOG . 'download/'); // EOF Super Download Shop v1.0 mod ?> You do have ?> as the last line in the file, don't you? Oh yes! Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 1, 2008 Share Posted January 1, 2008 Is that solved or an answer to the question? :-) Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Guest Posted January 1, 2008 Share Posted January 1, 2008 Is that solved or an answer to the question? :-) Sorry Geoff. Yes, it does mean that the answer to the question is Yes. There is indeed a ?> to end the line. Martin Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 1, 2008 Share Posted January 1, 2008 Can you post the entire admin configure php changing the sensitive bits define('DB_SERVER_USERNAME', '****_osc1'); define('DB_SERVER_PASSWORD', '****'); define('DB_DATABASE', '****_osc1'); Mine local xampp is <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://localhost'); // eg, http://localhost - should not be empty for productive servers define('HTTP_CATALOG_SERVER', 'http://localhost'); define('HTTPS_CATALOG_SERVER', ''); define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', 'C:/Program Files/xampp/htdocs/dev/catalog/'); // where the pages are located on the server define('DIR_WS_ADMIN', '/dev/catalog/admin/'); // absolute path required define('DIR_FS_ADMIN', 'C:/Program Files/xampp/htdocs/dev/catalog/admin/'); // absolute pate required define('DIR_WS_CATALOG', '/dev/catalog/'); // absolute path required define('DIR_FS_CATALOG', 'C:/Program Files/xampp/htdocs/dev/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 . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); // define our database connection define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', 'xx'); define('DB_SERVER_PASSWORD', 'xx'); define('DB_DATABASE', 'xx'); define('USE_PCONNECT', 'true'); // use persisstent connections? define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' // BOF Super Download Shop v1.0 mod define('DIR_FS_CATALOG_DOWNLOAD', DIR_FS_CATALOG . 'download/'); // EOF Super Download Shop v1.0 mod ?> Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Guest Posted January 1, 2008 Share Posted January 1, 2008 Geoff and everybody I have had a good look at all of this and I am beginning to think that the problem is more to do with my interpretation of my clients' DB connection protocols than anything else. A change of host recently has not helped at all! Why it worked OK BEFORE I put the Super Download Shop on beats me. I am going to speak to the host tomorrow and get them to walk me through the various connection thingies. I will of course come back to you if I need you considerable expertise. Finally, for the moment, many many thanks for all your help and the very best wishes for 2008. Martin Quote Link to comment Share on other sites More sharing options...
Guest Posted January 2, 2008 Share Posted January 2, 2008 Sorry to prolong this saga. I have now managed to connect, or I think I have! The following is the config file now: <quote> // define our webserver variables // FS = Filesystem (physical) // WS = Webserver (virtual) define('HTTP_SERVER', 'http://****.com/'); // eg, http://localhost - should not be empty for productive servers define('HTTP_CATALOG_SERVER', 'http://****.com/catalog'); define('HTTPS_CATALOG_SERVER', 'https://****.com/catalog'); define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where your pages are located on the server. if $DOCUMENT_ROOT doesnt suit you, replace with your local path. (eg, /usr/local/apache/htdocs) define('DIR_WS_ADMIN', '/admin/'); define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN); define('DIR_WS_CATALOG', '/catalog/'); define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG); 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 . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); // define our database connection define('DB_SERVER', 'mysql3.hostsname.net'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', '****'); define('DB_SERVER_PASSWORD', '****'); define('DB_DATABASE', '****'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql' // BOF Super Download Shop v1.0 mod define('DIR_FS_CATALOG_DOWNLOAD', DIR_FS_CATALOG . 'download/'); // EOF Super Download Shop v1.0 mod ?> When I try to go to www.xxxx.com/catalog/admin, I get a 404 page not found message and the address line changes to: http://xxxx.com//admin/login.php?osCAdminI...d055e4a274f1461 I wonder if a way out of all this is to do a reinstall. Martin Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.