Admin interface

[Guest]

Please advice, I installed the OS commerce software on my hosting server but cannot get to the admin interface to post my inventory or administer the available modules. http://mywebsite.com/admin/index.php I get an error

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

[Guest]

I cannot access the admin section of the OScommerce, please note that I deleted the directory during installation.

Awaiting your advice.

 

Thanks

[241]

First did you create the database.

 

Can you access the catalog

 

is the database information correct in both of your configure.php files

[helifan]

As a newbee am experiencing exactly same problem as RAKUMMA

 

Site was successfully tested on my LOCALHOST before uploading to the remote server.

 

In my case database is installed and CHMOD are set according to instructions.

 

I also have a "secondary" problem:

 

www.mydummydomain/catalog/index.php is displaying "OK" allthough displays a warning on top of screen:

 

Warning: The downloadable products directory does not exist: DIR_FS_DOWNLOAD. Downloadable products will not work until this directory is valid.

 

Then clicking on any link on the main page returns error " PAGE NOT FOUND"

the adress in the command bar looks like:

http://www.mydomain.comdir_ws_http_catalogindex.php/?cPath=1&osCsid=c25dc2d0b9ce2a935b18d664483d5c0b

 

Testing on my LOCALHOST gives, for the same adress link

 

http://localhost/catalog/index.php?cPath=1...6d6464a376f9000

 

I can see where the difference is but cannot find the string "dir_ws_http_catalogindex.php" in any files.

 

my catalog/configure.php file is

 

<?php

/*

  osCommerce, Open Source E-Commerce Solutions

  http://www.oscommerce.com

 

  Copyright © 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://www.mydummydomain.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', 'www.mydummydomain.com');

  define('HTTPS_COOKIE_DOMAIN', '');

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

  define('HTTPS_COOKIE_PATH', '');

  define('DIR_WS_HTTP_CATALOG', '/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', '/home/.sites/123/site171/web/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', 'mydummyusername');

  define('DB_SERVER_PASSWORD', 'mydumypassword');

  define('DB_DATABASE', 'mydummydatabase');

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

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

//  /home/.sites/123/site171/web/catalog/

?>

 

admin/includes/configure.php

 

<?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', 'HTTP://www.mydummydomain.com'); // eg, http://localhost or - https://localhost should not be NULL for productive servers

  define('HTTP_CATALOG_SERVER', 'HTTP://www.mydummydomain.com');

  define('HTTPS_CATALOG_SERVER', '');

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

  define('DIR_FS_DOCUMENT_ROOT', '/home/.sites/123/site171/web/catalog/'); // 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', '/catalog/admin/');

  define('DIR_FS_ADMIN', '/home/.sites/123/site171/web/catalog/admin/');

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

  define('DIR_FS_CATALOG', '/home/.sites/123/site171/web/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', 'localhost');

  define('DB_SERVER_USERNAME', 'myusername');

  define('DB_SERVER_PASSWORD', 'mypassword');

  define('DB_DATABASE', 'mydatabase');

  define('USE_PCONNECT', 'true');

  define('STORE_SESSIONS', 'mysql');

// moved to application_top.php

//  require(DIR_WS_INCLUDES . 'configure_added.php');

?>

 

Sorry being so long!

Thanks a lot