Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

How to install SSL on OSC: A Simple 1-2-3 Instruction

jpweber

By jpweber
in General Support

Recommended Posts

centtaco

centtaco

Posted
Posted

Ok I dont mean to repost but this might help some with my prob...

 

I just purchased a SSL from godaddy which is where I got my site hosted. They did all the transffering to a dedicated server i guess, but my site was still showing up http:// and I had to type in the "s" to make is https://. So I did your changes like this

 

define('HTTP_SERVER', 'http://www.99centtaco.com');

define('HTTPS_SERVER', 'http://www.99centtaco.com');

define('ENABLE_SSL', true);

define('HTTP_COOKIE_DOMAIN', '99centtaco.com');

define('HTTPS_COOKIE_DOMAIN', '99centtaco.com');

 

 

define('HTTPS_SERVER', 'http://www.99centtaco.com');

define('HTTPS_CATALOG_SERVER', 'http://www.99centtaco.com');

define('HTTPS_CATALOG_SERVER', 'http://www.99centtaco.com');

define('ENABLE_SSL_CATALOG', 'true');

 

I hope this is right. Well, when I went to use my ftp control I had some trouble copying the includes/configure.php.

It kept saying, cannot upload or some kind of error. So I deleted the original one and added the new one. Then I get this message on my site.

 

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/c/e/n/centtaco/html/includes/functions/database.php on line 19

Unable to connect to database server!

 

I called up godaddy and they said that I needed to change some things in my php file but they didn't tell me what i needed to change or where.

 

I also think i did another stupid thing. I thought I needed to redirect the database or something so i did an install again and that's what erased all my products. I am alittle upset because I'm going to have to redo all of it again.

 

After doing the reinstall my site was back up but without products. I tried your changes again and got the same error message as before. Godaddy says they did all the installations that was needed on their end I guess but I dont know what to do now. Can you please help?

Link to comment
Share on other sites
  • Replies 485
  • Created
  • Last Reply
BryceJr

BryceJr

Posted
Posted
I hope this is right. Well, when I went to use my ftp control I had some trouble copying the includes/configure.php.

It kept saying, cannot upload or some kind of error. So I deleted the original one and added the new one. Then I get this message on my site.

The reason you cannot overwrite your original configure.php file was because the permission is set to 444 or 400 via FTP or cpanel.

To overwrite your configure.php file:

1. Set the permission to the file from 444 to 644.

2. FTP your newly modified configure.php file to your site. This will overwrite your file in the server.

3. Set the permission back to 444 after you're done.

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/c/e/n/centtaco/html/includes/functions/database.php on line 19

Unable to connect to database server!

You don't have the correct information on your the database section of your configure.php files. Both configure.php file from /includes and admin/includes needs that portion to connect to the database.

 

The bottom portion looks like this:

// define our database connection

define('DB_SERVER', '');

define('DB_SERVER_USERNAME', '');

define('DB_SERVER_PASSWORD', '');

define('DB_DATABASE', '');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

 

Hint:

define('DB_SERVER', '');<-Log in to phpMyAdmin. You'll see something that looks like an IP address, ie 10.11.12.13

define('DB_SERVER_USERNAME', 'username');<-- This is the username you use to log in to phpMyAdmin

define('DB_SERVER_PASSWORD', 'password');<-- This is the password you use to log in to phpMyAdmin

define('DB_DATABASE', 'database_name');<-- This is the name of your database you created in phpMyAdmin/MYSQL

 

includes/configure.php

define('HTTP_SERVER', 'http://www.99centtaco.com');

define('HTTPS_SERVER', 'https://www.99centtaco.com');

define('ENABLE_SSL', 'true');

define('HTTP_COOKIE_DOMAIN', '.99centtaco.com');

define('HTTPS_COOKIE_DOMAIN', '.99centtaco.com');

 

admin/includes configure.php

define('HTTP_SERVER', 'https://www.99centtaco.com');

define('HTTP_CATALOG_SERVER', 'https://www.99centtaco.com');

define('HTTPS_CATALOG_SERVER', 'https://www.99centtaco.com');

define('ENABLE_SSL_CATALOG', 'true');

Link to comment
Share on other sites
centtaco

