Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Attempted SSL install, killed site


abbott75

Recommended Posts

Hey everyone.

 

Before I start I'd like to say a massive thankyou for this amazing peice of software!

 

I have recently set up my OSC and today tried to set up my SSL. I followed these instructions:

 

http://www.oscommerce.com/forums/topic/233458-how-to-install-ssl-on-osc-a-simple-1-2-3-instruction/

 

When I uploaded the new configuration.php files, I was presented with an error, so I reuploaded the default files. I'm still getting this error:

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'fullscal'@'localhost' (using password: NO) in /home/fullscal/public_html/catalog/includes/functions/database.php on line 19
Unable to connect to database server!

 

Is anyone able to help me? It is probably something very simple, but I've never used PHP before so I'm a bit of a n00b.

 

Thanks heaps for your help!

Adam

Link to comment
Share on other sites

Looks like you've uploaded a set of configure.php that aren't configured for your site - to configure do thus:

 

root>>includes>>configure.php:

 

 define('HTTP_SERVER', 'http://your_site.com');
 define('HTTPS_SERVER', 'https://your_site.com');
 define('ENABLE_SSL', true);
 define('HTTP_COOKIE_DOMAIN', 'your_site.com');
 define('HTTPS_COOKIE_DOMAIN', 'your_site.com');
 define('HTTP_COOKIE_PATH', '/');
 define('HTTPS_COOKIE_PATH', '/');
 define('DIR_WS_HTTP_CATALOG', '/');
 define('DIR_WS_HTTPS_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', '/home/your_user_name_here/public_html/your_store_directory_name/');
 define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
 define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 define('DB_SERVER', 'localhost');
 define('DB_SERVER_USERNAME', 'your_sql_table_user_name');
 define('DB_SERVER_PASSWORD', 'your_sql_table_passwprd');
 define('DB_DATABASE', 'your_sql_table_name');
 define('USE_PCONNECT', 'false');
 define('STORE_SESSIONS', 'mysql');

 

root>>admin>>includes>>configure.php:

 define('HTTP_SERVER', 'http://your_site.com');
 define('HTTPS_SERVER', 'https://your_site.com');
 define('ENABLE_SSL', true);
 define('DIR_FS_DOCUMENT_ROOT', '/home/your_user_name_here/public_html/your_store_directory_name/');
 define('DIR_WS_ADMIN', '/admin/');
 define('DIR_FS_ADMIN', '/home/your_user_name_here/public_html/your_store_directory_name/');
 define('DIR_WS_CATALOG', '/');
 define('DIR_FS_CATALOG', '/home/your_user_name_here/public_html/your_store_directory_name/');
 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('DB_SERVER', 'localhost');
 define('DB_SERVER_USERNAME', 'your_sql_table_user_name');
 define('DB_SERVER_PASSWORD', 'your_sql_table_passwprd');
 define('DB_DATABASE', 'your_sql_table_name');
 define('USE_PCONNECT', 'false');
 define('STORE_SESSIONS', 'mysql');

 

change all statements beginning "your_" to your details

My store is currently running Phoenix 1.0.3.0

I'm currently working on 1.0.7.2 and hope to get it live before 1.0.8.0 arrives (maybe 🙄 )

I used to have a list of add-ons here but I've found that with the ones that supporters of Phoenix get any other add-ons are not really neccessary

Link to comment
Share on other sites

Hi,

 

Check your configure.php files at the bottom of the page for the username and password of your database - Looks like these are wrong for your database

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Link to comment
Share on other sites

Alternately, could someone please show me what the entire code to both configure pages should look like? I need the whole thing, including anything at the top and bottom of the page. I'll try to restore mine from them.

 

Thanks heaps,

Adam

Link to comment
Share on other sites

Thanks for your help guys, but it has not fixed my problem.

 

Is there any way I can 'reinstall' the configure.php files back to how they originally were without touching the rest of the site?

 

Cheers

Adam

In the includes FOLDER (catalog and admin) where the normal configure.php files are there is a FOLDER named local

 

On some installs there may be a configure.php inside the local FOLDER (catalog and admin)

 

If there is, anything in it overrides anything in the normal configure.php files.

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Link to comment
Share on other sites

In the includes FOLDER (catalog and admin) where the normal configure.php files are there is a FOLDER named local

 

On some installs there may be a configure.php inside the local FOLDER (catalog and admin)

 

If there is, anything in it overrides anything in the normal configure.php files.

 

Thanks for your help but no, there is no extra configure.php in the local folder.

 

I think what I've done trying to fix it has just made my problem worse, so If anyone could show me what both complete configure codes should look like I think I should be able to rebuild what I've messed up from there.

 

Thanks

Adam

Link to comment
Share on other sites

Thanks for your help but no, there is no extra configure.php in the local folder.

 

I think what I've done trying to fix it has just made my problem worse, so If anyone could show me what both complete configure codes should look like I think I should be able to rebuild what I've messed up from there.

 

Thanks

Adam

Someone has already done that in this thread.

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Link to comment
Share on other sites

I'm a PHP n00b, so sorry if this is a stupid question, but shouldn't there be a bit more code at the top and bottom to complete the page?

 

Thanks for your patience,

Adam

All they left out would be the opening PHP tag:

 

<?php

And the closing one (optional):

 

?>

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Link to comment
Share on other sites

All they left out would be the opening PHP tag:

 

<?php

And the closing one (optional):

 

?>

 

Thanks so much germ, you're a champion.

 

I'm still having a little issue with a "1046 - No database selected" error, but I'm currently searching the fourm for the answer, I don't want to push my welcome with you guys too far ;)

 

Again, thank you all so much for your help.

 

Adam

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...