Connect to Database Failure

[Guest]

Hello,

 

I've discovered that people outside my house can apparently access my database on its hosted server just fine in order to run the osCommerce web install. I can't do it from my computer, or any in this house. I get the error:

 

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

 

I've got firewalls turned off on the computer, and no virus software or anything (its a Mac). The router has never had a problem accessing anything before until now. However, I'm guessing there are probably ports specific to the osCommerce install that need to be opened on my computer/router, etc?

 

If anyone can point to or give me a list of ports I need to double check, that would be great.

 

 

Thank you,

 

Timothy

[Guest]

Hello,

 

I've discovered that people outside my house can apparently access my database on its hosted server just fine in order to run the osCommerce web install. I can't do it from my computer, or any in this house. I get the error:

 

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

 

I've got firewalls turned off on the computer, and no virus software or anything (its a Mac). The router has never had a problem accessing anything before until now. However, I'm guessing there are probably ports specific to the osCommerce install that need to be opened on my computer/router, etc?

 

If anyone can point to or give me a list of ports I need to double check, that would be great.

Thank you,

 

Timothy

 

Tim -

I don't know about your specific scenario, or what ports are used, but I have just gone through my own brief hell with that same error message because our host set new logins and passwords and broke the database connection between the OSC php scripts and the MySQL database. I saw that same login error quite a bit until I updated the SQL login and password strings in BOTH copies of configure.php - includes/configure.php and includes/local/configure.php .

 

AND THEN I had to update the login string in TWO MORE copies of the same files which were hidden on the host's secure server.

 

Check first to confirm that the login data is correct, (using the same login and pwd in phpAdmin should confirm the strings. ) Then check to make sure all (4?) copies of configure.php are updated with the corrected connect string. IF you are running ssl configured as my host does, there will be 4 places to update the connect string.

 

The key to figuring out that there were ssl versions of the configure.php scripts was the fact that after I updated my main copies of configure.php, only the secured pages returned the error.

 

- Alan

[Guest]

The odd thing about my situation is that I've connected with multiple browsers to the hosted database on my computers at home, a friend's house, even the public library and all receive the same error:

 

New Installation

Database Import

A test connection made to the database was NOT successful.

The error message returned is:

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

 

Yet, the hosting support staff, on their computer, can connect on a regular internet connection. A support techie from the company that makes the Website OS my host uses (Hostopia), can connect to my database from his browser too. Because they seem to be able to go through the install just fine from their computers on their browsers, I don't believe a problem lies in my configuration files, or their location with the host servers. If that were true, no one could run through the install program through any browser, right?

 

I can't figure out why someone in one location seems able to connect, and not me, even from multiple different locations, computers and browsers. I think my tests have either ruled out a problem with routers and ports, or else have totally confirmed the problem lies there. I can't decide which.

 

I've got the hosting company trying to look up all the ports that need to be open to communicate freely with them. I'll try to open everything on my router at home. I've tried replacing my router with a plain switch, but the company that supplies ADSL to my house, uses some kind of modem or signal that won't allow direct connection. Instead, when you direct connect to the internet, you get their internet help website no matter what you type for an address. Really annoying.

 

Thanks for the help so far. Any further suggestions are greatly appreciated. I'll try to keep updating on any progress I make for further users who have similar troubles.

 

 

Cheers,

 

Timothy

[Guest]

Actually, I've tried installing both phpBB and osCommerce and failed to connect to the database. Anyone know any other very simple little scripts I could use to test my ability to connect to the database with the browser, and where I might find these scripts?

 

 

Thanks,

 

Timothy

[Guest]

Deleted all and started from scratch. Must have made an error in the install, or in my data entry. Everything seems to work now. Guess the problem was me.

 

 

Thanks,

 

Timothy