abbott75 Posted November 25, 2009 Share Posted November 25, 2009 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 More sharing options...
Xpajun Posted November 25, 2009 Share Posted November 25, 2009 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 More sharing options...
Mort-lemur Posted November 25, 2009 Share Posted November 25, 2009 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 More sharing options...
abbott75 Posted November 25, 2009 Author Share Posted November 25, 2009 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 Link to comment Share on other sites More sharing options...
abbott75 Posted November 25, 2009 Author Share Posted November 25, 2009 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 More sharing options...
germ Posted November 25, 2009 Share Posted November 25, 2009 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 More sharing options...
abbott75 Posted November 25, 2009 Author Share Posted November 25, 2009 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 More sharing options...
germ Posted November 25, 2009 Share Posted November 25, 2009 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 More sharing options...
abbott75 Posted November 25, 2009 Author Share Posted November 25, 2009 Someone has already done that in this thread. 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 Link to comment Share on other sites More sharing options...
germ Posted November 25, 2009 Share Posted November 25, 2009 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 More sharing options...
abbott75 Posted November 25, 2009 Author Share Posted November 25, 2009 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 More sharing options...
abbott75 Posted November 26, 2009 Author Share Posted November 26, 2009 Just a thank you to everyone, my site is back up and running, SSL working perfectly. Thank you so much to everyone for their help, this is an amazing community. Adam Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.