On Fri, 17 Jun 2005, puregin wrote:

What do your webserver logs tell you? I'm inclined to suspect that your webserver process does not have permission to read the includes directory or its files.

It does. I've tried setting the ownerships of the files to the userid of the webserver, the userid of myself with proper rights under 'other' section of permissions, the works. The errors are always the same.

<EOL> Tib

Op zaterdag 18 juni 2005 13:51, schreef Tib:

Incidentally, the only error that ever showed up in my apache logs regarding drupal was this:

[Fri Jun 17 21:15:32 2005] [error] [client 192.168.1.22] Directory index forbidden by rule: /home/tib/public_html/drupal/includes/

Make sure you have allowOverride All set. otherwise Drupal cannot set its variables with .htaccess. Drupal will work without .htaccess, so optionally you can remove it completely.

Regards, Bèr

drupal locations:

/home/tib/public_html/drupal www.tigerknight.org/~tib/drupal

Apache info:

modrewrite is compiled in and does not need to be loaded

Question:

What am I supposed to put for the 'RewriteBase' value in the drupal/.htaccess file? I've tried just '/drupal' as well as '/~tib/drupal' but that doesn't seem to work. I keep getting errors of:

'It appears your host is not configured correctly for Clean URLs. Please check for ModRewrite support with your administrator.'

<EOL> Tib

Thanks for the direction. Couldn't quite piece it together just from that but did some puzzling around.

End result:

For some reason even though I didn't have 'allowoverride all' set for the drupal directory it was working for the most part o_O. I setup a specific 'Directory' entry for the /home/tib/public_html/drupal path and set it to override all.

The rewritebase then got set to /~tib/drupal instead of just /drupal and it works fine now. Woohoo :]

<EOL> Tib

On Sun, 19 Jun 2005, puregin wrote:

Check out, for example,

http://www.opensa.org/manual/apache_guide/urlmapping.html

in particular the section on user directories.

Djun

On 19 Jun 2005, at 7:34 AM, Tib wrote:

drupal locations:

/home/tib/public_html/drupal www.tigerknight.org/~tib/drupal

Apache info:

modrewrite is compiled in and does not need to be loaded

Question:

What am I supposed to put for the 'RewriteBase' value in the drupal/.htaccess file? I've tried just '/drupal' as well as '/~tib/drupal' but that doesn't seem to work. I keep getting errors of:

'It appears your host is not configured correctly for Clean URLs. Please check for ModRewrite support with your administrator.'

<EOL> Tib --

Hi Tib!

If you set a db prefix in settings.php you must have all the tables with the same prefix in your database. You can have one installation without any prefix and many others with several prefixes.

That's it! ;-) Cheers, Emiliano.

Tib wrote:

Ok - so I have my first site, which has no prefix.. now how do I add another site with it's own prefix? I've extracted the drupal files into a new folder, verified that it has access to modrewrite, and configured the sites/default/settings.php to have a prefix of my choosing, and setup the .htaccess properly. But when I go to the web page it errors out telling me the tablespace for my prefix doesn't exist.

The handbook doesn't really cover this that I could find. Hopefully I'm just reading too fast and missing something obvious..?

<EOL> Tib

On Sun, 19 Jun 2005 15:45:48 -0500 (CDT) Tib tib@tigerknight.org wrote Re: [drupal-support] New sites and db prefixes :

...

Hi Tib!

If you set a db prefix in settings.php you must have all the tables with the same prefix in your database. You can have one installation without any prefix and many others with several prefixes.

Hi,

That is actually not completely correct. If you look at the explanation in your settings.php you find above your prefix setting that you can use "arrays". That way you can have multiple sites run over your same prefix-table and still have many different prefix-tables. Also you do not not an installation without any prefix. Every site can have it's prefix, only you need one prefix to be a complete database. The rest can be bits and peaces. That way Drupal can run in a database that is used by another script or program.

Actually all this should run out of first hand without programming knowledge. As it is clearly explained in the handbook and settings.php file. But sometimes, OK with me also, most of the times, it are the easiest things that one oversees the first ;-)

Cheers, William.

That's it! ;-) Cheers, Emiliano.

I'm curious, because I don't know too much about databases. A basic drupal installation has 55 tablespaces. If you were to just use new prefixes anytime you configured a new site (and even if you didn't you'd only save so much room when it comes to number of tablespaces), how many could you have before it became too much for mysql to deal with?

