Do Customers have to log in twice?

[philip56]

Hi.

 

On my site, if a customer logs in, buys and then proceeds to checkout, they have to log in again. (Trolley contents are preserved) If they browse with out logging in, decide to buy, proceed to checkout, they are of course prompted to log in. When they are in they are told their trolley is empty!!. If they then log out, their trolley contents reappear!

 

Can anyone please shed some light on this bizarre situation?

 

Thanks in anticipation.

 

Philip

[Jack_mcs]

It sounds like a sessions ID problem. Go to admin->configuration->sessions and disable everything except Prevent Spirder Sessions. If that doesn't fix it, post your configure file here, minue sensitive data.

 

Jack

[philip56]

It sounds like a sessions ID problem. Go to admin->configuration->sessions and disable everything except Prevent Spirder Sessions. If that doesn't fix it, post your configure file here, minue sensitive data.

 

Jack

 

 

Thanks Jack

 

That partially solved it. Customers still have to log in twice but at least the contentys of the guest trolley is preserved. (Although the trolley contents box indicates it is empty until login is complete). I forgot to mention earlier that with the shared SSL active, the images in admin cataloge do not show.

 

admin/includes/configure.php follows.

 

Thanks again for your help

 

Philip

 

// Define the webserver and path parameters

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

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

define('HTTP_SERVER', 'https://server8.pcs-net.com/mysite'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://mysite);

define('HTTPS_CATALOG_SERVER', 'https://server8.pcs-net.com/mysite');

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

define('DIR_FS_DOCUMENT_ROOT', '/var/www/html/oscommerce/'); // where the pages are located on the server

define('DIR_WS_ADMIN', '/oscommerce/foldername/'); // absolute path required

define('DIR_FS_ADMIN', '/var/www/html/oscommerce/foldername/'); // absolute pate required

define('DIR_WS_CATALOG', '/oscommerce/'); // absolute path required

define('DIR_FS_CATALOG', '/var/www/html/oscommerce/'); // absolute path required

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', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'username');

define('DB_SERVER_PASSWORD', 'password');

define('DB_DATABASE', 'databasename');

define('USE_PCONNECT', 'false'); // use persisstent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

[Jack_mcs]

Since the problem you are having is on the shop side (not admin), you need to post the configure for it.

 

Jack

[philip56]

Since the problem you are having is on the shop side (not admin), you need to post the configure for it.

 

Jack

 

 

Sorry, I meant to do that.

 

<?php

/*

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

// Define the webserver and path parameters

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

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

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

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

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

define('HTTP_COOKIE_DOMAIN', 'mysite');

define('HTTPS_COOKIE_DOMAIN', 'mysite');

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

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

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

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

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', '/var/www/html/oscommerce/');

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

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

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'username');

define('DB_SERVER_PASSWORD', 'password');

define('DB_DATABASE', 'database');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

 

Regards

 

Philip

[Jack_mcs]

Change these

define('HTTP_COOKIE_PATH', '/oscommerce');
define('HTTPS_COOKIE_PATH', '/oscommerce');

to these

define('HTTP_COOKIE_PATH', '/oscommerce/');
define('HTTPS_COOKIE_PATH', '/oscommerce/');

I assume where you have mysite, it is really something like mysite.com. If not, you will need to change that too.

 

Jack

[philip56]

Change these

define('HTTP_COOKIE_PATH', '/oscommerce');
define('HTTPS_COOKIE_PATH', '/oscommerce');

to these

define('HTTP_COOKIE_PATH', '/oscommerce/');
define('HTTPS_COOKIE_PATH', '/oscommerce/');

I assume where you have mysite, it is really something like mysite.com. If not, you will need to change that too.

 

Jack

 

 

Hi Jack

 

I tried that this evening and I'm afraid it made no difference. You are corrct about my address, its pjleisurewear.co.uk, so I assume that doesn't need a / after it.

 

Philip

[♥Vger]

It looks like your hosted on an Apache server using Red Hat Enterprise Linux. If this is the case then change this:

define('DB_SERVER', 'localhost');

to this:

define('DB_SERVER', '127.0.0.1');

 

Other than that I can find no prolem with your includes/configure.php file settings. But what may be happening is that you may have an alternative configure.php file in the includes/local/ folder. If you find one at that location then either rename or delete it - because it will override the includes/configure.php file.

 

Vger

[philip56]

It looks like your hosted on an Apache server using Red Hat Enterprise Linux. If this is the case then change this:

define('DB_SERVER', 'localhost');

to this:

define('DB_SERVER', '127.0.0.1');

 

Other than that I can find no prolem with your includes/configure.php file settings. But what may be happening is that you may have an alternative configure.php file in the includes/local/ folder. If you find one at that location then either rename or delete it - because it will override the includes/configure.php file.

 

Vger

 

Thanks Vger.

 

I tried your suggestion and got the following error:-

 

Warning: mysql_connect(): Host 'localhost.localdomain' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /var/www/html/oscommerce/includes/functions/database.php on line 19

Unable to connect to database server!

 

That puts me well out of my depth!!

 

The answer to your point about includes/local/configure.php, is yes, I have recently installed one so I can run the fancier invoice and packing slips contribution. If I rename it, the problem still persists. I include a listing though, just so you can hopefully check it for me.

 

*/

 

// Folder Definitions

define('DIR_FS_ADMIN', '/var/www/html/oscommerce/adminname/'); // absolute path required

define('EMAIL_INVOICE_DIR', 'email_invoice/');

define('INVOICE_TEMPLATE_DIR', 'templates/');

 

// Email Invoice File Definitions

define('FILENAME_EMAIL_INVOICE', 'email_invoice.php');

define('FILENAME_EMAIL_CACHE_FILE', 'temp_cache.php');

define('FILENAME_ORDERS_INVOICE', 'invoice.php');

 

?>

 

Many thanks for your advice once again

 

Philip

[philip56]

Thanks Vger.

 

I tried your suggestion and got the following error:-

 

Warning: mysql_connect(): Host 'localhost.localdomain' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /var/www/html/oscommerce/includes/functions/database.php on line 19

Unable to connect to database server!

 

That puts me well out of my depth!!

 

The answer to your point about includes/local/configure.php, is yes, I have recently installed one so I can run the fancier invoice and packing slips contribution. If I rename it, the problem still persists. I include a listing though, just so you can hopefully check it for me.

 

*/

 

// Folder Definitions

define('DIR_FS_ADMIN', '/var/www/html/oscommerce/adminname/'); // absolute path required

define('EMAIL_INVOICE_DIR', 'email_invoice/');

define('INVOICE_TEMPLATE_DIR', 'templates/');

 

// Email Invoice File Definitions

define('FILENAME_EMAIL_INVOICE', 'email_invoice.php');

define('FILENAME_EMAIL_CACHE_FILE', 'temp_cache.php');

define('FILENAME_ORDERS_INVOICE', 'invoice.php');

 

?>

 

Many thanks for your advice once again

 

Philip

 

One this I have forgotten to mention, is that between every page load when I am logged in as a customer, I get a "this page is displaying both secure and insecure items" warning which is a bit irritating. Is this significant or merely a browser warning.

 

Heres hoping

 

Philip

[♥Vger]

Warning: mysql_connect(): Host 'localhost.localdomain' is blocked because of many connection errors.

 

Actually, getting that error is an improvement. Now you need to move those extra settings from the includes/local/configure.php file to the correct includes/configure.php file for that add-on, and then delete or rename the includes/local/ configure.php file. That file is for development use only, and is not normally a full configure.php file.

 

Vger

[nordzok64]

Actually, getting that error is an improvement. Now you need to move those extra settings from the includes/local/configure.php file to the correct includes/configure.php file for that add-on, and then delete or rename the includes/local/ configure.php file. That file is for development use only, and is not normally a full configure.php file.

 

Vger

 

 

Help i have been following the post because is resembled a problem i was having , problem is now i deleted my includes/configure.php file (by accident) now i am getting this message------Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /hsphere/local/home/nordzok6/xtreme-grind.com/catalog/includes/functions/database.php on line 19

Unable to connect to database server!-------I'm not sure how i can get this file back.

[Jack_mcs]

Many times there will be a backup of the configure file in the includes directory. If it is not there, just download the oscommerce package and use the one from there. You will have to fill in the items specific to your shop, of course.

 

Jack

[philip56]

Actually, getting that error is an improvement. Now you need to move those extra settings from the includes/local/configure.php file to the correct includes/configure.php file for that add-on, and then delete or rename the includes/local/ configure.php file. That file is for development use only, and is not normally a full configure.php file.

 

Vger

 

Hi Vger

 

Sorry I have taken so long to reply to ypur last post, but this is the first chance I have had to look at your reply. I,m afraid I still got the same error as brfore.

 

The includes/configure.php file I tried was as follows.

 

/ Define the webserver and path parameters

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

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

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

define('HTTPS_SERVER', 'https://server8.pcs-net.com/pjleisurewear.co.uk'); // eg, https://localhost - should not be empty for productive servers

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

define('HTTP_COOKIE_DOMAIN', 'www.pjleisurewear.co.uk');

define('HTTPS_COOKIE_DOMAIN', 'www.pjleisurewear.co.uk');

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

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

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

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

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', '/var/www/html/oscommerce/');

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

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

 

// Folder Definitions

define('DIR_FS_ADMIN', '/var/www/html/oscommerce/garfield/'); // absolute path required

define('EMAIL_INVOICE_DIR', 'email_invoice/');

define('INVOICE_TEMPLATE_DIR', 'templates/');

 

// Email Invoice File Definitions

define('FILENAME_EMAIL_INVOICE', 'email_invoice.php');

define('FILENAME_EMAIL_CACHE_FILE', 'temp_cache.php');

define('FILENAME_ORDERS_INVOICE', 'invoice.php');

 

// define our database connection

define('DB_SERVER', '127.0.0.1'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'username');

define('DB_SERVER_PASSWORD', 'password');

define('DB_DATABASE', 'databasename');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

 

Any further advice would be gratefully received.

 

Philip

?>

[philip56]

I have spotted something I should have left out of that post and have amended the site!

 

Philip

[♥Vger]

define('HTTPS_COOKIE_DOMAIN', 'server8.pcs-net.com/pjleisurewear.co.uk');

 

Vger

[philip56]

define('HTTPS_COOKIE_DOMAIN', 'server8.pcs-net.com/pjleisurewear.co.uk');

 

 

Thanks for your help again Vger - still got the same error I'm afraid.

configure.php is now:-

 

*/

 

// Define the webserver and path parameters

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

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

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

define('HTTPS_SERVER', 'https://server8.pcs-net.com/pjleisurewear.co.uk'); // eg, https://localhost - should not be empty for productive servers

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

define('HTTP_COOKIE_DOMAIN', 'www.pjleisurewear.co.uk');

define('HTTPS_COOKIE_DOMAIN', 'server8.pcs-net.com/pjleisurewear.co.uk');

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

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

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

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

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', '/var/www/html/oscommerce/');

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

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

 

// Folder Definitions

define('DIR_FS_ADMIN', '/var/www/html/oscommerce/directory/'); // absolute path required

define('EMAIL_INVOICE_DIR', 'email_invoice/');

define('INVOICE_TEMPLATE_DIR', 'templates/');

 

// Email Invoice File Definitions

define('FILENAME_EMAIL_INVOICE', 'email_invoice.php');

define('FILENAME_EMAIL_CACHE_FILE', 'temp_cache.php');

define('FILENAME_ORDERS_INVOICE', 'invoice.php');

 

// define our database connection

define('DB_SERVER', '127.0.0.1'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'username');

define('DB_SERVER_PASSWORD', 'password');

define('DB_DATABASE', 'databasename');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

 

Have I got the structure of the define('DIR_FS_ADMIN' line (line 38) right?

 

Kind regards

 

Philip

[philip56]

Hi again

 

In addition to the question in my post above, should I look to make any changes in admin/includes/configure.php? (It's listed early on in this post.)

 

Regards

 

Philip

[philip56]

Hi.

 

You did it again Vger.

 

If I add the following

 

define('HTTPS_COOKIE_DOMAIN', 'server8.pcs-net.com/pjleisurewear.co.uk');

 

but don't change 'localhost', it works fine.

 

Thanks very much indeed.

 

One last quick query though.

 

When I am adding new items to the catalogue, I do not see it's image on the catalogue page. Not a major problem I admit, but it means that I have to go ito the site itself to check it uploaded OK. Any Idea why? Is it something to do with admin/configure.php/directory protection?

 

Many thanks again for yours ( and everyone on the forum) help

 

Kind regards

 

Philip