I agree this is a setup issue ... I didn't think it would have anything to do with the local hosts file. The name of the database server I can ping, and I can use Squirrel or MySQL Administrator to connect and authenticate to the database.

I presumed that the install.php page got the user, password, database, host, etc from the form on that page. It seems like the username, password, database are all correct .... but the host seems to constantly default to localhost and NOT the host that I entered in on the form.

I even went to install.mysql.inc file and hardcoded my database ... and it still didn't work .... Maybe I need to bounce Drupal after I changed that .inc file?

Earnie Boyd wrote:

Quoting "Tom Holmes Jr." tom@tomholmes.net:

...

I've got Drupal working on one or two other machines because the database was local.

Now I've got an instance of Drupal I want to install ... but the database is on another server ..... I put in the database, database user, user password, the new server name and port .... and it STILL tries to connect to localhost like it is NEVER getting the name of the server I entered in.

I'm about to go into the install.mysql.inc file and just hard-code it at this point ... just to get it setup ....

Any ideas? Thanks!

What is in your local hosts file? Can you trace the path to the ``other machine'' to determine why you're using the localhost? This is a setup issue.

Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/

Ok boy .... no need to get snarky and start making presumptions ...

I found out what the issue is, and it was *MY* fault ... but I hope my ignorance will help other people not make the same mistake .... ok?

There are 3 machines involved: the actual machine with the database, the actual machine with the drupal, and the last machine which was my laptop that I was using to do the install.

I used MySQL-Administrator to make sure that the drupal_user and password could be accessed from my laptop ... as I usually do ... But since the Drupal was on another machine .. I had to make sure I added the host (second machine) and permissions to the database. Once I added that host to the mysql user ... and then set permissions on the database .... it worked.

I sincerely hope this helps out other people .... it's all part of being a community.

Thanks!

Tom

Earnie Boyd wrote:

Quoting "Tom Holmes Jr." tom@tomholmes.net:

...

I agree this is a setup issue ... I didn't think it would have anything to do with the local hosts file. The name of the database server I can ping, and I can use Squirrel or MySQL Administrator to connect and authenticate to the database.

I presumed that the install.php page got the user, password, database, host, etc from the form on that page. It seems like the username, password, database are all correct .... but the host seems to constantly default to localhost and NOT the host that I entered in on the form.

Let me guess, you copied the settings.php from development to production. Change the copied file with your favorite editor.

...

I even went to install.mysql.inc file and hardcoded my database ... and it still didn't work .... Maybe I need to bounce Drupal after I changed that .inc file?

You're just asking for issues. There is no need to modify this file!!!

Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/