I know at work the most I've seen is almost 600, but that's on Oracle databases where a single tablespace can be more than 2Gb and the system specs it's hosted on are absurd. What about a lowly linux box - pIII 500 with 192mb memory?

<EOL> Tib

Wait.. I think I know what this is about. Considering the layout of how we are going to use drupal here, I went through and renamed all the tablespaces I was using for my site to have a prefix (the tib_ one) and everything seemed perfectly fine - apparently the indexing method got screwed up because it was reporting duplicates all the way up till it found a new number (thankfully only 9) and picked up again.

Why did renaming tablespaces reset the content index number?

<EOL> Tib

On Mon, 20 Jun 2005, Tib wrote:

I was trying to use the story module, and when I created my first page it gave me a 'duplicate entry' error. I thought maybe the ()'s and such in the text were confusing it, so I tried again with none of that.

I still get the error. Why is the story module using the same content type (node) as a page, yet has it's own counter to track actual records/entries?

This is going to be a pain in the ass real quick unless I can find a work around. Any ideas?

Duplicate entry '2' for key 1 query: INSERT INTO tib_node (status, moderate, promote, sticky, comment, title, body, format, uid, created, type, teaser, changed, nid) VALUES('1', '0', '0', '0', '2', 'test', 'testing', '3', '1', '1119314160', 'story', 'testing', '1119314228', '2') in /home/tib/public_html/includes/database.mysql.inc on line 66.

On Wed, 22 Jun 2005 00:42:13 +0200, Tib tib@tigerknight.org wrote:

The first time I registered an account outside the admin one through the web pages (for anonymous users) it worked fine. But now every time after I am getting the following error and I'm not sure what to do. The UID number is incrementing, but because of the 'duplicate' error, the accounts never get created. What's going on?

user error: Duplicate entry '' for key 2 query: INSERT INTO tib_users (pass, created, changed, uid) VALUES ('8ea960a46ddefee8f7c895deb6d089a2', '1119393043', '1119393043', '8') in /home/tib/public_html/includes/database.mysql.inc on line 66.

Have you added a prefix to the sequences table? This error and the previous one you posted could be explained if that table wasn't being updated correctly.

*it* being a self-register via the web interface. Also my apologies for the double post folks - didn't catch that second address when I was writing.

On Wed, 22 Jun 2005, Tib wrote:

I had gone through and re-prefixed all the tables associated with this site by hand earlier in the day. I did it again a few hours later and things seemed back to normal. What sort of marker is the 'created' field? Seconds, date hash, etc. Was I just trying too often and it didn't move on to the next number? The contents of the table itself look normal.

<EOL> Tib

On Wed, 22 Jun 2005, Tim Altman wrote:

On Wed, 22 Jun 2005 00:42:13 +0200, Tib tib@tigerknight.org wrote:

The first time I registered an account outside the admin one through the web pages (for anonymous users) it worked fine. But now every time after I am getting the following error and I'm not sure what to do. The UID number is incrementing, but because of the 'duplicate' error, the accounts never get created. What's going on?

user error: Duplicate entry '' for key 2 query: INSERT INTO tib_users (pass, created, changed, uid) VALUES ('8ea960a46ddefee8f7c895deb6d089a2', '1119393043', '1119393043', '8') in /home/tib/public_html/includes/database.mysql.inc on line 66.

Have you added a prefix to the sequences table? This error and the previous one you posted could be explained if that table wasn't being updated correctly.

hi all -

I want to get a Drupal site all up and running in the background, and then switch it to live.

If i configure the site on one URL, and then move it to a new URL, is the only change needed in the

sites/default/settings.php

-> $base_url =

or are URL entries somehow written into the DB? the DB connection URL will remain the same.

Is there another way to do this? eg can i setup the site in a subdirectory?

tx!

/dc

Please do not reply to an existing thread. Even when blanking out subject and body, it breaks threading in the archives and mail clients.

Please start with a new blank message.

Ber

Op maandag 20 juni 2005 04:15, schreef D_C:

hi all -

I want to get a Drupal site all up and running in the background, and then switch it to live.

If i configure the site on one URL, and then move it to a new URL, is the only change needed in the

sites/default/settings.php

