Hello,
I'm having quite a time trying to get Drupal up and running, and I'm not even getting consistent error messages, depending on what machine I try to connect from. I'm using Red Hat Linux Enterprise with up to date versions of PHP and MySQL, and Apache 1.3. I am new to all of these technologies, as I come from a Windows background, so I could very well be missing something obvious. Please bear with me as I explain in further (and probably too much) detail.
When I try to connect from the server itself, I consistently get a pop-up alert which says "The connection was refused when attempting to contact scoop.domainname.com" (which is the hostname of the machine). I've tried different variants of the address in both the browser and the conf.php file with no result.
Now, I get a different response when I try connecting from a different machine logged into the same domain. I'm taken to a directory listing when I browse to http://ipaddress/drupal, and I get the following error when browsing to http://ipaddress/drupal/index.php:
Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) in /usr/local/apache/htdocs/drupal/includes/database.mysql.inc on line 31
Access denied for user 'root'@'localhost' (using password: YES)
And when browsing from outside our company network, I'm back to the first response ("The connection was refused when attempting to contact scoop.domainname.com").
I don't know if the problem has to do with how the machine is registered on our network (why would an outside machine attempt to connect to the Drupal site using its internal name?) or if it's database-related, but I'm at a complete loss. My bosses are not technical people so they don't understand why I'm having problems, and they want results yesterday. Please help!!!!
Thanks so much!
Anna
Comments
base_url setting?
What is your base_url setting in your conf.php file?
base_url
I've tried various ones - http://ipaddress, http://localhost..... No change.
By the way, I ran across some further instructions for setting up httpd.conf on Linux and followed them - now I'm consistently getting the "Access denied for user 'root'@'localhost' (using password: YES)" error on all machines, inside or outside the network.
Thanks!
Log in from the command line?
Why aren't you using a fully qualified domain name for the $base_url? Something like "http://www.servernmame.com". When you type in "hostname" at the command line, what do you see?
Do you have command line access? Can you log into mysql from the command line. Try typing 'mysql -u username -p databasename' followed by the password and see what happens. Also, as a security precaution, you shouldn't be trying to log into mysql as root. You should have a different user for any Drupal database you are using.
FIXED!!
I found the following article regarding MySQL 4.1's new method of hashing passwords, and that turned out to be the problem.
http://dev.mysql.com/doc/mysql/en/Password_hashing.html
Thanks for the help everyone!