Test connection made to the database was NOT successful.

[proane]

System Config: Windows 2000 /w IIS, MySQL and PHP 4

 

I am on step 5 and 7 where the install is trying to make a test connection to my database and I keep getting this error:

 

osCommerce Configuration

 

A test connection made to the database was NOT successful.

 

The error message returned is:

 

Table 'catalog.configuration' doesn't exist

 

Please click on the Back button below to review your database server settings.

 

If you require help with your database server settings, please consult your hosting company.

 

What I dont understand is, during step 3 I was still able to create and import a database called 'catalog'. Now for some reason its not letting me connect to it anymore, originally i had created the database on:

 

Localhost, username, no password and database 'catalog'

 

Now when I am doing step 5 I have tried a plethora of different host names, localhost, the actual ip, the actual domain name, etc. and I still keep getting this error. When looking with Mysqlwinadmin at the "catalog" database, everything seems to be inside there, so why can't I seem to connect?

 

I have searched the forums far and wide for any help, yet cant seem to find anything. I've set up osCommerce on windows and linux boxes before with apache but never IIS. I am at this point completely frustrated with Windows and if it werent for the clients demands i would be on *nix /w Apache in a second. Please help me have a good weekend :(

[markchiu]

sorry...i can't remember correctly....but when I installed on step 5, I didn't change anything tho...still use the localhost....and others the same as the step 2 settings.......but you say you also tried localhost and it still didn't work???

 

which i mean

 

 

try the same setting from step 2 also for step 5, you should have no problem..if you can past the step 2 settings..... :?:

 

 

:oops: sorry...i can really help like these(I am still learning as well)...hope someone else can really helo you :wink:

[proane]

Yah, I tried doing the exact same settings as I put into step 2.. copied it line by line.

 

I use:

 

Database server: localhost

username: myusername

password: NONE

database name: catalog

persistent connection: on

session storage: files

 