-> $base_url =

or are URL entries somehow written into the DB? the DB connection URL will remain the same.

Is there another way to do this? eg can i setup the site in a subdirectory?

tx!

/dc

Regards, Bèr

Hi,

I am working on a similar issue. In order for you to create a second site in the same database. You have to create the tables which you refer to in your settings.php file. So, you can take the database.mysql file, replace all instructions by adding the prefix and then importing the file. For example: CREATE TABLE access should be replaced with CREATE TABLE dr_access Then, you import the file. Some have suggested using two databases. Drupal is supposed to be easily used by the end user. This is not possible. I have struggled so hard to make it do what I want it to do. Clearly, this is because I have no knowledge of PHP. If I did, this would be a great and powerful platform.

I hope this helps.

Regards

----- Original Message ----- From: "Tib" tib@tigerknight.org To: drupal-support@drupal.org Sent: Sunday, June 19, 2005 4:17 PM Subject: [drupal-support] New sites and db prefixes

Ok - so I have my first site, which has no prefix.. now how do I add another site with it's own prefix? I've extracted the drupal files into a new folder, verified that it has access to modrewrite, and configured the sites/default/settings.php to have a prefix of my choosing, and setup the .htaccess properly. But when I go to the web page it errors out telling me the tablespace for my prefix doesn't exist.

The handbook doesn't really cover this that I could find. Hopefully I'm just reading too fast and missing something obvious..?