centtaco

Posted
Posted

OK that seemed to take care of the problem on this error message.

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/c/e/n/centtaco/html/includes/functions/database.php on line 19

Unable to connect to database server!

 

 

But now all my images in my site are gone?? Any clues?

 

My Includes/configure.php

 

define('HTTP_SERVER', 'http://www.99centtaco.com');

define('HTTPS_SERVER', 'http://www.99centtaco.com');

define('ENABLE_SSL', true);

define('HTTP_COOKIE_DOMAIN', 'www.99centtaco.com');

define('HTTPS_COOKIE_DOMAIN', 'www.99centtaco.com');

define('HTTP_COOKIE_PATH', '/~seaman/osc_13/Trinity.1634/');

define('HTTPS_COOKIE_PATH', '/~seaman/osc_13/Trinity.1634/');

define('DIR_WS_HTTP_CATALOG', '/~seaman/osc_13/Trinity.1634/');

define('DIR_WS_HTTPS_CATALOG', '/~seaman/osc_13/Trinity.1634/');

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', '/usr/home/seaman/public_html/osc_13/Trinity.1634/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

 

My admin/includes/configure.php

 

define('HTTP_SERVER', 'http://www.99centtaco.com');

define('HTTP_CATALOG_SERVER', 'http://www.99centtaco.com');

define('HTTPS_CATALOG_SERVER', 'http://www.99centtaco.com');

define('ENABLE_SSL_CATALOG', 'true');

define('DIR_FS_DOCUMENT_ROOT', '/usr/home/seaman/public_html/osc_13/Trinity.1634/');

define('DIR_WS_ADMIN', '/~seaman/osc_13/Trinity.1634/admin/');

define('DIR_FS_ADMIN', '/usr/home/seaman/public_html/osc_13/Trinity.1634/admin/');

define('DIR_WS_CATALOG', '/~seaman/osc_13/Trinity.1634/');

define('DIR_FS_CATALOG', '/usr/home/seaman/public_html/osc_13/Trinity.1634/');

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/');

Link to comment
Share on other sites
  • 2 weeks later...
Guest

Guest

Posted
Posted

an ssl will always have the http at the front, only part you choose is www.mysite.com or mysite.com and they get merged onto the cert. you have to adjust your configure.php properly. if your host does not have aliases setup (where people can get to your site with www or without the www) depends also. however when i set them up i always go with www.mysite.com

Link to comment
Share on other sites
acbatchelor

acbatchelor

Posted
Posted

ok, i bought ssl from godaddy and installed it. however, it is not working.

 

it says in firefox:

 

-------------------------------------------------------------

i am using an invalid certificate

 

The certificate is only valid for the following names:

*.bluehost.com , bluehost.com

 

(Error code: ssl_error_bad_cert_domain)

-------------------------------------------------------------

 

how can the certificate only be valid for bluehost.com when i installed it under my website name?

Link to comment
Share on other sites
germ

germ

Posted
Posted

osC doesn't give a dang who you bought it from or where it's installed.

 

It just uses what you tell it to use in your configure files.

 

I recently wrote a contribution to help with SSL implementation.

 

SSL Help

 

Support thread for SSL Help contribution

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
acbatchelor

acbatchelor

Posted
Posted
osC doesn't give a dang who you bought it from or where it's installed.

 

It just uses what you tell it to use in your configure files.

 

I recently wrote a contribution to help with SSL implementation.

 

SSL Help

 

Support thread for SSL Help contribution

 

i already read all that. i also tried the contribution but everything is fine. guess i will have to ask the host.

Link to comment
Share on other sites
Guest

Guest

Posted
Posted

Ok Now I am more confused than ever. I am seeing so many different ways to code the configure.php files that I rdeeally dont know what I need to do. I am using a shared SSL. Unfortunatley my host wont let me install a dedicated one. yes I will be looking for a new host soon. I guess this is what happens when you dont do your home work on hosts. So please let me know what I need to do to configure my files correctly. I have the domain url's https: for the shared SSL but need pointers on what i need to do to get the important pages of the catalog protected.

Pat

Link to comment
Share on other sites
  • 2 weeks later...
Daft Moniker

Daft Moniker

