By beresbart on
My Drupal install stalls at the database connection test.
DB name, DB Username, DB passwrd, Database Host are all correctly entered, but I still get
Failed to connect to your MySQL database server. MySQL reports the following message: Unknown MySQL server host 'dabminor.ipowermysql.com ' (1).
* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct database hostname?
* Are you sure that the database server is running?
As a newbie I am about ready to go back to my old CMS.
Any ideas?
Comments
=-=
define stalls please?
just sits and browser continues to be "working" ? or does the page refresh?
have you opened sites/settings.php to see if the file is actually being written to?
have you checked permissions on settings.php to insure it's writable?
are you using the INSTALL.txt file to insure you are following the proper steps ?
Stalls = returns an error
Stalls = returns an error and waits on my further input
settings.php is writable
Don't know how to check to see if settings.php is being written to.
I have googled "Failed to connect to your MySQL database server". This seems to be a widely experienced problem, but there's little in the way of useful info.
thank you
Is dabminor.ipowermysql.com
Is dabminor.ipowermysql.com the same db host name that you have been using in your old CMS? If so, is the trailing space that I see in 'dabminor.ipowermysql.com ' in you error message a typo, or is that what you have specified?
OMG
OMG! One trailing space?
How did I miss that.
Thank you for noticing cog.rusty!
Can I buy you a drink?
I'm in.
Thank you very much.
beres
Heh, believe it or not,
Heh, believe it or not, noticing these things immediately is part of my work-induced damage.
Same problem!
Hi all,
I have the same problem; I've have set up the MySQL database, created a user account, made sure that that user account has all permissions, put the installation will not recognize the MySQL database.
Here's the error dialog I get:
The following error must be resolved before you can continue the installation process:
Failed to connect to your MySQL database server. MySQL reports the following message: Access denied for user 'rivermus_rmcomm'@'cp01.shiftreload.com.au' (using password: YES).
* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct database hostname?
* Are you sure that the database server is running?
For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider.
I have made sure that the database host is correct, and I even tried another user account, copying and pasting UIDs and passwords. Same result as above.
Any thoughts? I've been bashing at this for some time now!
Bruce M Campbell
BeeMCee Consulting
Communications, Technology, Design
Bowen Island, BC
This is a different error.
This is a different error. Unfortunately the cause can be any of the listed ones and you are in a better position that anyone to troubleshoot it.
Have you used cp01.shiftreload.com.au for a database before? Are you sure that that this is your database host?
Is "rivermus_" a user account name automatically prepended to your db username and to your db database name?
Maybe related to SELinux FC4?
Thanks for noticing the detail, cog.rusty. I reposted this in a new topic with some more detail [http://drupal.org/node/355854]. shiftreload.com is the service provider, and cp01 is the server. The domain is Rivermuse.com, which is hosted by shiftreload. When I enter "rivermuse.com" into the database host field, the error I copied shows up.
They use Cpanel 11 for hosting admin, so the DNS resolves to that server, and Cpanel uses the domain host owner UserID (rivermus) as the prefix for all MySQL DBs and user IDs.
I bit further digging in the Drupal Installation troubleshooting documentation suggests that it is something arcane in the OS (maybe?). Funny thing is (I'm 3 days new to this company, as well as Drupal!), there seems to be an instance of Drupal already running on this server, for the support group. Somebody clearly got Drupal to connect to another MySQL database. There are 50 tables in the other DB.
I may need to find out who created the other instance, and find out what they did.
Bruce M Campbell
BeeMCee Consulting
Communications, Technology, Design
Bowen Island, BC
On all shared hosts that I
On all shared hosts that I have used, the db host is just "localhost".
Some other hosts that I have heard of (namely godaddy) use different numeric IPs for the db host, which they mention in their cpanel info. Your web server's domains/subdomains/IPs are not necessarily the same as your db server's.
Take a look at your database with phpmyadmin. It should mention some server name.
Or you could ask your host's tech support.
Do'oh!
Lo and behold, even though I initially left the Database host as "localhost", and I got an error message, after bashing through the documentation, taking numerous breaks, and eating a pop-tart, I opened a new browser window, navigated to the install.php. started from scratch, and suddenly, it worked!
I am now happily configuring away. I can't possibly imagine what I have done differently, except closing the initial browser window, opening a brand new one, then trying over.
Bruce M Campbell
BeeMCee Consulting
Communications, Technology, Design
Bowen Island, BC