(note, if i use the actual IP, i get an Access denied for user: '@%' to database 'catalog' and if i enter a password whilst using localhost as the IP, i get a similar error, but this isn't what im concerned with)

 

and..

 

A test connection made to the database was successful.

 

Please continue the installation process to execute the database import procedure.

 

It is important this procedure is not interrupted, otherwise the database may end up corrupt.

 

The file to import must be located and named at:

 

/install/oscommerce.sql

 

step 3:

 

New Installation

 

Database Import

 

The database import was successful!

 

I enter in all my proper data for step 4, and for step 5 I enter in the exact same information as in step 2, and still get the same problem:

 

Table 'catalog.configuration' doesn't exist

 

BTW, what is the correct Webserver Root Directory to put in when using a Windows box? e:my website ? or e://my website/ ?? How does osCommerce treat a space in there from windowS?

[markchiu]

i think should be like /folder/folder/......... etc from the webserver point of view...

 

i don't know your problem is just too weird for me :o ....if it happened in step 5, it should also be happened on step 2.......

 

oh..well..i only have the last idea...delete the catalog database...and create something else(a new datebase..like shopdata..well..it's your decision tho...)..because catalog might conflict the file name.......I guess...if it's not right..don't blame me..... :wink: :lol: :oops:

[proane]

Just tried it with another database 'oscommerce' and still the exact same problems.

 

Anyone else know what the heck is going on?

[amoun]

Are you sure you have the coorect permissions to access the files, they won;t be visible, ie the error you'll get is they don't exist

 

 

roger

[jpf]

BTW, what is the correct Webserver Root Directory to put in when using a Windows box? e:my website ? or e://my website/ ?? How does osCommerce treat a space in there from windowS?

 

If setup corerectly -

 

http://localhost/

(your locally installed web server - including IIS and Apache)

 

or

 

http://localhost/catalog/

(for default osC install)

[proane]

I had intially thought that this might be some sort of permissions problem, but I cant seem to find anything related to mysql that doesnt have the proper permissions for webusers.

 

On a side note, I cant seem to find any *.configuration files at all, and I dont know if this perhaps is the problem.

 

I also cant seem to login to mysql server from another computer remotely.. I dont know if this may have anything to do with it?

 

Any more takers?

[proane]

So nobody else is knowledgable on why MySQL will allow me to make a test connection to begin with and then not allow for anything to be made on the last step, step 5 & 7?

 

I could really use the help :roll:

[Guest]

Why not just install OSC manually? :? Upload the database and edit /catalog/includes/configure.php and admin/includes/configure.php and your problems will be solved.

[proane]

Hey Zaq,

 

I tried going through the old 'exchange project' windows manual configuration, edited the following:

 

define http server

define https server

define db server

" " " " " user name:

" " " " " user password:

 

in both catalog/admin/ and /catalog/. Yet to my dismay i had no luck at all, something is telling me its all windows fault (yes yes, i blame windows when something goes a wry, never myself.)

 

If anyone else knows anything about 1146 errors on IIS + php + mysql and what I can do to get it to look at the "catalog" not "catalog.configuration"?

[proane]

Just FYI, When i edited all the above files, and go to either the catalog/index.php or /catalog/admin/index.php I get this one error:

 

1146 - Table 'catalog.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

[Ajeh]

Is your MySQL database called: catalog or did you call it something else?

 

When you created your user name and password for it, did you connect that user name and password to your MySQL database?

 

The username and password are case sensitive, make sure they are written that way in your /includes/configure.php files.

[Guest]

Using phpmyadmin try the following:

DROP TABLE IF EXISTS configuration;

CREATE TABLE configuration (

configuration_id int NOT NULL auto_increment,

configuration_title varchar(64) NOT NULL,

configuration_key varchar(64) NOT NULL,

configuration_value varchar(255) NOT NULL,

configuration_description varchar(255) NOT NULL,

configuration_group_id int NOT NULL,

sort_order int(5) NULL,

last_modified datetime NULL,

date_added datetime NOT NULL,

use_function varchar(255) NULL,

set_function varchar(255) NULL,

PRIMARY KEY (configuration_id)

);

[Ajeh]

:onfire:

Using phpmyadmin try the following:

DROP TABLE IF EXISTS configuration;

CREATE TABLE configuration (

configuration_id int NOT NULL auto_increment,

configuration_title varchar(64) NOT NULL,

configuration_key varchar(64) NOT NULL,

configuration_value varchar(255) NOT NULL,

configuration_description varchar(255) NOT NULL,

configuration_group_id int NOT NULL,

sort_order int(5) NULL,

last_modified datetime NULL,

date_added datetime NOT NULL,

use_function varchar(255) NULL,

set_function varchar(255) NULL,

PRIMARY KEY (configuration_id)

);

 

:onfire:

WARNING: Do not run that command without a backup!

 

Never suggest such a drastic modificaition to a MySQL database without a backup warning ... some folks see that and just go with it and you end up costing them hours of time to rebuild their shop.

 

Rule of thumb ... backup, backup, backup!!! Then do dangerous things ... 8)

[Guest]

Yes by all means backup!

But it seems this case is a failure of a fresh install.

Maybe he should redownload and try again??

[Ajeh]

Yes by all means backup!

But it seems this case is a failure of a fresh install.

Maybe he should redownload and try again??

 

I kind of lean towards that myself. It would be cleaner. You can assure all files got uploaded to the site properly and drop the whole MySQL database if there was nothing important in there and load a fresh oscommerce.sql

[proane]

When you created your user name and password for it, did you connect that user name and password to your MySQL database?

 

Well, when I am using the user name and password that exists in my.ini, in this case a test/test user/password. Am I completely skipping over an important part here or something? I dont remember ever having to do any password linking in previous installs, but perhaps im just dazed and confused.

 

--Patrick

[proane]

Hey guys,

 

I have tried a fresh install with both the regular release of osCommerce, and even the *EDIT* in hopes that I would have had some fluke luck.

 

My results? Nothing, same old error. Still giving me the error that it cant find table catalog.config. I gotta take a break from this computer stuff but when I get back I think that I am going to try that "phpadmin" solution that fl70 had suggested to me. I have to take a break for now, but I'll tell you guys what the results are.

 

Thanks for all the help and support here.

 

--Patrick

 

 

*EDIT* - Johnson

[Ajeh]

Hey guys,

 

I have tried a fresh install with both the regular release of osCommerce, and even the *EDIT* in hopes that I would have had some fluke luck.

 

My results? Nothing, same old error. Still giving me the error that it cant find table catalog.config. I gotta take a break from this computer stuff but when I get back I think that I am going to try that "phpadmin" solution that fl70 had suggested to me. I have to take a break for now, but I'll tell you guys what the results are.

 

Thanks for all the help and support here.

 

--Patrick

 

 

*EDIT* - Johnson

 

At the bottom of both the /includes/configure.php are the following:

// define our database connection

 define('DB_SERVER', ''); // eg, localhost - should not be empty for productive servers

 define('DB_SERVER_USERNAME', '');

 define('DB_SERVER_PASSWORD', '');

 define('DB_DATABASE', 'osCommerce');

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

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

 

Did you fill this out with your information on your MySQL file?

 

Example:

// define our database connection

 define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

 define('DB_SERVER_USERNAME', 'fred');

 define('DB_SERVER_PASSWORD', 'letmein');

 define('DB_DATABASE', 'my_database_name');

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

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