..........help seriously needed...............:'(

[moisea]

hello,

i am working on my site on localhost using osc ms2.2 and easyphp 1.8. however, when trying to loggon, to check out or to register, i get the following error.

connection was refused when attempting to contact localhost

can anyone please help me ? any ideas why it is happening?

many thanks.

[Sierrab]

hello,

i am working on my site on localhost using osc ms2.2 and easyphp 1.8. however, when trying to loggon, to check out or to register, i get the following error.

 

can anyone please help me ? any ideas why it is happening?

many thanks.

<{POST_SNAPBACK}>

 

Check ther db settings in both the configure.php files. I use an identical set-up to yours with no problem. Do you have the catalog in the www folder of the EasypHP folder?

 

Are you accessing through the right address in your browser?

127.0.0.1/catalog/ (for the catalog in the root folder?

 

Steve

[moisea]

Check ther db settings in both the configure.php files. I use an identical set-up to yours with no problem. Do you have the catalog in the www folder of the EasypHP folder?

 

Are you accessing through the right address in your browser?

127.0.0.1/catalog/ (for the catalog in the root folder?

 

Steve

<{POST_SNAPBACK}>

 

thanks steve,

i have done all of the above advice you given me

 

<?php
/*
 $Id: configure.php,v 1.14 2003/07/09 01:15:48 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 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://localhost'); // eg, http://localhost - should not be empty for productive servers
 define('HTTPS_SERVER', 'https://localhost'); // eg, https://localhost - should not be empty for productive servers
 define('ENABLE_SSL', true); // secure webserver for checkout procedure?
 define('HTTP_COOKIE_DOMAIN', 'localhost');
 define('HTTPS_COOKIE_DOMAIN', 'localhost');
 define('HTTP_COOKIE_PATH', '/mysite.com/catalog/');
 define('HTTPS_COOKIE_PATH', '/mysit.com/catalog/');
 define('DIR_WS_HTTP_CATALOG', '/mysite.com/catalog/');
 define('DIR_WS_HTTPS_CATALOG', '/mysite.com/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','c:/program files/easyphp1-8/www/mysite.com/catalog/');
 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', 'root');
 define('DB_SERVER_PASSWORD', '');
 define('DB_DATABASE', 'db_mydatabase');
 define('USE_PCONNECT', 'true'); // use persistent connections?
 define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>

 

still can't make it work. any help please?

thanks.

[♥Vger]

define('USE_PCONNECT', 'false');

 

Many servers are (rightly) set up to refuse Persistent Connections.

 

And as this is a local install you won't have a full SSL certificate, so make the following changes:

 

define('HTTPS_SERVER', '');

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

define('HTTP_COOKIE_DOMAIN', 'localhost');

define('HTTPS_COOKIE_DOMAIN', '');

define('HTTP_COOKIE_PATH', '/mysite.com/catalog/');

define('HTTPS_COOKIE_PATH', '');

define('DIR_WS_HTTP_CATALOG', '/mysite.com/catalog/');

define('DIR_WS_HTTPS_CATALOG', '');

 

Vger

[♥Vger]

PostScript

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

 

Unless you have set up EasyPHP to handle virtual domains then you also need to make these changes:

 

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

define('HTTPS_COOKIE_PATH', '');

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

define('DIR_WS_HTTPS_CATALOG', '');

 

Vger

[Guest]

If this is a Linux box you need to add an entry in /etc/hosts file for localhost if it's not already there. Just guessing that could cause problems since it wouldn't know how to resolve localhost.

 

127.0.0.1 localhost.localdomain localhost

 

Maybe you have database corruption and were using a different IP address before?

[♥Vger]

No, this is EasyPHP on a local install, so there should not be any need to modify any hosts file.

 

It's the configure.php files that are incorrectly set up.

 

Vger

[moisea]

No,  this is EasyPHP on a local install, so there should not be any need to modify any hosts file.

 

It's the configure.php files that are incorrectly set up.

 

Vger

<{POST_SNAPBACK}>

 

thanks guys,

 

i found it . i did this and i am not sure about anyway it works with this

define('HTTPS_SERVER', '[COLOR=red]http[/COLOR]://localhost'); // eg, https://localhost - should not be empty for productive servers

 

https changed to http.

however, in my admin side i deleted the default customer john doe i am getting this as error.

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1

select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id order by c.customers_lastname, c.customers_firstname limit -20, 20

[TEP STOP]

whats going on :-" not my day 2day.............

[moisea]

thanks guys,

 

i found it . i did this and i am not sure about anyway it works with this

define('HTTPS_SERVER', '[COLOR=red]http[/COLOR]://localhost'); // eg, https://localhost - should not be empty for productive servers

 

https changed to http.

however, in my admin side i deleted the default customer john doe i am getting this as error.

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1

select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id order by c.customers_lastname, c.customers_firstname limit -20, 20

[TEP STOP]

whats going on  :-"  not my day 2day.............

<{POST_SNAPBACK}>

 

 

sorry guys, the answer was simply change

 

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

 

to false.

good night.

[moisea]

thanks guys,

 

i found it . i did this and i am not sure about anyway it works with this

define('HTTPS_SERVER', '[COLOR=red]http[/COLOR]://localhost'); // eg, https://localhost - should not be empty for productive servers

 

https changed to http.

however, in my admin side i deleted the default customer john doe i am getting this as error.

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1

select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id order by c.customers_lastname, c.customers_firstname limit -20, 20

[TEP STOP]

whats going on  :-"  not my day 2day.............

<{POST_SNAPBACK}>

 

 

sorry guys, the answer was simply change

 

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

 

true to false. thx to fissiaux in oscfr

good night.