can't get multi-site to install
jerimee - May 6, 2008 - 17:16
Here is my site: http://ncdponline.org/
Here is my subdomain that I'm trying to install as a multi-site: http://two.ncdponline.org/
The directory is named /public_html/sites/two.ncdponline.org and it has settings.php
$base_url = 'http://two.ncdponline.org'; // NO trailing slash!
$db_url is correct
The error I'm getting is Table 'ncdponli_two.access' doesn't exist query. Of course, it doesn't exist yet: 'm trying to run the install script. Do I need to do something special to get install to run?
The document root of subdomain two.ncdponline.org is public_html
Thanks for help; it's much needed. (I've been trying to do this for 3 weeks).
=-=
you state
Fact: Drupal won't install if you've done anything to the settings.php file. you need to use a fresh unaldulterated settings.php. This was expalined to you by me, in your other thread. http://drupal.org/node/247615#comment-811782 where I state to use a "new" settings.php file.
when drupal recognizes that settings.php doesn't have a $db_url string, it will run the installer, just as you did the first time you installed drupal.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
and now I get this
http://two.ncdponline.org/
Site off-line
The site is currently not available due to technical problems. Please try again later. Thank you for your understanding.
If you are the maintainer of this site, please check your database settings in the settings.php file and ensure that your hosting provider's database server is running. For more help, see the handbook, or contact your hosting provider.
The mysql error was: Access denied for user 'username'@'localhost' (using password: YES).
=-=
try running two.ncdponline.org/install.php
insure the settings.php file is 777
also insure that you've nothing added to it, including base_url
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
error
Requirements problem
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 'username'@'localhost' (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.
Please check the error messages and try again.
=-=
your second drupal install seems to think its already installed. Why this is happening exactly I have no idea. Could be because you didn't do it properly from the get go by following the steps in perfect order.
Try clearing your browser cache
if necessary set up another subdomain and follow the correct steps.
I just followed the procedures and teh multisite installation ran install.php to install the second set of tables. Which is what it is supposed to do.
The only other thing anyone can do at this point if you can't get it done is to do it for you. For that you would have to provide account information so someone can FTP to your server and check out what is going on.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
let me try one more time
Edited by: VeryMisunderstood; removed pasting of settings.php
No need to paste settings.php, it can be read from CVS if necessary. In future when you want to paste a 1/2 page of code, use pastebin.com and link to it here.
settings.php
If I add new stuff to settings.php I get errors about how it can't find the tables.
If I add a blank settings.php I get Access denied for user 'username'@'localhost'
If I add the settings.php of the first site I just get a duplicate of that site
=-=
Looking at your folder structure I think I see where the problem may reside.
yoru original drupal install may be takling over because you've your main site installed at public_html
my multisites are one level deeper.
example:
public_html/main -> main install
public_html/subdomain which points its doc root to public_html/main
The above allows my host panel to create its subdomain folder and me to create a public_html/main/sites/subdomain.maindomain.com folder and bypass any outside interference from other drupal installations in same domain.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
Ok then I'll move my main
Ok then I'll move my main domain to it's own folder and try again.
But I think before I do that I'll see what happens if I just manually make the tables Drupal is looking for (with a modified settings.php). At least I can see it's trying to install.
oh it gets real mad!
If the database tables are there it gets mad that they already exist. If the tables aren't there it gets mad that they don't exist.
=-=
The second set of tables would have to have a prefix on them that the installer woudl ask for. If you are doing it manually you will have to add a prefix to the tables so that the main install and the second inmstall do not try to use the same tables.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
don't they use entirely different databases?
I'll have to give you access to the server so that you can talk a look. Are you still willing to look into this?
=-=
They can use entirely different DB's yes if you have no intentions on sharing anything between the two installs.
I, personally, can't take a look until I get home from my day job.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
I thought this was your day job
You answer almost every single question that gets answered. I hope the Drupal community finds a way to pay you back.
I think the issue is specific to my host and the main domain being firmly rooted to public_html. I'm going to get another add-on domain with root main like you suggested. Maybe that will work better.
I installed the multi-site on my local machine, so I know it's possible. Just have to work out the kinks.