Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Catalog works but Administration not


Lycon

Recommended Posts

i just installed osCommerce and i got a error about Step 7 (like many others had).

 

but besides that the Catalog works but the Administration page doesnt work :(

 

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/sites/site165/web/catalog/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

So i went to database.php and line 19 looked like this

      $$link = mysql_connect($server, $username, $password);

i havent changed anything like entering my pass, but i have changed the configure file at admin/includes. Ive changed it because i read someone else doing it, although i dont see any of this at the install thingy :blink:

 

btw i have not touched any other file, only the files i talked about in this thread. So maybe im missing something, if so, plz tell me :D

 

below is the configure.php file at admin/includes.

Lines with *** are the ones ive edited (only at the bottom though). And i thought that "DB_DATABASE" is the name of the database, is it?

 

I think this is all the info i had to give, Could someone plz help me fix the administration page?

 

<?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

 

  Copyright ? 2002 osCommerce

 

  Released under the GNU General Public License

*/

 

// define our webserver variables

// FS = Filesystem (physical)

// WS = Webserver (virtual)

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

 

// define our database connection

  define('DB_SERVER', '***database host***');

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

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

  define('DB_DATABASE', '***entered DB name***');

  define('USE_PCONNECT', 'false');

  define('STORE_SESSIONS', '');

?>

Link to comment
Share on other sites

Everything seems ok - obviously, you may find that you have entered the info in wrong but that is producing the wrong error. Can you connect to mySql through phpmyadmin? Have you tried putting DB_SERVER as "localhost"?

 

Have you ever got onto the Admin page?

Link to comment
Share on other sites

define('HTTP_SERVER', 'http://www.yourdomain.com');

define('HTTP_CATALOG_SERVER', 'www.yourdomain.com');

define('STORE_SESSIONS', 'mysql');

define('DB_DATABASE', 'yourdomain_com_-_databasename');

define('DB_SERVER', 'localhost');

 

or

 

define('DB_SERVER', '127.0.0.1');

 

That should help you out.

 

Vger

Link to comment
Share on other sites

I was going to suggest those but my Admin configure does not have them details in and it works fine. Hmm...maybe I ought to go change that.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...