Confiuration Problems

kevu · March 8, 2007

Hello,

After several issues, It says I have sucessfully installed the OS commerce database. NOw where fo I go from here to the configuration page? I have done the post installation also. When I type the following url it asks me for the protected pasword then getting the following message??

http://www.nadanspices.com/catalog/admin/

1046 - No Database Selected

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[TEP STOP]

Can someone help? Thanks!

davidinottawa · March 8, 2007

1046 - No Database Selected
select configuration_key as cfgKey, configuration_value as cfgValue from configuration

Check your database connection string paramters at the bottom of two files :

includes/configure.php

admin/includes/configure.php

Here's a useful link as well : http://www.oscommerce.com/forums/index.php?showtopic=193738

kevu · March 9, 2007

Check your database connection string paramters at the bottom of two files :
includes/configure.php

admin/includes/configure.php

Here's a useful link as well : http://www.oscommerce.com/forums/index.php?showtopic=193738

I made changes in the two PHP files as described in the topic=1937388. But still problem? Now I am getting a blank page after I typed the uid and pw.

Visit My Website

Also I am getting the same error > 1046 - No Database Selected at the following link.

Visit My Website

Question: Which link I need to use for my configuration (after installation) from the above? My files are locatated in /httpdocs/catalog/admin

I am still playing with it but if you can give me any hints would be appreciated. Thanks. Thomas

[email protected] · March 9, 2007

This config below worked perfect with Godaddy and their SSL.

My SSL was issued as www.lisahermannjewelry.com not lisahermannjewelry.com

cat/includes/config

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

define('HTTPS_SERVER', 'https://www.lisahermannjewelry.com'); // eg, https://localhost - should not be empty for productive servers

define('ENABLE_SSL', true); // secure webserver for checkout procedure?

define('HTTP_COOKIE_DOMAIN', '.lisahermannjewelry.com');

('HTTPS_COOKIE_DOMAIN', '.lisahermannjewelry.com');

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

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

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

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

You need to get permission from your properties area in the config to upload the changes sometimes

cat/admin/include/config

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

define('HTTP_CATALOG_SERVER', 'https://lisahermannjewelry.com');

define('HTTPS_CATALOG_SERVER', 'https://lisahermannjewelry.com');

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

kevu · March 9, 2007

Hello,

Thanks for you help and I tried to do it but little confusion on some folderes. Please see the following files and can you let me know which line may be wrong. I am confused as different user's instructions are not the same. Also, what permission do I need to have it on the two PHP files (744, 755 or 777)?

My directory where all the files are > httpdocs/catalog/..........

1. The following is what I have in my Admin/includes.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

Released under the GNU General Public License

*/

// define our webserver variables

// FS = Filesystem (physical)

// WS = Webserver (virtual)

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

define('HTTP_CATALOG_SERVER', 'http://www.nadanspices.com');

define('HTTPS_CATALOG_SERVER', 'https://www.nadanspices.com');

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

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

define('DIR_FS_ADMIN', '/httpdocs/catalog/admin/');

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

define('DIR_FS_CATALOG', '/httpdocs/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', '******');

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

define('DB_DATABASE', 'mydbname');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

?>

2. includes/configure.php

<?php

/*

$Id: configure.php,v 1.14 2003/07/09 01:15:48 hpdl 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.nadanspices.com'); // eg, http://localhost - should not be empty for productive servers

define('HTTPS_SERVER', 'https://www.nadanspices.com'); // eg, https://localhost - should not be empty for productive servers

define('ENABLE_SSL', false); // secure webserver for checkout procedure?

define('HTTP_COOKIE_DOMAIN', 'www.nadanspices.com');

define('HTTPS_COOKIE_DOMAIN', 'www.nadanspices.com');

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

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

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

define('DIR_WS_HTTPS_CATALOG', '/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', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/');

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', '('*****');

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

define('DB_DATABASE', 'mydbname');

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

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

?>

Once this setup done correctly, what URL I go to setup mystore configuration etc.?

YOur help is greatly appreciated. Thanks!

♥Vger · March 9, 2007

Well, the first thing is that you don't have a full ssl certificate, only a shared ssl certificate from globat.com. So for now disable ssl until you know how to set your site up to use their shared ssl.

includes/configure.php

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

define('HTTP_SERVER', 'http://www.nadanspices.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.nadanspices.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', '');

the line below needs to be your actual pathway e.g. '/var/www/html/' - ask your hosts if you don't know what it is - we can't tell you

define('DIR_FS_CATALOG', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/');

admin/includes/configure.php

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

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

define('HTTP_CATALOG_SERVER', 'http://www.nadanspices.com');

define('HTTPS_CATALOG_SERVER', '');

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

define('DIR_FS_DOCUMENT_ROOT', /httpdocs/); // this line is probably wrong - see DIR_FS_CATALOG above

define('DIR_WS_ADMIN', '/catalog/admin/');

define('DIR_FS_ADMIN', '/httpdocs/catalog/admin/'); also probably wrong - see DIR_FS_CATALOG above

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

define('DIR_FS_CATALOG', '/httpdocs/catalog/'); also probably wrong - see DIR_FS_CATALOG above

Vger

kevu · March 9, 2007

Hello Vger,

Thanks for your quick response. .

Globat.com commandconsole Current Directory(pathway):root/httpdocs/ where the /httpdocs/ contains all my html and index files (including my homepage) for my current website so as the catalog folder for oscommerce. The SSL shared part is HTTPSDOCS.

Anyhow, I have made the changes in the 2 php files according to that and now I am getting the "no database selected error" again! though I have my database connection defined in the 2 PHP files. Following are the two links I used then got the DB error.

> http://www.nadanspices.com/catalog/admin/

http://www.nadanspices.com/catalog/

1046 - No Database Selected

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[TEP STOP]

So If the Globat.com commandconsole Current Directory(pathway):root/httpdocs/, is the following setup correct?

The following are the current includes/configure.php

define('HTTP_SERVER', 'http://www.nadanspices.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.nadanspices.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', '');

admin/includes/configure.php file

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

define('HTTP_CATALOG_SERVER', 'http://www.nadanspices.com/catalog');

define('HTTPS_CATALOG_SERVER', '');

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

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

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

define('DIR_FS_CATALOG', '/httpdocs/catalog/');

Your help is greatly appreciated. I am totally lost. Thanks again. Thomas!

istyfu · April 3, 2007

Please from the start! What do I need to do when I get this error:

1046 - No database selected

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[TEP STOP]

Please help me! Thank you!

davidinottawa · April 3, 2007

Please from the start! What do I need to do when I get this error:

1046 - No database selected

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[TEP STOP]

Please help me! Thank you!

Check your database connection string paramters at the bottom of two files :

includes/configure.php

admin/includes/configure.php

Confiuration Problems

Recommended Posts

kevu

davidinottawa

kevu

[email protected]

kevu

♥Vger

kevu

istyfu

davidinottawa

Archived

Browse

Activity