The Setup:
using drupal 6.15 (downloaded from drupal.org) on debian lenny in a virtual machine
running myphpadmin and mysql and apache2
im doing this at/for local access at a community college; so i control the vm/os and i can manage the dns records
i followed this for the install:
http://www.johnandcailin.com/blog/cailin/easy-peasy-lemon-squeezy-drupal...
usually id use aptitude but it has an older version of drupal and i wanted to be certain that i knew where everything was going and was up-to-date.
ive been using these links to try and figure out how to set things up
http://drupal.org/node/107347
http://drupal.org/node/235765
/etc/apache2/ports.conf has my virtual hosts setup and going to the main site/subsites works fine
i have the A record for the host set to drupal.school.edu
I have CNAMEs set for site1.drupalmu.school.edu site2...etc
directory structure:
/var/www/drupal
/var/www/drupal/sites
/var/www/drupal/sites/drupalmu.school.edu/
/var/www/drupal/sites/site1.drupalmu/ (site2, etc)
i have the root mysql user, and an administrator user with full privileges
i have databases named: drupalmu, site1, site2, (etc...)
the *only* diff between settings.php in each site/subsite folder is the line:
$db_url = 'mysql://username:password@localhost/$dbname'
where $dbname is drupalmu, site1, site2, etc
The Problem
for drupalmu.school.edu i get the drupal install ready to go
for site1.drupalmu.school.edu (and others) i get
"site offline...The mysql error was: Access denied for user 'administrator'@'localhost' (using password: YES)."
what is causing this sql error and how can I resolve it?
Comments
_
If you're expecting to see the drupal install screen, the settings.php file must be the default one that comes with Drupal; if it's been modified, Drupal thinks that the install has been done.
I clearly have some kind of
I clearly have some kind of misunderstanding between what the HOWTOs are telling me and what youve told me, so I did some playing around and heres what Im seeing.
I have default/* which has an unmodified settings.php
I have drupalmu.../which has the db line modified with a user and db name
I have site1.../ which has a similar modification to drupalmu/
drupalmu.school.edu asks for an install
site1.drupalmu gives me the aforementioned error.
so i fiddled with copying the default/settings.php into both of those folders, no change....change default/settings.php and i get a different error, so now I understand what youre saying...but since /etc/apache2/ports.conf shows the following:
DocumentRoot /var/www/drupal
ServerName drupalmu.school.edu
DocumentRoot /var/www/drupal
ServerName site1.drupalmu.school.edu
im wondering if, that since they should all be using default/settings.php (which is a copy of default.settings.php) then why *am* I getting
"site offline...
The mysql error was: Access denied for user 'administrator'@'localhost' (using password: YES)."
for the subsites site1.drupalmu... but not for drupalmu.school.edu itself? any ideas? Im used to working with linux some, but not apache or mysql or anything website related so this is really getting me :-/
Got it....my issue was having
Got it....my issue was having a default/settings.php when i only need that one in the directories of each subfolder.
/facepalm