Mailing-List: contact modules-dev-help@httpd.apache.org; run by ezmlm
Precedence: bulk
Reply-To: modules-dev@httpd.apache.org
Received-SPF: pass (nike.apache.org: local policy)
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>
	<015f01c98faf$bbc63e30$3352ba90$@jorge@decimal.pt> <4998871E.70602@dmi.me.uk>
In-Reply-To: <4998871E.70602@dmi.me.uk>
Subject: RE: mod_vhost_dbd
Date: Sun, 15 Feb 2009 21:31:50 -0000
Message-ID: <017c01c98fb4$d0948790$71bd96b0$@jorge@decimal.pt>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AcmPs1G8LFaPR2XnTG65/pls+LSkGAAAUrAg
Content-Language: pt

> Yup. I place no restrictions at all. It doesn't even have to be a
> single
> table -- it can be the result of a multi-table join, as long as all of
> the columns have different names. They can be renamed using "AS", like
> "SELECT a.id, a.name, h.name AS hname FROM table1 a, table2 h" for
> example, which would then be accessed as ${id}, ${name}, ${hname}. Take
> a quick glance at the sample configuration
> <http://www.dmi.me.uk/code/apache/mod_sqltemplate/99_mod_sqltemplate.co
> nf>
> from the mod_sqltemplate site.

Good!

> 
> It can be from anything that can send Apache a signal (USR1 causes a
> graceful restart) as well. Running apache2ctl can be done from anything
> that has the right permissions to signal Apache.

Hum... I'll have to do something with netcat or so, because the web
interface that will manage the sql records, will be on another server.
Not a big problem.

> You can leave your existing configuration files and create a completely
> new one that handles all of your new virtualhosts.

Great!