Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SSL error


dstegall

Recommended Posts

I obtained an SSL certificate from my hosting provider and it was automatically installed for me. I changed the config files in admin and catalog both. When I go to www.mysite.com/catalog I get the following error.

 

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

Unable to connect to database server!

 

I opened database.php and am at a loss. Any help would be greatly appreciated.

 

Faithfully,

 

Dawn

Link to comment
Share on other sites

Hi Dawn,

I may be off base here so be sure to backup files. If I'm not mistaken the above error is the tep_db_connect function. There probably is nothing wrong with that. I would recheck your config files. Make sure the db server, username, password, and db are in there correctly. Those are what are passed to the above function.

Hope that helps.

Link to comment
Share on other sites

Ok, I fixed that and then I had problems with images not showing up. I found a solution here on the forum that fixed it somewhat, but it still doesn't look right.

 

https://www.faithfullyyours.net/catalog

 

Plus more errors...

 

downloads as seen at top

when I clicked on one of the categories I got an error

 

I was hoping to launch on Friday. :(

 

Thanks for any help!

 

Faithfully,

 

Dawn

Link to comment
Share on other sites

Hi Dawn,

I think the problem is still in your config file. Can you post the one for your catalog minus the db info. Also are you offering downloadable products? From the error I'm guessing you have not created that directory. It may also be something typed wrong in the config. Lets the catalog side first then we will get admin if you have probs there too.

Link to comment
Share on other sites

Thank you.

 

// Define the webserver and path parameters

// * DIR_FS_* = Filesystem directories (local/physical)

// * DIR_WS_* = Webserver directories (virtual/URL)

define('HTTP_SERVER', 'http://www.faithfullyyours.net');// eg, http://localhost - should not be empty for productive servers

define('HTTPS_SERVER', 'https://www.faithfullyyours.net'); // eg, https://localhost - should not be empty for productive servers

define('ENABLE_SSL', true); // secure webserver for checkout procedure?

define('HTTP_COOKIE_DOMAIN', 'www.faithfullyyours.net');

define('HTTPS_COOKIE_DOMAIN', 'faithfullyyours.net');

define('HTTP_COOKIE_PATH', '/catalog');

define('HTTPS_COOKIE_PATH', '/catalog');

define('DIR_WS_HTTP_CATALOG', '/catalog');

define('DIR_WS_HTTPS_CATALOG', '/catalog');

define('DIR_WS_IMAGES', 'https://www.faithfullyyours.net/catalog/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', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/');

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

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

Link to comment
Share on other sites

Okay, a big mistake was made when the full SSL Cert was purchased - it is made out to www.FAITHFULLYYOURS.NET and not to www.faithfullyyours.net

 

You'll need to get your hosts to get it reissued correctly.

 

Once that is done make the following changes:

 

define('HTTPS_COOKIE_DOMAIN', 'www.faithfullyyours.net');

define('HTTP_COOKIE_PATH', '/catalog/');

define('HTTPS_COOKIE_PATH', '/catalog/');

define('DIR_WS_HTTP_CATALOG', '/catalog/');

define('DIR_WS_HTTPS_CATALOG', '/catalog/');

define('DIR_WS_IMAGES', 'images/');

 

define('DIR_FS_CATALOG', 'full/path/to/root/'); // e.g. /var/www/html/catalog/

 

Vger

Link to comment
Share on other sites

Lets try this

 

// Define the webserver and path parameters

// * DIR_FS_* = Filesystem directories (local/physical)

// * DIR_WS_* = Webserver directories (virtual/URL)

define('HTTP_SERVER', 'http://www.faithfullyyours.net');// eg, http://localhost - should not be empty for productive servers

define('HTTPS_SERVER', 'https://www.faithfullyyours.net'); // eg, https://localhost - should not be empty for productive servers

define('ENABLE_SSL', true); // secure webserver for checkout procedure?

define('HTTP_COOKIE_DOMAIN', 'www.faithfullyyours.net');

define('HTTPS_COOKIE_DOMAIN', 'faithfullyyours.net');

define('HTTP_COOKIE_PATH', '/catalog/');

define('HTTPS_COOKIE_PATH', '/catalog/');

define('DIR_WS_HTTP_CATALOG', '/catalog/');

define('DIR_WS_HTTPS_CATALOG', '/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', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/');

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

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

Link to comment
Share on other sites

Try this link:

 

https://faithfullyyours.net/catalog/

 

(No "www").

 

It looked like the real thing to me.

;)

 

Maybe this:

 

define('HTTPS_SERVER', 'https://www.faithfullyyours.net'); // eg, https://localhost - should not be empty for productive servers

 

Needs to be:

 

define('HTTPS_SERVER', 'https://faithfullyyours.net'); // eg, https://localhost - should not be empty for productive servers

:unsure:

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

The SSL Cert is made out to www.FAITHFULLYYOURS.NET - and it's not made out to faithfullyyours.net - so the www. must be observed.

 

The SSL Cert must also be replaced with one issued to www.faithfullyyours.net and not to www.FAITHFULLYYOURS.NET

 

Vger

Link to comment
Share on other sites

Y y M.

 

I I h n t y p i t t, I w h b.

 

A t p.

 

I a s a m.

 

W y e f m?

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 just got off the phone with my hosting provider and he said it isn't case sensitive. He checked everything out and seems to be secure. I changed the download and that error is gone. What is wrong is the horizontal header menu had a background to it. Plus the breadcrumb line/My Account/Cart Contents/Checkout had a purple background. And the category/information/etc boxes had purple borders.

 

Thanks for your help!

 

Faithfully,

 

Dawn

Link to comment
Share on other sites

Ok, but I don't really understand

 

define('DIR_FS_CATALOG', 'full/path/to/root/'); // e.g. /var/www/html/catalog/

 

Where do I find this path?

 

Sorry to be such a pain. :(

Link to comment
Share on other sites

For now make all of the corrections accept for the

 

define('DIR_FS_CATALOG', 'full/path/to/root/'); // e.g. /var/www/html/catalog/

 

For now leave that as

 

define('DIR_FS_CATALOG', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/');

 

Lets see what happens with that

Link to comment
Share on other sites

The easiest way to see your path is by going to your admin then tools then file manager. Right under where it says File Manager you should see your full path.

BTW

You are not being a pain at all. Just someone who needs help.

Link to comment
Share on other sites

Ok, the site looks right again. But I have the following error at the top:

 

Warning Warning: The downloadable products directory does not exist: DIR_FS_DOWNLOAD. Downloadable products will not work until this directory is valid.

 

Here is what I have:

define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');

define('DIR_FS_CATALOG', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/');

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

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

 

And when I go to admin I have the following error:

 

Error: Catalog images directory does not exist: /home/dstegall/public_html/catalog/images/

 

Which I'm thinking is the path I need for above. Also when I click on tools, I get a page not found error.

 

Thanks for getting me this far. I'm praying I can launch tomorrow.

 

Faithfully,

 

Dawn

Link to comment
Share on other sites

Hi Dawn,

There is a config file in admin/includes. You need to make sure you have the right settings in there.

Can you make sure the downloads and pub directories are there? Can you also check to see if you have a local dir inside of the catalog/includes? Sometimes there is a config file in there.The reson I ask about that one is because I don't know why your error message showing cgi-bin/download. It should be download.

Link to comment
Share on other sites

To find out the path to the root of your web you can ask your hosting company - or do this:

 

Create a new text file on your desktop and rename it to cwd.php (ignore the warning about changing the file type).

 

Put this code in it:

<?php
$p = getcwd();
echo $p;
?>

 

Upload the file via FTP to your 'catalog' folder.

 

Go to this address in your browser: http://www.faithfullyyours.net/catalog/cwd.php - and printed out on the screen will be the DIR_FS pathway to your catalog folder. Write it down, and then delete the cwd.php file from the catalog folder (don't leave it there).

 

Vger

Link to comment
Share on other sites

On catalog side:

Warning: The downloadable products directory does not exist: /cgi-bin/download/. Downloadable products will not work until this directory is valid.

 

define('HTTP_SERVER', 'http://www.faithfullyyours.net'); // eg, http://localhost - should not be empty for productive servers

define('HTTPS_SERVER', 'https://www.faithfullyyours.net'); // eg, https://localhost - should not be empty for productive servers

define('ENABLE_SSL', true); // secure webserver for checkout procedure?

define('HTTP_COOKIE_DOMAIN', 'www.faithfullyyours.net');

define('HTTPS_COOKIE_DOMAIN', 'www.faithfullyyours.net');

define('HTTP_COOKIE_PATH', '');

define('HTTPS_COOKIE_PATH', '');

define('DIR_WS_HTTP_CATALOG', '/catalog/');

define('DIR_WS_HTTPS_CATALOG', '/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', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/');

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

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

 

On admin side:

Error: Catalog images directory does not exist: /catalog/images/

 

define('HTTP_SERVER', 'http://www.faithfullyyours.net'); // eg, http://localhost or - https://localhost should not be NULL for productive servers

define('HTTP_CATALOG_SERVER', 'https://www.faithfullyyours.net');

define('HTTPS_CATALOG_SERVER', 'https://www.faithfullyyours.net');

define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module

define('DIR_FS_DOCUMENT_ROOT', '/home/dstegall/public_html'); // 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', '/catalog/admin/');

define('DIR_FS_ADMIN', '/home/dstegall/public_html/catalog/admin/');

define('DIR_WS_CATALOG', '/catalog/');

define('DIR_FS_CATALOG', '/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/');

 

I did what Vger said, results:

 

/home/content/d/s/t/dstegall/html/catalog

 

Also, Brian, there is no config file in local and I don't see anything about downloads in the admin config file.

 

Thanks guys!

Link to comment
Share on other sites

First off I just want to say it srongly recomended to change the name of the admin folder and make those changes in your config files, but lets get this working first.

On the admin config

 

define('HTTP_CATALOG_SERVER', 'https://www.faithfullyyours.net');

 

Should be

 

define('HTTP_CATALOG_SERVER', 'http://www.faithfullyyours.net');

 

Now this I'm not sure about so write these down. where you see

 

'/home/dstegall/public_html

 

Replace with

 

/home/content/d/s/t/dstegall/html/

 

If Vger suggests differently, please follower her lead.

 

On the catalog config I believe the cookie paths should be /catalog/

Link to comment
Share on other sites

The download problem has been solved but I still have problems with switching to ssl pages. The source code show the base href as http not https. If I chose not to show the nonsecure items, all that shows is the text. Nothing from the stylesheet no buttons or pictures.

 

Can someone please see if I need to change something in my con fig file or is there another problem? Thank you!

 

 

 

define('HTTP_SERVER', 'http://www.faithfullyyours.net'); // eg, http://localhost - should not be empty for productive servers

define('HTTPS_SERVER', 'https://www.faithfullyyours.net'); // eg, https://localhost - should not be empty for productive servers

define('ENABLE_SSL', true); // secure webserver for checkout procedure?

define('HTTP_COOKIE_DOMAIN','www.faithfullyyours.net');

define('HTTPS_COOKIE_DOMAIN','www.faithfullyyours.net');

define('HTTP_COOKIE_PATH', '/catalog/');

define('HTTPS_COOKIE_PATH', '/catalog/');

define('DIR_WS_HTTP_CATALOG', '/catalog/');

define('DIR_WS_HTTPS_CATALOG', '/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', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) .'/');

define('DIR_FS_CATALOG',$DOCUMENT_ROOT.'/catalog/');

define('DIR_FS_DOCUMENT_ROOT','/home/dstegall/public_html/faithfullyyours.net/');

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

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

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...