FFS driving me mad this .... pls help someone!

[khcreations]

Hi,still new'ish,do more reading than typing these days.

Trying to get a cart up + running for a friend.

 

Tested the site on my local host, cart works + admin area connects fine, but

on free hosting am using from www.freehostia.com for testing till all works ,

The cart works ok, but the "admin" area does not connect, so it connects to the store db but not the "admin area"

 

Meanwhile...

accessing

http://tbpop.freehostia.com/admin/

gives me the following message

 

Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/www/tbpop.freehostia.com/admin/includes/functions/database.php on line 17

Unable to connect to database server!

 

Ive been typing bits into yahoo, searching these forums, even read "Warning: mysql_connect(): Can't connect to local MySQL server through socket Solution" but am not able to follow :(

 

ive played around with my configure.php file in the admin/includes/ dir

but from reading abit, am getting convinced its the server not the configure.php which is the problem...

 

stressing + getting very wound up as this cart was meant to simple but am at a complete dead end right now with it :(

 

please someone with the knowledge drop me some help

 

thanks very much for your time people

Kev

[oschellas]

Can you post the database configuration from both configure files (without passwords)?

[Guest]

Hi,still new'ish,do more reading than typing these days.

Trying to get a cart up + running for a friend.

 

Tested the site on my local host, cart works + admin area connects fine, but

on free hosting am using from www.freehostia.com for testing till all works ,

The cart works ok, but the "admin" area does not connect, so it connects to the store db but not the "admin area"

 

Meanwhile...

accessing

http://tbpop.freehostia.com/admin/

gives me the following message

 

Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/www/tbpop.freehostia.com/admin/includes/functions/database.php on line 17

Unable to connect to database server!

 

Ive been typing bits into yahoo, searching these forums, even read "Warning: mysql_connect(): Can't connect to local MySQL server through socket Solution" but am not able to follow :(

 

ive played around with my configure.php file in the admin/includes/ dir

but from reading abit, am getting convinced its the server not the configure.php which is the problem...

 

stressing + getting very wound up as this cart was meant to simple but am at a complete dead end right now with it :(

 

please someone with the knowledge drop me some help

 

thanks very much for your time people

Kev

 

Do you have mysql command line access ?

Do you have :

localhost

set as your db server in your admin/includes/configure.php file ?

 

It makes no sense that you can connect to the store, but not the admin.

Are you trying to connect through https://

[khcreations]

Do you have mysql command line access ?

Do you have :

localhost

set as your db server in your admin/includes/configure.php file ?

 

It makes no sense that you can connect to the store, but not the admin.

Are you trying to connect through https://

 

Hi Thanks for replies so far people.

 

here is the /includes/configure.php

 

define('HTTP_SERVER', 'http://tbpop.freehostia.com/'); // 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?

define('HTTP_COOKIE_DOMAIN', 'tbpopart');

define('HTTPS_COOKIE_DOMAIN', '');

define('HTTP_COOKIE_PATH', '');

define('HTTPS_COOKIE_PATH', '');

define('DIR_WS_HTTP_CATALOG', '');

define('DIR_WS_HTTPS_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', 'http://tbpop.freehostia.com/');

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

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

 

// define our database connection

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

define('DB_SERVER_USERNAME', 'server_username');

define('DB_SERVER_PASSWORD', 'password');

define('DB_DATABASE', 'database');

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

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

 

 

and here is the /admin/includes/configure.php

 

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

define('HTTP_CATALOG_SERVER', 'http://tbpop.freehostia.com/');

define('HTTPS_CATALOG_SERVER', '');

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

define('DIR_FS_DOCUMENT_ROOT', 'tbpop.freehostia.com/'); // where the pages are located on the server

define('DIR_WS_ADMIN', '/tony booth/catalog/admin/'); // absolute path required

define('DIR_FS_ADMIN', 'tbpop.freehostia.com/admin/'); // absolute pate required

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

define('DIR_FS_CATALOG', ''); // 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', 'mysql3.freehostia.com'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'server_username');

define('DB_SERVER_PASSWORD', 'password');

define('DB_DATABASE', 'database');

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

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

 

Will be checking later, hopefully its something very simple,

 

Thanks People

[khcreations]

i have no idea, AT ALL!!!! but its now working

am totally confused... :s

 

now i must:

 

setup SSL for the admin, customer login

 

+ setup the paypal account.

 

Thanks 4 reading

Kev

[Guest]

i have no idea, AT ALL!!!! but its now working

am totally confused... :s

 

now i must:

 

setup SSL for the admin, customer login

 

+ setup the paypal account.

 

don't forget to protect your admin area :

 

Downlaod the .htaccess file under the admin directory.

Open the file to see where the .htpasswd file is kept - then go download it.

Generate a new set of credentials using this : http://home.flash.net/cgi-bin/pw.pl

and dump the output into the .htpasswd file

then re-uplaod the .htpasswd file.

 

Or, your control panel with your host should be able to provide a 'Password Protected Directory' link