Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Catalog works but Administration not


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?




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


  osCommerce, Open Source E-Commerce Solutions



  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_WS_CATALOG', '/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');




define('DB_SERVER', '');


That should help you out.



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


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

  • Create New...