Database import on new install

[Guest]

Ok, I'm trying to setup a fresh clean install of osCommerce and am having problems connecting to the database on install.

 

Server specs:

Plesk 7.1.x CP

Latest release of PHP, MySQL etc.

RedHat 3ES.

 

Setup, uploaded and set file permissions per docs, created in the cp the database, and added a database user.

 

Went to my /catalogue/install and started the process, on step 2, enter in my domain, user id, password, and database, choose persistant connection and store session files in db. click next, get:

 

A test connection made to the database was NOT successful.

The error message returned is:

Host '66.98.140.139' is not allowed to connect to this MySQL server

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.

 

 

So, what do I need to do to fix? Thanks

[Guest]

most likely you are using php 5 which is not compatible with osCommerce MS2.2, you should downgrade to php 4.3.11 if that is the case.

 

else you have the wrong database name, password (most likely the case)

[Guest]

Here is my php:

 

[root@gz /]# rpm -qa |grep php

phpWiki-(none)-1.2-7108

php-mysql-(none)-4.3.10-3.rhel3.art

php-domxml-(none)-4.3.10-3.rhel3.art

php-pear-(none)-4.3.9-11.rhel3.art

phpAds-(none)-2.0-7101

phpsurveyor-(none)-0.98-7106

php-xmlrpc-(none)-4.3.10-3.rhel3.art

php-pgsql-(none)-4.3.10-3.rhel3.art

phpMyFamily-(none)-1.4.0-7101

phpBB-(none)-2.0.11-7101

phpDig-(none)-1.85-7101

php-mcrypt-(none)-4.3.10-3.rhel3.art

php-imap-(none)-4.3.10-3.rhel3.art

php-devel-(none)-4.3.10-3.rhel3.art

php-(none)-4.3.10-3.rhel3.art

phpMoney-(none)-1.3-7105

phpBugTracker-(none)-1.19-7101

phpBook-(none)-1.50-7102

php-snmp-(none)-4.3.10-3.rhel3.art

php-ldap-(none)-4.3.10-3.rhel3.art

php-mbstring-(none)-4.3.10-3.rhel3.art

[root@gz /]#

 

I've double and tripled checked the id/pw.. checked for case etc..

tested by loging into the shell, and using mysql -uxxxxx -pxxxxx logs me into the system, then type connect database name and get connected..

 

But not thru the web script...

[Guest]

Ok, solution found!

 

When you are setting up a new installation of osCommerce and you get

A test connection made to the database was NOT successful.

the following should correct your problem.

 

Where you enter your database server name, if using your domain or domain with port 3306 doesn't get you connected then you can try localhost:3306 and that should get you connected to your database and allow you to install the table structure.

 

If someone could add this to the install documentation that could help lots of folks.