Posted
Posted

So I changed my two configure.php files in both catalogue and admin directories.

 

Now when I go to my main domain, it results with the following error:

 

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/p/s/h/xxxxxxxxxxxxx/html/includes/functions/database.php on line 19

Unable to connect to database server!

 

How do I fix this or is there something I didn't do correctly?

 

My SSL, hosting, and domain are all through GoDaddy.com - The SSL Cert is showing as active and live.

 

Yahoo IM: swg_rene@yahoo.com

 

UPDATE: I have replaced the changed configure.php files with my original, unaltered backup files and I still get this error.

 

Please help!

Link to comment
Share on other sites
Daft Moniker

Daft Moniker

Posted
Posted
So I changed my two configure.php files in both catalogue and admin directories.

 

Now when I go to my main domain, it results with the following error:

 

 

 

How do I fix this or is there something I didn't do correctly?

 

My SSL, hosting, and domain are all through GoDaddy.com - The SSL Cert is showing as active and live.

 

Yahoo IM: swg_rene@yahoo.com

 

UPDATE: I have replaced the changed configure.php files with my original, unaltered backup files and I still get this error.

 

Please help!

 

 

Okay,

 

So I've added in my db name, login, pass, etc for my config files. Now I am getting the following error:

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'xxxx@xx.xxx.xx'@'xx.xxx.xxx.xxx' (using password: YES) in /home/content/p/s/h/psheppard11/html/includes/functions/database.php on line 19

Unable to connect to database server!

 

If I remove my 'xxx@IPaddy' and just put in 'xxxxx' as my username it tells me:

 

1146 - Table 'xxxx.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

Please help :)

Link to comment
Share on other sites
  • 2 weeks later...
mycolumbus

mycolumbus

Posted
Posted

Hello,

 

I've followed the instructions exactly, and the SSL padlock shows, the https:// shows and customers have actually ordered with the new https secure pages. However, when I go to login as admin to my cart, I get the below:

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'mysql'@'localhost' (using password: NO) in /home/qye/public_html/shop/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

I'm sure this is a simple fix. Any ideas?

 

Thank you.

Link to comment
Share on other sites
  • 1 month later...
nealc

nealc

Posted
Posted

I don't know why your host would do such a thing? My site uses the same domain for the secure and unsecured areas. Visit My Website to see what I am talking about, you can go from the main index page to the my account area to see the difference.

I am currently just learning osCommerce and PHP, but am always willing to help out.

 

Have successfully installed the following: Discount Coupons, UPS shipping module, Ultimate SEO URL's, Easy Meta Tags for SEO 1.0, Google XML Sitemap SEO v1.3, HTML Editor for Email and Newsletters.

Link to comment
Share on other sites
BryceJr

BryceJr

Posted
Posted
I cannot seem to get my SSL working, My host as given me a domain for my SSL which is different from my normal domain

 

e.g:

 

Http://www.domain.co.uk

https://Domain.ssl-01.com/

 

do I need to transfer all the files which require SSL to the https://Domain.ssl-01.com/ domain?

If you have not purchased a dedicated ssl certificate in your domain and properly installed it, you'll be using your host's shared ssl. Until you acquire and install yours, you cannot use define('HTTPS_SERVER', 'https://www.domain.co.uk');

. You'll be using the configure below.

 

Includes/Configure.php:

define('HTTP_SERVER', 'http://www.domain.co.uk');

define('HTTPS_SERVER', 'https://Domain.ssl-01.com');

define('ENABLE_SSL', true);

define('HTTP_COOKIE_DOMAIN', '.www.yoursite.com');

define('HTTPS_COOKIE_DOMAIN', 'Domain.ssl-01.com');

 

When your site switch to SSL(secure pages), oscommerce automatically secures the necessary pages such as login, create account, checkout pages, etc.

Link to comment
Share on other sites
ecartz

♥ecartz

Posted
Posted
do I need to transfer all the files which require SSL to the https://Domain.ssl-01.com/ domain?
You would have to ask your host. Usually when they do shared SSL like this, they give you a directory under the shared SSL that is just an alias for your regular directory. In that case, it should just work (although you may have to monkey with includes/configure.php to get the links and such working).

 

