Admin page issue

MelissaG · October 2, 2005

Hello helpful folks out there, Im having an issue and Im sure I have taken care of this once and unsure as to what is going on, but no I dont remember how to fix this error:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /hsphere/local/home/cienega/cienegacreek.com/catalog/admin/includes/functions/database.php on line 19

Unable to connect to database server!

Here is the coding in my database and I think Im suppose to add something or change something on line 19

??????? help please

Melissa

♥Vger · October 3, 2005

It's more likely a problem with your admin/includes/configure.php file

Post it here, minus the database user name and password.

Vger

flex5150 · October 4, 2005

I have a similar issue, after installing some contribs I seem to have altered my configure.php file in admin/includes if you have any fix its that would be excellent. here is my configure.php

It is the same error as in the first post and I think it was because I used a backup and not an updated file

Thanks!!

<?php

/*

$Id: configure.php,v 1.14 2003/02/21 16:55:24 dgw_ Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

// define our webserver variables

// FS = Filesystem (physical)

// WS = Webserver (virtual)

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

define('HTTP_CATALOG_SERVER', '');

define('HTTPS_CATALOG_SERVER', '');

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

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // 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', '/admin/');

define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN);

define('DIR_WS_CATALOG', '');

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

// osplayer lite start

define('DIR_FS_CATALOG_MP3', DIR_FS_CATALOG . 'data/mp3/');

// osplayer lite end

// define our database connection

define('DB_SERVER', 'mysql53.secureserver.net');

define('DB_SERVER_USERNAME', '************');

define('DB_SERVER_PASSWORD', '*****');

define('DB_DATABASE', 'mxmusicstore');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', '');

?>

MelissaG · October 4, 2005

It's more likely a problem with your admin/includes/configure.php file

Post it here, minus the database user name and password.

Vger

OK I made a few adjustments to admin/includes/configure.php, so this is what it looks like now:

<?php

/*

$Id: configure.php,v 1.14 2003/02/21 16:55:24 dgw_ Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

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://www.cienegacreek.com'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', '');

define('HTTPS_CATALOG_SERVER', '');

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

define('DIR_FS_DOCUMENT_ROOT', ''); // where the pages are located on the server

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

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

define('DB_SERVER_USERNAME', '**********');

define('DB_SERVER_PASSWORD', '*****');

define('DB_DATABASE', 'cienega_countrystore');

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

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

?>

after the first refresh it asked me to log in so I do and this is what happened, I refresh again and it does not ask me to log in anymore, I just get this error:

Not Found

The requested URL /admin/login.php was not found on this server.

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

Apache/1.3.31 Server at cienegacreek.com Port 80

thanks

Melissa

MelissaG · October 4, 2005

then I check the url and it says http://www.cienegacreek.com/admin/login.php

so I type in the correct one http://www.cienegacreek.com/catalog/admin

It then asks me to login again and I get this error:

1046 - No Database Selected

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[TEP STOP]

Any ideas?

thanks

Melissa

dwepplo · October 4, 2005

Hi,

I'm sorry I can't offer any solutions - only more admin page problems. The storefront seems to work fine, but when I try and open the admin page I get the following error message:

Fatal error: Cannot re-assign $this in c:\wamp\www\catalog\admin\includes\classes\upload.php on line 31

Thank you for any help.

Dan

Admin page issue

Recommended Posts

MelissaG

♥Vger

flex5150

MelissaG

MelissaG

dwepplo

Archived

Browse

Activity