PDA

View Full Version : Install script fails to log into mysql server



bjrafferty
03-29-2004, 10:43 AM
I filled out the database server name, username, password, and left the persistent connections box blank, and chose database session storage.

When I submitted that, I received the following error message :
**********
A test connection made to the database was NOT successful.

The error message returned is:

Access denied for user: '[email protected]' (Using password: YES)

***********

I double checked the password, and it failed again.
I was worried that the language specification drop-down box on the mysql.catalog.com homepage was the problem, so I tried using WS_FTP instead of a browser to log into mysql.catalog.com and it works fine.

The page source of the error screen shows the folowing line :
********
<input type="hidden" name="DB_SERVER" value="mysql.catalog.com"><input type="hidden" name="DB_SERVER_USERNAME" value="aehf"><input type="hidden" name="DB_SERVER_PASSWORD" value="******"><input type="hidden" name="DB_DATABASE" value="aehf"><input type="hidden" name="STORE_SESSIONS" value="mysql"><input type="hidden" name="install[]" value="database"><input type="hidden" name="install[]" value="configure">
********

It did have the CORRECT password but I have astrixed it out since this is a public forum.

Anybody have any clues ???

michael_s
03-29-2004, 11:26 AM
It is not the install script. You are not specifiying either the correct username/password or database. Plain and simple. Also check that you have access to mysql...

bjrafferty
03-29-2004, 12:14 PM
I use the very same username and password to log into mysql.catalog.com and succeed doing it by hand using a browser.

I just now did log in using a browser and verified that the name of the database was correct as well.

What else is there to do to check ?

michael_s
03-29-2004, 01:09 PM
All I can tell you is that this error:


A test connection made to the database was NOT successful.

The error message returned is:

Access denied for user: '[email protected]' (Using password: YES)

Is a mysql login error. It has nothing to do with the installer, other than the fact that the username/dbname/password combo you are using is incorrect, or the script does not have permissions to login. Check the user permissions on the database. Most likely it is something simple though. Extra space at the end of username or password, or something like that...

peteyg
03-30-2004, 02:25 AM
I htought you set the db server as localhost or 127.0.0.1 then set your username password and the DB name...

michael_s
03-30-2004, 08:13 AM
peteyg, good eyes! I missed that.

bjrafferty, you need to set the DB_SERVER to localhost or 127.0.0.1 . If it is not on the same server as your oscommerce installation, you need to set mysql to accept remote connections. That is the problem.

dessel
06-23-2004, 10:43 AM
Hey I was having the same problems. I thought, as the instructions in the installation script say, the DB Host was supposed to be an IP so I was using mine. Turns out I had to delete it and replace it with "localhost".... worked fine.

michael_s
06-23-2004, 07:37 PM
dessel, all servers are different, but if the mysql server is on the same machine as the web site, you can almost always use 'localhost' as the DB_SERVER (You shouldn't use your websites IP, unless you are also running the MySQL server on that IP).