Return-Path: 
 <modules-dev-return-2247-apmail-httpd-modules-dev-archive=httpd.apache.org@httpd.apache.org>
Delivered-To: apmail-httpd-modules-dev-archive@minotaur.apache.org
Received: (qmail 84355 invoked from network); 15 Feb 2009 20:56:03 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 15 Feb 2009 20:56:03 -0000
Received: (qmail 23884 invoked by uid 500); 15 Feb 2009 20:55:59 -0000
Delivered-To: apmail-httpd-modules-dev-archive@httpd.apache.org
Received: (qmail 23852 invoked by uid 500); 15 Feb 2009 20:55:59 -0000
Mailing-List: contact modules-dev-help@httpd.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:modules-dev-help@httpd.apache.org>
List-Unsubscribe: <mailto:modules-dev-unsubscribe@httpd.apache.org>
List-Post: <mailto:modules-dev@httpd.apache.org>
List-Id: <modules-dev.httpd.apache.org>
Reply-To: modules-dev@httpd.apache.org
Delivered-To: mailing list modules-dev@httpd.apache.org
Received: (qmail 23839 invoked by uid 99); 15 Feb 2009 20:55:59 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 15 Feb 2009 12:55:59 -0800
X-ASF-Spam-Status: No, hits=1.2 required=10.0
	tests=MSGID_MULTIPLE_AT,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: local policy)
Received: from [195.23.114.76] (HELO smtp.decimal.pt) (195.23.114.76)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 15 Feb 2009 20:55:49 +0000
Received: from smtp.decimal.pt (localhost.localdomain [127.0.0.1])
	by smtp.decimal.pt (Postfix) with ESMTP id 6FC7A249DD
	for <modules-dev@httpd.apache.org>; Sun, 15 Feb 2009 20:55:28 +0000 (WET)
Received: by smtp.decimal.pt (Postfix, from userid 1001)
	id 638772B871; Sun, 15 Feb 2009 20:55:28 +0000 (WET)
X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on lira
X-Spam-Level: 
Received: from pcjorge (87-196-156-177.net.novis.pt [87.196.156.177])
	by smtp.decimal.pt (Postfix) with ESMTPA id D59F0249DD
	for <modules-dev@httpd.apache.org>; Sun, 15 Feb 2009 20:55:27 +0000 (WET)
From: "Jorge Bastos" <mysql.jorge@decimal.pt>
To: <modules-dev@httpd.apache.org>
References: <013601c98ef4$50227650$f06762f0$@jorge@decimal.pt>
	<499874F0.9090908@dmi.me.uk>
	<013201c98fa9$98ddaf80$ca990e80$@jorge@decimal.pt>
	<015501c98fac$1edbfbd0$5c93f370$@jorge@decimal.pt>
 <49987F6A.7030502@dmi.me.uk>
In-Reply-To: <49987F6A.7030502@dmi.me.uk>
Subject: RE: mod_vhost_dbd
Date: Sun, 15 Feb 2009 20:55:28 -0000
Message-ID: <015f01c98faf$bbc63e30$3352ba90$@jorge@decimal.pt>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AcmPrrfyQNArdBRVTcCGq8VbrS6m7wAAEZcw
Content-Language: pt
X-Virus-Scanned: ClamAV using ClamSMTP
X-Virus-Checked: Checked by ClamAV on apache.org
X-Old-Spam-Status: No, score=-2.4 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00,
	MSGID_MULTIPLE_AT autolearn=no version=3.2.5

> Thanks -- it's always nice to be appreciated. Let me know if you hit
> any
> problems, as I don't have the resources to test it in lots of different
> situations.

I'll :)

> This is possible using mod_sqltemplate. Suppose in your database, you
> have a "php_register_globals" column, which is either "On" or "Off".
> Then this will work:
> 
> <SQLRepeat ".... blah sql to select virtualhosts... ">
> <VirtualHost *:80>
> # ...
> php_flag register_globals ${php_register_globals}
> # ...
> </VirtualHost>
> </SQLRepeat>
> 
> > When I say this values for php, it may happen that other ones appear.
> >
> You can use a similar method for any directives. You can even have
> fully
> custom directives:
> 
> <SQLRepeat...>
> <VirtualHost *:80>
> #...
> ${custom}
> #...
> </VirtualHost>
> </SQLRepeat>

So I think my problem is resolved!
Resuming, I can have as many columns I want in the hosts table, correct? If
so, I can have the config I want!!! That's fantastic, I've been looking for
something like this for some years!

> You can tell Apache to perform a config reload (e.g. via apache2ctl
> graceful), which will force the configuration to be re-read from the
> database.

Hum but this only via commandline correct?



Another thing, apache read's this, when it loads and stays with this info on
memory correct?
The existing virtualhosts that I have, I can leave that intact, and start
using the new virtualhosts with this configuration, correct?