<EOL> Tib -- [ Drupal support list | http://lists.drupal.org/ ]

Ack - although I found you also need to edit the insert commands to reflect the new prefix too. D'oh!

<EOL> Tib

On Sun, 19 Jun 2005, Tib wrote:

Excellent - this is exactly what I needed to see. I knew it could do it (I mean come on - that seemed like the whole point of it actually) but there didn't seem to be any method provided with drupal for doing so.

Thanks!

<EOL> Tib

On Sun, 19 Jun 2005, Christopher Taylor wrote:

Hi,

I am working on a similar issue. In order for you to create a second site in the same database. You have to create the tables which you refer to in your settings.php file. So, you can take the database.mysql file, replace all instructions by adding the prefix and then importing the file. For example: CREATE TABLE access should be replaced with CREATE TABLE dr_access Then, you import the file. Some have suggested using two databases. Drupal is supposed to be easily used by the end user. This is not possible. I have struggled so hard to make it do what I want it to do. Clearly, this is because I have no knowledge of PHP. If I did, this would be a great and powerful platform.

I hope this helps.

Regards

----- Original Message ----- From: "Tib" tib@tigerknight.org To: drupal-support@drupal.org Sent: Sunday, June 19, 2005 4:17 PM Subject: [drupal-support] New sites and db prefixes

Ok - so I have my first site, which has no prefix.. now how do I add another site with it's own prefix? I've extracted the drupal files into a new folder, verified that it has access to modrewrite, and configured the sites/default/settings.php to have a prefix of my choosing, and setup the .htaccess properly. But when I go to the web page it errors out telling me the tablespace for my prefix doesn't exist.

The handbook doesn't really cover this that I could find. Hopefully I'm just reading too fast and missing something obvious..?

<EOL> Tib -- [ Drupal support list | http://lists.drupal.org/ ]

On Sat, 18 Jun 2005, puregin wrote:

On 17 Jun 2005, at 11:41 PM, Gerhard Killesreiter wrote:

...

On Fri, 17 Jun 2005, Tib wrote:

...

By editing bootstrap.inc and removing the 'includes/' from the database.inc, session.inc, and module.inc listings at the end I was able to get to the next error - shown below.

If you need this, something went wrong when unpacking the Drupal tar file. The directory structure should be:

index.php includes/ modules/ themes/

...

All files ending in .inc should be in includes/.

It looks like includes/ was created, since the warning is generated in "/home/tib/public_html/drupal/includes/bootstrap.inc on line 645"

BOFH excuse: I didn't have my morning tea yet.

Now that I'm looking more closely at the warning, it appears that the PHP include path does not include '.' - should it?

I checked my local installation and it has. So it probably should.

Cheers, Gerhard

If you need this, something went wrong when unpacking the Drupal tar file. The directory structure should be:

index.php includes/ modules/ themes/

All files ending in .inc should be in includes/.

Nope. They are proper. directory structure as follows:

-rw-r--r-- 1 tib users 19761 Jun 1 15:16 CHANGELOG.txt -rw-r--r-- 1 tib users 10280 Apr 23 00:07 INSTALL.txt -rw-r--r-- 1 tib users 18019 Sep 15 2004 LICENSE.txt -rw-r--r-- 1 tib users 1428 Sep 15 2004 MAINTAINERS.txt -rw-r--r-- 1 tib users 749 Jan 9 03:22 cron.php drwxr-sr-x 2 tib users 4096 Jun 17 15:45 database -rw-r--r-x 1 tib users 8430 Jun 11 2003 favicon.ico drwxr-sr-x 2 tib users 4096 Jun 17 21:28 includes -rw-r--r-- 1 tib users 595 Aug 21 2004 index.php drwxr-sr-x 2 tib users 4096 Jun 17 15:45 modules drwxr-sr-x 2 tib users 4096 Jun 17 15:45 scripts drwxr-sr-x 3 tib users 4096 Jun 17 15:45 sites drwxr-sr-x 6 tib users 4096 Jun 17 15:45 themes -rw-r--r-- 1 tib users 8787 Apr 6 14:04 update.php -rw-r--r-- 1 tib users 384 Aug 21 2004 xmlrpc.php

The webserver is 'nobody:nogroup' and has read/execute permissions in all the proper places. As mentioned before even if I change the ownerships directly to the userid and group of the webserver it still has the errors.

<EOL> Tib

Which is what I ws using since the beginning.

On Mon, 20 Jun 2005, Ron Mahon wrote:

To Start php 5 was not supported until 4.6

Ron

InterNet Marketing Resource Center A Free Super Mart of Articles, Demos, Tutorials everything you need to Succeed on the net. www.inmrc.com

-----Original Message----- From: Tib [mailto:tib@tigerknight.org] Sent: Friday, June 17, 2005 10:34 PM To: drupal-support@drupal.org Subject: [drupal-support] Installation problems

Everything went smoothly at first until it came time to point a web browser at it and login.

------------------------------- Warning: main(includes/database.inc) [function.main]: failed to open stream: No such file or directory in /home/tib/public_html/drupal/includes/bootstrap.inc on line 643

Warning: main() [function.include]: Failed opening 'includes/database.inc' for inclusion (include_path='/usr/local/lib/php') in /home/tib/public_html/drupal/includes/bootstrap.inc on line 643

Warning: main(includes/session.inc) [function.main]: failed to open stream: No such file or directory in /home/tib/public_html/drupal/includes/bootstrap.inc on line 644

Warning: main() [function.include]: Failed opening 'includes/session.inc' for inclusion (include_path='/usr/local/lib/php') in /home/tib/public_html/drupal/includes/bootstrap.inc on line 644

Warning: main(includes/module.inc) [function.main]: failed to open stream: No such file or directory in /home/tib/public_html/drupal/includes/bootstrap.inc on line 645

Warning: main() [function.include]: Failed opening 'includes/module.inc' for inclusion (include_path='/usr/local/lib/php') in /home/tib/public_html/drupal/includes/bootstrap.inc on line 645

Fatal error: Call to undefined function db_fetch_object() in /home/tib/public_html/drupal/includes/bootstrap.inc on line 199 -------------------------------

By editing bootstrap.inc and removing the 'includes/' from the database.inc, session.inc, and module.inc listings at the end I was able to get to the next error - shown below.

------------------------------ Warning: db_set_active(includes/database.mysql.inc) [function.db-set-active]: failed to open stream: No such file or directory in /home/tib/public_html/drupal/includes/database.inc on line 116

Warning: db_set_active() [function.include]: Failed opening 'includes/database.mysql.inc' for inclusion (include_path='/usr/local/lib/php') in /home/tib/public_html/drupal/includes/database.inc on line 116

Fatal error: Call to undefined function db_connect() in /home/tib/public_html/drupal/includes/database.inc on line 122 ------------------------------

Now what I'd like to know is if the first correction I made, by way of bootstrap.inc, will screw up other things in a kickdown fashion.

Next how do I get around the database issue?

Finally - why is this happening to start with?

I'm running php5.0.4, mysql 4.0.24, and apache 1.3.27.

Thanks

<EOL> Tib