ONION Posted January 15, 2005 Posted January 15, 2005 Hiya. sorry for asking yet another SSL question but ive search and havent found anything that really answers me. i have a server with a hosting company to which i can host up to 200 websites. i currently have 5 of my stores hosted there. in the cpanel of each account it has an option for SSL managment. where i can create SSL certificates etc and get them signed. i ahve done this and i now have an SSL as far as i know? all my pages are located in public_html yet the ssl is on the main ftp page. so it reads something like public_ftp public_html SSL in public_html is my domain with sub folders such as catalog. how do i go about using this SSL? would it be a shared one as i havent paid any fees? or would it be an option with my account that i can create as many SSL's as i want? i dont want to email them incase they start charging me ;) lol if it is an SSL any ideas how i can implement it? cheers folks :)
wheeloftime Posted January 15, 2005 Posted January 15, 2005 Hiya. sorry for asking yet another SSL question but ive search and havent found anything that really answers me. i have a server with a hosting company to which i can host up to 200 websites. i currently have 5 of my stores hosted there. in the cpanel of each account it has an option for SSL managment. where i can create SSL certificates etc and get them signed. i ahve done this and i now have an SSL as far as i know? all my pages are located in public_html yet the ssl is on the main ftp page. so it reads something like public_ftp public_html SSL in public_html is my domain with sub folders such as catalog. how do i go about using this SSL? would it be a shared one as i havent paid any fees? or would it be an option with my account that i can create as many SSL's as i want? i dont want to email them incase they start charging me ;) lol if it is an SSL any ideas how i can implement it? cheers folks :) <{POST_SNAPBACK}> Your setup sounds a lot like I had on the Cobalt server with my host (they moved it now to a Plesk server which makes, made, SSL a bit more complicated) and from my experiences on that Cobalt server with SSL installation I can only tell how it worked for me. The directory names were different but there was also a SSL directory with a seperate public_html directory where my shop files resided. In my control panel I could create SSL certificates like you but those are self-signed certificates and while these are free they have a big disadvantage; you always get a warning that the certificate is not a trusted one although the name on the certificate and the domain match. Nothing wrong with that by itself but probably a lot of people will not like any popup concerning the security of a site and will go away. If you don't want to take the risk of people going away and need SSL you will have to buy a trusted root certificate for every domain/shop you are hosting (I haven't decided yet but I will probably go for one with freeSSL which are quite affordable). For testing the SSL connection you just have to try and find out if the setup of your server is correct. After you created the self-signed certificate you configure both the configure.php files from osC to use SSL for the admin and the needed parts of the shop and normally you then have SSL for those. A quick test is just loading your shop and change http to https in your address bar. If the server has been configured correctly it will automatically change from unsecure to secure with the same files in place at public_html. If not you will have to ask your host how they have setup the server for use with SSL.
ONION Posted January 15, 2005 Author Posted January 15, 2005 Your setup sounds a lot like I had on the Cobalt server with my host (they moved it now to a Plesk server which makes, made, SSL a bit more complicated) and from my experiences on that Cobalt server with SSL installation I can only tell how it worked for me.The directory names were different but there was also a SSL directory with a seperate public_html directory where my shop files resided. In my control panel I could create SSL certificates like you but those are self-signed certificates and while these are free they have a big disadvantage; you always get a warning that the certificate is not a trusted one although the name on the certificate and the domain match. Nothing wrong with that by itself but probably a lot of people will not like any popup concerning the security of a site and will go away. If you don't want to take the risk of people going away and need SSL you will have to buy a trusted root certificate for every domain/shop you are hosting (I haven't decided yet but I will probably go for one with freeSSL which are quite affordable). For testing the SSL connection you just have to try and find out if the setup of your server is correct. After you created the self-signed certificate you configure both the configure.php files from osC to use SSL for the admin and the needed parts of the shop and normally you then have SSL for those. A quick test is just loading your shop and change http to https in your address bar. If the server has been configured correctly it will automatically change from unsecure to secure with the same files in place at public_html. If not you will have to ask your host how they have setup the server for use with SSL. <{POST_SNAPBACK}> ahhh, yeah i see what you mean. ive just tested it and set it up. i can see the warnings. i think ill just disable the account setup function in os and enable paypal as the gatway for now. i will cross the SSL bridge once i switch to visa/card payments. cheers for the useful info :)
SunnyWales Posted January 15, 2005 Posted January 15, 2005 ahhh, yeah i see what you mean.ive just tested it and set it up. i can see the warnings. i think ill just disable the account setup function in os and enable paypal as the gatway for now. i will cross the SSL bridge once i switch to visa/card payments. cheers for the useful info :) <{POST_SNAPBACK}> I've tried this for the past month. Quite a lot of guests but no customers logged in yet. I only use Paypal and Nochex (with their own SSL) but people won't log as customers because their email etc is floating around the ether! I'm trying to sort mine out as we speak. Wendy Wendy Go on spread some sunshine!
ONION Posted January 15, 2005 Author Posted January 15, 2005 I've tried this for the past month. Quite a lot of guests but no customers logged in yet. I only use Paypal and Nochex (with their own SSL) but people won't log as customers because their email etc is floating around the ether! I'm trying to sort mine out as we speak. Wendy <{POST_SNAPBACK}> yeah ive just been reading into freeSSL http://www.freessl.com/faq.html seems to be a decent company to use and good rates. thing id like to know though. is if i purchase thier SSL's how do i link them into my cart which is located in ../catalog/ ?
wheeloftime Posted January 15, 2005 Posted January 15, 2005 yeah ive just been reading into freeSSL http://www.freessl.com/faq.htmlseems to be a decent company to use and good rates. thing id like to know though. is if i purchase thier SSL's how do i link them into my cart which is located in ../catalog/ ? <{POST_SNAPBACK}> If you look in your SSL directory there should be a couple of files, three I believe, which are your self-signed certificate. I could just delete those, create a new one and voila I had renewed my certificate. In principle you should be able to just FTP the files you get from freeSSL or whomever you choose to that directory and you have an official SSL. I could also be that you should import those files through your control panel, if you have that option, to get them on the right place and otherwise your hosting provider will have to do it for you. You might ask them first if going the easy way is enough.
ONION Posted January 15, 2005 Author Posted January 15, 2005 If you look in your SSL directory there should be a couple of files, three I believe, which are your self-signed certificate. I could just delete those, create a new one and voila I had renewed my certificate. In principle you should be able to just FTP the files you get from freeSSL or whomever you choose to that directory and you have an official SSL. I could also be that you should import those files through your control panel, if you have that option, to get them on the right place and otherwise your hosting provider will have to do it for you. You might ask them first if going the easy way is enough. <{POST_SNAPBACK}> hmm, ill try that then :) what do i put in here though: define('HTTP_SERVER', ''); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', ''); // eg, https://localhost - should not be empty for productive servers define('ENABLE_SSL', false); // secure webserver for checkout procedure? i know i change false to true, but what about the defines? with the setup ive got the SSL is before the public_html folder. does this matter? or do i just point both to www.mydomain.com and it will pick it all up automatically?
wheeloftime Posted January 15, 2005 Posted January 15, 2005 hmm, ill try that then :) what do i put in here though: ?define('HTTP_SERVER', ''); // eg, http://localhost - should not be empty for productive servers ?define('HTTPS_SERVER', ''); // eg, https://localhost - should not be empty for productive servers ?define('ENABLE_SSL', false); // secure webserver for checkout procedure? i know i change false to true, but what about the defines? with the setup ive got the SSL is before the public_html folder. does this matter? or do i just point both to www.mydomain.com and it will pick it all up automatically? <{POST_SNAPBACK}> http://www.mydomain.com and https://www.mydomain.com should do it for you. It doesn't matter where the SSL directory fysically is, as long as it is configured to work for the public_html directory it's fine. You already said the shop worked between non-ssl and sll mode and so your configuration is fine.
ONION Posted January 15, 2005 Author Posted January 15, 2005 http://www.mydomain.com and https://www.mydomain.com should do it for you. It doesn't matter where the SSL directory fysically is, as long as it is configured to work for the public_html directory it's fine. You already said the shop worked between non-ssl and sll mode and so your configuration is fine. <{POST_SNAPBACK}> any ideas how i fill all of this in??? <?php /* $Id: configure.php,v 1.14 2003/02/21 16:55:24 dgw_ Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ // define our webserver variables // FS = Filesystem (physical) // WS = Webserver (virtual) define('HTTP_SERVER', ''); // eg, http://localhost or - https://localhost should not be NULL for productive servers define('HTTP_CATALOG_SERVER', ''); define('HTTPS_CATALOG_SERVER', ''); define('ENABLE_SSL_CATALOG', 'true'); // 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', ''); define('DB_SERVER_USERNAME', 'mysql'); define('DB_SERVER_PASSWORD', ''); define('DB_DATABASE', 'osCommerce'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', ''); ?> everytime i change one of them to put www.vinyperfection.co.uk etc i get this errer : 1046 - No Database Selected select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP] i dont get what im doing wrong. this is how i filled it in : <?php/* $Id: configure.php,v 1.14 2003/02/21 16:55:24 dgw_ Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Released under the GNU General Public License*/ // define our webserver variables// FS = Filesystem (physical)// WS = Webserver (virtual) define('HTTP_SERVER', 'www.vinylperfection.co.uk'); // eg, http://localhost or - https://localhost should not be NULL for productive servers define('HTTP_CATALOG_SERVER', 'www.vinylperfection.co.uk'); define('HTTPS_CATALOG_SERVER', 'www.vinylperfection.co.uk'); define('ENABLE_SSL_CATALOG', 'true'); // 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', 'www.vinylperfection.co.uk'); define('DB_SERVER_USERNAME', 'mysql'); define('DB_SERVER_PASSWORD', ''); define('DB_DATABASE', 'osCommerce'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', '');?>[/ i have this same problem in both the config.php files :(i havent been able to find anywhere here which walks you through setting this bit up.
Guest Posted January 15, 2005 Posted January 15, 2005 you have no http:// in front of your www for you servers you should set store_sessions to mysql
ONION Posted January 15, 2005 Author Posted January 15, 2005 you have no http:// in front of your www for you servers you should set store_sessions to mysql <{POST_SNAPBACK}> ok ive done this : <?php /* $Id: configure.php,v 1.14 2003/02/21 16:55:24 dgw_ Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ // define our webserver variables // FS = Filesystem (physical) // WS = Webserver (virtual) define('HTTP_SERVER', 'http://www.vinylperfection.co.uk'); // eg, http://localhost or - https://localhost should not be NULL for productive servers define('HTTP_CATALOG_SERVER', 'http://www.vinylperfection.co.uk'); define('HTTPS_CATALOG_SERVER', 'https://www.vinylperfection.co.uk'); define('ENABLE_SSL_CATALOG', 'true'); // 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', 'vinylper_osc1'); define('DB_SERVER_USERNAME', 'vinylper_osc1'); define('DB_SERVER_PASSWORD', ''); define('DB_DATABASE', 'osCommerce'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', 'mysql'); ?> but now im getting this error : Warning: mysql_connect(): Unknown MySQL Server Host 'vinylper_osc1' (0) in /home/vinylper/public_html/catalog/includes/functions/database.php on line 19Unable to connect to database server! what should i be putting as the server host? the DB is vinylper_osc1 and url is www.vinylperfection.co.uk i dont know what else to try. ive tried it as http:// https:// and just www. <_<
ONION Posted January 15, 2005 Author Posted January 15, 2005 ok ive done this : <?php /* ?$Id: configure.php,v 1.14 2003/02/21 16:55:24 dgw_ Exp $ ?osCommerce, Open Source E-Commerce Solutions ?http://www.oscommerce.com ?Copyright (c) 2002 osCommerce ?Released under the GNU General Public License */ // define our webserver variables // FS = Filesystem (physical) // WS = Webserver (virtual) ?define('HTTP_SERVER', 'http://www.vinylperfection.co.uk'); // eg, http://localhost or - https://localhost should not be NULL for productive servers ?define('HTTP_CATALOG_SERVER', 'http://www.vinylperfection.co.uk'); ?define('HTTPS_CATALOG_SERVER', 'https://www.vinylperfection.co.uk'); ?define('ENABLE_SSL_CATALOG', 'true'); // 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', 'vinylper_osc1'); ?define('DB_SERVER_USERNAME', 'vinylper_osc1'); ?define('DB_SERVER_PASSWORD', ''); ?define('DB_DATABASE', 'osCommerce'); ?define('USE_PCONNECT', 'false'); ?define('STORE_SESSIONS', 'mysql'); ?> but now im getting this error : what should i be putting as the server host? the DB is vinylper_osc1 and url is www.vinylperfection.co.uk i dont know what else to try. ive tried it as http:// https:// and just www. <_< <{POST_SNAPBACK}> oh and if i put the server as just vinylperfection.co.uk i get this error : Warning: mysql_connect(): Access denied for user: '[email protected]' (Using password: NO) in /home/vinylper/public_html/catalog/includes/functions/database.php on line 19Unable to connect to database server! its the same error when i put the password in except it says password (yes)
wheeloftime Posted January 15, 2005 Posted January 15, 2005 oh and if i put the server as just vinylperfection.co.uk i get this error :its the same error when i put the password in except it says password (yes) <{POST_SNAPBACK}> Normally your DB_SERVER should be set to 'localhost' and the other information you should have been given by your provider (or you must have those at hand if you created all yourself, that's something no one can answer for you).
Guest Posted January 15, 2005 Posted January 15, 2005 this: define('DIR_WS_ADMIN', '/admin/'); should most likely be this: define('DIR_WS_ADMIN', '/catalog/admin/'); if this is a new install perhaps start it over
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.