Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Setting up my SSL-need help.


Aye Poppin

Recommended Posts

Posted

I did it step by step and it's still messed up <_<

 

Warning: mysql_connect(): Access denied for user: 'mysql@localhost' (Using password: NO) in /home/httpd/vhosts/ayepoppintees.com/httpdocs/includes/functions/database.php on line 19

Unable to connect to database server!

 

any ideas?

Posted

this is what the code looks like.

 

 

  if (USE_PCONNECT == 'true') {
  $$link = mysql_pconnect($server, $username, $password);
} else {
  $$link = mysql_connect($server, $username, $password);
}

Posted

Could you post your your_store.com/includes/configure.php and admin/includes/configure.php files without the database information?

Posted

here is admin

<?php
/*
 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 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', 'https://www.ayepoppintees.com'); // eg, http://localhost - should not be empty for productive servers
 define('HTTP_CATALOG_SERVER', 'https://www.ayepoppintees.com');
 define('HTTPS_CATALOG_SERVER', 'https://www.ayepoppintees.com');
 define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module
 define('DIR_FS_DOCUMENT_ROOT', '/home/httpd/vhosts/ayepoppintees.com/httpdocs/'); // where the pages are located on the server
 define('DIR_WS_ADMIN', '/admin/'); // absolute path required
 define('DIR_FS_ADMIN', '/home/httpd/vhosts/ayepoppintees.com/httpdocs/admin/'); // absolute pate required
 define('DIR_WS_CATALOG', ''); // absolute path required
 define('DIR_FS_CATALOG', '/home/httpd/vhosts/ayepoppintees.com/httpdocs/'); // 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', '');
 define('DB_SERVER_PASSWORD', '');
 define('DB_DATABASE', 'osdb');
 define('USE_PCONNECT', 'false'); // use persisstent connections?
 define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'
?>

 

the other

<?php
/*
 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 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', 'https://www.ayepoppintees.com'); // eg, http://localhost - should not be empty for productive servers
 define('HTTP_CATALOG_SERVER', 'https://www.ayepoppintees.com');
 define('HTTPS_CATALOG_SERVER', 'https://www.ayepoppintees.com');
 define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module
 define('DIR_FS_DOCUMENT_ROOT', '/home/httpd/vhosts/ayepoppintees.com/httpdocs/'); // where the pages are located on the server
 define('DIR_WS_ADMIN', '/admin/'); // absolute path required
 define('DIR_FS_ADMIN', '/home/httpd/vhosts/ayepoppintees.com/httpdocs/admin/'); // absolute pate required
 define('DIR_WS_CATALOG', ''); // absolute path required
 define('DIR_FS_CATALOG', '/home/httpd/vhosts/ayepoppintees.com/httpdocs/'); // 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', '');
 define('DB_SERVER_PASSWORD', '');
 define('DB_DATABASE', 'osdb');
 define('USE_PCONNECT', 'false'); // use persisstent connections?
 define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'
?>

Posted

The answer is fairly simple - it's almost certain that your MySQL User Name is not 'mysql'.

 

If that's not the problem then either the MySQL Password or database name is wrong.

 

You are also hosted by a company who haven't bothered to Sym Link the httpdocs and httpsdocs folders to one another - so all of your folders and files need to be duplicated in the httpsdocs folder.

 

Finally - why on earth do you want the whole site to run under https? Google (the most important search engine in the world) do not give Page Rank points to any https pages - so you are kicking yourself in the teeth by doing that.

 

Vger

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...