Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Just installed Super Download Shop but.....


Guest

Recommended Posts

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

Link to comment
Share on other sites

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.

Even at a Mensa convention someone is the dumbest person in the room.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Even at a Mensa convention someone is the dumbest person in the room.

Link to comment
Share on other sites

well appears that You have modified the db parameters in the config file.

 

 

Do chek.

 

Satish

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

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

Link to comment
Share on other sites

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?

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

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!

Link to comment
Share on other sites

Is that solved or an answer to the question?

 

:-)

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

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

Link to comment
Share on other sites

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

?>

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

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...