By Jerimee on
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).
Comments
=-=
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.
still can't get it to work
Now I have http://ncdponline.COM and addon domain that points to public_html/main
I also created subdomain http://two.ncdponline.com that points to public_html/main/sites/two.ncdponline.com/
That folder is a copy of default, with the following modifications:
I replaced settings.php with default.settings.php (I renamed default.settings.php to settings.php)
I created the folders "modules," "themes," and "tmp." The files folder was already there.
I get the following error:
http://two.ncdponline.com/install.php?profile=default
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.
I think I got it
I got it done using separate databases.
how I did it
This is likely to just be a big collection of nonsense, but this is how I finally got it to work on my host (Bluehost):
I want a set of subdomains, each with their own database, but all running off the same Drupal code.
I DID have to put the "main" or initial site in it's own directory that was NOT public_html. The main site is located in public_html/main/ and the the sites directory is, of course, public_html/main/sites. This means the subdomains files are stored in directory public_html/main/sites/mysub.example.com/
That said, the root of the subdomain IS THE SAME root folder as the main domain. In my case the root was public_html/main/
Here is how I create a new subdomain:
Create a new sub domain by logging into Bluehost and using the c-panel:
•Enter new sub domain name
•ensure that the document root of that subdomain is the SAME as the main domain ("public_html/main")
•Confirm the domain is created by opening it in a web browser: at this point it will look exactly like the main domain (because they both have the same root).
In Smart FTP (or other FTP client)
• On the remote server go to main folder > sites > default
• select default and download to desktop
From Desktop
• Go to the desktop select the new default folder
• Create new folders inside the default: modules, themes, and tmp
• Within the folder delete the setting.php.
• Rename default.settings.php to settings.php
• Rename the folder to the new web site name: mysub.example.com
In Smart FTP
• Upload new folder (mysub.example.com) to the server in the sites directory (along side default)
In your web browser
• Go to the subdomain page (mysub.example.com) and refresh the page. A message: site off-line should come up.
• In the address window type "/install.php" behind the web name (mysub.example.com/install.php)
In BlueHost we now need to create a new database:
• go to MY SQL databases
• Create a new database by typing in the name
• Click create
• assign a user to that database with ALL privledges
From Desktop:
Go back to the desktop to the mysub.example.com folder
• Open setting.php in wordpad or other text editor (
• When document opens, go down to database settings
• Look for $db_url = 'mysql://username:password@localhost/databasename';
• Change user name and password and databasename (the password is the password for the user assigned to the database)
• Save file
In Smart FTP
• upload the modified settings.php to the mysub.example.com folder (public_html/main/sites/mysub.example.com/)
Finally, in your web browser
• refresh mysub.example.com/install.php (or type it into the browser)
• Install Drupal in English
The trick to this (the solution to my individual problem) is that you have to trigger the subdomain in the browser TWICE with two different values in $db_url. The first time you do it you get a "site-offline" and/or a mysql error message, and the second time you actually get the installation procedure. When I made the changes to $db_url BEFORE I triggered the subdomain in the browser with the defaults, I was getting stuck with the main site; Drupal refused to recognize the subdomain as a distinct site with a distinct database. I don't know what the explanation for this is.
How did you create multi-site? Need a little help.
Hi, jerimee. I've encountered your post today, am trying to do the same thing . . . creating multiple sites in one Drupal installation. I don't mind using a shared DB or separate DBs (although I do prefer separate DBs). I am glad that, after all those days (weeks maybe?), you've finally got it all worked out.
Due to your experience with this, I would like to pick your brain.
Your instructions above is very clear, but I cannot figure out the subdomain part . . .
* I've created a subdomain (testdrupal) at my host (ix Web Hosting). When this was done, a new subdirectory (testdrupal.mydomain.com) containing pertinent starter files was created under "/" (I supposed that this is the document root--a Linux server). So now "testdrupal.mydomain.com" looks like this: "/testdrupal.mydomain.com"
* So your instruction said "ensure that the document root of that subdomain is the SAME as the main domain ("public_html/main")".
Well, my Drupal "main" is at "/mydomain.com/drupal" . . . meaning index.php, install.php, cron.php, .htaccess, etc. are all in "/mydomain.com/drupal/" folder.
Now, how do I ensure that the document root of "testdrupal.mydomain.com" is the same as "mydomain.com/drupal" ?
I am stuck at this part that I am not understanding . . . do I have to move the "testdrupal.mydomain.com" into some other folders before I run the install to create this new site for "testdrupal"?
I would be grateful for your experienced insights.
JC
=-=
check your host panel, where you may have the ability to point the subdomain you created to the original drupal installs folder.
Ultimatley that is what needs to be done.
I'm not familiar with iX however at site 5 after the subdomain is created the admin panel offers the ability change the doc root of the subdomain so instead of pointing to the folder it automatically created, you can point it to the drupal main install folder.
Thanks first for your reply,
Thanks first for your reply, VeryMisunderstood.
On Site5, what is that option (the option that allows you to change the document root of the subdomain to point to somewhere else) called? Is it something along the line of indexing or directory indexing?
On ixWH, there is "Directory Indexes" that sounds like doing the same thing as described above. I've made the change, it's not pointing to my main Drupal site yet, but I guess it just takes some time for that to happen.
We'll see :)
jc
=-=
it's called the document root.
after a subdomain is created I can point that subdomain to any folder on the host.
Hello,
Hello, VeryMisunderstood.
Yes, I understand. My question was which was the feature in the Control Panel or host server administrative interface of Site5 that allows you to point that subdomain to other folders on the host. On my host, I believe is "Directory Indexes", but so far it is not making my subdomain pointing to the Drupal installation like I want it to. May be it's some other feature then . . . but I don't know which one :(
jc
=-=
@ site5 we have what is called backstage, which is basically cpanel with a custom theme. from this backstage area I control setting up the server to do what I want within my account limitations.
I don't know if "directory indexes" is the same thing. Changing the doc root on site5 happens almost immediately.
asking your host may help more then I can in this case.
Yes, I am on Live Chat with
Yes, I am on Live Chat with my host since my last post here :P
It seems it is "redirection" rather than "directory indexing". I am not certain whether this is what people who got multi-site set-up working are talking about. At least right now, when I type in the URL of my subdomain, I go to my main Drupal page.
Thanks for all your help & insights. :)
jc