If you do need to have files in two separate places, you can just upload all the files both places. Just make sure that you keep the versions in synch.

 

Oh, and Nealc, hosts do this because it is cheaper than a dedicated SSL. With dedicated SSL, someone has to pay to get a new certificate signed for every site. With shared, they all use the same certificate. That said, most hosts who offer shared will set up dedicated if you buy the certificate. Some hosts have the ability to sign certificates for you (without having to pay per site). In that case, it's almost as easy for them to set up a dedicated SSL. However, they have to pay extra for the ability to sign certificates.

Always back up before making changes.

Link to comment
Share on other sites
Montey

Montey

Posted
Posted
If you have not purchased a dedicated ssl certificate in your domain and properly installed it, you'll be using your host's shared ssl. Until you acquire and install yours, you cannot use define('HTTPS_SERVER', 'https://www.domain.co.uk');

. You'll be using the configure below.

 

Includes/Configure.php:

define('HTTP_SERVER', 'http://www.domain.co.uk');

define('HTTPS_SERVER', 'https://Domain.ssl-01.com');

define('ENABLE_SSL', true);

define('HTTP_COOKIE_DOMAIN', '.www.yoursite.com');

define('HTTPS_COOKIE_DOMAIN', 'Domain.ssl-01.com');

 

When your site switch to SSL(secure pages), oscommerce automatically secures the necessary pages such as login, create account, checkout pages, etc.

 

I did try this, but all I get is the ‘cannot display error page’

 

I thought purchasing the SSL Cert from my host would same me some time…lol

Link to comment
Share on other sites
Montey

Montey

Posted
Posted

Can anyone help, it’s sending me mad!

 

I've seen a few osc websites that have a https://secure.domain.co.uk so I think its possible to have the SSL in separate secure area?

 

Can I do this with symlink / system links?

 

Any help would be greatly appreciated

Link to comment
Share on other sites
BryceJr

BryceJr

Posted
Posted
Can anyone help, it’s sending me mad!

 

I've seen a few osc websites that have a https://secure.domain.co.uk so I think its possible to have the SSL in separate secure area?

 

Can I do this with symlink / system links?

 

Any help would be greatly appreciated

If your host set you up with the antiquated two folder system, you may want to read >>this and >>this.

 

If they can't help you with this without charging you, get your money back and find a new host.

Link to comment
Share on other sites
Montey

Montey

Posted
Posted

Hi Bryce, Thank you for your help

 

I have contacted my host they told me I need to create SymLink myself, as they I cannot do this! (The guy I spoke to didn't have a clue what a symlink was!)

 

I requested a refund for my Shared SSL they told it was not possible!

Link to comment
Share on other sites
webman2015

webman2015

Posted
Posted

Please help:

 

I set up the SSL certificate on my hosting account with no problem. I am using Verisign SSL. They checked my certificates and say there is no problem. But after making the changes to the configure.php file, all of my products are missing. The homepage shows up and the categories show up. But all products lead to a blank page.

 

My website is http://www.homelightingtoday.com

 

Now, I have been trying to fix this for two weeks. I opened a brand new hosting account and re-installed all my files and database because I had this problem two weeks ago. I uploaded the whole website and the database of 40,000 items. After a week of work, I installed the SSL certificate on the server again with no problem. Then I altered the configure.php by simply changing one little thing. I changed the ssl from "false" to "true". Suddenly, all my products are gone again.

 

Example: go to my home page, click on "bath lighting", then click on "contemporary" and with internet explorer, I get a blank white page.

 

Anybody know what went wrong here?

 

My configure.php is:

define('HTTP_SERVER', 'http://www.homelightingtoday.com');

define('HTTPS_SERVER', 'https://www.homelightingtoday.com');

define('ENABLE_SSL', true);

 

I have tried various ideas with the above settings from adding or removing the www and trying to reset my configure.php to its original settings. All with no results.

 

I just dont know what to do anymore.

 

this is my third time rebuilding the whole website because of this error.

 

I have spent days scouring the web for clues or related problems.

 

Any help would be greatly appreciated.

 

Troy

Link to comment
Share on other sites

Archived

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

Go to topic listing
×
×
  • Create New...