Results 1 to 8 of 8

Thread: Install script fails to log into mysql server

  1. #1
    bjrafferty
    Guest


    Default Install script fails to log into mysql server

    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: 'aehf@209.217.33.253' (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 ???

  2. #2
    osCMax Developer


    Install script fails to log into mysql server

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    23,012
    Total Contributions For

    michael_s     $ 10.00
    Rep Power
    594


    Default

    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...
    Michael Sasek

    osCmax 2.5.4 is now available via auto-installation using Softaculous!

    Stay Up To Date with everything osCMax:
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    bjrafferty
    Guest


    Default

    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 ?

  4. #4
    osCMax Developer


    Install script fails to log into mysql server

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    23,012
    Total Contributions For

    michael_s     $ 10.00
    Rep Power
    594


    Default

    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: 'aehf@209.217.33.253' (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...
    Michael Sasek

    osCmax 2.5.4 is now available via auto-installation using Softaculous!

    Stay Up To Date with everything osCMax:
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  5. #5
    peteyg
    Guest


    Default

    I htought you set the db server as localhost or 127.0.0.1 then set your username password and the DB name...

  6. #6
    osCMax Developer


    Install script fails to log into mysql server

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    23,012
    Total Contributions For

    michael_s     $ 10.00
    Rep Power
    594


    Default

    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.
    Michael Sasek

    osCmax 2.5.4 is now available via auto-installation using Softaculous!

    Stay Up To Date with everything osCMax:
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  7. #7
    dessel
    Guest


    Default

    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.

  8. #8
    osCMax Developer


    Install script fails to log into mysql server

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    23,012
    Total Contributions For

    michael_s     $ 10.00
    Rep Power
    594


    Default

    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).
    Michael Sasek

    osCmax 2.5.4 is now available via auto-installation using Softaculous!

    Stay Up To Date with everything osCMax:
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

Similar Threads

  1. 2006 - MySQL server has gone away
    By blioux in forum osCmax v2 Installation issues
    Replies: 3
    Last Post: 01-12-2006, 12:10 PM
  2. Can't connect to MySQL server on '207.44.142.34' (111)???
    By currie_muncher in forum osCommerce 2.2 Installation Help
    Replies: 2
    Last Post: 05-19-2005, 09:08 PM
  3. Install Fails on Database Import
    By JohnWayne in forum osCMax v1.7 Installation
    Replies: 1
    Last Post: 10-13-2004, 05:27 AM
  4. install script NOT THERE!!
    By ReginaStelling in forum osCMax v1.7 Installation
    Replies: 4
    Last Post: 06-29-2004, 07:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •